Class SQLite3

Inheritance
object
SQLite3
Namespace: Unity.VisualScripting.Dependencies.Sqlite
Assembly: solution.dll
Syntax
public static class SQLite3

Methods

BindBlob(IntPtr, int, byte[], int, IntPtr)

Declaration
public static extern int BindBlob(IntPtr stmt, int index, byte[] val, int n, IntPtr free)
Parameters
Type Name Description
IntPtr stmt
int index
byte[] val
int n
IntPtr free
Returns
Type Description
int

BindDouble(IntPtr, int, double)

Declaration
public static extern int BindDouble(IntPtr stmt, int index, double val)
Parameters
Type Name Description
IntPtr stmt
int index
double val
Returns
Type Description
int

BindInt(IntPtr, int, int)

Declaration
public static extern int BindInt(IntPtr stmt, int index, int val)
Parameters
Type Name Description
IntPtr stmt
int index
int val
Returns
Type Description
int

BindInt64(IntPtr, int, long)

Declaration
public static extern int BindInt64(IntPtr stmt, int index, long val)
Parameters
Type Name Description
IntPtr stmt
int index
long val
Returns
Type Description
int

BindNull(IntPtr, int)

Declaration
public static extern int BindNull(IntPtr stmt, int index)
Parameters
Type Name Description
IntPtr stmt
int index
Returns
Type Description
int

BindParameterIndex(IntPtr, string)

Declaration
public static extern int BindParameterIndex(IntPtr stmt, string name)
Parameters
Type Name Description
IntPtr stmt
string name
Returns
Type Description
int

BindText(IntPtr, int, string, int, IntPtr)

Declaration
public static extern int BindText(IntPtr stmt, int index, string val, int n, IntPtr free)
Parameters
Type Name Description
IntPtr stmt
int index
string val
int n
IntPtr free
Returns
Type Description
int

BusyTimeout(IntPtr, int)

Declaration
public static extern SQLite3.Result BusyTimeout(IntPtr db, int milliseconds)
Parameters
Type Name Description
IntPtr db
int milliseconds
Returns
Type Description
SQLite3.Result

Changes(IntPtr)

Declaration
public static extern int Changes(IntPtr db)
Parameters
Type Name Description
IntPtr db
Returns
Type Description
int

Close(IntPtr)

Declaration
public static extern SQLite3.Result Close(IntPtr db)
Parameters
Type Name Description
IntPtr db
Returns
Type Description
SQLite3.Result

ColumnBlob(IntPtr, int)

Declaration
public static extern IntPtr ColumnBlob(IntPtr stmt, int index)
Parameters
Type Name Description
IntPtr stmt
int index
Returns
Type Description
IntPtr

ColumnByteArray(IntPtr, int)

Declaration
public static byte[] ColumnByteArray(IntPtr stmt, int index)
Parameters
Type Name Description
IntPtr stmt
int index
Returns
Type Description
byte[]

ColumnBytes(IntPtr, int)

Declaration
public static extern int ColumnBytes(IntPtr stmt, int index)
Parameters
Type Name Description
IntPtr stmt
int index
Returns
Type Description
int

ColumnCount(IntPtr)

Declaration
public static extern int ColumnCount(IntPtr stmt)
Parameters
Type Name Description
IntPtr stmt
Returns
Type Description
int

ColumnDouble(IntPtr, int)

Declaration
public static extern double ColumnDouble(IntPtr stmt, int index)
Parameters
Type Name Description
IntPtr stmt
int index
Returns
Type Description
double

ColumnInt(IntPtr, int)

Declaration
public static extern int ColumnInt(IntPtr stmt, int index)
Parameters
Type Name Description
IntPtr stmt
int index
Returns
Type Description
int

ColumnInt64(IntPtr, int)

Declaration
public static extern long ColumnInt64(IntPtr stmt, int index)
Parameters
Type Name Description
IntPtr stmt
int index
Returns
Type Description
long

ColumnName(IntPtr, int)

Declaration
public static extern IntPtr ColumnName(IntPtr stmt, int index)
Parameters
Type Name Description
IntPtr stmt
int index
Returns
Type Description
IntPtr

ColumnName16(IntPtr, int)

Declaration
public static string ColumnName16(IntPtr stmt, int index)
Parameters
Type Name Description
IntPtr stmt
int index
Returns
Type Description
string

ColumnString(IntPtr, int)

Declaration
public static string ColumnString(IntPtr stmt, int index)
Parameters
Type Name Description
IntPtr stmt
int index
Returns
Type Description
string

ColumnText(IntPtr, int)

Declaration
public static extern IntPtr ColumnText(IntPtr stmt, int index)
Parameters
Type Name Description
IntPtr stmt
int index
Returns
Type Description
IntPtr

