roSqliteDatabase
This is the main SQLite object that "owns" the database. You can create as many of these objects as you need. The JavaScript equivalent is to use the IndexedDB.
ifSqliteDatabse
Open(path As String) As Boolean
Opens an existing database file. This method returns True
upon success.
Create(path As String) As Boolean
Creates a new, empty database file. This method returns True
upon success.
Passing ":memory:"
to this method creates a database in non-persistent storage. This is useful for high-volume database applications that might cause wear issues on an SD card.
Close()
Closes an open database.
CreateStatement(sql_text As String) As Object
Creates a new roSqliteStatement object using the specified SQL string.
RunBackground(sql_text As String, associative_array As Object) As Integer
Runs the specified SQL statement in the background and binds variables using the passed roAssociativeArray.
SetMemoryLimit(limit As Integer)
Sets the "soft" memory limit under which SQLite will attempt to remain (see the SQLite documentation for details).
The SetMemoryLimit()
method sets global parameters. It must, therefore, be called before any other calls are made on the database object.
ON THIS PAGE
ifMessagePort
SetPort(port As roMessagePort)
Posts messages of type roSqliteEvent to the attached message port.
Examples
Creating a Database:
db = CreateObject("roSqliteDatabase")
print db
openResult = db.Create("SD:/test.db")
if openResult
print "Created OK"
else
print "Creation FAILED"
end
endif
Creating a Table in a Database:
createStmt = db.CreateStatement("CREATE TABLE playback (md5 text PRIMARY KEY, path PATH, playback_count INT);")
print createStmt
if type(createStmt) <> "roSqliteStatement" then
print "We didn't get a statement returned!!"
end
endif
sqlResult = createStmt.Run()
print sqlResult
if sqlResult = SQLITE_COMPLETE
print "Table Created OK"
else
print "Table Creation FAILED"
endif
createStmt.Finalise()