Class Index

Classes


v1.2.1

Built-In Namespace _global_

Field Summary
Field Attributes Field Name and Description
This is the primary entry point for gaining access to the SequelSphere database.
Method Summary
Method Attributes Method Name and Description
onsuccess (e)
Field Detail
{ DB } db
This is the primary entry point for gaining access to the SequelSphere database. You can use this object to retrieve the database catalog and create tables:
	    db.catalog.createTable({
	    	tableName: "EMPL",
	    	columns: [ "EMPL_ID", "NAME", "AGE", "DEPT_ID" ],
	    	primaryKey: [ "EMPL_ID" ],
	    	data: [
	    		[0,"Bob",32,0],
	    		[1,"John",37,2],
	    		[2,"Fred",28,1],
	    		[3,"Sue",26,3],
	    		[4,"Beth",22,99],
	    		[5,"Mary",27,3],
	    		[6,"Adrian",24,1]
	    	]
	    });
	

Or you can use the db object to perform queries:

	    var res = db.query(sql);
	    for (var row = 0; row < res.data.length; ++row) {
	        for (var col = 0; col < res.columnNames.length; ++col) {
	            var cellVal = res.data[row][col];
	            // use data here
	        }
	    }
	

See DB and DBCatalog for a full list of the functions available for manipulating and querying data in the database.

See:
DB#query
DBCatalog#createTable
Method Detail
onsuccess (e)
Parameters:
e

©2012 Sequel Sphere, LLC.