Merge lp:~qqworini/ubuntu-rssreader-app/database_v1 into lp:~ubuntu-shorts-dev/ubuntu-rssreader-app/trunk

[Joey Chan]

first complete version of database, feel free to find bugs or help us to improve it :)

some functions seems not perfect enough, we should discuss them some time.

first complete version of database, feel free to find bugs or help us to improve it :)

some functions seems not perfect enough, we should discuss them some time.

[Ubuntu Phone Apps Jenkins Bot (ubuntu-phone-apps-jenkins-bot)]

PASSED: Continuous integration, rev:11
http://91.189.93.125:8080/job/ubuntu-rssreader-app-ci/2/
Executed test runs:
    SUCCESS: http://91.189.93.125:8080/job/ubuntu-rssreader-app-raring-amd64-ci/2

Click here to trigger a rebuild:
http://91.189.93.125:8080/job/ubuntu-rssreader-app-ci/2/rebuild

review: Approve (continuous-integration)

[Roman Shchekin (mrqtros)]

Very good work, Joey! I have very hot time - making my graduate project, so I will active participate in development after final or stable design guides! ;)

23.05.13 15:19 Ubuntu Phone Apps Jenkins Bot написал(а):

Review: Approve continuous-integration

PASSED: Continuous integration, rev:11

http://91.189.93.125:8080/job/ubuntu-rssreader-app-ci/2/

Executed test runs:
SUCCESS: http://91.189.93.125:8080/job/ubuntu-rssreader-app-ci/2/

Click here to trigger a rebuild:

http://91.189.93.125:8080/job/ubuntu-rssreader-app-ci/2/

--
http://91.189.93.125:8080/job/ubuntu-rssreader-app-ci/2/

Your team Ubuntu RSS Feed Reader Developers is requested to review the proposed merge of lp:~qqworini/ubuntu-rssreader-app/database_v1 into lp:ubuntu-rssreader-app.

[Roman Shchekin (mrqtros)]

Seems good ;)

review: Approve

[Roman Shchekin (mrqtros)]

I think that we shouldn't use separate table for settings because of QSettings.
Maybe Guys from Toolkit team will provide its functionality in QML?

And only for Joey - I agree with your advice (using object instead of variable args), but why you are not used this technique in function
function addArticle(title, link, description, pubdate, guid, feed_id)
with huge amout of args? :)
Mb better will be
function addArticle(title, articleObj)

[Joey Chan (qqworini)]

> I think that we shouldn't use separate table for settings because of
> QSettings.
> Maybe Guys from Toolkit team will provide its functionality in QML?
>
> And only for Joey - I agree with your advice (using object instead of variable
> args), but why you are not used this technique in function
> function addArticle(title, link, description, pubdate, guid, feed_id)
> with huge amout of args? :)
> Mb better will be
> function addArticle(title, articleObj)

1. of course qsetting is better, setting table will be replaced if qsetting port to qml;
2. using object instead of variable args, this is a solution for function overload or unknown args' length, in function "addArticle", all args are fixed, no need to use obj;
besides, you can find many "update" functions for every table, like feed and article, I've tried to use obj to make those functions overload, but later I found this is not optimised, because some functions like "updateArticleStatus", it's much high frequency use than other functions. So finally I decided to separate them instead of "overload" them

[lp:~qqworini/ubuntu-rssreader-app/database_v1]

12. By Joey Chan on 2013-05-28

bugs fixed for database module

[Ubuntu Phone Apps Jenkins Bot (ubuntu-phone-apps-jenkins-bot)]

PASSED: Continuous integration, rev:12
http://91.189.93.125:8080/job/ubuntu-rssreader-app-ci/3/
Executed test runs:
    SUCCESS: http://91.189.93.125:8080/job/ubuntu-rssreader-app-raring-amd64-ci/3

Click here to trigger a rebuild:
http://91.189.93.125:8080/job/ubuntu-rssreader-app-ci/3/rebuild

review: Approve (continuous-integration)

