#!/usr/bin/env python3

import sys
import os
import asyncio
import tempfile
import aiosqlite
import zstandard
import string
from pypaste.server import Paste, Storage, keygen
from pypaste.server.sqlite import Sqlite
from pypaste.server.s3 import S3
from datetime import datetime
from pathlib import Path
from secrets import choice


def truncate(path: Path) -> None:
    with open(path, "w") as f:
        f.truncate(0)


def random_string(length: int) -> str:
    return "".join(choice(string.ascii_letters) for _ in range(length))


async def test_vacuum(storage: Storage):
    # generate random string to avoid it getting compressed
    content = random_string(32)
    size_compressed = len(zstandard.compress(content.encode()))

    for x in range(1024 // size_compressed + 1):
        await storage.insert(Paste(datetime.now(), None, content), keygen(6))

    await storage.vacuum(256)

    assert (use := await storage.get_used()) is not None and use <= 256


async def test_exists_but_not_in_our_table(storage: Storage) -> None:
    key = keygen(6)

    await storage.connection.execute(
        "insert into pastes values(?, ?, ?, ?, ?)",
        (key.data, key.length, datetime.now().isoformat(), None, bytes()),
    )

    assert not await storage.exists(key)


async def test_exists(storage: Storage) -> None:
    dt = datetime.now()
    key = keygen(6)

    await storage.insert(Paste(dt, "test", "hello world"), key)

    assert await storage.exists(key)

    assert not await storage.exists(keygen(6))


async def test_delete(storage: Storage) -> None:
    dt = datetime.now()
    key = keygen(6)

    await storage.insert(Paste(dt, "test", "hello world"), key)

    assert await storage.exists(key)

    await storage.delete(key)

    assert not await storage.exists(key)


async def test_insert_retrieve(storage: Storage) -> None:
    dt = datetime.now()
    key = keygen(6)

    await storage.insert(Paste(dt, "test", "hello world"), key)

    paste = await storage.retrieve(key)

    assert paste is not None
    assert paste.dt == dt
    assert paste.syntax == "test"
    assert paste.text == "hello world"


async def test_sqlite(tests):
    for test in tests:
        with tempfile.TemporaryDirectory() as tmpdir:
            f = Path(tmpdir) / "pastes.sqlite"
            truncate(f)

            async with aiosqlite.connect(f) as connection:
                await connection.execute(
                    (
                        "create table pastes("
                        "key blob,"
                        "key_length int,"
                        "datetime text,"
                        "size int,"
                        "syntax text"
                        ")"
                    )
                )

                storage = Sqlite(connection)

                await storage.setup()

                await test(storage)


async def main() -> int:
    tests = [
        test_insert_retrieve,
        test_delete,
        test_exists,
        test_exists_but_not_in_our_table,
        test_vacuum,
    ]

    await test_sqlite(tests)

    return 0


if __name__ == "__main__":
    sys.exit(asyncio.run(main()))