CODITECT MEMORY-CONTEXT Database Initialization

Creates SQLite database with schema for sessions, patterns, and checkpoints. Supports privacy controls, NESTED LEARNING, and context retrieval.

Usage: python3 scripts/core/db_init.py [--reset] [--verbose]

Options: --reset Drop existing tables before creating --verbose Show detailed SQL execution

Author: AZ1.AI CODITECT Team Sprint: Sprint +1 - MEMORY-CONTEXT Implementation Day 3 Date: 2025-11-16

File: db_init.py

Classes

`DatabaseInitError`

Base exception for database initialization errors

`SchemaError`

Schema loading or validation error

`ConnectionError`

Database connection error

`DatabaseInitializer`

Initialize CODITECT MEMORY-CONTEXT database.

Functions

`main()`

Main entry point.

`connect()`

Create database connection.

`load_schema()`

Load SQL schema from file.

`execute_schema(conn, schema_sql)`

Execute schema SQL statements.

`verify_schema(conn)`

Verify database schema was created correctly.

`reset_database(conn)`

Drop all tables and views (for reset).

`initialize(reset)`

Initialize database with schema.

Usage

python db_init.py

Classes​

DatabaseInitError​

SchemaError​

ConnectionError​

DatabaseInitializer​

Functions​

main()​

connect()​

load_schema()​

execute_schema(conn, schema_sql)​

verify_schema(conn)​

reset_database(conn)​

initialize(reset)​

Usage​