codex/memory_db.py

import sqlite3
from datetime import datetime

conn = sqlite3.connect("codex_memory.db", check_same_thread=False)
cur = conn.cursor()

cur.execute("""
CREATE TABLE IF NOT EXISTS memory (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    timestamp TEXT,
    user TEXT,
    task TEXT,
    code TEXT,
    result TEXT
)
""")
conn.commit()

def log_event(user, task, code, result):
    cur.execute(
        "INSERT INTO memory VALUES (NULL, ?, ?, ?, ?, ?)",
        (datetime.utcnow().isoformat(), user, task, code, str(result))
    )
    conn.commit()