Script 3637b9daf7e4_generate_main_copr_dirs_py
[hide private]
[frames] | no frames]

Source Code for Script script-3637b9daf7e4_generate_main_copr_dirs_py

 1  """generate main copr_dirs 
 2   
 3  Revision ID: 3637b9daf7e4 
 4  Revises: ac5917e5c4fe 
 5  Create Date: 2018-06-25 23:18:56.969792 
 6   
 7  """ 
 8   
 9  # revision identifiers, used by Alembic. 
10  revision = '3637b9daf7e4' 
11  down_revision = 'ac5917e5c4fe' 
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 20 session.execute("""INSERT INTO copr_dir (name,copr_id,ownername,main) 21 (SELECT copr.name,copr.id,concat('@', "group".name),True FROM copr JOIN "group" ON copr.group_id = "group".id WHERE copr.deleted=False) 22 ON CONFLICT DO NOTHING;""") 23 24 session.execute(""" 25 INSERT INTO copr_dir (name,copr_id,ownername,main) 26 (SELECT copr.name,copr.id,username,True FROM copr JOIN "user" ON copr.user_id = "user".id WHERE copr.deleted=False AND copr.group_id is NULL) 27 ON CONFLICT DO NOTHING;""") 28 29 session.execute("""UPDATE package SET copr_dir_id=(SELECT id from copr_dir where copr_dir.copr_id=package.copr_id AND copr_dir.main=True) WHERE copr_dir_id is NULL""") 30 session.execute("""UPDATE build SET copr_dir_id=(SELECT id from copr_dir where copr_dir.copr_id=build.copr_id AND copr_dir.main=True) WHERE copr_dir_id is NULL""")
31 32
33 -def downgrade():
34 pass
35