import sqlite3

db_config = {
            'database': r'z:\pos_hipermarket\db\beta_sb_pos_sqlite.db'
        }

def create_connection():
    conn = None
    try:
        #conn = sqlite3.connect('pos_hipermarket.db')
        conn = sqlite3.connect(db_config['database'])
        conn.row_factory = sqlite3.Row  # Supaya hasilnya seperti dictionary
        print(f"koneksi berhasil")
        #cursor = conn.cursor()
    except sqlite3.Error as e:
        print(f"Error connecting to database: {e}")
    return conn

def initialize_database():
    conn = create_connection()
    if conn is not None:
        cursor = conn.cursor()

        # Create tables
        #cursor.execute('''
        #CREATE TABLE IF NOT EXISTS users (
        #    id INTEGER PRIMARY KEY AUTOINCREMENT,
        #    username TEXT NOT NULL UNIQUE,
        #    password TEXT NOT NULL,
        #    role TEXT NOT NULL CHECK(role IN ('admin', 'kasir', 'owner')),
        #    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
        #);
        #''')

        #cursor.execute('''
        #CREATE TABLE IF NOT EXISTS barang (
        #    id INTEGER PRIMARY KEY AUTOINCREMENT,
        #    kode_barang TEXT NOT NULL UNIQUE,
        #    nama_barang TEXT NOT NULL,
        #    harga REAL NOT NULL,
        #    stok INTEGER NOT NULL,
        #    kategori TEXT,
        #    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
        #);
        #''')

        #cursor.execute('''
        #CREATE TABLE IF NOT EXISTS transaksi (
        #    id INTEGER PRIMARY KEY AUTOINCREMENT,
        #    no_nota TEXT NOT NULL UNIQUE,
        #    user_id INTEGER NOT NULL,
        #    total REAL NOT NULL,
        #    bayar REAL NOT NULL,
        #    kembali REAL NOT NULL,
        #    tanggal TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        #    FOREIGN KEY (user_id) REFERENCES users(id)
        #);
        #''')

        #cursor.execute('''
        #CREATE TABLE IF NOT EXISTS transaksi_detail (
        #    id INTEGER PRIMARY KEY AUTOINCREMENT,
        #    transaksi_id INTEGER NOT NULL,
        #    barang_id INTEGER NOT NULL,
        #    jumlah INTEGER NOT NULL,
        #    harga_satuan REAL NOT NULL,
        #    subtotal REAL NOT NULL,
        #    FOREIGN KEY (transaksi_id) REFERENCES transaksi(id),
        #    FOREIGN KEY (barang_id) REFERENCES barang(id)
        #);
        #''')

        #conn.commit()
        conn.close()
    else:
        print("Failed to create database connection.")