def hard_purge(feed_uid): feed_uid = int(feed_uid) with dbop.db() as db: db.execute("delete from fm_items where item_feed_uid=?", [feed_uid]) db.execute("delete from fm_rules where rule_feed_uid=?", [feed_uid]) db.execute("delete from fm_feeds where feed_uid=?", [feed_uid]) db.commit() filters.invalidate()
def hard_purge(feed_uid): feed_uid = int(feed_uid) from singleton import db c = db.cursor() try: c.execute("delete from fm_items where item_feed_uid=?", [feed_uid]) c.execute("delete from fm_rules where rule_feed_uid=?", [feed_uid]) c.execute("delete from fm_feeds where feed_uid=?", [feed_uid]) db.commit() finally: c.close() filters.invalidate()
def update_feed_filter(feed_uid, feed_filter): """Update a feed desc""" feed_uid = int(feed_uid) feed_filter = feed_filter.strip() if feed_filter: # check syntax compile(filters.normalize_rule(feed_filter), 'web form', 'eval') val = feed_filter else: val = None with dbop.db() as db: db.execute("update fm_feeds set feed_filter=? where feed_uid=?", [val, feed_uid]) db.commit() filters.invalidate()
def update_feed_filter(feed_uid, feed_filter): """Update a feed desc""" feed_uid = int(feed_uid) feed_filter = feed_filter.strip() if feed_filter: # check syntax compile(filters.normalize_rule(feed_filter), 'web form', 'eval') val = feed_filter else: val = None from singleton import db c = db.cursor() try: c.execute("update fm_feeds set feed_filter=? where feed_uid=?", [val, feed_uid]) db.commit() filters.invalidate() finally: c.close()