forked from mtusi2026/mtusi2026lab4
36 lines
1.1 KiB
Python
36 lines
1.1 KiB
Python
from pathlib import Path
|
|
|
|
import psycopg
|
|
|
|
from app.settings import database_connection
|
|
|
|
|
|
def main() -> None:
|
|
migration_dir = Path(__file__).with_name("migrations")
|
|
with psycopg.connect(**database_connection(), autocommit=False) as connection:
|
|
connection.execute(
|
|
"""
|
|
CREATE TABLE IF NOT EXISTS schema_migrations (
|
|
version varchar(255) PRIMARY KEY,
|
|
applied_at timestamptz NOT NULL DEFAULT clock_timestamp()
|
|
)
|
|
"""
|
|
)
|
|
for migration in sorted(migration_dir.glob("*.sql")):
|
|
already_applied = connection.execute(
|
|
"SELECT 1 FROM schema_migrations WHERE version = %s",
|
|
(migration.name,),
|
|
).fetchone()
|
|
if already_applied:
|
|
continue
|
|
connection.execute(migration.read_text(encoding="utf-8"))
|
|
connection.execute(
|
|
"INSERT INTO schema_migrations (version) VALUES (%s)",
|
|
(migration.name,),
|
|
)
|
|
connection.commit()
|
|
|
|
|
|
if __name__ == "__main__":
|
|
main()
|