def create_tables()

in 4-mmrag_tooluse/ingest.py [0:0]

• 36 lines of code
• 1 McCabe index (conditional complexity)

def create_tables(cursor):
    """
    Create tables for Free Cash Flow data.
    """
    cursor.execute('''
    CREATE TABLE IF NOT EXISTS Free_Cash_Flow_Less_Equipment_Finance_Leases (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        report_date TEXT,
        quarter TEXT,
        operating_cash_flow REAL,
        purchases_of_property_and_equipment REAL,
        equipment_acquired_under_finance_leases REAL,
        principal_repayments_of_other_finance_leases REAL,
        principal_repayments_of_financing_obligations REAL,
        free_cash_flow_less_equipment_finance_leases REAL
    )
    ''')

    cursor.execute('''
    CREATE TABLE IF NOT EXISTS Free_Cash_Flow_Less_Principal_Repayments (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        report_date TEXT,
        quarter TEXT,
        operating_cash_flow REAL,
        purchases_of_property_and_equipment REAL,
        principal_repayments_of_finance_leases REAL,
        principal_repayments_of_financing_obligations REAL,
        free_cash_flow_less_principal_repayments REAL
    )
    ''')

    cursor.execute('''
    CREATE TABLE IF NOT EXISTS Free_Cash_Flow_Reconciliation (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        report_date TEXT,
        quarter TEXT,
        operating_cash_flow REAL,
        purchases_of_property_and_equipment REAL,
        free_cash_flow REAL
    )
    ''')