7d702e9cbd
- Add db.py PostgreSQL abstraction layer (connection, upsert, table mgmt) - Replace sqlite3 with psycopg2 in: live_candle_fetcher, resampler, data_fetcher, fetch_history, import_csv, indicators, base_strategy - Sanitize table names (colons -> underscores) for PostgreSQL compat - Replace INSERT OR REPLACE with ON CONFLICT upserts - Replace pandas to_sql() with batch upsert_candles() - Add scripts: resampler_loop, gap_detector, backup_runner, cron_scheduler - Add migrate_sqlite_to_pg.py for one-time data migration - Add Dockerfile, docker-compose.yml, supervisord.conf - Add postgres/postgresql.conf tuned for 4GB RAM (Synology DS1513+) - Add .dockerignore, .env.docker.example, secrets template - Update requirements.txt (psycopg2-binary), .gitignore - Add MIGRATION_PLAN.md with full plan and todo list
49 lines
776 B
Plaintext
49 lines
776 B
Plaintext
# --- Secrets & Environment ---
|
|
# Ignore local environment variables
|
|
.env
|
|
# Ignore virtual environment folders
|
|
.venv/
|
|
venv/
|
|
|
|
# --- Python ---
|
|
# Ignore cache files
|
|
__pycache__/
|
|
*.py[cod]
|
|
|
|
# --- Data & Logs ---
|
|
# Ignore all database files (db, write-ahead log, shared memory)
|
|
_data/*.db
|
|
_data/*.db-shm
|
|
_data/*.db-wal
|
|
|
|
# Ignore all JSON files in the data folder
|
|
_data/*.json
|
|
|
|
# Ignore all log files
|
|
_logs/
|
|
|
|
# --- SDK ---
|
|
# Ignore all contents of the sdk directory
|
|
sdk/
|
|
|
|
# --- Other ---
|
|
# Ignore custom agents directory
|
|
agents/
|
|
|
|
# Ignore temporary files and examples
|
|
.temp/
|
|
|
|
# Ignore Jekyll files
|
|
.nojekyll
|
|
|
|
# --- Editor & OS Files ---
|
|
# Ignore VSCode, JetBrains, and macOS/Windows system files
|
|
.vscode/
|
|
.idea/
|
|
.DS_Store
|
|
Thumbs.db
|
|
.opencode/
|
|
|
|
# --- Docker ---
|
|
secrets/
|
|
.env.docker |