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
10 revision = '3637b9daf7e4'
11 down_revision = 'ac5917e5c4fe'
12
13 from alembic import op
14 import sqlalchemy as sa
15
16
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
35