ColumnText16(IntPtr, int)

Declaration
public static extern IntPtr ColumnText16(IntPtr stmt, int index)
Parameters
Type Name Description
IntPtr stmt
int index
Returns
Type Description
IntPtr

ColumnType(IntPtr, int)

Declaration
public static extern SQLite3.ColType ColumnType(IntPtr stmt, int index)
Parameters
Type Name Description
IntPtr stmt
int index
Returns
Type Description
SQLite3.ColType

Config(ConfigOption)

Declaration
public static extern SQLite3.Result Config(SQLite3.ConfigOption option)
Parameters
Type Name Description
SQLite3.ConfigOption option
Returns
Type Description
SQLite3.Result

EnableLoadExtension(IntPtr, int)

Declaration
public static extern SQLite3.Result EnableLoadExtension(IntPtr db, int onoff)
Parameters
Type Name Description
IntPtr db
int onoff
Returns
Type Description
SQLite3.Result

Errmsg(IntPtr)

Declaration
public static extern IntPtr Errmsg(IntPtr db)
Parameters
Type Name Description
IntPtr db
Returns
Type Description
IntPtr

ExtendedErrCode(IntPtr)

Declaration
public static extern SQLite3.ExtendedResult ExtendedErrCode(IntPtr db)
Parameters
Type Name Description
IntPtr db
Returns
Type Description
SQLite3.ExtendedResult

Finalize(IntPtr)

Declaration
public static extern SQLite3.Result Finalize(IntPtr stmt)
Parameters
Type Name Description
IntPtr stmt
Returns
Type Description
SQLite3.Result

GetErrmsg(IntPtr)

Declaration
public static string GetErrmsg(IntPtr db)
Parameters
Type Name Description
IntPtr db
Returns
Type Description
string

Initialize()

Declaration
public static extern SQLite3.Result Initialize()
Returns
Type Description
SQLite3.Result

LastInsertRowid(IntPtr)

Declaration
public static extern long LastInsertRowid(IntPtr db)
Parameters
Type Name Description
IntPtr db
Returns
Type Description
long

LibVersionNumber()

Declaration
public static extern int LibVersionNumber()
Returns
Type Description
int

Open(byte[], out IntPtr, int, IntPtr)

Declaration
public static extern SQLite3.Result Open(byte[] filename, out IntPtr db, int flags, IntPtr zvfs)
Parameters
Type Name Description
byte[] filename
IntPtr db
int flags
IntPtr zvfs
Returns
Type Description
SQLite3.Result

Open(string, out IntPtr)

Declaration
public static extern SQLite3.Result Open(string filename, out IntPtr db)
Parameters
Type Name Description
string filename
IntPtr db
Returns
Type Description
SQLite3.Result

Open(string, out IntPtr, int, IntPtr)

Declaration
public static extern SQLite3.Result Open(string filename, out IntPtr db, int flags, IntPtr zvfs)
Parameters
Type Name Description
string filename
IntPtr db
int flags
IntPtr zvfs
Returns
Type Description
SQLite3.Result

Open16(string, out IntPtr)

Declaration
public static extern SQLite3.Result Open16(string filename, out IntPtr db)
Parameters
Type Name Description
string filename
IntPtr db
Returns
Type Description
SQLite3.Result

Prepare2(IntPtr, string)

Declaration
public static IntPtr Prepare2(IntPtr db, string query)
Parameters
Type Name Description
IntPtr db
string query
Returns
Type Description
IntPtr

Prepare2(IntPtr, string, int, out IntPtr, IntPtr)

Declaration
public static extern SQLite3.Result Prepare2(IntPtr db, string sql, int numBytes, out IntPtr stmt, IntPtr pzTail)
Parameters
Type Name Description
IntPtr db
string sql
int numBytes
IntPtr stmt
IntPtr pzTail
Returns
Type Description
SQLite3.Result

Reset(IntPtr)

Declaration
public static extern SQLite3.Result Reset(IntPtr stmt)
Parameters
Type Name Description
IntPtr stmt
Returns
Type Description
SQLite3.Result

SetDirectory(uint, string)

Declaration
public static extern int SetDirectory(uint directoryType, string directoryPath)
Parameters
Type Name Description
uint directoryType
string directoryPath
Returns
Type Description
int

Shutdown()

Declaration
public static extern SQLite3.Result Shutdown()
Returns
Type Description
SQLite3.Result

Step(IntPtr)

Declaration
public static extern SQLite3.Result Step(IntPtr stmt)
Parameters
Type Name Description
IntPtr stmt
Returns
Type Description
SQLite3.Result