Developer
070cd4d5a5
Add generated .pi-map.md and .pi-map.index.md files across the repository so the project navigation maps are shared and versioned. These artifacts are maintained by project_map_init/patch/validate and must be kept in sync with source edits. Note: .cache/ remains ignored (added in previous commit).
27 lines
1.2 KiB
Markdown
27 lines
1.2 KiB
Markdown
# scripts
|
|
dir: scripts
|
|
|
|
index: scripts/.pi-map.index.md
|
|
|
|
## role
|
|
Operational utility scripts for database maintenance and security management in containerized production environments.
|
|
## files
|
|
- fix_ghost_migration.sh | Diagnoses a "ghost" Alembic migration issue by checking for orphaned migration files, database version state, and column existence in a production environment. | dep: bash, find, psql, grep
|
|
- update_db_password.py | Securely update the PostgreSQL password for the 'headquarter' database user via a Docker container | exp: func:main() → None, call:getpass.getpass, call:print, call:sys.exit, call:subprocess.run, call:result.stdout.strip | dep: getpass, subprocess, sys
|
|
## arch
|
|
Standalone imperative shell scripts and Python scripts using subprocess calls to Docker CLI for container orchestration, with direct database connectivity via SQLAlchemy/Alembic for schema introspection and PostgreSQL for credential updates.
|
|
## tags
|
|
migration, ghost, update, password, database, fix, main, call:getpass.getpass
|
|
## symbols
|
|
- main
|
|
- call:getpass.getpass
|
|
- call:print
|
|
- call:sys.exit
|
|
- call:subprocess.run
|
|
- call:result.stdout.strip
|
|
## workflows
|
|
- change scripts behavior
|
|
read: fix_ghost_migration.sh, update_db_password.py
|
|
## dirty
|
|
-
|