Module that handles SQLite databases management. More...

Functions
int	Database::open (string filename)
	Open/Create an SQLite database. More...

void	Database::close (int db)
	Close an opened database. More...

table	Database::execQuery (int db, string query)
	Execute a query. More...

Detailed Description

Module that handles SQLite databases management.

Function Documentation

int Database::open ( string filename )

Open/Create an SQLite database.

Usage example:: db = Database.open("ur0:shell/db/app.db")

Database
Definition: luaDatabase.cpp:7

Database::open
int open(string filename)
Open/Create an SQLite database.

Parameters

filename - Filename of the database to open.

void Database::close ( int db )

Close an opened database.

Usage example:: Database.close(db)

Database::close
void close(int db)
Close an opened database.

Parameters

db	- A valid database handle.

Execute a query.

Usage example:: results = Database.execQuery(db, "SELECT columnName FROM tableName")

Graphics.debugPrint(0, 0, results[1].columnName, Color.new(255, 255, 255))

Color
Definition: luaColor.cpp:6

Graphics
Definition: luaGraphics.cpp:15

Color::new
int new(int r, int g, int b, int a)
Create a new color.

Database::execQuery
table execQuery(int db, string query)
Execute a query.

Graphics::debugPrint
void debugPrint(number x, number y, string text, int color)
Print a text on screen using system font.

Parameters

db	- A valid database handle.
query	- An SQL query to execute.