///////////////////////////////////////////////////////////////////////////
//
// 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';
|
Download
