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();
Re: database objectnow, it work as exec(query) too.
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))") ?
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.
Sysop: | digital man |
---|---|
Location: | Riverside County, California |
Users: | 1,050 |
Nodes: | 15 (0 / 15) |
Uptime: | 64:08:16 |
Calls: | 236,058 |
Calls today: | 6 |
Files: | 60,364 |
D/L today: |
91 files (88,211K bytes) |
Messages: | 289,832 |