[Looking for Hire] Develop Monkey Addons!

Local db:SQLite3DB = SQLite3.Load("database.db")

db.Close()

Local thisResult:SQLite3Result = db.Query("INSERT INTO table ( field_1,field_2,field_3) VALUES ( NULL, 'cat', 123 )")
Local anotherResult:SQLite3Result = db.Query("UPDATE table SET field_2 = 'woop' WHERE field_1 = 1 LIMIT 1")
Local selectResult:SQLite3Result = db.Query("SELECT * FROM table ORDER BY field_1 ASC LIMIT 3")
If selectResult->numRows > 0
  while local row:StringMap<String> = selectResult->fetchAssoc()
    ' DO SOMETHING WITH row
  end
end

_db = New SQLite3DataBase()
_db.Load("database.db")

_db.Query("CREATE TABLE Books(Id INTEGER PRIMARY KEY, Title TEXT, Author TEXT, ISBN TEXT DEFAULT 'not available')")
_db.Query("INSERT INTO Books(Id, Title, Author, ISBN)VALUES(1, 'War and Peace', 'Leo Tolstoy', '978-0345472403')")
_db.Query("INSERT INTO Books(Id, Title, Author, ISBN)VALUES(2, 'diesdas', 'Leo Tolstoy', '978-0345472403')")
_db.Query("INSERT INTO Books(Id, Title, Author, ISBN)VALUES(3, 'blibla', 'Leo Tolstoy', '978-23423')")
_db.Query("INSERT INTO Books(Id, Title, Author, ISBN)VALUES(4, 'blubla', 'Leo Tolstoy', '978-2342342342')")

Local result:= _db.Exec("SELECT * FROM Books")
While result.Read()
	For Local e:= Eachin result.StringMap
	      Print e.Key + "/" + e.Value
	End 
Wend