#! /usr/bin/env python

import sys

sys.path.insert(0, ".")

import logging

logging.basicConfig(
    stream=sys.stdout,
    level=logging.INFO,
    format="%(asctime)s %(levelname)s %(message)s",
    datefmt="%H:%M:%S",
)

from tracker.logger import get_logger

logger = get_logger("fix")
from datetime import datetime
from tracker import db

db.setup_session()

from tracker import soundcloud

if __name__ == "__main__":
    logger.info("Starting sc_tracks fix")

    num_to_do = 1000

    for i in range(num_to_do // 50):
        logger.info(f"Doing {i}")
        rows = db.Session.execute(
            """select scid, a.created_at::text, a.last_playback_count, t.last_playback_count
            from sc_tracks_archived a join sc_tracks t using (scid) limit 50"""
        ).fetchall()

        dbg = "\n".join([str(s) for s in rows])
        logger.info(f"Scids: {dbg}")

        soundcloud.unarchive_tracks([r[0] for r in rows])