administrator
29 lines
696 B
Python
29 lines
696 B
Python
"""
|
|
migrate_add_wanted.py — přidá sloupec wanted BOOLEAN NOT NULL DEFAULT FALSE do tabulky photos.
|
|
Bezpečné spustit vícekrát (idempotentní).
|
|
"""
|
|
|
|
import psycopg2
|
|
|
|
DB = dict(host="192.168.1.76", port=5432, user="vladimir.buzalka",
|
|
password="Vlado7309208104++", database="fotky_buzalkovi")
|
|
|
|
SQL = """
|
|
ALTER TABLE photos
|
|
ADD COLUMN IF NOT EXISTS wanted BOOLEAN NOT NULL DEFAULT FALSE;
|
|
"""
|
|
|
|
conn = psycopg2.connect(**DB)
|
|
conn.autocommit = True
|
|
cur = conn.cursor()
|
|
|
|
print("Přidávám sloupec wanted…")
|
|
cur.execute(SQL)
|
|
print("Hotovo.")
|
|
|
|
cur.execute("SELECT COUNT(*) FROM photos WHERE wanted = FALSE")
|
|
n = cur.fetchone()[0]
|
|
print(f"Fotek s wanted=FALSE: {n:,}")
|
|
|
|
conn.close()
|