=== modified file '.bzrignore'
--- .bzrignore	2013-04-04 11:05:43 +0000
+++ .bzrignore	2013-05-28 03:32:25 +0000
@@ -4,3 +4,4 @@
 debian/app-template/
 debian/*.debhelper.log
 debian/*.substvars
+RE:\.?[^.]+
 
=== modified file 'databasemodule_v2.js'
--- databasemodule_v2.js	2013-05-14 17:57:48 +0000
+++ databasemodule_v2.js	2013-05-28 03:32:25 +0000
@@ -5,7 +5,15 @@
 var gDbCache = undefined
 function openStdDataBase() {
     if (gDbCache === undefined)
-        gDbCache = SQL.LocalStorage.openDatabaseSync("RSS Reader", "1.0", "App main DB", 10000) // Look, I changed DB name.
+    {
+        gDbCache = SQL.LocalStorage.openDatabaseSync("RSS Reader", "1.0", "App main DB", 1000000) // Look, I changed DB name.
+    }
+
+    // check table exist after open the database
+    gDbCache.transaction(function(tx){
+        checkTableExists(tx/*, opts*/);
+    }
+    )
     return gDbCache
 }
 
@@ -14,27 +22,722 @@
  * NOTE 1 - it's JS function with variable number of arguments.
  * NOTE 2 - mb "checkTableExisting" is better name.
  */
