def last_paused_at(): last_paused = 0 try: if not control.existsPath(control.dataPath): control.makeFile(control.dataPath) dbcon = db.connect(control.traktSyncFile) dbcur = dbcon.cursor() ck_table = dbcur.execute( '''SELECT * FROM sqlite_master WHERE type='table' AND name='service';''' ).fetchone() if ck_table: match = dbcur.execute( '''SELECT * FROM service WHERE setting="last_paused_at";''' ).fetchone() if match: last_paused = int(cleandate.iso_2_utc(match[1])) else: dbcur.execute( '''INSERT OR REPLACE INTO service Values (?, ?)''', ('last_paused_at', '1970-01-01T20:00:00.000Z')) else: dbcur.execute( '''CREATE TABLE IF NOT EXISTS service (setting TEXT, value TEXT, UNIQUE(setting));''' ) except: log_utils.error() finally: dbcur.close() dbcon.close() return last_paused
def getActivity(): try: i = getTraktAsJson('/sync/last_activities') if not i: return 0 activity = [] activity.append(i['movies']['watched_at']) # added 8/30/20 activity.append(i['movies']['collected_at']) activity.append(i['movies']['watchlisted_at']) activity.append(i['movies']['paused_at']) # added 8/30/20 activity.append(i['movies']['hidden_at']) # added 4/02/21 activity.append(i['episodes']['watched_at']) # added 8/30/20 activity.append(i['episodes']['collected_at']) activity.append(i['episodes']['watchlisted_at']) activity.append(i['episodes']['paused_at']) # added 8/30/20 activity.append(i['shows']['watchlisted_at']) activity.append(i['shows']['hidden_at']) # added 4/02/21 activity.append(i['seasons']['watchlisted_at']) activity.append(i['seasons']['hidden_at']) # added 4/02/21 activity.append(i['lists']['liked_at']) activity.append(i['lists']['updated_at']) activity = [int(cleandate.iso_2_utc(i)) for i in activity] activity = sorted(activity, key=int)[-1] return activity except: log_utils.error()
def last_sync(type): last_sync_at = 0 try: dbcon = get_connection() dbcur = get_connection_cursor(dbcon) ck_table = dbcur.execute( '''SELECT * FROM sqlite_master WHERE type='table' AND name='service';''' ).fetchone() if ck_table: match = dbcur.execute('''SELECT * FROM service WHERE setting=?;''', (type, )).fetchone() if match: last_sync_at = int(cleandate.iso_2_utc(match[1])) else: dbcur.execute( '''INSERT OR REPLACE INTO service Values (?, ?)''', (type, '1970-01-01T20:00:00.000Z')) else: dbcur.execute( '''CREATE TABLE IF NOT EXISTS service (setting TEXT, value TEXT, UNIQUE(setting));''' ) dbcur.connection.commit() except: from resources.lib.modules import log_utils log_utils.error() finally: dbcur.close() dbcon.close() return last_sync_at
def getEpisodesWatchedActivity(): try: i = getTraktAsJson('/sync/last_activities') if not i: return 0 activity = [] activity.append(i['episodes']['watched_at']) activity = [int(cleandate.iso_2_utc(i)) for i in activity] activity = sorted(activity, key=int)[-1] return activity except: log_utils.error()
def getCollectedActivity(): try: i = getTraktAsJson('/sync/last_activities') activity = [] activity.append(i['movies']['collected_at']) activity.append(i['episodes']['collected_at']) activity = [int(cleandate.iso_2_utc(i)) for i in activity] activity = sorted(activity, key=int)[-1] return activity except: pass
def getWatchedActivity(): try: i = getTraktAsJson('/sync/last_activities') activity = [] activity.append(i['movies']['watched_at']) activity.append(i['episodes']['watched_at']) activity = [int(cleandate.iso_2_utc(i)) for i in activity] activity = sorted(activity, key=int)[-1] return activity except: pass
def getWatchedActivity(): try: i = getTraktAsJson('/sync/last_activities') activity = [] activity.append(i['movies']['watched_at']) activity.append(i['episodes']['watched_at']) activity = [int(cleandate.iso_2_utc(i)) for i in activity] activity = sorted(activity, key=int)[-1] print("TRAKT WATCHED ACTIVITY", activity) return activity except: pass
def getWatchedActivity(): try: i = getTraktAsJson("/sync/last_activities") activity = [] activity.append(i["movies"]["watched_at"]) activity.append(i["episodes"]["watched_at"]) activity = [int(cleandate.iso_2_utc(i)) for i in activity] activity = sorted(activity, key=int)[-1] return activity except: pass
def getWatchedActivity(): try: result = getTrakt('/sync/last_activities') i = json.loads(result) activity = [] activity.append(i['movies']['watched_at']) activity.append(i['episodes']['watched_at']) activity = [int(cleandate.iso_2_utc(i)) for i in activity] activity = sorted(activity, key=int)[-1] return activity except: pass
def getActivity(): try: i = getTraktAsJson('/sync/last_activities') activity = [] activity.append(i['movies']['collected_at']) activity.append(i['episodes']['collected_at']) activity.append(i['movies']['watchlisted_at']) activity.append(i['shows']['watchlisted_at']) activity.append(i['seasons']['watchlisted_at']) activity.append(i['episodes']['watchlisted_at']) activity.append(i['lists']['updated_at']) activity.append(i['lists']['liked_at']) activity = [int(cleandate.iso_2_utc(i)) for i in activity] activity = sorted(activity, key=int)[-1] return activity except: pass
def getActivity(): try: i = getTraktAsJson('/sync/last_activities') activity = [] activity.append(i['movies']['collected_at']) activity.append(i['episodes']['collected_at']) activity.append(i['movies']['watchlisted_at']) activity.append(i['shows']['watchlisted_at']) activity.append(i['seasons']['watchlisted_at']) activity.append(i['episodes']['watchlisted_at']) activity.append(i['lists']['updated_at']) activity.append(i['lists']['liked_at']) activity = [int(cleandate.iso_2_utc(i)) for i in activity] activity = sorted(activity, key=int)[-1] return activity except Exception: pass
def getActivity(): try: i = getTraktAsJson("/sync/last_activities") activity = [] activity.append(i["movies"]["collected_at"]) activity.append(i["episodes"]["collected_at"]) activity.append(i["movies"]["watchlisted_at"]) activity.append(i["shows"]["watchlisted_at"]) activity.append(i["seasons"]["watchlisted_at"]) activity.append(i["episodes"]["watchlisted_at"]) activity.append(i["lists"]["updated_at"]) activity.append(i["lists"]["liked_at"]) activity = [int(cleandate.iso_2_utc(i)) for i in activity] activity = sorted(activity, key=int)[-1] return activity except: pass