Hello, world!!
"); print(""); //<--END SCRIPT //example: //fetching client-supplied values: //ie. /script.js?somevar=someval&myvar=myval //print value of "myvar" print(Cgi.any("myvar"), "Page visited: ", nVisits, " times.
"); //set duration of variables Session.time(7*24*60*60); //increment value and store to session Session.set(sSessVarName, (nVisits+1)+""); print(""); //Session is stored to disk automatically at and of script execution. //<--END SCRIPT -------------------------------------------------------------------------------- FILE CLASS -------------------------------------------------------------------------------- GromJS built-in "File" class provides access to files for read/write, and additional functions for manipulating file data such as lock, truncate, seek, etc. File data I/O by functions read()/write() is in chunk mode and "textual" (data is first converted to string then stored), ie. calling function myfile.read(20) reads 20 bytes from current file position, myfile.write("abcd") writes string "abcd" to file's current position. Numeric values (numbers) are read/written in their string (textual) representation. Functions nread()/nwrite() provide binary file I/O for numeric values, ie. each nwrite() call stores JavaScript Number type binary value to file, and nread() retrives it from file in same way. Additional information about file itself ie. file type (regular, dir, symlink etc.), permissions, etc. can be obtained using Server.stat() function. //example var fileobj = new File(string FILEPATH); var fileobj = new File("/path/to/myfile.txt"); //class prototype: class File { //methods bool open(string OPENMODE [,uint CREATEMODE]); /*Open file by specified mode OPENMODE; see below.*/ bool close(); /*Close; also removes any lock file has set.*/ int write(string DATA [, string DATA2, ...]); /*Write to file; multiple arguments; returns number of bytes written; on error returns -1. */ string read([uint LEN]); /*Read LEN bytes and return as JavaScript string; if no argument read all available bytes from current file position onward; on failure null returned. */ int cat([uint LEN]); /*Cat LEN bytes to stdout, if no argument, cat all available bytes from current file position onward; returns number of bytes done; -1 returned on error. */ uint tell(); /*Returns current file position index.*/ bool seek([uint ABSPOSITION]); /*Seek to new absolute position within file, if no argument seek to end of file. */ string path(); /*Returns file path used in "new File(PATH)" call.*/ bool lock(string LOCKTYPE); /*Lock using LOCKTYPE; see below.*/ bool unlock(); /*Release lock.*/ bool truncate([uint LEN]); /*Truncate opened file to new length; if no argument truncate to current file position. */ }; File open modes: ---------------- r = Open for reading w = Open for writing and set file position to beggining of file c = Create file by mode CREATEMODE if not existing t = Truncate file a = Open for write/append and set position to end of file, excludes truncate flag File lock modes: ---------------- s = Set shared lock x = Set exclusive lock n = Non-blocking, attempt to set lock but if locked by another process and would block, return error EWOULDBLOCK u = Unlock //example var fileobj = new File("/path/to/myfile.txt"); //set errno 0 Server.errno(0); //open for RW, truncate and if not existing create mode 0644 if ( fileobj.open("rwtc", 0644)==true ) { //set exclusive lock, blocking if ( fileobj.lock("x")==true ) { //locked fileobj.unlock(); } //set non-blocking exclusive lock if ( fileobj.lock("xn")==true ) { //locked fileobj.unlock(); } //set shared lock; process blocked untill capable of setting lock if ( fileobj.lock("s")==true ) { //locked fileobj.unlock(); } fileobj.close(); } //error else { //ie. [errno 13] Permission denied print(Server.errnstr(),"Thread by: ",HTMLENCODE(Thrd._suser),"
"); if ( Msglst!=null ) { var Msg; //One message //Print messages in a loop while ( (Msg=Msglst.next())!=null ) { //Print messages print("By: ",
HTMLENCODE(Msg._suser),
"
",
HTMLENCODE(Msg._smessage),
"
[error] ",Bdbc.error(),"
"); } print(""); //<--END SCRIPT -------------------------------------------------------------------------------- MYSQL CLASS -------------------------------------------------------------------------------- GromJS "Mysql" class provides JavaScript API for manipulating MySQL database. //class prototype: class Mysql { //methods bool connect(string HOSTNAM, string USER, string PSWRD [, uint PORT, string FIFOSOCK]); /*Connect to MySQL database server, returns true on success*/ bool close(); /*Close connection to Mysql database*/ bool query(string STMT); /*Execute SQL statement STMT and create result set; returns true on success */ bool exec(string STMT); /*Same as "query()"*/ bool ping(); /*Check if connection active, reconnect if required, returns true on success */ bool selectdb(string DBNAME); /*Select database*/ array colnames(); /*Returns array of column names in result set*/ uint colnum(); /*Number of columns in result set*/ uint colcount(); /*Same as "colnum()"*/ array rowfetch(); /*Return a single row from result, as JavaScript array of strings; null returned if no row is available */ array fetchrow(); /*Same as "rowfetch()"*/ array array rowsallfetch(); /*Return all rows from result as JavaScript two- dimensional array of strings */ array array fetchallrows(); /*Same as "rowsallfetch()"*/ uint insertid(); /*Returns id created by database last insert operation*/ uint affectedrows(); /*Number of rows affected by INSERT, DELETE etc. operations*/ string error(); /*MySQL db error string*/ uint errno(); /*MySQL db error number*/ string realescapestring(string DATA); /*Escapes special characters according to character set of the connection */ string escapestring(string DATA); /*Escape string*/ void freeresult(); /*Results are free'd automatically; if required freeresult() can be used */ }; //BEGIN CODE--> //Mysql class; //Create new database and table, insert values, and then select and print //values from table print(""); var Mdb = new Mysql(); //Mysql class //set errno 0 Server.errno(0); //Connect to MySQL server if ( Mdb.connect("domain.com","usernam345","pswrd345",3306,"/tmp/mysql.sock")==true ) { //create database, table, insert values... //Mdb.query("CREATE DATABASE testdb"); //Mdb.selectdb("testdb"); //Mdb.query("CREATE TABLE testtbl ..."); //Mdb.query("INSERT INTO testtbl ..."); //query values: if ( Mdb.selectdb("testdb")==true ) { //now query if ( Mdb.query("SELECT id FROM testtbl")==true ) { var onerow; //get row as JS Array object from result set while ( (onerow=Mdb.rowfetch())!=null ) { //print column: //1Ok, connected to PostgreSQL server
"); //SQL statement var sSqlstmt = "CREATE TABLE ttesttbl( " +" rowid integer PRIMARY KEY, " +" smpl2 varchar(255), " +" smpl3 varchar(255) " +" ); "; //execute SQL statement if ( Pgdb.exec(sSqlstmt)==true ) { print("Ok, created table
"); } else { print("Error exec
"); print("[",Pgdb.error(),"]
"); } //insert values to database //Pgdb.exec("INSERT INTO ttesttbl ... "); //Pgdb.exec("INSERT INTO ttesttbl ... "); //etc etc.. //execute SQL statement if ( Pgdb.query("SELECT rowid,smpl2,smpl3 FROM ttesttbl")==true ) { while ( (onerow=Pgdb.fetchrow())!=null ) { //123 -- xyz -- abcError query
"); print("[",Pgdb.error(),"]
"); } Pgdb.close(); } else { print("Error connect
"); print("[",Pgdb.error(),"]
"); } print(""); // <--END CODE -------------------------------------------------------------------------------- SQLITE CLASS -------------------------------------------------------------------------------- GromJS "Sqlite" class provides JavaScript API for manipulating Sqlite3 database. //constructor var databaseobj = new Sqlite(string DBPATH); var databaseobj = new Sqlite("/path/to/mydatabase.db"); //class prototype: class Sqlite { //methods bool open(); /*Open database, returns true on success.*/ bool close(); /*Close database.*/ bool exec(string STATEMENT); /*Execute a result-less SQL statement; returns true on success.*/ bool query(string SQLQUERY); /*Execute SQL query SQLQUERY and create result set; returns true on success */ string colname(uint INDX); /*For column at INDX return column name used in CREATE table statement */ array colnames(); /*Array of column names in result set*/ string coltype(uint INDX); /*For column at INDX return column data type used in CREATE statement ie. INTEGER, CHAR, FLOAT */ uint colcount(); /*Number of columns in result set*/ uint colnum(); /*Same as "colcount()"*/ uint rowcount(); /*Number of rows in result set*/ bool rowhas(); /*Returns true if there is row under cursor available*/ array rowfetch(); /*From result set get single row, returned as JavaScript array of strings; null returned if no row available */ array fetchrow(); /*Same as "rowfetch()"*/ array array rowsallfetch(); /*From result set get all rows, returned as JavaScript two-dimensional array of strings */ array array fetchallrows(); /*Same as "rowsallfetch()"*/ uint rowlastinsertid(); /*Returns id created by database last insert operation*/ uint lastinsertrowid(); /*Alias for rowlastinsertid*/ bool rewind(); /*Move to first row of result set*/ string error(); /*Returns Sqlite3 error string*/ void freeresult(); /*Results are free'd automatically; if required freeresult() can be used */ }; //Example: //BEGIN SCRIPT--> //demonstrate using Sqlite3 database and JavaScript interface print(""); var dbfilepath = "mydatabase.db"; var Sqdb = new Sqlite(dbfilepath); print("Opening database.| "); print(Sqdb.colname(ccol)); print(" ("); print(Sqdb.coltype(ccol)); print(") | "); } print("
| "); print(onerow[indx]); print(" | "); } print("
");
print(pipeobj.read()); //read and print output, if any
print("");
}
//error
else {
print("Failed writing to pipe [errno " , Server.errno() ,"]