import sys
import os

sys.path.insert(0, '/home/vh13236/przydasie')
os.chdir('/home/vh13236/przydasie')
os.environ['DJANGO_SETTINGS_MODULE'] = 'finanse.settings'

import django
django.setup()

from django.db import connection

with connection.cursor() as cursor:
    cursor.execute("""CREATE TABLE IF NOT EXISTS app_user (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        email TEXT NOT NULL UNIQUE,
        name TEXT NOT NULL DEFAULT '',
        provider TEXT NOT NULL DEFAULT 'google',
        created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
    )""")
    cursor.execute("""CREATE TABLE IF NOT EXISTS app_transaction (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        amount DECIMAL(10,2) NOT NULL,
        category TEXT NOT NULL,
        txn_date DATETIME NOT NULL,
        user_id INTEGER NOT NULL REFERENCES app_user(id)
    )""")
    cursor.execute("""CREATE TABLE IF NOT EXISTS app_budget (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        category TEXT NOT NULL,
        amount DECIMAL(10,2) NOT NULL DEFAULT 0,
        user_id INTEGER NOT NULL REFERENCES app_user(id),
        UNIQUE(user_id, category)
    )""")
    cursor.execute("""CREATE TABLE IF NOT EXISTS django_session (
        session_key VARCHAR(40) NOT NULL PRIMARY KEY,
        session_data TEXT NOT NULL,
        expire_date DATETIME NOT NULL
    )""")

print("Tabele utworzone pomyślnie!")