Database<\/span> =<\/span> Class<\/span>.<\/span>create<\/span>({<\/span><\/div> initialize<\/span>:<\/span> function<\/span>(<\/span>tableName<\/span>)<\/span> {<\/span><\/div> this<\/span>.<\/span>tableName<\/span> =<\/span> tableName<\/span>;<\/span><\/div> this<\/span>.<\/span>db<\/span> =<\/span> openDatabase<\/span>(<\/span>"Database Name"<\/span>,<\/span> "1.0"<\/span>,<\/span> "Display Name"<\/span>,<\/span> 10000<\/span>);<\/span><\/div> },<\/span><\/div> <\/div>
handleFirstTimers<\/span>:<\/span> function<\/span>(<\/span>firstTimeCallback<\/span>,<\/span> everyOtherTimeCallback<\/span>)<\/span> {<\/span><\/div> this<\/span>.<\/span>db<\/span>.<\/span>transaction<\/span>(<\/span>function<\/span>(<\/span>tx<\/span>)<\/span> {<\/span><\/div> tx<\/span>.<\/span>executeSql<\/span>(<\/span>"CREATE TABLE IF NOT EXISTS "<\/span> +<\/span> this<\/span>.<\/span>tableName<\/span> +<\/span> " (flag REAL)"<\/span>,[],<\/span> function<\/span>(<\/span>tx<\/span>,<\/span> result<\/span>)<\/span> {<\/span><\/div> tx<\/span>.<\/span>executeSql<\/span>(<\/span>"SELECT flag FROM "<\/span> +<\/span> this<\/span>.<\/span>tableName<\/span>,<\/span> [],<\/span> function<\/span>(<\/span>tx<\/span>,<\/span> result<\/span>)<\/span> {<\/span><\/div> if<\/span> (<\/span>result<\/span>.<\/span>rows<\/span>.<\/span>length<\/span> ==<\/span> 0<\/span>)<\/span> {<\/span><\/div> tx<\/span>.<\/span>executeSql<\/span>(<\/span>"INSERT INTO "<\/span> +<\/span> this<\/span>.<\/span>tableName<\/span> +<\/span> " (flag) VALUES (1)"<\/span>,<\/span> [],<\/span> function<\/span>(<\/span>tx<\/span>,<\/span> result<\/span>)<\/span> {<\/span><\/div> <\/div>
firstTimeCallback<\/span>();<\/span><\/div> <\/div>
},<\/span> function<\/span>(<\/span>tx<\/span>,<\/span> error<\/span>)<\/span> {<\/span><\/div> Mojo<\/span>.<\/span>Log<\/span>.<\/span>error<\/span>(<\/span>"There was an error inserting into "<\/span> +<\/span> this<\/span>.<\/span>tableName<\/span> +<\/span> ": "<\/span> +<\/span> error<\/span>.<\/span>message<\/span>);<\/span><\/div> });<\/span><\/div> }<\/span> else<\/span> {<\/span><\/div> <\/div>
everyOtherTimeCallback<\/span>();<\/span><\/div> <\/div>
}<\/span><\/div> },<\/span> function<\/span>(<\/span>tx<\/span>,<\/span> error<\/span>)<\/span> {<\/span><\/div> Mojo<\/span>.<\/span>Log<\/span>.<\/span>error<\/span>(<\/span>"There was a problem selecting the column from "<\/span> +<\/span> this<\/span>.<\/span>tableName<\/span> +<\/span> " table: "<\/span> +<\/span> error<\/span>.<\/span>message<\/span>);<\/span><\/div> <\/div>
});<\/span><\/div> },<\/span> function<\/span>(<\/span>tx<\/span>,<\/span> error<\/span>)<\/span> {<\/span><\/div> Mojo<\/span>.<\/span>Log<\/span>.<\/span>error<\/span>(<\/span>"There was a problem creating the "<\/span> +<\/span> this<\/span>.<\/span>tableName<\/span> +<\/span> " table: "<\/span> +<\/span> error<\/span>.<\/span>message<\/span>);<\/span><\/div> });<\/span><\/div> });<\/span><\/div> }<\/span><\/div>});<\/span><\/div> <\/div><\/pre><\/div>\n \n <\/div>\n\n
\n