feat: init db module with schema, seed and migration

main.py

@@ -1,14 +0,0 @@
-from flask import Flask, jsonify
-
-app = Flask(__name__)
-
-@app.route('/api/health')
-def health():
-    return jsonify({'status': 'ok', 'module': 'api'})
-
-@app.route('/api/version')
-def version():
-    return jsonify({'version': '1.0.0'})
-
-if __name__ == '__main__':
-    app.run(host='0.0.0.0', port=5000)

migrate.py

@@ -0,0 +1,21 @@
+import sqlite3
+import os
+
+DB_PATH = 'app.db'
+
+def migrate():
+    conn = sqlite3.connect(DB_PATH)
+    cursor = conn.cursor()
+    
+    with open('schema.sql', 'r') as f:
+        cursor.executescript(f.read())
+    
+    with open('seed.sql', 'r') as f:
+        cursor.executescript(f.read())
+    
+    conn.commit()
+    conn.close()
+    print(f"Database migrated: {DB_PATH}")
+
+if __name__ == '__main__':
+    migrate()

requirements.txt

@@ -1,2 +0,0 @@
-flask>=3.0
-gunicorn>=21.2

routes/users.py

@@ -1,10 +0,0 @@
-from flask import jsonify
-
-def register_routes(app):
-    @app.route('/api/users')
-    def list_users():
-        return jsonify({'users': []})
-    
-    @app.route('/api/users/<int:user_id>')
-    def get_user(user_id):
-        return jsonify({'id': user_id, 'name': 'Alice'})

schema.sql

@@ -0,0 +1,13 @@
+CREATE TABLE IF NOT EXISTS users (
+    id INTEGER PRIMARY KEY AUTOINCREMENT,
+    name TEXT NOT NULL,
+    email TEXT UNIQUE,
+    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
+);
+
+CREATE TABLE IF NOT EXISTS sessions (
+    id INTEGER PRIMARY KEY AUTOINCREMENT,
+    user_id INTEGER REFERENCES users(id),
+    token TEXT NOT NULL,
+    expires_at TIMESTAMP NOT NULL
+);

seed.sql

@@ -0,0 +1,3 @@
+INSERT INTO users (name, email) VALUES ('Alice', 'alice@example.com');
+INSERT INTO users (name, email) VALUES ('Bob', 'bob@example.com');
+INSERT INTO users (name, email) VALUES ('Charlie', 'charlie@example.com');