from SQLiteInterface import SQLiteInterface

if __name__ == "__main__":
    # 实例化一个 SQLiteInterface 类
    db_interface = SQLiteInterface()
    # 建表语句
    create_table_sql = '''
    CREATE TABLE IF NOT EXISTS AlipayCashFlowStatement (
        cashflow_id INTEGER PRIMARY KEY AUTOINCREMENT,
        date TEXT NOT NULL,
        category TEXT NOT NULL,
        counterparty TEXT NOT NULL,
        description TEXT,
        transaction_type TEXT NOT NULL,
        amount REAL NOT NULL,
        payment_method TEXT,
        status TEXT NOT NULL,
        note TEXT,
        label TEXT, 
        currency TEXT NOT NULL DEFAULT 'CNY',
        cashflow_account_name TEXT, 
        opening_balance REAL DEFAULT 0
    );
    '''

    try:
        # 尝试执行创建表的SQL语句
        db_interface.run_sql(create_table_sql)
        print("表创建成功。")

    except Exception as e:
        # 捕获并打印所有其他未预期的错误
        print(f"操作失败: {e}")