AHK class providing support to access SQLite databases.
The repo contains two versions of the class and sample scripts:
- Sources_v1.1 for the current AHK 1.1 version
- Sources_v2 for the upcoming AHK v2 version.
- Create a new instance of the class SQLiteDB calling
MyDB := New SQLiteDB - Open your database calling
MyDB.OpenDB(MyDatabaseFilePath). If the file doesn't exist, a new database will be created unless you specify "False" as the third parameter. - MyDB object provides four methods to pass SQL statements to the database:
MyDB.Exec(SQL)
Should be called for all SQL statements which don't return values from the database (e.g. CREATE, INSERT, UPDATE, etc.).MyDB.GetTable(SQL, Table, ...)
Should be called for SELECT statements whenever you want to get the complete result of the query as a "Table" object for direct access via the row index. All field values will be returned "in their zero-terminated string representation" (and accordingly an empty string for NULL values).MyDB.Query(SQL, RecordSet, ...)
Should be called for SELECT statements whenever you want to get the result of the query as a "RecordSet" object. You'll have to call the built-in methodRecordSet.Next()to access the records sequentially. OnlyDB-Query()does handle BLOBs properly. All other field types will be returned as strings (seeDB.GetTable()). If you don't need the RecordSet anymore, callRecordSet.Free()to release the resources.MyDB.StoreBLOB(SQL, BlobArray)
Should be called whenever BLOBs shall be stored in the database. For each BLOB in the row you have to specify a?parameter within the statement. The parameters are numbered automatically from left to right starting with 1. For each parameter you have to pass an object within BlobArray containing the address and the size of the BLOB.
- After all work is done, call
MyDB.CloseDB()to close the database. For all still existing queriesRecordSet.Free()will be called internally. - For further details look at the inline documentation in the class script and the sample scripts, please.