simple python script to create an SQLite database and add Alice $83k

create.py

import sqlite3
import os

def create_database(db_path, value):
    if os.path.exists(db_path):
        os.remove(db_path)
    
    conn = sqlite3.connect(db_path)
    cursor = conn.cursor()
    
    cursor.execute('''
        CREATE TABLE IF NOT EXISTS accounts(
            id INTEGER PRIMARY KEY,
            username TEXT,
            amount_cents INTEGER
        )
    ''')
    
    amount_cents = int(value * 100)
    cursor.execute('INSERT INTO accounts (username, amount_cents) VALUES (?, ?)', 
                  ('Alice', amount_cents))
    
    conn.commit()
    conn.close()


def main():
    db_path = 'bank.db'
    original_amount = 83886.08
    create_database(db_path, original_amount)

if __name__ == "__main__":
    main()