from db import cursor, connection
import hashlib
import secrets
import json
import time


# get valid token hashes for a given user_id
def valid_tokens(user_id):
    tokens = json.loads(
        cursor.execute(
            "select valid_tokens from users where user_id = ?", [user_id]
        ).fetchone()[0]
    )
    # return only tokens that aren't expired
    return [
        token for token in tokens
        if token["expirationDate"] > int(time.time() * 1000)
    ]


def validate_token(user_id, token):
    tokens = valid_tokens(user_id)
    return hashlib.sha256(str(token).encode()).hexdigest() in [
        t["token"] for t in tokens
        if t["expirationDate"] > int(time.time() * 1000)
    ]


def modify_tokens(user_id, formatted_token, remove):
    temp_tokens = valid_tokens(user_id)
    temp_tokens.remove(formatted_token
                       ) if remove else temp_tokens.append(formatted_token)
    cursor.execute(
        "update users set valid_tokens = ? where user_id = ?",
        [json.dumps(temp_tokens), user_id]
    )
    connection.commit()


def add_token(user_id, formatted_token):
    modify_tokens(user_id, formatted_token, False)


def revoke_token(user_id, formatted_token):
    modify_tokens(user_id, formatted_token, True)


def hash_token(token):
    return {
        "token": hashlib.sha256(str(token["token"]).encode()).hexdigest(),
        "expirationDate": token["expirationDate"]
    }


def generate_token():
    return {
        "token": secrets.token_hex(128),
        "expirationDate": int(time.time() * 1000) + (24 * 60 * 60 * 1000)
    }