def insert_feed_result_entry(c, feed_result_id, feed_entry_id):
execute(c, '''insert into feed_result_entry(feed_result_id, feed_entry_id)
values(?,?)''', (feed_result_id, feed_entry_id))
def insert_feed_entry(c, feed_id, url, title, summary, publication, data):
execute(
c,
'''insert into feed_entry(feed_id, url, title, summary, published, data)
values(?,?,?,?,?,?) ''',
(feed_id, url, title, summary, publication, data))
def insert_rss_feed_result(c, feed_result_id, request_etag):
execute(c, '''insert into rss_feed_result(feed_result_id, request_etag)
values(?,?)''', (feed_result_id, request_etag))
def insert_feed_result_unread(c, feed_result_id):
execute(c, '''insert into feed_result_unread(feed_result_id)
values(?)''', (feed_result_id, ))
def update_feed_result(cursor, feed_result_id, updated, json):
return execute(cursor, '''update feed_result
set updated = ?,
data = ?
where id = ? ''', (updated, json, feed_result_id))
def insert_feed_result(c, result_id, published, updated, data):
execute(c, '''insert into feed_result(result_id, published, updated, data)
values(?,?,?,?)''', (result_id, published, updated, data))
def insert_feed_result_location(c, feed_id, result_url):
execute(c, '''insert into feed_result_location(feed_id, url)
values(?, ?)''', (feed_id, result_url))
def insert_feed(c, url, title, description):
execute(c, '''insert into feed (url, title, description)
values(?,?,?) ''', (url, title, description))
def insert_feed_entry(c, feed_id, url, title, summary, publication, data):
execute(c, '''insert into feed_entry(feed_id, url, title, summary, published, data)
values(?,?,?,?,?,?) ''', (feed_id, url, title, summary, publication, data))