document.write('<link rel="stylesheet" href="http://gist.github.com/stylesheets/gist/embed.css"/>')





document.write('<div id=\"gist-204125\" class=\"gist\">\n  \n  \n    \n            \n\n      <div class=\"gist-file\">\n        <div class=\"gist-data gist-syntax\">\n          \n          \n          \n            <div class=\"gist-highlight\"><pre><div class=\"line\" id=\"LC1\">&nbsp;&nbsp;<span class=\"k\">this<\/span><span class=\"p\">.<\/span><span class=\"nx\">db<\/span><span class=\"p\">.<\/span><span class=\"nx\">transaction<\/span><span class=\"p\">(<\/span><span class=\"kd\">function<\/span><span class=\"p\">(<\/span><span class=\"nx\">tx<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span><\/div><div class=\"line\" id=\"LC2\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"nx\">tx<\/span><span class=\"p\">.<\/span><span class=\"nx\">executeSql<\/span><span class=\"p\">(<\/span><span class=\"s2\">&quot;CREATE TABLE IF NOT EXISTS &quot;<\/span> <span class=\"o\">+<\/span> <span class=\"k\">this<\/span><span class=\"p\">.<\/span><span class=\"nx\">tableName<\/span> <span class=\"o\">+<\/span> <span class=\"s2\">&quot; (flag REAL)&quot;<\/span><span class=\"p\">,[],<\/span> <span class=\"kd\">function<\/span><span class=\"p\">(<\/span><span class=\"nx\">tx<\/span><span class=\"p\">,<\/span> <span class=\"nx\">result<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span><\/div><div class=\"line\" id=\"LC3\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"nx\">tx<\/span><span class=\"p\">.<\/span><span class=\"nx\">executeSql<\/span><span class=\"p\">(<\/span><span class=\"s2\">&quot;SELECT flag FROM &quot;<\/span> <span class=\"o\">+<\/span> <span class=\"k\">this<\/span><span class=\"p\">.<\/span><span class=\"nx\">tableName<\/span><span class=\"p\">,<\/span> <span class=\"p\">[],<\/span> <span class=\"kd\">function<\/span><span class=\"p\">(<\/span><span class=\"nx\">tx<\/span><span class=\"p\">,<\/span> <span class=\"nx\">result<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span><\/div><div class=\"line\" id=\"LC4\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"k\">if<\/span> <span class=\"p\">(<\/span><span class=\"nx\">result<\/span><span class=\"p\">.<\/span><span class=\"nx\">rows<\/span><span class=\"p\">.<\/span><span class=\"nx\">length<\/span> <span class=\"o\">==<\/span> <span class=\"mi\">0<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span><\/div><div class=\"line\" id=\"LC5\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"nx\">tx<\/span><span class=\"p\">.<\/span><span class=\"nx\">executeSql<\/span><span class=\"p\">(<\/span><span class=\"s2\">&quot;INSERT INTO &quot;<\/span> <span class=\"o\">+<\/span> <span class=\"k\">this<\/span><span class=\"p\">.<\/span><span class=\"nx\">tableName<\/span> <span class=\"o\">+<\/span> <span class=\"s2\">&quot; (flag) VALUES (1)&quot;<\/span><span class=\"p\">,<\/span> <span class=\"p\">[],<\/span> <span class=\"kd\">function<\/span><span class=\"p\">(<\/span><span class=\"nx\">tx<\/span><span class=\"p\">,<\/span> <span class=\"nx\">result<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span><\/div><div class=\"line\" id=\"LC6\">&nbsp;<\/div><div class=\"line\" id=\"LC7\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"nx\">firstTimeCallback<\/span><span class=\"p\">();<\/span><\/div><div class=\"line\" id=\"LC8\">&nbsp;<\/div><div class=\"line\" id=\"LC9\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"p\">},<\/span> <span class=\"kd\">function<\/span><span class=\"p\">(<\/span><span class=\"nx\">tx<\/span><span class=\"p\">,<\/span> <span class=\"nx\">error<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span><\/div><div class=\"line\" id=\"LC10\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"nx\">Mojo<\/span><span class=\"p\">.<\/span><span class=\"nx\">Log<\/span><span class=\"p\">.<\/span><span class=\"nx\">error<\/span><span class=\"p\">(<\/span><span class=\"s2\">&quot;There was an error inserting into &quot;<\/span> <span class=\"o\">+<\/span> <span class=\"k\">this<\/span><span class=\"p\">.<\/span><span class=\"nx\">tableName<\/span> <span class=\"o\">+<\/span> <span class=\"s2\">&quot;: &quot;<\/span> <span class=\"o\">+<\/span> <span class=\"nx\">error<\/span><span class=\"p\">.<\/span><span class=\"nx\">message<\/span><span class=\"p\">);<\/span><\/div><div class=\"line\" id=\"LC11\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"p\">});<\/span><\/div><div class=\"line\" id=\"LC12\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"p\">}<\/span> <span class=\"k\">else<\/span> <span class=\"p\">{<\/span><\/div><div class=\"line\" id=\"LC13\">&nbsp;<\/div><div class=\"line\" id=\"LC14\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"nx\">everyOtherTimeCallback<\/span><span class=\"p\">();<\/span><\/div><div class=\"line\" id=\"LC15\">&nbsp;<\/div><div class=\"line\" id=\"LC16\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"p\">}<\/span><\/div><\/pre><\/div>\n          \n        <\/div>\n\n        <div class=\"gist-meta\">\n          <a href=\"http://gist.github.com/raw/204125/9bbb6dac21302560e87ece5ffc02c3f62f670663/gistfile1.js\" style=\"float:right;\">view raw<\/a>\n          <a href=\"http://gist.github.com/204125#file_gistfile1.js\" style=\"float:right;margin-right:10px;color:#666\">gistfile1.js<\/a>\n          <a href=\"http://gist.github.com/204125\">This Gist<\/a> brought to you by <a href=\"http://github.com\">GitHub<\/a>.\n        <\/div>\n      <\/div>\n    \n  \n<\/div>\n')
