Script 7723d580c625_copy_private_data_to_private_tables_py
[hide private]
[frames] | no frames]

Source Code for Script script-7723d580c625_copy_private_data_to_private_tables_py

 1  """copy private data to private tables 
 2   
 3  Revision ID: 7723d580c625 
 4  Revises: 29c352bde564 
 5  Create Date: 2018-12-03 13:49:15.501999 
 6   
 7  """ 
 8   
 9  # revision identifiers, used by Alembic. 
10  revision = '7723d580c625' 
11  down_revision = '29c352bde564' 
12   
13  from alembic import op 
14  import sqlalchemy as sa 
15   
16   
17 -def upgrade():
18 session = sa.orm.sessionmaker(bind=op.get_bind())() 19 session.execute("""INSERT INTO copr_private(webhook_secret, scm_api_auth_json, copr_id) 20 (select webhook_secret, scm_api_auth_json, id from copr);""") 21 session.execute("""INSERT INTO user_private(mail, timezone, api_login, api_token, api_token_expiration, user_id) 22 (select mail, timezone, api_login, api_token, api_token_expiration, id as user_id from \"user\");""")
23
24 -def downgrade():
25 # no downgrade 26 pass
27