def clear_local_bookmarks(): # clear all venom bookmarks from kodi database
conn = db.connect(control.get_video_database_path())
cursor = conn.cursor()
try:
cursor.execute("SELECT * FROM files WHERE strFilename LIKE '%plugin.video.venom%'")
file_ids = [str(i[0]) for i in cursor.fetchall()]
for table in ["bookmark", "streamdetails", "files"]:
cursor.execute("DELETE FROM {} WHERE idFile IN ({})".format(table, ','.join(file_ids)))
cursor.connection.commit()
except:
log_utils.error()
pass
cursor.close()
def clear_local_bookmark(url): # clear all item specific bookmarks from kodi database
conn = db.connect(control.get_video_database_path())
cursor = conn.cursor()
try:
cursor.execute('SELECT * FROM files WHERE strFilename LIKE "%{}%"'.format(url))
file_ids = [str(i[0]) for i in cursor.fetchall()]
if not file_ids:
return
for table in ["bookmark", "streamdetails", "files"]:
cursor.execute("DELETE FROM {} WHERE idFile IN ({})".format(table, ','.join(file_ids)))
cursor.connection.commit()
except:
log_utils.error()
finally:
cursor.close() ; conn.close()
