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
10 revision = '7723d580c625'
11 down_revision = '29c352bde564'
12
13 from alembic import op
14 import sqlalchemy as sa
15
16
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
27