feat: init api module with Flask app and user routes

main.py

@@ -0,0 +1,14 @@
+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

@@ -1,21 +0,0 @@
-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

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

routes/users.py

@@ -0,0 +1,10 @@
+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

@@ -1,13 +0,0 @@
-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

@@ -1,3 +0,0 @@
-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');