Class_SQLiteDB

AHK SQLite API Wrapper

AHK class providing support to access SQLite databases.

The repo contains two versions of the class and sample scripts:

1. Sources_v1.1 for the current AHK 1.1 version
2. Sources_v2 for the upcoming AHK v2 version.

Additional stuff

• SQLite documentation
• SQLite download page

Basic usage

• 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 method RecordSet.Next() to access the records sequentially. Only DB-Query() does handle BLOBs properly. All other field types will be returned as strings (see DB.GetTable()). If you don't need the RecordSet anymore, call RecordSet.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 queries RecordSet.Free() will be called internally.
• For further details look at the inline documentation in the class script and the sample scripts, please.