migrations/versions/0065_users_current_session_id.py

"""empty message

Revision ID: 0065_users_current_session_id
Revises: 0064_update_template_process
Create Date: 2017-02-17 11:48:40.669235

"""

# revision identifiers, used by Alembic.
revision = "0065_users_current_session_id"
down_revision = "0064_update_template_process"

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


def upgrade():
    op.add_column(
        "users",
        sa.Column("current_session_id", postgresql.UUID(as_uuid=True), nullable=True),
    )


def downgrade():
    op.drop_column("users", "current_session_id")
Add current_session_id to the user model, update on login when we change the last logged in time, set the current session id to a random uuid this way, we can compare it to the cookie a user has, and if they differ then we can log them out also update user.logged_in_at at 2FA rather than password check, since that feels more accurate 2017-02-17 14:06:16 +00:00			`"""empty message`

			`Revision ID: 0065_users_current_session_id`
			`Revises: 0064_update_template_process`
			`Create Date: 2017-02-17 11:48:40.669235`

			`"""`

			`# revision identifiers, used by Alembic.`
reformat 2023-08-29 14:54:30 -07:00			`revision = "0065_users_current_session_id"`
			`down_revision = "0064_update_template_process"`
Add current_session_id to the user model, update on login when we change the last logged in time, set the current session id to a random uuid this way, we can compare it to the cookie a user has, and if they differ then we can log them out also update user.logged_in_at at 2FA rather than password check, since that feels more accurate 2017-02-17 14:06:16 +00:00
			`import sqlalchemy as sa`
black, isort, flake8 Signed-off-by: Cliff Hill <Clifford.hill@gsa.gov> 2023-12-08 21:43:52 -05:00			`from alembic import op`
Add current_session_id to the user model, update on login when we change the last logged in time, set the current session id to a random uuid this way, we can compare it to the cookie a user has, and if they differ then we can log them out also update user.logged_in_at at 2FA rather than password check, since that feels more accurate 2017-02-17 14:06:16 +00:00			`from sqlalchemy.dialects import postgresql`

reformat 2023-08-29 14:54:30 -07:00
Add current_session_id to the user model, update on login when we change the last logged in time, set the current session id to a random uuid this way, we can compare it to the cookie a user has, and if they differ then we can log them out also update user.logged_in_at at 2FA rather than password check, since that feels more accurate 2017-02-17 14:06:16 +00:00			`def upgrade():`
reformat 2023-08-29 14:54:30 -07:00			`op.add_column(`
			`"users",`
			`sa.Column("current_session_id", postgresql.UUID(as_uuid=True), nullable=True),`
			`)`
Add current_session_id to the user model, update on login when we change the last logged in time, set the current session id to a random uuid this way, we can compare it to the cookie a user has, and if they differ then we can log them out also update user.logged_in_at at 2FA rather than password check, since that feels more accurate 2017-02-17 14:06:16 +00:00

			`def downgrade():`
reformat 2023-08-29 14:54:30 -07:00			`op.drop_column("users", "current_session_id")`