Module dabab11132c1_initial_db_setup
[hide private]
[frames] | no frames]

Source Code for Module dabab11132c1_initial_db_setup

  1  """Initial DB setup 
  2   
  3  Revision ID: dabab11132c1 
  4  Revises: None 
  5  Create Date: 2018-09-04 09:58:36.678749 
  6   
  7  """ 
  8   
  9  # revision identifiers, used by Alembic. 
 10  revision = 'dabab11132c1' 
 11  down_revision = None 
 12   
 13  from alembic import op 
 14  import sqlalchemy as sa 
 15   
 16  import sys, os 
 17  sys.path.append(os.getcwd()) 
 18  import coprs 
 19   
 20   
21 -def upgrade():
22 # ### commands auto generated by Alembic - please adjust! ### 23 op.create_table('action', 24 sa.Column('id', sa.Integer(), nullable=False), 25 sa.Column('action_type', sa.Integer(), nullable=False), 26 sa.Column('object_type', sa.String(length=20), nullable=True), 27 sa.Column('object_id', sa.Integer(), nullable=True), 28 sa.Column('old_value', sa.String(length=255), nullable=True), 29 sa.Column('new_value', sa.String(length=255), nullable=True), 30 sa.Column('data', sa.Text(), nullable=True), 31 sa.Column('result', sa.Integer(), nullable=True), 32 sa.Column('message', sa.Text(), nullable=True), 33 sa.Column('created_on', sa.Integer(), nullable=True), 34 sa.Column('ended_on', sa.Integer(), nullable=True), 35 sa.PrimaryKeyConstraint('id') 36 ) 37 op.create_table('counter_stat', 38 sa.Column('name', sa.String(length=127), nullable=False), 39 sa.Column('counter_type', sa.String(length=30), nullable=True), 40 sa.Column('counter', sa.Integer(), server_default='0', nullable=True), 41 sa.PrimaryKeyConstraint('name') 42 ) 43 op.create_table('group', 44 sa.Column('id', sa.Integer(), nullable=False), 45 sa.Column('name', sa.String(length=127), nullable=True), 46 sa.Column('fas_name', sa.String(length=127), nullable=True), 47 sa.PrimaryKeyConstraint('id') 48 ) 49 op.create_table('mock_chroot', 50 sa.Column('id', sa.Integer(), nullable=False), 51 sa.Column('os_release', sa.String(length=50), nullable=False), 52 sa.Column('os_version', sa.String(length=50), nullable=False), 53 sa.Column('arch', sa.String(length=50), nullable=False), 54 sa.Column('is_active', sa.Boolean(), nullable=True), 55 sa.PrimaryKeyConstraint('id') 56 ) 57 op.create_table('user', 58 sa.Column('id', sa.Integer(), nullable=False), 59 sa.Column('username', sa.String(length=100), nullable=False), 60 sa.Column('mail', sa.String(length=150), nullable=False), 61 sa.Column('timezone', sa.String(length=50), nullable=True), 62 sa.Column('proven', sa.Boolean(), nullable=True), 63 sa.Column('admin', sa.Boolean(), nullable=True), 64 sa.Column('api_login', sa.String(length=40), nullable=False), 65 sa.Column('api_token', sa.String(length=40), nullable=False), 66 sa.Column('api_token_expiration', sa.Date(), nullable=False), 67 sa.Column('openid_groups', coprs.helpers.JSONEncodedDict(), nullable=True), 68 sa.PrimaryKeyConstraint('id'), 69 sa.UniqueConstraint('username') 70 ) 71 op.create_table('copr', 72 sa.Column('id', sa.Integer(), nullable=False), 73 sa.Column('name', sa.String(length=100), nullable=False), 74 sa.Column('homepage', sa.Text(), nullable=True), 75 sa.Column('contact', sa.Text(), nullable=True), 76 sa.Column('repos', sa.Text(), nullable=True), 77 sa.Column('created_on', sa.Integer(), nullable=True), 78 sa.Column('description', sa.Text(), nullable=True), 79 sa.Column('instructions', sa.Text(), nullable=True), 80 sa.Column('deleted', sa.Boolean(), nullable=True), 81 sa.Column('playground', sa.Boolean(), nullable=True), 82 sa.Column('auto_createrepo', sa.Boolean(), nullable=True), 83 sa.Column('user_id', sa.Integer(), nullable=True), 84 sa.Column('group_id', sa.Integer(), nullable=True), 85 sa.Column('forked_from_id', sa.Integer(), nullable=True), 86 sa.Column('webhook_secret', sa.String(length=100), nullable=True), 87 sa.Column('build_enable_net', sa.Boolean(), server_default='1', nullable=False), 88 sa.Column('unlisted_on_hp', sa.Boolean(), nullable=False), 89 sa.Column('latest_indexed_data_update', sa.Integer(), nullable=True), 90 sa.Column('persistent', sa.Boolean(), server_default='0', nullable=False), 91 sa.Column('auto_prune', sa.Boolean(), server_default='1', nullable=False), 92 sa.ForeignKeyConstraint(['forked_from_id'], ['copr.id'], ), 93 sa.ForeignKeyConstraint(['group_id'], ['group.id'], ), 94 sa.ForeignKeyConstraint(['user_id'], ['user.id'], ), 95 sa.PrimaryKeyConstraint('id') 96 ) 97 op.create_table('krb5_login', 98 sa.Column('user_id', sa.Integer(), nullable=False), 99 sa.Column('config_name', sa.String(length=30), nullable=False), 100 sa.Column('primary', sa.String(length=80), nullable=False), 101 sa.ForeignKeyConstraint(['user_id'], ['user.id'], ), 102 sa.PrimaryKeyConstraint('config_name', 'primary') 103 ) 104 op.create_table('copr_chroot', 105 sa.Column('buildroot_pkgs', sa.Text(), nullable=True), 106 sa.Column('mock_chroot_id', sa.Integer(), nullable=False), 107 sa.Column('copr_id', sa.Integer(), nullable=False), 108 sa.Column('comps_zlib', sa.LargeBinary(), nullable=True), 109 sa.Column('comps_name', sa.String(length=127), nullable=True), 110 sa.Column('module_md_zlib', sa.LargeBinary(), nullable=True), 111 sa.Column('module_md_name', sa.String(length=127), nullable=True), 112 sa.ForeignKeyConstraint(['copr_id'], ['copr.id'], ), 113 sa.ForeignKeyConstraint(['mock_chroot_id'], ['mock_chroot.id'], ), 114 sa.PrimaryKeyConstraint('mock_chroot_id', 'copr_id') 115 ) 116 op.create_table('copr_permission', 117 sa.Column('copr_builder', sa.SmallInteger(), nullable=True), 118 sa.Column('copr_admin', sa.SmallInteger(), nullable=True), 119 sa.Column('user_id', sa.Integer(), nullable=False), 120 sa.Column('copr_id', sa.Integer(), nullable=False), 121 sa.ForeignKeyConstraint(['copr_id'], ['copr.id'], ), 122 sa.ForeignKeyConstraint(['user_id'], ['user.id'], ), 123 sa.PrimaryKeyConstraint('user_id', 'copr_id') 124 ) 125 op.create_table('legal_flag', 126 sa.Column('id', sa.Integer(), nullable=False), 127 sa.Column('raise_message', sa.Text(), nullable=True), 128 sa.Column('raised_on', sa.Integer(), nullable=True), 129 sa.Column('resolved_on', sa.Integer(), nullable=True), 130 sa.Column('copr_id', sa.Integer(), nullable=True), 131 sa.Column('reporter_id', sa.Integer(), nullable=True), 132 sa.Column('resolver_id', sa.Integer(), nullable=True), 133 sa.ForeignKeyConstraint(['copr_id'], ['copr.id'], ), 134 sa.ForeignKeyConstraint(['reporter_id'], ['user.id'], ), 135 sa.ForeignKeyConstraint(['resolver_id'], ['user.id'], ), 136 sa.PrimaryKeyConstraint('id') 137 ) 138 op.create_table('module', 139 sa.Column('id', sa.Integer, primary_key=True), 140 sa.Column('name', sa.String(100), nullable=False), 141 sa.Column('stream', sa.String(100), nullable=False), 142 sa.Column('version', sa.BigInteger, nullable=False), 143 sa.Column('summary', sa.String(100), nullable=False), 144 sa.Column('description', sa.Text), 145 sa.Column('created_on', sa.Integer, nullable=True), 146 sa.Column('yaml_b64', sa.Text), 147 sa.Column('copr_id', sa.Integer, sa.ForeignKey('copr.id')), 148 ) 149 op.create_table('package', 150 sa.Column('id', sa.Integer(), nullable=False), 151 sa.Column('name', sa.String(length=100), nullable=False), 152 sa.Column('source_type', sa.Integer(), nullable=True), 153 sa.Column('source_json', sa.Text(), nullable=True), 154 sa.Column('webhook_rebuild', sa.Boolean(), nullable=True), 155 sa.Column('enable_net', sa.Boolean(), server_default='0', nullable=False), 156 sa.Column('old_status', sa.Integer(), nullable=True), 157 sa.Column('copr_id', sa.Integer(), nullable=True), 158 sa.ForeignKeyConstraint(['copr_id'], ['copr.id'], ), 159 sa.PrimaryKeyConstraint('id'), 160 sa.UniqueConstraint('copr_id', 'name', name='packages_copr_pkgname') 161 ) 162 op.create_table('build', 163 sa.Column('id', sa.Integer(), nullable=False), 164 sa.Column('pkgs', sa.Text(), nullable=True), 165 sa.Column('built_packages', sa.Text(), nullable=True), 166 sa.Column('pkg_version', sa.Text(), nullable=True), 167 sa.Column('canceled', sa.Boolean(), nullable=True), 168 sa.Column('repos', sa.Text(), nullable=True), 169 sa.Column('submitted_on', sa.Integer(), nullable=False), 170 sa.Column('results', sa.Text(), nullable=True), 171 sa.Column('memory_reqs', sa.Integer(), nullable=True), 172 sa.Column('timeout', sa.Integer(), nullable=True), 173 sa.Column('enable_net', sa.Boolean(), server_default='0', nullable=False), 174 sa.Column('source_type', sa.Integer(), nullable=True), 175 sa.Column('source_json', sa.Text(), nullable=True), 176 sa.Column('fail_type', sa.Integer(), nullable=True), 177 sa.Column('is_background', sa.Boolean(), server_default='0', nullable=False), 178 sa.Column('user_id', sa.Integer(), nullable=True), 179 sa.Column('copr_id', sa.Integer(), nullable=True), 180 sa.Column('package_id', sa.Integer(), nullable=True), 181 sa.ForeignKeyConstraint(['copr_id'], ['copr.id'], ), 182 sa.ForeignKeyConstraint(['package_id'], ['package.id'], ), 183 sa.ForeignKeyConstraint(['user_id'], ['user.id'], ), 184 sa.PrimaryKeyConstraint('id') 185 ) 186 op.create_index('build_canceled', 'build', ['canceled'], unique=False) 187 op.create_table('build_chroot', 188 sa.Column('mock_chroot_id', sa.Integer(), nullable=False), 189 sa.Column('build_id', sa.Integer(), nullable=False), 190 sa.Column('git_hash', sa.String(length=40), nullable=True), 191 sa.Column('status', sa.Integer(), nullable=True), 192 sa.Column('started_on', sa.Integer(), nullable=True), 193 sa.Column('ended_on', sa.Integer(), nullable=True), 194 sa.Column('last_deferred', sa.Integer(), nullable=True), 195 sa.ForeignKeyConstraint(['build_id'], ['build.id'], ), 196 sa.ForeignKeyConstraint(['mock_chroot_id'], ['mock_chroot.id'], ), 197 sa.PrimaryKeyConstraint('mock_chroot_id', 'build_id') 198 ) 199 op.create_index(op.f('ix_build_chroot_ended_on'), 'build_chroot', ['ended_on'], unique=False)
200 # ### end Alembic commands ### 201 202
203 -def downgrade():
204 pass
205