-/*\r
-@version: 0.1\r
-@author: Sudheer K. <scifi1947 at gmail.com>\r
-@license: GNU General Public License\r
-*/\r
-\r
-function getDatabase() {\r
- logMessage("Opening MarketsToday database..");\r
- return openDatabaseSync("MarketsToday", "1.0", "StorageDatabase", 100);\r
-}\r
-\r
-function logMessage(strMessage){\r
- if (logUtility){\r
- logUtility.logMessage(strMessage);\r
- }\r
- else{\r
- console.log(strMessage);\r
- }\r
-}\r
-\r
-// Initialize tables\r
-function initialize() {\r
- var db = getDatabase();\r
- db.transaction(\r
- function(tx) {\r
- // Create the settings table if it doesn't already exist\r
- // If the table exists, this is skipped\r
- tx.executeSql('CREATE TABLE IF NOT EXISTS settings(setting TEXT UNIQUE, value TEXT)');\r
- tx.executeSql('CREATE TABLE IF NOT EXISTS tickers(symbol TEXT UNIQUE)');\r
- },\r
- function(error) {\r
- logMessage("Error ["+error.code +"] - " + error.DOMString+" occurred.");\r
- });\r
-}\r
-\r
-function getSetting(setting) {\r
- var db = getDatabase();\r
- var res="";\r
- db.transaction(\r
- function(tx) {\r
- var rs = tx.executeSql('SELECT value FROM settings WHERE setting=?;', [setting]);\r
- if (rs.rows.length > 0) {\r
- res = rs.rows.item(0).value;\r
- logMessage(setting+" is "+res);\r
- } else {\r
- res = "Unknown";\r
- }\r
- },\r
- function(error) {\r
- logMessage("Error ["+error.code +"] - " + error.DOMString+" occurred.");\r
- }\r
- );\r
- return res;\r
-}\r
-\r
-\r
-function setSetting(setting, value) {\r
- var db = getDatabase();\r
- var res = "";\r
- db.transaction(\r
- function(tx) {\r
- var rs = tx.executeSql('INSERT OR REPLACE INTO settings VALUES (?,?);', [setting,value]);\r
- if (rs.rowsAffected > 0) {\r
- res = "OK";\r
- logMessage("Updated "+setting+" to "+value);\r
- } else {\r
- res = "Error";\r
- }\r
- },\r
- function(error) {\r
- logMessage("Error ["+error.code +"] - " + error.DOMString+" occurred.");\r
- }\r
- );\r
- return res;\r
-}\r
-\r
-function addSymbol(symbol){\r
- logMessage('SQL> INSERT OR REPLACE INTO tickers VALUES ('+[symbol]+')');\r
- var db = getDatabase();\r
- var res = "";\r
- logMessage("Opened MarketsToday database..");\r
-\r
- db.transaction(function(tx) {\r
- var rs = tx.executeSql('INSERT OR REPLACE INTO tickers VALUES (?);', [symbol]);\r
- logMessage("Inserted/replaced "+rs.rowsAffected+" rows");\r
- if (rs.rowsAffected > 0) {\r
- res = "OK";\r
- } else {\r
- res = "Error";\r
- }\r
- },\r
- function(error) {\r
- logMessage("Error ["+error.code +"] - " + error.DOMString+" occurred.");\r
- }\r
- );\r
- return res;\r
-}\r
-\r
-function removeSymbol(symbol){\r
- logMessage('SQL> DELETE FROM tickers WHERE symbol = '+[symbol]);\r
- var db = getDatabase();\r
- var res = "";\r
- db.transaction(function(tx) {\r
- var rs = tx.executeSql('DELETE FROM tickers WHERE symbol = ?;', [symbol]);\r
- logMessage("Deleted "+rs.rowsAffected+" rows");\r
- if (rs.rowsAffected > 0) {\r
- res = "OK";\r
- } else {\r
- res = "Error";\r
- }\r
- },\r
- function(error) {\r
- logMessage("Error ["+error.code +"] - " + error.DOMString+" occurred.");\r
- }\r
- );\r
- return res;\r
-}\r
-\r
-function getAllSymbols(){\r
- var db = getDatabase();\r
- var symbolsArray = new Array();\r
- db.transaction(function(tx) {\r
- var rs = tx.executeSql('SELECT symbol FROM tickers');\r
- logMessage("Fetched "+rs.rows.length+" rows");\r
- var i = 0;\r
- for (i = 0; i < rs.rows.length; i++){\r
- symbolsArray[i] = rs.rows.item(i).symbol;\r
- }\r
- },\r
- function(error) {\r
- logMessage("Error ["+error.code +"] - " + error.DOMString+" occurred.");\r
- }\r
- );\r
- return symbolsArray;\r
-}\r
+/*
+@version: 0.2
+@author: Sudheer K. <scifi1947 at gmail.com>
+@license: GNU General Public License
+*/
+
+function getDatabase() {
+ logMessage("Opening MarketsToday database..");
+ return openDatabaseSync("MarketsToday", "1.0", "StorageDatabase", 100);
+}
+
+function logMessage(strMessage){
+ if (logUtility){
+ logUtility.logMessage(strMessage);
+ }
+ else{
+ console.log(strMessage);
+ }
+}
+
+// Initialize tables
+function initialize() {
+ var db = getDatabase();
+ db.transaction(
+ function(tx) {
+ // Create the settings table if it doesn't already exist
+ // If the table exists, this is skipped
+ tx.executeSql('CREATE TABLE IF NOT EXISTS settings(setting TEXT UNIQUE, value TEXT)');
+ tx.executeSql('CREATE TABLE IF NOT EXISTS tickers(symbol TEXT UNIQUE)');
+ },
+ function(error) {
+ logMessage("Error ["+error.code +"] - " + error.DOMString+" occurred.");
+ });
+}
+
+function getSetting(setting) {
+ var db = getDatabase();
+ var res="";
+ db.transaction(
+ function(tx) {
+ var rs = tx.executeSql('SELECT value FROM settings WHERE setting=?;', [setting]);
+ if (rs.rows.length > 0) {
+ res = rs.rows.item(0).value;
+ logMessage(setting+" is "+res);
+ } else {
+ res = "Unknown";
+ }
+ },
+ function(error) {
+ logMessage("Error ["+error.code +"] - " + error.DOMString+" occurred.");
+ }
+ );
+ return res;
+}
+
+
+function setSetting(setting, value) {
+ var db = getDatabase();
+ var res = "";
+ db.transaction(
+ function(tx) {
+ var rs = tx.executeSql('INSERT OR REPLACE INTO settings VALUES (?,?);', [setting,value]);
+ if (rs.rowsAffected > 0) {
+ res = "OK";
+ logMessage("Updated "+setting+" to "+value);
+ } else {
+ res = "Error";
+ }
+ },
+ function(error) {
+ logMessage("Error ["+error.code +"] - " + error.DOMString+" occurred.");
+ }
+ );
+ return res;
+}
+
+function addSymbol(symbol){
+ logMessage('SQL> INSERT OR REPLACE INTO tickers VALUES ('+[symbol]+')');
+ var db = getDatabase();
+ var res = "";
+ logMessage("Opened MarketsToday database..");
+
+ db.transaction(function(tx) {
+ var rs = tx.executeSql('INSERT OR REPLACE INTO tickers VALUES (?);', [symbol]);
+ logMessage("Inserted/replaced "+rs.rowsAffected+" rows");
+ if (rs.rowsAffected > 0) {
+ res = "OK";
+ } else {
+ res = "Error";
+ }
+ },
+ function(error) {
+ logMessage("Error ["+error.code +"] - " + error.DOMString+" occurred.");
+ }
+ );
+ return res;
+}
+
+function removeSymbol(symbol){
+ logMessage('SQL> DELETE FROM tickers WHERE symbol = '+[symbol]);
+ var db = getDatabase();
+ var res = "";
+ db.transaction(function(tx) {
+ var rs = tx.executeSql('DELETE FROM tickers WHERE symbol = ?;', [symbol]);
+ logMessage("Deleted "+rs.rowsAffected+" rows");
+ if (rs.rowsAffected > 0) {
+ res = "OK";
+ } else {
+ res = "Error";
+ }
+ },
+ function(error) {
+ logMessage("Error ["+error.code +"] - " + error.DOMString+" occurred.");
+ }
+ );
+ return res;
+}
+
+function getAllSymbols(){
+ var db = getDatabase();
+ var symbolsArray = new Array();
+ db.transaction(function(tx) {
+ var rs = tx.executeSql('SELECT symbol FROM tickers');
+ logMessage("Fetched "+rs.rows.length+" rows");
+ var i = 0;
+ for (i = 0; i < rs.rows.length; i++){
+ symbolsArray[i] = rs.rows.item(i).symbol;
+ }
+ },
+ function(error) {
+ logMessage("Error ["+error.code +"] - " + error.DOMString+" occurred.");
+ }
+ );
+ return symbolsArray;
+}