Changes between Version 10 and Version 11 of DeveloperGuidelines/EdenMobile/Database


Ignore:
Timestamp:
02/24/17 12:24:42 (5 years ago)
Author:
Dominic König
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • DeveloperGuidelines/EdenMobile/Database

    v10 v11  
    8484== emSQL ==
    8585
    86 '''$emdb''' uses the {{{emSQL}}} helper module to construct common SQL statements. It can be found in www/js/modules/sql.js.
    87 
    88 Examples:
    89 {{{
    90 #!js
    91 
    92 // Schema definition
    93 var schema = {
    94     id: {
    95         type: 'id'
    96     },
    97     name: {
    98         type: 'string',
    99         label: 'Name',
    100         notnull: true
    101     },
    102     number: {
    103         type: 'integer',
    104     },
    105 };
    106 
    107 // Create an emSQL helper for this schema
    108 var table = emSQL.Table('testtable', schema);
    109 
    110 // Produce SQL to create the table
    111 // sql == 'CREATE IF NOT EXISTS "testtable" (id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT NOT NULL,number INTEGER)'
    112 var sql = table.create();
    113 
    114 // Produce SQL to insert data
    115 // => produces a tuple: an SQL string with placeholders and an array with values (for use with db.executeSql)
    116 // sql == ['INSERT INTO "testtable" (name,number) VALUES (?,?)', ['testing',4]]
    117 sql = table.insert({name: 'testing', number: 4});
    118 
    119 // Produce SQL to select data
    120 // sql == 'SELECT testtable.id,testtable.name FROM "testtable" WHERE number>2'
    121 sql = table.select(['id', 'name'], 'number>2');
    122 
    123 // Produce SQL to drop the table
    124 // sql == 'DROP TABLE IF EXISTS "testtable"'
    125 sql = table.drop();
    126 
    127 }}}
     86'''$emDB''' uses the {{{emSQL}}} service to construct common SQL statements. It can be found in www/services/sql.js.