generated from dopt-python/py311
20 lines
377 B
Python
20 lines
377 B
Python
# %%
|
|
import sqlalchemy as sql
|
|
|
|
from wce_crm import db
|
|
|
|
# %%
|
|
stmt = sql.text(
|
|
"ALTER TABLE grunderfassung_unternehmen ADD COLUMN Metadaten_wiedereintrittsdatum DATE"
|
|
)
|
|
|
|
with db.ENGINE.begin() as conn:
|
|
conn.execute(stmt)
|
|
|
|
# %%
|
|
stmt = sql.text("ALTER TABLE grunderfassung_unternehmen RENAME TO grunderfassung")
|
|
|
|
with db.ENGINE.begin() as conn:
|
|
conn.execute(stmt)
|
|
# %%
|