"""last_edit_at

Revision ID: 9576c33caf0f
Revises: 95d02e1fbed9
Create Date: 2023-02-08 12:38:21.826682

"""
from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects import postgresql

from migrations.utils import get_table

# revision identifiers, used by Alembic.
revision = '9576c33caf0f'
down_revision = '95d02e1fbed9'
branch_labels = None
depends_on = None


def upgrade():
    op.add_column('Project', sa.Column('last_edit_at', sa.TIMESTAMP(timezone=True), server_default=sa.text('CURRENT_TIMESTAMP'), nullable=False))
    bind = op.get_bind()
    project = get_table(bind, "Project")
    op.execute(project.update().values(last_edit_at=project.c.updated_at))


def downgrade():
    op.drop_column('Project', 'last_edit_at')