1 """add login_attemps and locked_at field to user table
2
3 Revision ID: 188374910655
4 Revises: f30cf048c228
5 Create Date: 2022-08-12 19:05:59.776361
6
7 """
8
9 import sqlalchemy as sa 1 ctx 1a
10
11 from alembic import op 1 ctx 1a
12
13 # revision identifiers, used by Alembic.
14 revision = "188374910655" 1 ctx 1a
15 down_revision = "f30cf048c228" 1 ctx 1a
16 branch_labels : str | tuple [ str , ... ] | None = None 1 ctx 1a
17 depends_on : str | tuple [ str , ... ] | None = None 1 ctx 1a
18
19
20 def upgrade ( ) : 1 ctx 1a
21 op . add_column ( "users" , sa . Column ( "login_attemps" , sa . Integer ( ) , nullable = True ) ) 1 ctx 1a
22 op . add_column ( "users" , sa . Column ( "locked_at" , sa . DateTime ( ) , nullable = True ) ) 1 ctx 1a
23
24
25 def downgrade ( ) : 1 ctx 1a
26 op . drop_column ( "users" , "locked_at" )
27 op . drop_column ( "users" , "login_attemps" )