Establishes foundation for migrating baseball simulation from Discord bot to web application using service-oriented architecture pattern. Key components: - FastAPI application structure with dependency injection - Service layer foundation with base classes and container - Comprehensive directory documentation with README files - PostgreSQL containerization with Docker Compose - Testing structure for unit/integration/e2e tests - Migration planning documentation - Rotating log configuration per user requirements Architecture follows Model/Service/Controller pattern to improve testability, maintainability, and scalability over original monolithic Discord app. 🤖 Generated with [Claude Code](https://claude.ai/code) Co-Authored-By: Claude <noreply@anthropic.com>
9 lines
368 B
SQL
9 lines
368 B
SQL
-- Initial database setup for Paper Dynasty
|
|
-- This script runs when the PostgreSQL container is first created
|
|
|
|
-- Create any additional databases needed for testing
|
|
CREATE DATABASE paper_dynasty_test;
|
|
|
|
-- Grant permissions
|
|
GRANT ALL PRIVILEGES ON DATABASE paper_dynasty TO paper_dynasty_user;
|
|
GRANT ALL PRIVILEGES ON DATABASE paper_dynasty_test TO paper_dynasty_user; |