23
23
/* This variable will store result of any operation with database.
27
27
/* Load all feed from database.
28
28
* Mb later we will need some criteria, such as tag, date and so on!
30
30
function loadFeeds() {
31
31
var db = openStdDataBase()
33
34
db.transaction(function(tx) {
34
35
ensureFeedTableExists(tx)
35
dbResult = tx.executeSql("SELECT * FROM UserFeeds")
36
console.log("SELECTED: ", dbResult.rows.length)
36
dbResultLocal = tx.executeSql("SELECT * FROM UserFeeds")
37
console.log("SELECTED: ", dbResultLocal.rows.length)
38
feeds = dbResultLocal.rows
41
44
/* Add feed to database.
70
74
console.log("INSERT ID", dbResult.insertId)
75
80
/* Update information about feed with new information.
77
82
function updateFeedWithInfo(link, d) {
78
83
var db = openStdDataBase()
80
85
db.transaction(function (tx) {
81
86
ensureFeedTableExists(tx)
82
87
dbResult = tx.executeSql('UPDATE UserFeeds SET displayName=?, siteLink=?, description=? WHERE link=?',
84
89
console.log("UPDATE, AFFECTED ROWS", dbResult.rowsAffected)
89
95
/* Delete feed from database.
91
97
function deleteFeed(link) {
92
98
var db = openStdDataBase()
94
100
db.transaction(function (tx) {
95
102
ensureFeedTableExists(tx)
96
dbResult = tx.executeSql('DELETE FROM UserFeeds WHERE link = ?', [link])
97
console.log("DELETE, AFFECTED ROWS", dbResult.rowsAffected)
103
dbResultLocal = tx.executeSql('DELETE FROM UserFeeds WHERE link = ?', [link])
104
console.log("DELETE, AFFECTED ROWS", dbResultLocal.rowsAffected)
105
result = dbResultLocal
102
111
/* Select all entries from database.
104
113
function loadEntries(feedLink, all) {
105
114
all = all || false
106
115
var db = openStdDataBase()
108
118
db.transaction(function(tx) {
109
119
ensureEntriesTableExists(tx)
111
dbResult = tx.executeSql('SELECT * FROM FeedEntries')
112
else dbResult = tx.executeSql('SELECT * FROM FeedEntries WHERE feedLink = ?', [feedLink])
113
console.log("loadEntries, SELECTED ROWS", dbResult.rows.length)
122
dbResultLocal = tx.executeSql('SELECT * FROM FeedEntries')
123
else dbResultLocal = tx.executeSql('SELECT * FROM FeedEntries WHERE feedLink = ?', [feedLink])
124
console.log("loadEntries, SELECTED ROWS", dbResultLocal.rows.length)
125
entries = dbResultLocal.rows;
131
/* Select all entries from database.
133
function loadFeed(feedLink) {
134
var db = openStdDataBase()
135
var feed = {displayName: "Unknown"}
136
db.transaction(function(tx) {
137
ensureEntriesTableExists(tx)
138
var dbResult = tx.executeSql('SELECT * FROM UserFeeds WHERE link = ?', [feedLink])
139
console.log("feedName, SELECTED ROWS", dbResult.rows.length)
140
if(dbResult.rows.length > 0) {
141
feed = dbResult.rows.item(0)
118
148
/* Append entry to database.
120
150
function addEntry(feedLink, hash, d) {
121
151
var db = openStdDataBase()
123
153
if (feedLink === undefined || hash === undefined) {
124
154
console.log("Database, addEntry: feedLink and hash can't be undefined")
142
172
// console.log("ENTRY INSERT ID", dbResult.insertId)
147
178
/* Remove all entries from database by feed link.
149
180
function removeEntriesOfFeed(feedLink) {
150
181
var db = openStdDataBase()
152
183
db.transaction(function(tx) {
153
184
ensureEntriesTableExists(tx)
154
185
dbResult = tx.executeSql('DELETE FROM FeedEntries WHERE feedLink = ?', [feedLink])
159
191
/* Only for debug purposes.