Velocity Reviews

Velocity Reviews (http://www.velocityreviews.com/forums/index.php)
-   Javascript (http://www.velocityreviews.com/forums/f68-javascript.html)
-   -   server-side JavaScript: Example 2: Sqlite class (http://www.velocityreviews.com/forums/t936355-server-side-javascript-example-2-sqlite-class.html)

GVDC 06-28-2008 04:11 PM

server-side JavaScript: Example 2: Sqlite class
 
Example server-side JavaScript Web script, Sqlite class

//demonstrate usage of SQLite3 database and JavaScript interface
// BEGIN CODE -->
printf("<html>");
printf("<body bgcolor=\"#ffffff\" color=\"#333333\">");

var dbfilepath = "mydatabase.db";
var databaseobj = new Sqlite(dbfilepath); //Sqlite class

//set errno 0
Server.errno(0);

printf("<b>Opening database.</b><br>");

if ( databaseobj.open()==true ) {
printf("Executing CREATE and INSERT statement.<br>");

//SQL statement
var ssqlstmt = ""
+"CREATE TABLE ttesttable (i INTEGER PRIMARY KEY, cname CHAR(255), cweight INTEGER); "
+"INSERT INTO ttesttable (cname,cweight) VALUES ('firstuser',95); "
+"INSERT INTO ttesttable (cname,cweight) VALUES ('anotheruser',263); "
;

//if statements executed ok
if ( databaseobj.exec(ssqlstmt)==true ) {
printf("Two rows inserted.<br>");
printf("Using SELECT query to fetch inserted values.<br>");
//query
if ( databaseobj.query("SELECT * FROM ttesttable")==true ) {
//printing selected values in tabular form ie.
//colname (TYPE) colname (TYPE) colname (TYPE)
//--------------------------------------------------
//value value value
//value value value
printf("Printing selected values in tabular form.<br><br>");
printf("<table bgcolor=\"#DDDDDD\" cellspacing=1 cellpadding=4>");

//print header row
printf("<tr bgcolor=\"#eeeeee\">");
for ( var ccol=0; ccol!=databaseobj.colcount(); ccol++ ) {
printf("<td><b>");
printf(databaseobj.colname(ccol));
printf(" (");
printf(databaseobj.coltype(ccol));
printf(")</b></td>");
}
printf("</tr>");


//print rows
var nrows = 0;
while ( (onerow=databaseobj.rowfetch())!=null ) {
printf("<tr bgcolor=\"#FFFFFF\">");
for ( var indx in onerow ) {
printf("<td>");
printf(onerow[indx]);
printf("</td>");
}
printf("</tr>");

nrows++;
}

printf("</table>");
printf("<br>");

printf("<i>number of rows in select query [");
printf(nrows);
printf("]</i><br>");
}
}
//error
else {
//ie. table already exists etc
printf("Error in exec, error [" ,databaseobj.error(), "]<br>");
}

printf("<b>Closing database.</b><br>");
databaseobj.close();
printf("Database closed.<br>");
}
//error
else {
//ie. invalid path, no permission etc
printf("Error opening database, error [" ,databaseobj.error(), "]<br>");
}



printf("Deleting database file.<br>");
//delete database file
if ( Server.unlink(dbfilepath)==true ) {
printf("Database file deleted.<br>");
}
else {
//ie. invalid path, no permission etc
printf("Error deleting file ",dbfilepath,", system errno [" ,Server.errno(), "]<br>");
}



printf("</body>");
printf("</html>");


// <--END CODE









--









All times are GMT. The time now is 10:35 AM.

Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.