+
+/*
+The best way to do function overloading with parameters is not to check the argument length or the types;
+checking the types will just make your code slow and you have the fun of Arrays, nulls, Objects, etc.
+What most developers do is tack on an object as the last argument to their methods.
+This object can hold anything.
+
+function foo(a, b, opts) {
+
+}
+
+
+foo(1, 2, {"method":"add"});
+foo(3, 4, {"test":"equals", "bar":"tree"});
+
+
+copied from stackoverflow: http://stackoverflow.com/questions/456177/function-overloading-in-javascript-best-practices
+
+I suggest change "function checkTableExists" to: function checkTableExists(transaction, opts ),
+no need to check argument length or the types
+
+or just make it simple, like below
+*/
 function checkTableExists(transaction /* and additional string keys */) {
-    for (var i = 1; i < arguments.length; i++) { // First argument is transaction so i = 1.
-        var arg = arguments[i]
-        switch (arg) {
-            case "feeds":
-                transaction.executeSql('CREATE TABLE IF NOT EXISTS ...')
-                break
-            case "articles":
-                transaction.executeSql('CREATE TABLE IF NOT EXISTS ...')
-                break
-                // ...
-            case "all": // Check all tables existing.
-                transaction.executeSql('CREATE TABLE IF NOT EXISTS ...')
-                transaction.executeSql('CREATE TABLE IF NOT EXISTS ...')
-                transaction.executeSql('CREATE TABLE IF NOT EXISTS ...')
-                break
-            default:
-                // mb some staff.
-                break;
-        }
+//    for (var i = 1; i < arguments.length; i++) { // First argument is transaction so i = 1.
+//        var arg = arguments[i]
+//        switch (arg) {
+//            case "feeds":
+//                transaction.executeSql('CREATE TABLE IF NOT EXISTS ...')
+//                break
+//            case "articles":
+//                transaction.executeSql('CREATE TABLE IF NOT EXISTS ...')
+//                break
+//                // ...
+//            case "all": // Check all tables existing.
+    transaction.executeSql('PRAGMA foreign_keys = ON;')   // enable foreign key support
+    transaction.executeSql("CREATE TABLE IF NOT EXISTS feed  (id  INTEGER  NOT NULL PRIMARY KEY AUTOINCREMENT,source  VARCHAR(99)  NULL,title  VARCHAR(99)  NULL,link  VARCHAR(99)  NULL,description  TEXT  NULL,pubdate  INTEGER  NULL,image  VARCHAR(99)  NULL);")
+    transaction.executeSql("CREATE TABLE IF NOT EXISTS tag  (id  INTEGER  NOT NULL PRIMARY KEY AUTOINCREMENT,name  VARCHAR(99)  NOT NULL UNIQUE );")
+    transaction.executeSql("CREATE TABLE IF NOT EXISTS feed_tag  (id  INTEGER  NOT NULL PRIMARY KEY AUTOINCREMENT,feed_id  INTEGER  NULL,tag_id  INTEGER  NULL,FOREIGN KEY(feed_id) REFERENCES feed(id) on delete cascade);")
+    transaction.executeSql("CREATE TABLE IF NOT EXISTS article ( id  INTEGER  PRIMARY KEY AUTOINCREMENT NOT NULL, title  VARCHAR(99)  NULL, link  VARCHAR(99)  NULL, description  TEXT  NULL, pubdate  INTEGER  NULL, status  char(1)  NULL DEFAULT '0', favourite  char(1)  NULL DEFAULT '0', image  VARCHAR(99)  NULL, guid VARCHAR(99) NULL, feed_id  INTEGER  NULL,count INTEGER NULL DEFAULT 0);")
+    transaction.executeSql("CREATE TABLE IF NOT EXISTS settings  ( id INTEGER, current_database_version VARCHAR(99) NULL, database_last_updated  VARCHAR(99)  NULL, view_mode char(1) NULL DEFAULT '0', update_interval INTEGER NULL DEFAULT 0, network_mode char(1) NULL DEFAULT '0');")
+    var rs = transaction.executeSql("select * from settings")
+    if (rs.rows.length == 0)
+    {
+        transaction.executeSql('INSERT INTO settings VALUES(?, ?, ?, ?, ?, ?)',
+                               [1 , 1.0, "000000", '0', 0, '0'])
     }
+//                break
+//            default:
+//                // mb some staff.
+//                break;
+//        }
+//    }
 }
 
 // TODO More staff, discussed in Joey's letters and scheme.
+
+
+
+
+/* feed operations
+ * include select, insert, update and delete operations
+ *
+ *
+ */
+// select
+function loadFeeds()
+{
+    var db = openStdDataBase()
+    var dbResult
+//    var feeds
+    db.transaction(function(tx) {
+        dbResult = tx.executeSql("SELECT * FROM feed")
+        console.log("feed SELECTED: ", dbResult.rows.length)
+        //feeds = dbResultLocal.rows
+    }
+    )
+    return dbResult;  // I suggest that return the whole result in order to know if error occurs
+}
+
+// insert
+function addFeed(title, source)  // from user input
+{
+    var dbResult
+    var db = openStdDataBase()
+    db.transaction(function (tx) {
+//        ensureFeedTableExists(tx)
+
+        /* Check uniqueness.
+         */
+        dbResult = tx.executeSql("SELECT * FROM feed WHERE source=?", [source])
+        if (dbResult.rows.length > 0) {
+            console.log("Database, addFeed: already exist feed with source: ", source)
+            //dbResult.exist = true // TODO TMP, mb need string with error, will see later.
+            return {"error": true, "exist": true};
+        }
+
+        dbResult = tx.executeSql('INSERT INTO feed (title, source) VALUES(?, ?)',
+                                 [title , source])
+        console.log("feed INSERT ID: ", dbResult.insertId)
+    }
+    )
+    return dbResult;
+}
+
+// update
+function updateFeedByUser(id, title, source)  // from user input
+{
+    var db = openStdDataBase()
+    var dbResult
+    db.transaction(function (tx) {
+//        ensureFeedTableExists(tx)
+        dbResult = tx.executeSql('UPDATE feed SET title=?, source=? WHERE id=?',
+                                 [title, source, id])
+        console.log("feed UPDATE, AFFECTED ROWS: ", dbResult.rowsAffected)
+    }
+    )
+    return dbResult
+}
+
+function updateFeedByXml(id, link, description, pubdate)   // from xml file
+{
+    var db = openStdDataBase()
+    var dbResult
+    db.transaction(function (tx) {
+//        ensureFeedTableExists(tx)
+        dbResult = tx.executeSql('UPDATE feed SET link=?, description=?, pubdate=? WHERE id=?',
+                                 [link, description, pubdate, id])
+        console.log("feed UPDATE, AFFECTED ROWS: ", dbResult.rowsAffected)
+    }
+    )
+    return dbResult
+}
+
+function updateFeedImage(id, image)  //  offline image path
+{
+    var db = openStdDataBase()
+    var dbResult
+    db.transaction(function (tx) {
+//        ensureFeedTableExists(tx)
+        dbResult = tx.executeSql('UPDATE feed SET image=? WHERE id=?',
+                                 [image, id])
+        console.log("feed UPDATE, AFFECTED ROWS: ", dbResult.rowsAffected)
+    }
+    )
+    return dbResult
+}
+
+function updateFeedCount(id, count)  //
+{
+    var db = openStdDataBase()
+    var dbResult
+    db.transaction(function (tx) {
+//        ensureFeedTableExists(tx)
+        dbResult = tx.executeSql('UPDATE feed SET count=? WHERE id=?',
+                                 [count, id])
+        console.log("feed UPDATE, AFFECTED ROWS: ", dbResult.rowsAffected)
+    }
+    )
+    return dbResult
+}
+
+// delete
+function deleteFeed(id)
+{
+    var db = openStdDataBase()
+    var dbResult
+    db.transaction(function (tx) {
+//        ensureFeedTableExists(tx)
+        tx.executeSql('PRAGMA foreign_keys = ON;')   // enable foreign key support
+        dbResult = tx.executeSql('delete from feed WHERE id=?',
+                                 [id])
+        console.log("feed delete, AFFECTED ROWS: ", dbResult.rowsAffected)
+    }
+    )
+    return dbResult
+}
+
+
+
+/* article operations
+ * include select, insert, update and delete operations
+ *
+ *
+ */
+// select
+function loadArticles()
+{
+    var db = openStdDataBase()
+    var dbResult
+
+    db.transaction(function(tx) {
+        dbResult = tx.executeSql("SELECT * FROM article")
+        console.log("article SELECTED: ", dbResult.rows.length)
+
+    }
+    )
+    return dbResult;
+}
+
+// insert
+function addArticle(title, link, description, pubdate, guid, feed_id)
+{
+    var dbResult
+    var db = openStdDataBase()
+    db.transaction(function (tx) {
+//        ensureFeedTableExists(tx)
+
+        /* Check uniqueness.
+         */
+        dbResult = tx.executeSql("SELECT * FROM article WHERE guid=?", [guid])
+        if (dbResult.rows.length > 0) {
+            console.log("Database, add article: already exist article with source: ", guid)
+            //dbResult.exist = true // TODO TMP, mb need string with error, will see later.
+            return {"error": true, "exist": true};
+        }
+
+        dbResult = tx.executeSql('INSERT INTO article (title, link, description, pubdate, guid, feed_id) VALUES(?, ?, ?, ?, ?, ?)',
+                                 [title , link, description, pubdate, guid, feed_id])
+        console.log("article INSERT ID: ", dbResult.insertId)
+    }
+    )
+    return dbResult;
+}
+
+// update
+function updateArticleStatus(id, status)
+{
+    var db = openStdDataBase()
+    var dbResult
+    db.transaction(function (tx) {
+//        ensureFeedTableExists(tx)
+        dbResult = tx.executeSql('UPDATE article SET status=? WHERE id=?',
+                                 [status, id])
+        console.log("article UPDATE, AFFECTED ROWS: ", dbResult.rowsAffected)
+    }
+    )
+    return dbResult
+}
+
+function updateArticleFavourite(id, favourite)
+{
+    var db = openStdDataBase()
+    var dbResult
+    db.transaction(function (tx) {
+//        ensureFeedTableExists(tx)
+        dbResult = tx.executeSql('UPDATE article SET favourite=? WHERE id=?',
+                                 [favourite, id])
+        console.log("article UPDATE, AFFECTED ROWS: ", dbResult.rowsAffected)
+    }
+    )
+    return dbResult
+}
+
+function updateArticleImage(id, image)  //  offline image path
+{
+    var db = openStdDataBase()
+    var dbResult
+    db.transaction(function (tx) {
+//        ensureFeedTableExists(tx)
+        dbResult = tx.executeSql('UPDATE article SET image=? WHERE id=?',
+                                 [image, id])
+        console.log("article UPDATE, AFFECTED ROWS: ", dbResult.rowsAffected)
+    }
+    )
+    return dbResult
+}
+
+
+// delete
+function deleteArticle(id)
+{
+    var db = openStdDataBase()
+    var dbResult
+    db.transaction(function (tx) {
+//        ensureFeedTableExists(tx)
+        dbResult = tx.executeSql('delete from article WHERE id=?',
+                                 [id])
+        console.log("article delete, AFFECTED ROWS: ", dbResult.rowsAffected)
+    }
+    )
+    return dbResult
+}
+
+// clear article table, only status='2' and favourite='1' remain
+function clearArticle(feed_id)
+{
+    var db = openStdDataBase()
+    var dbResult
+    db.transaction(function (tx) {
+//        ensureFeedTableExists(tx)
+        dbResult = tx.executeSql("delete from article WHERE (status='0' OR status='1') AND favourite='0' AND feed_id=?", [feed_id])
+        console.log("article delete, AFFECTED ROWS: ", dbResult.rowsAffected)
+    }
+    )
+    return dbResult
+}
+
+
+/* tag operations
+ * include select, insert, update and delete operations
+ *
+ *
+ */
+// select
+function loadTags()
+{
+    var db = openStdDataBase()
+    var dbResult
+
+    db.transaction(function(tx) {
+        dbResult = tx.executeSql("SELECT * FROM tag")
+        console.log("tag SELECTED: ", dbResult.rows.length)
+
+    }
+    )
+    return dbResult;
+}
+
+// insert
+function addTag(name)
+{
+    var dbResult
+    var db = openStdDataBase()
+    db.transaction(function (tx) {
+//        ensureFeedTableExists(tx)
+
+        /* Check uniqueness.
+         */
+        dbResult = tx.executeSql("SELECT * FROM tag WHERE name=?", [name])
+        if (dbResult.rows.length > 0) {
+            console.log("Database, add tag: already exist tag with source: ", name)
+            //dbResult.exist = true // TODO TMP, mb need string with error, will see later.
+            return {"error": true, "exist": true};
+        }
+
+        dbResult = tx.executeSql('INSERT INTO tag (name) VALUES(?)',
+                                 [name])
+        console.log("article INSERT ID: ", dbResult.insertId)
+    }
+    )
+    return dbResult;
+}
+
+// update
+function updateTag(id, name)
+{
+    var db = openStdDataBase()
+    var dbResult
+    db.transaction(function (tx) {
+//        ensureFeedTableExists(tx)
+        dbResult = tx.executeSql('UPDATE tag SET name=? WHERE id=?',
+                                 [name, id])
+        console.log("tag UPDATE, AFFECTED ROWS: ", dbResult.rowsAffected)
+    }
+    )
+    return dbResult
+}
+
+// delete
+function deleteTag(id)
+{
+    var db = openStdDataBase()
+    var dbResult
+    db.transaction(function (tx) {
+//        ensureFeedTableExists(tx)
+        dbResult = tx.executeSql('delete from tag WHERE id=?',
+                                 [id])
+        console.log("tag delete, AFFECTED ROWS: ", dbResult.rowsAffected)
+    }
+    )
+    return dbResult
+}
+
+
+/* feed_tag operations
+ * include select, insert and delete operations
+ *
+ *
+ */
+// select
+function loadFeedTags()
+{
+    var db = openStdDataBase()
+    var dbResult
+
+    db.transaction(function(tx) {
+        dbResult = tx.executeSql("SELECT * FROM feed_tag")
+        console.log("feed_tag SELECTED: ", dbResult.rows.length)
+
+    }
+    )
+    return dbResult;
+}
+
+// insert
+function addFeedTag(feed_id, tag_id)
+{
+    var dbResult
+    var db = openStdDataBase()
+    db.transaction(function (tx) {
+//        ensureFeedTableExists(tx)
+
+        /* Check uniqueness.
+         */
+        dbResult = tx.executeSql("SELECT * FROM feed_tag WHERE feed_id=? AND tag_id=? ", [feed_id, tag_id])
+        if (dbResult.rows.length > 0) {
+            console.log("Database, add feed_tag: already exist feed_tag with source: ", feed_id, tag_id)
+            //dbResult.exist = true // TODO TMP, mb need string with error, will see later.
+            return {"error": true, "exist": true};
+        }
+
+        dbResult = tx.executeSql('INSERT INTO feed_tag (feed_id, tag_id) VALUES(?, ?)',
+                                 [feed_id, tag_id])
+        console.log("feed_tag INSERT ID: ", dbResult.insertId)
+    }
+    )
+    return dbResult;
+}
+
+// delete
+function deleteFeedTag(id)
+{
+    var db = openStdDataBase()
+    var dbResult
+    db.transaction(function (tx) {
+//        ensureFeedTableExists(tx)
+        dbResult = tx.executeSql('delete from feed_tag WHERE id=?',
+                                 [id])
+        console.log("feed_tag delete, AFFECTED ROWS: ", dbResult.rowsAffected)
+    }
+    )
+    return dbResult
+}
+
+
+/* settings operations
+ * include select and update operations
+ *
+ *
+ */
+// select  //for each setting
+function getDBVersion()
+{
+    var db = openStdDataBase()
+    var dbResult
+    var dbVersion = ""
+
+    db.transaction(function(tx) {
+        dbResult = tx.executeSql("SELECT current_database_version FROM settings where id=1")
+        if (dbResult.rows.length > 0)
+        {
+            dbVersion = dbResult.rows.item(0).current_database_version ;
+        }
+
+    }
+    )
+    return dbVersion;
+}
+
+function getDBLastUpdate()
+{
+    var db = openStdDataBase()
+    var dbResult
+    var dbLastUpdate = ""
+
+    db.transaction(function(tx) {
+        dbResult = tx.executeSql("SELECT database_last_updated FROM settings where id=1")
+        if (dbResult.rows.length > 0)
+        {
+            dbLastUpdate = dbResult.rows.item(0).database_last_updated ;
+        }
+
+    }
+    )
+    return dbLastUpdate;
+}
+
+function getViewMode()
+{
+    var db = openStdDataBase()
+    var dbResult
+    var dbViewMode = ""
+
+    db.transaction(function(tx) {
+        dbResult = tx.executeSql("SELECT view_mode FROM settings where id=1")
+        if (dbResult.rows.length > 0)
+        {
+            dbViewMode = dbResult.rows.item(0).view_mode ;
+        }
+
+    }
+    )
+    return dbViewMode;
+}
+
+function getUpdateInterval()
+{
+    var db = openStdDataBase()
+    var dbResult
+    var dbUpdateInterval = 0
+
+    db.transaction(function(tx) {
+        dbResult = tx.executeSql("SELECT update_interval FROM settings where id=1")
+        if (dbResult.rows.length > 0)
+        {
+            dbUpdateInterval = dbResult.rows.item(0).update_interval ;
+        }
+
+    }
+    )
+    return dbUpdateInterval;
+}
+
+function getNetworkMode()
+{
+    var db = openStdDataBase()
+    var dbResult
+    var dbNetworkMode = ""
+
+    db.transaction(function(tx) {
+        dbResult = tx.executeSql("SELECT network_mode FROM settings where id=1")
+        if (dbResult.rows.length > 0)
+        {
+            dbNetworkMode = dbResult.rows.item(0).network_mode ;
+        }
+
+    }
+    )
+    return dbNetworkMode;
+}
+
+// update  //for each setting
+function setDBVersion(current_database_version)
+{
+    var db = openStdDataBase()
+    var dbResult
+    db.transaction(function (tx) {
+//        ensureFeedTableExists(tx)
+        dbResult = tx.executeSql('UPDATE settings SET current_database_version=? WHERE id=1',
+                                 [current_database_version])
+        console.log("settings UPDATE, AFFECTED ROWS: ", dbResult.rowsAffected)
+    }
+    )
+    return dbResult
+}
+
+function setDBLastUpdate(database_last_updated)
+{
+    var db = openStdDataBase()
+    var dbResult
+    db.transaction(function (tx) {
+//        ensureFeedTableExists(tx)
+        dbResult = tx.executeSql('UPDATE settings SET database_last_updated=? WHERE id=1',
+                                 [database_last_updated])
+        console.log("settings UPDATE, AFFECTED ROWS: ", dbResult.rowsAffected)
+    }
+    )
+    return dbResult
+}
+
+function setViewMode(view_mode)
+{
+    var db = openStdDataBase()
+    var dbResult
+    db.transaction(function (tx) {
+//        ensureFeedTableExists(tx)
+        dbResult = tx.executeSql('UPDATE settings SET view_mode=? WHERE id=1',
+                                 [view_mode])
+        console.log("settings UPDATE, AFFECTED ROWS: ", dbResult.rowsAffected)
+    }
+    )
+    return dbResult
+}
+
+function setUpdateInterval(update_interval)
+{
+    var db = openStdDataBase()
+    var dbResult
+    db.transaction(function (tx) {
+//        ensureFeedTableExists(tx)
+        dbResult = tx.executeSql('UPDATE settings SET update_interval=? WHERE id=1',
+                                 [update_interval])
+        console.log("settings UPDATE, AFFECTED ROWS: ", dbResult.rowsAffected)
+    }
+    )
+    return dbResult
+}
+
+function setNetworkMode(network_mode)
+{
+    var db = openStdDataBase()
+    var dbResult
+    db.transaction(function (tx) {
+//        ensureFeedTableExists(tx)
+        dbResult = tx.executeSql('UPDATE settings SET network_mode=? WHERE id=1',
+                                 [network_mode])
+        console.log("settings UPDATE, AFFECTED ROWS: ", dbResult.rowsAffected)
+    }
+    )
+    return dbResult
+}
+
+
+
+/* operations for testing
+ * include clear and drop operations
+ * not completed yet
+ *
+ */
+// clear
+function clearData(table)
+{
+    var db = openStdDataBase()
+
+    switch(table)
+    {
+    case "feed":
+        db.transaction(function(tx) {
+            tx.executeSql("delete from feed")
+            console.log("feed clear")
+        }
+        )
+        break;
+    case "article":
+        db.transaction(function(tx) {
+            tx.executeSql("delete from article")
+            console.log("article clear")
+        }
+        )
+        break;
+    case "tag":
+        db.transaction(function(tx) {
+            tx.executeSql("delete from tag")
+            console.log("tag clear")
+        }
+        )
+        break;
+    case "feed_tag":
+        db.transaction(function(tx) {
+            tx.executeSql("delete from feed_tag")
+            console.log("feed_tag clear")
+        }
+        )
+        break;
+    case "settings":
+        db.transaction(function(tx) {
+            tx.executeSql("delete from settings")
+            console.log("settings clear")
+        }
+        )
+        break;
+    default:
+        db.transaction(function(tx) {
+            tx.executeSql("delete from feed_tag")
+            tx.executeSql("delete from feed")
+            tx.executeSql("delete from tag")
+            tx.executeSql("delete from article")
+            tx.executeSql("delete from settings")
+            console.log("DATABASE clear")
+        }
+        )
+    }
+}
+
+// drop
+function dropTable(table)
+{
+    var db = openStdDataBase()
+
+    switch(table)
+    {
+    case "feed":
+        db.transaction(function(tx) {
+            tx.executeSql("DROP TABLE IF EXISTS feed")
+            console.log("feed deleted")
+        }
+        )
+        break;
+    case "article":
+        db.transaction(function(tx) {
+            tx.executeSql("DROP TABLE IF EXISTS article")
+            console.log("article deleted")
+        }
+        )
+        break;
+    case "tag":
+        db.transaction(function(tx) {
+            tx.executeSql("DROP TABLE IF EXISTS tag")
+            console.log("tag deleted")
+        }
+        )
+        break;
+    case "feed_tag":
+        db.transaction(function(tx) {
+            tx.executeSql("DROP TABLE IF EXISTS feed_tag")
+            console.log("feed_tag deleted")
+        }
+        )
+        break;
+    case "settings":
+        db.transaction(function(tx) {
+            tx.executeSql("DROP TABLE IF EXISTS settings")
+            console.log("settings deleted")
+        }
+        )
+        break;
+    default:
+        db.transaction(function(tx) {
+            tx.executeSql("DROP TABLE IF EXISTS feed")
+            tx.executeSql("DROP TABLE IF EXISTS article")
+            tx.executeSql("DROP TABLE IF EXISTS tag")
+            tx.executeSql("DROP TABLE IF EXISTS feed_tag")
+            tx.executeSql("DROP TABLE IF EXISTS settings")
+            console.log("DATABASE deleted")
+        }
+        )
+    }
+}