Class SQLite3

Inheritance

object

SQLite3

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Unity.VisualScripting.Dependencies.Sqlite

Assembly: Unity.VisualScripting.Core.Editor.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