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()