README 1.53 KB
Newer Older
gwenn's avatar
gwenn committed
1
Yet another SQLite binding based on:
gwenn's avatar
gwenn committed
2 3
 - original [Russ Cox's](http://code.google.com/p/gosqlite/) implementation,
 - the [Patrick Crosby's](https://github.com/patrickxb/fgosqlite/) fork.
Patrick Crosby's avatar
Patrick Crosby committed
4

gwenn's avatar
gwenn committed
5
Open supports flags.
gwenn's avatar
gwenn committed
6
Conn#Exec handles multiple statements (separated by semicolons) properly.
gwenn's avatar
gwenn committed
7
Conn#Prepare can optionnaly #Bind as well.
gwenn's avatar
gwenn committed
8
Conn#Close ensures that all dangling statements are finalized.
gwenn's avatar
gwenn committed
9 10
Stmt#Exec is renamed in Stmt#Bind and a new Stmt#Exec method is introduced to #Bind and #Step.
Stmt#Bind uses native sqlite3_bind_x methods and failed if unsupported type.
gwenn's avatar
gwenn committed
11
Stmt#Next returns a (bool, os.Error) couple like Reader#Read.
gwenn's avatar
gwenn committed
12
Stmt#Scan uses native sqlite3_column_x methods.
gwenn's avatar
gwenn committed
13
Stmt#NamedScan is added. It's compliant with [go-dbi](https://github.com/thomaslee/go-dbi/) API but I think its signature should be improved/modified.
gwenn's avatar
gwenn committed
14 15 16 17 18 19 20 21
Stmt#ScanColumn/NamedScanColumn are added to test NULL value.

Misc:
Conn#EnableFkey/IsFKeyEnabled
Conn#Changes/TotalChanges
Conn#LastInsertRowid
Conn#Interrupt
Conn#Begin/BeginTransaction(type)/Commit/Rollback
gwenn's avatar
gwenn committed
22
Conn#GetAutocommit
23
Conn#EnableLoadExtension/LoadExtension
gwenn's avatar
gwenn committed
24 25

Stmt#ExecUpdate
gwenn's avatar
gwenn committed
26
Stmt#BindParameterCount/BindParameterIndex/BindParameterName
gwenn's avatar
gwenn committed
27
Stmt#ClearBindings
gwenn's avatar
gwenn committed
28
Stmt#ColumnCount/ColumnIndex(name)/ColumnName(index)
29
Stmt#ReadOnly
gwenn's avatar
gwenn committed
30 31 32 33 34 35 36

Blob:
ZeroBlobLength
Conn#NewBlobReader
Conn#NewBlobReadWriter

Meta:
gwenn's avatar
gwenn committed
37
Conn#Databases
gwenn's avatar
gwenn committed
38 39 40
Conn#Tables
Conn#Columns
Conn#ForeignKeys
gwenn's avatar
gwenn committed
41
Conn#Indexes/IndexColumns
gwenn's avatar
gwenn committed
42 43 44 45 46 47 48 49 50 51 52 53 54

Time:
JulianDay
JulianDayToUTC
JulianDayToLocalTime

Trace:
Conn#BusyHandler
Conn#Profile
Conn#ProgressHandler
Conn#SetAuthorizer
Conn#Trace
Stmt#Status