Re: database object
By: Ragnarok to DOVE-Net.Sync_JavaScript on Sun Apr 08 2007 05:32 pm

Hi people
i try to add a database support the the js script in syncrhonet
i use (at moment) sqlite as backend.

i thinking in an object that may be used to easy storage data for door or modules and easy access via sql standard commands.
an simple example of script code :

db = new Sqlite("/tmp/tu_base.db");
db.open();
db.stmt = "CREATE TABLE prueba (field1 int , field2 varchar(100))"; db.exec();

Why not just db.exec("CREATE TABLE prueba (field1 int , field2 varchar(100))") ?

digital man (xbox-live: digitlman)

Snapple "Real Fact" #161:
The first TV network kids show in the U.S. was "Captain Kangaroo."
Norco, CA WX: 88.3øF, 31% humidity, 4 mph SSE wind, 0.00 inches rain/24hrs
---
þ Synchronet þ Vertrauen þ Home of Synchronet þ telnet://vert.synchro.net

Ragnarok wrote:

db = new Sqlite("/tmp/tu_base.db");
db.open();
db.stmt = "CREATE TABLE prueba (field1 int , field2 varchar(100))";
db.exec();

Why not just db.exec("CREATE TABLE prueba (field1 int , field2
varchar(100))") ?

now, it work as exec(query) too.

Suggestion for syntax...

var db = new Sqlite("/tmp/tu_base.db");
try {
db.open(); //throw an object when a connection fails...
var results = db.exec("CREATE TABLE ...");
//should return 0, no rows effected

results = db.query("SELECT ...");
results.rows <-- array of rows
results.columns <-- array of column titles
for (i in results.rows) {
results.rows[i]["columnName"]
...or...
results.rows[i][columnIndex]
}
} catch(dbError) {
console.write("ERROR: " + dbError.message + "\r\n\r\n");
}

Just a suggestion on this, to keep it easy enough to use the results...
a .exec() method which executes the query and returns the rows affected as the result... a .query() method which returns a results object that has a rows array defined (each row containing an associative array for columns, in order)... as well as a columns array listing the column names.. results.rows.length could be used to determin a result count.

Have a DatabaseErrorObject that is thrown when an error state occurs, with a .toString() and .Message properties for use in a result message.

--
Michael J. Ryan - tracker1(at)theroughnecks(dot)net - www.theroughnecks.net icq: 4935386 - AIM/AOL: azTracker1 - Y!: azTracker1 - MSN/Win: (email)

---
þ Synchronet þ theroughnecks.net - you know you want it