X-Git-Url: http://git.maemo.org/git/?a=blobdiff_plain;f=src%2Fvicar-config-qml%2Fqml%2Fvicarconfigqml%2FLibrary%2Fjs%2FDBUtility.js;h=654f48b386a31b4306c6d2a262654aff9877dea8;hb=HEAD;hp=058358393dbdc8dd2a46f8201595bdda27399925;hpb=74800375ecf7f41e290cf7cc7fa9ee8b230be68e;p=vicar

diff --git a/src/vicar-config-qml/qml/vicarconfigqml/Library/js/DBUtility.js b/src/vicar-config-qml/qml/vicarconfigqml/Library/js/DBUtility.js
index 0583583..654f48b 100644
--- a/src/vicar-config-qml/qml/vicarconfigqml/Library/js/DBUtility.js
+++ b/src/vicar-config-qml/qml/vicarconfigqml/Library/js/DBUtility.js
@@ -1,5 +1,5 @@
 /*
-@version: 0.2
+@version: 0.7
 @author: Sudheer K. <scifi1947 at gmail.com>
 @license: GNU General Public License
 */
@@ -26,7 +26,7 @@ function initialize() {
             // 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 PRIMARY KEY, value TEXT)');
-            tx.executeSql('CREATE TABLE IF NOT EXISTS rules(id INTEGER PRIMARY KEY, numberpattern TEXT, gatewaynumber TEXT, dtmfformat TEXT, dtmfprefix TEXT, dtmfsuffix TEXT)');
+            tx.executeSql('CREATE TABLE IF NOT EXISTS profiles(id INTEGER PRIMARY KEY, numberpattern TEXT, gatewaynumber TEXT, dtmfformat TEXT, dtmfprefix TEXT, dtmfsuffix TEXT)');
           },
         function(error) {
             logMessage("Error ["+error.code +"] - " + error.DOMString+" occurred.");
@@ -75,13 +75,13 @@ function setSetting(setting, value) {
 }
 
 function addRule(ruleObj){
-    logMessage('SQL> INSERT INTO rules(id, numberpattern, gatewaynumber, dtmfformat, dtmfprefix, dtmfsuffix) VALUES (NULL, '+[ruleObj.numberpattern, ruleObj.gatewaynumber, ruleObj.dtmfformat, ruleObj.dtmfprefix, ruleObj.dtmfsuffix]+')');
+    logMessage('SQL> INSERT INTO profiles(id, numberpattern, gatewaynumber, dtmfformat, dtmfprefix, dtmfsuffix) VALUES (NULL, '+[ruleObj.numberpattern, ruleObj.gatewaynumber, ruleObj.dtmfformat, ruleObj.dtmfprefix, ruleObj.dtmfsuffix]+')');
     var db = getDatabase();
     var res = "";
     logMessage("Opened VICaR database..");
 
     db.transaction(function(tx) {
-               var rs = tx.executeSql('INSERT INTO rules(id, numberpattern, gatewaynumber, dtmfformat, dtmfprefix, dtmfsuffix) VALUES (NULL, ?, ?, ?, ?, ?);', [ruleObj.numberpattern, ruleObj.gatewaynumber, ruleObj.dtmfformat, ruleObj.dtmfprefix, ruleObj.dtmfsuffix]);
+               var rs = tx.executeSql('INSERT INTO profiles(id, numberpattern, gatewaynumber, dtmfformat, dtmfprefix, dtmfsuffix) VALUES (NULL, ?, ?, ?, ?, ?);', [ruleObj.numberpattern, ruleObj.gatewaynumber, ruleObj.dtmfformat, ruleObj.dtmfprefix, ruleObj.dtmfsuffix]);
                logMessage("Inserted "+rs.rowsAffected+" rows");
                if (rs.rowsAffected > 0) {
                  res = "OK";
@@ -97,7 +97,7 @@ function addRule(ruleObj){
 }
 
 function updateRule(id,ruleObj){
-    logMessage('SQL> UPDATE rules set numberpattern = '+[ruleObj.numberpattern]+
+    logMessage('SQL> UPDATE profiles set numberpattern = '+[ruleObj.numberpattern]+
                ', gatewaynumber = '+[ruleObj.gatewaynumber]+
                ', dtmfformat = '+[ruleObj.dtmfformat]+
                ', dtmfprefix = '+[ruleObj.dtmfprefix]+
@@ -106,7 +106,7 @@ function updateRule(id,ruleObj){
     var db = getDatabase();
     var res = "";
     db.transaction(function(tx) {
-           var rs = tx.executeSql('UPDATE rules set numberpattern = ?, gatewaynumber = ?, dtmfformat = ?, dtmfprefix = ?, dtmfsuffix = ? WHERE id = ?;',
+           var rs = tx.executeSql('UPDATE profiles set numberpattern = ?, gatewaynumber = ?, dtmfformat = ?, dtmfprefix = ?, dtmfsuffix = ? WHERE id = ?;',
                             [ruleObj.numberpattern, ruleObj.gatewaynumber, ruleObj.dtmfformat, ruleObj.dtmfprefix, ruleObj.dtmfsuffix, id]);
            logMessage("Updated "+rs.rowsAffected+" rows");
            if (rs.rowsAffected > 0) {
@@ -123,11 +123,11 @@ function updateRule(id,ruleObj){
 }
 
 function removeRule(id){
-    logMessage('SQL> DELETE FROM rules WHERE id = '+[id]);
+    logMessage('SQL> DELETE FROM profiles WHERE id = '+[id]);
     var db = getDatabase();
     var res = "";
     db.transaction(function(tx) {
-         var rs = tx.executeSql('DELETE FROM rules WHERE id = ?;', [id]);
+         var rs = tx.executeSql('DELETE FROM profiles WHERE id = ?;', [id]);
                logMessage("Deleted "+rs.rowsAffected+" rows");
                if (rs.rowsAffected > 0) {
                  res = "OK";
@@ -147,7 +147,7 @@ function getAllRules(){
     var rulesArray = new Array();
     var ruleObj;
     db.transaction(function(tx) {
-           var rs = tx.executeSql('SELECT * FROM rules');
+           var rs = tx.executeSql('SELECT * FROM profiles');
            logMessage("Fetched "+rs.rows.length+" rows");
            var i = 0;
            for (i = 0; i < rs.rows.length; i++){
@@ -179,8 +179,8 @@ function getRuleByID(id){
     var db = getDatabase();
     var ruleObj;
     db.transaction(function(tx) {
-           logMessage('SQL> SELECT * FROM rules WHERE id = '+[id]);
-           var rs = tx.executeSql('SELECT * FROM rules WHERE id = '+[id]);
+           logMessage('SQL> SELECT * FROM profiles WHERE id = '+[id]);
+           var rs = tx.executeSql('SELECT * FROM profiles WHERE id = '+[id]);
            logMessage("Fetched "+rs.rows.length+" rows");
            if (rs.rows.length > 0){
                ruleObj = new Object();