#!/usr/bin/env python3
"""store.readable(): may this version work with a library a beta left (docs/plan/skin-milionar/340-beta-channel.md, B5)?

Run: python3 scripts/library_harness/test_store_readable.py
"""
import os
import sqlite3
import sys
import tempfile
import unittest

ROOT = os.path.abspath(os.path.join(os.path.dirname(os.path.abspath(__file__)), '..', '..'))
sys.path.insert(0, ROOT)
from wcs.library2 import store  # noqa: E402


class ReadableTests(unittest.TestCase):
    def setUp(self):
        folder = tempfile.TemporaryDirectory()
        self.addCleanup(folder.cleanup)
        self.path = os.path.join(folder.name, 'library.db')

    def library(self, *changes):
        store.connect(self.path).close()
        conn = sqlite3.connect(self.path, isolation_level=None)
        for change in changes:
            conn.execute(change)
        conn.close()
        return store.readable(self.path)

    def test_the_own_library_and_none_at_all_are_readable(self):
        self.assertTrue(store.readable(self.path))
        self.assertTrue(self.library())

    def test_a_beta_may_add_tables_and_columns_a_row_does_not_need(self):
        self.assertTrue(self.library('CREATE TABLE beta_only(id INTEGER PRIMARY KEY, data TEXT NOT NULL)',
                                     'ALTER TABLE flags ADD COLUMN note TEXT',
                                     "ALTER TABLE flags ADD COLUMN level INTEGER NOT NULL DEFAULT 0",
                                     'PRAGMA user_version=99'))

    def test_a_column_every_row_needs_is_not_readable(self):
        self.assertFalse(self.library("ALTER TABLE flags ADD COLUMN level INTEGER NOT NULL DEFAULT 0",
                                      'CREATE TABLE f2(key TEXT PRIMARY KEY, value TEXT, level INTEGER NOT NULL)',
                                      'INSERT INTO f2(key, value, level) SELECT key, value, level FROM flags',
                                      'DROP TABLE flags', 'ALTER TABLE f2 RENAME TO flags'))

    def test_a_renamed_or_dropped_part_is_not_readable(self):
        self.assertFalse(self.library('ALTER TABLE flags RENAME COLUMN value TO amount'))
        os.remove(self.path)
        self.assertFalse(self.library('DROP TABLE flags'))

    def test_a_damaged_file_is_not_readable(self):
        with open(self.path, 'wb') as handle:
            handle.write(b'not a database' * 100)
        self.assertFalse(store.readable(self.path))


if __name__ == '__main__':
    unittest.main(verbosity=1)
