Icontem

File: demo/table1.js

Recommend this page to a friend!
  Classes of Alexey Znaev  >  XBSDB  >  demo/table1.js  >  Download  
File: demo/table1.js
Role: Example script
Content type: text/plain
Description: Demo table one - just numbers & strings
Class: XBSDB
Manipulate arrays with an SQL-like language
Author: By
Last change: changed access
Date: 8 years ago
Size: 2,030 bytes
 

Contents

Class file image Download
///////////////////////////////////////////////////////////////////////////
//
//    XBSDB - Cross-Browser JavaScript Database library
//    Copyright (C) 2010 Alexey A.Znayev
//
//    This file is part of XBSDB demo.
//
//    Alexey A.Znayev, znaeff@mail.ru
//
///////////////////////////////////////////////////////////////////////////

// All tables related data are in global variables for better viewing

//name
var sTable1Name = 'table1';

//JSON dump
var sTable1Dump = '{\
"aStructure":[\
["n1","number"],\
["s1","string"],\
["s2","string"]\
],\
"aData":[\
[1,"001","s001"],\
[2,"001","s001"],\
[3,"002","s002"],\
[4,"003","s003"],\
[5,"004","s004"],\
[6,"005","s005"],\
[7,"006","s006"],\
[8,"007","s007"],\
[9,"007","s007"],\
[10,"007","s007"],\
[11,"008","s008"],\
[12,"009","s009"],\
[13,"011","s011"],\
[14,"021","s021"],\
[15,"031","s031"],\
[16,"041","s041"],\
[17,"051","s051"],\
[18,"061","s061"],\
[19,"071","s071"],\
[20,"081","s081"],\
[21,"091","s091"],\
[22,"101","s101"],\
[23,"101","s10"],\
[24,"101","s101"],\
[25,"101","s10"],\
[26,"101","s201"],\
[27,"101","s301"],\
[28,"101","s401"],\
[29,"101","s501"],\
[30,"101","s601"],\
[31,"701","s701"],\
[32,"801","s801"],\
[33,"901","s901-1"],\
[34,"901","s901-2"],\
[35,"901","s901-3"],\
[36,"901","s901-4"],\
[37,"901","s901-5"],\
[38,"901","s901-6"]\
],\
"aKeys":[\
{"sExpression":"n1"},\
{"sExpression":"s1"},\
{"sExpression":"s2"},\
{"sExpression":"n1+s1"},\
{"sExpression":"s1+s2"},\
{"sExpression":"s1+\'123\'"}\
]\
}';

//table description
var sTable1Description = 'Just small example of numbers and strings';

//field descriptions
var aTable1StructureDescription = [
 'Numeric field',
 'String field',
 'String field too'
];

//values of demo page fields
var sTable1QueryFieldsValue = '    n1   s1 s2 ';
var sTable1QueryWhereValue  = "(s1='101' or s1='201') and s2='s101'";
var sTable1QueryOrderByValue = "  '' + s1 + s2  ";
var sTable1QueryLimitValue = '   10';