c6425235a2
Major Changes: - Migrated web framework from Quart (async) to Flask (sync) - Added MariaDB database integration with SQLAlchemy ORM - Implemented dynamic content management for portfolio New Features: - Database models for Profile, Skills, Projects, ProjectTags, and SocialLinks - RESTful API endpoints for CRUD operations on all entities - Database initialization script (init_db.py) with sample data - Docker Compose configuration with MariaDB service Modified Files: - app.py: Replaced Quart with Flask, added database initialization - config.py: Added database configuration with environment variables - routes/home.py: Converted async to sync, added database queries - requirements.txt: Replaced Quart/Hypercorn with Flask/Gunicorn, added Flask-SQLAlchemy and PyMySQL - docker-compose.yml: Added MariaDB service with health checks - templates/: Updated all templates to use dynamic data from database with Jinja2 - .env.example: Added database configuration variables - README.md: Complete rewrite with new setup instructions and API documentation New Files: - models.py: SQLAlchemy models for all database entities - init_db.py: Database initialization script - routes/api.py: REST API endpoints for content management Benefits: - Simplified architecture (sync vs async) - Better ecosystem compatibility - Dynamic content management via database - Easy content updates through REST API - Improved deployment with standard WSGI server (Gunicorn)
33 lines
882 B
Python
33 lines
882 B
Python
#!/usr/bin/env python
|
|
# -*- coding: utf-8 -*-
|
|
|
|
# Copyright Hersel Giannella
|
|
|
|
from pydantic_settings import BaseSettings
|
|
|
|
class Config(BaseSettings):
|
|
APP_HOST: str = "127.0.0.1"
|
|
APP_PORT: int = 5000
|
|
DEBUG: bool = True
|
|
SECRET_KEY: str = "default_secret_key"
|
|
|
|
# Database Configuration
|
|
DB_HOST: str = "localhost"
|
|
DB_PORT: int = 3306
|
|
DB_USER: str = "portfolio_user"
|
|
DB_PASSWORD: str = "portfolio_password"
|
|
DB_NAME: str = "portfolio_db"
|
|
|
|
@property
|
|
def SQLALCHEMY_DATABASE_URI(self) -> str:
|
|
"""Construct MariaDB connection string"""
|
|
return f"mysql+pymysql://{self.DB_USER}:{self.DB_PASSWORD}@{self.DB_HOST}:{self.DB_PORT}/{self.DB_NAME}"
|
|
|
|
SQLALCHEMY_TRACK_MODIFICATIONS: bool = False
|
|
SQLALCHEMY_ECHO: bool = False # Set to True for SQL query debugging
|
|
|
|
class Config:
|
|
env_file = ".env"
|
|
|
|
config = Config()
|