def upgrade():
    op.create_table(
        'itemstat', sa.Column('id', sa.GUID(), nullable=False),
        sa.Column('item_id', sa.GUID(), nullable=False),
        sa.Column('name', sa.String(length=64), nullable=False),
        sa.Column('value', sa.Integer(), nullable=False),
        sa.PrimaryKeyConstraint('id'),
        sa.UniqueConstraint('item_id', 'name', name='unq_itemstat_name'))
def upgrade():
    op.create_table('adminmessage', sa.Column('id', sa.GUID(), nullable=False),
                    sa.Column('user_id', sa.GUID(), nullable=True),
                    sa.Column('date_created', sa.DateTime(), nullable=True),
                    sa.Column('message', sa.Text(), nullable=True),
                    sa.ForeignKeyConstraint(
                        ['user_id'],
                        ['user.id'],
                    ), sa.PrimaryKeyConstraint('id'))
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table(
        'itemoption', sa.Column('id', sa.GUID(), nullable=False),
        sa.Column('item_id', sa.GUID(), nullable=False),
        sa.Column('name', sa.String(length=64), nullable=False),
        sa.Column('value', sa.Text(), nullable=False),
        sa.Column('date_created', sa.DateTime(), nullable=False),
        sa.PrimaryKeyConstraint('id'),
        sa.UniqueConstraint('item_id', 'name', name='unq_itemoption_name'))
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table(
        'event', sa.Column('id', sa.GUID(), nullable=False),
        sa.Column('type', sa.String(length=32), nullable=False),
        sa.Column('item_id', sa.GUID(), nullable=False),
        sa.Column('date_created', sa.DateTime(), nullable=True),
        sa.Column('date_modified', sa.DateTime(), nullable=True),
        sa.Column('data', sa.JSONEncodedDict(), nullable=True),
        sa.PrimaryKeyConstraint('id'),
        sa.UniqueConstraint('type', 'item_id', name='unq_event_key'))
def upgrade():
    op.create_table('project_plan',
                    sa.Column('project_id', sa.GUID(), nullable=False),
                    sa.Column('plan_id', sa.GUID(), nullable=False),
                    sa.ForeignKeyConstraint(
                        ['plan_id'],
                        ['plan.id'],
                    ), sa.ForeignKeyConstraint(
                        ['project_id'],
                        ['project.id'],
                    ), sa.PrimaryKeyConstraint('project_id', 'plan_id'))
def upgrade():
    op.create_table(
        'latest_green_build',
        sa.Column('id', sa.GUID(), nullable=False),
        sa.Column('project_id', sa.GUID(), nullable=False),
        sa.Column('branch', sa.String(length=128), nullable=False),
        sa.Column('build_id', sa.GUID(), nullable=False),
        sa.PrimaryKeyConstraint('id'),
        sa.ForeignKeyConstraint(['project_id'], ['project.id'], ),
        sa.ForeignKeyConstraint(['build_id'], ['build.id'], ),
        sa.UniqueConstraint('project_id', 'branch', name='unq_project_branch')
    )
def upgrade():
    op.create_table(
        'buildphase', sa.Column('id', sa.GUID(), nullable=False),
        sa.Column('build_id', sa.GUID(), nullable=False),
        sa.Column('repository_id', sa.GUID(), nullable=False),
        sa.Column('project_id', sa.GUID(), nullable=False),
        sa.Column('label', sa.String(length=128), nullable=False),
        sa.Column('status', sa.Enum(), nullable=False),
        sa.Column('result', sa.Enum(), nullable=False),
        sa.Column('date_started', sa.DateTime(), nullable=True),
        sa.Column('date_finished', sa.DateTime(), nullable=True),
        sa.Column('date_created', sa.DateTime(), nullable=True),
        sa.ForeignKeyConstraint(
            ['build_id'],
            ['build.id'],
        ), sa.ForeignKeyConstraint(
            ['project_id'],
            ['project.id'],
        ), sa.ForeignKeyConstraint(
            ['repository_id'],
            ['repository.id'],
        ), sa.PrimaryKeyConstraint('id'))
    op.create_table(
        'buildstep', sa.Column('id', sa.GUID(), nullable=False),
        sa.Column('build_id', sa.GUID(), nullable=False),
        sa.Column('phase_id', sa.GUID(), nullable=False),
        sa.Column('repository_id', sa.GUID(), nullable=False),
        sa.Column('project_id', sa.GUID(), nullable=False),
        sa.Column('label', sa.String(length=128), nullable=False),
        sa.Column('status', sa.Enum(), nullable=False),
        sa.Column('result', sa.Enum(), nullable=False),
        sa.Column('node_id', sa.GUID(), nullable=True),
        sa.Column('date_started', sa.DateTime(), nullable=True),
        sa.Column('date_finished', sa.DateTime(), nullable=True),
        sa.Column('date_created', sa.DateTime(), nullable=True),
        sa.ForeignKeyConstraint(
            ['build_id'],
            ['build.id'],
        ), sa.ForeignKeyConstraint(
            ['node_id'],
            ['node.id'],
        ), sa.ForeignKeyConstraint(
            ['phase_id'],
            ['buildphase.id'],
        ), sa.ForeignKeyConstraint(
            ['project_id'],
            ['project.id'],
        ), sa.ForeignKeyConstraint(
            ['repository_id'],
            ['repository.id'],
        ), sa.PrimaryKeyConstraint('id'))
    op.drop_table(u'step')
    op.drop_table(u'phase')
Exemplo n.º 8
0
def upgrade():
    op.create_table(
        'snapshot', sa.Column('id', sa.GUID(), nullable=False),
        sa.Column('project_id', sa.GUID(), nullable=False),
        sa.Column('build_id', sa.GUID(), nullable=True),
        sa.Column('status', sa.Enum(), server_default='0', nullable=False),
        sa.ForeignKeyConstraint(
            ['build_id'],
            ['build.id'],
        ),
        sa.ForeignKeyConstraint(['project_id'], ['project.id'],
                                ondelete='CASCADE'),
        sa.PrimaryKeyConstraint('id'))
def upgrade():
    op.create_table(
        'comment', sa.Column('id', sa.GUID(), nullable=False),
        sa.Column('build_id', sa.GUID(), nullable=False),
        sa.Column('user_id', sa.GUID(), nullable=False),
        sa.Column('job_id', sa.GUID(), nullable=True),
        sa.Column('text', sa.Text(), nullable=True),
        sa.Column('date_created', sa.DateTime(), nullable=True),
        sa.ForeignKeyConstraint(['build_id'], ['build.id'],
                                ondelete='CASCADE'),
        sa.ForeignKeyConstraint(['job_id'], ['job.id'], ondelete='CASCADE'),
        sa.ForeignKeyConstraint(['user_id'], ['user.id'], ondelete='CASCADE'),
        sa.PrimaryKeyConstraint('id'))
def upgrade():
    op.create_table(
        'bazeltarget', sa.Column('id', sa.GUID(), nullable=False),
        sa.Column('step_id', sa.GUID(), nullable=False),
        sa.Column('job_id', sa.GUID(), nullable=False),
        sa.Column('name', sa.Text(), nullable=False),
        sa.Column('status', sa.Enum(), nullable=False),
        sa.Column('result', sa.Enum(), nullable=False),
        sa.Column('duration', sa.Integer(), nullable=True),
        sa.Column('date_created', sa.DateTime(), nullable=False),
        sa.ForeignKeyConstraint(['step_id'], ['jobstep.id'],
                                ondelete='CASCADE'),
        sa.ForeignKeyConstraint(['job_id'], ['job.id'], ondelete='CASCADE'),
        sa.PrimaryKeyConstraint('id'))
def upgrade():
    op.create_table(
        'projectoption', sa.Column('id', sa.GUID(), nullable=False),
        sa.Column('project_id', sa.GUID(), nullable=False),
        sa.Column('name', sa.String(length=64), nullable=False),
        sa.Column('value', sa.Text(), nullable=False),
        sa.Column('date_created', sa.DateTime(), nullable=False),
        sa.ForeignKeyConstraint(
            ['project_id'],
            ['project.id'],
        ), sa.PrimaryKeyConstraint('id'),
        sa.UniqueConstraint('project_id',
                            'name',
                            name='unq_projectoption_name'))
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('phabricatordiff',
                    sa.Column('id', sa.GUID(), nullable=False),
                    sa.Column('diff_id', sa.Integer(), nullable=True),
                    sa.Column('revision_id', sa.Integer(), nullable=True),
                    sa.Column('source_id', sa.GUID(), nullable=True),
                    sa.Column('url', sa.String(), nullable=True),
                    sa.Column('date_created', sa.DateTime(), nullable=True),
                    sa.ForeignKeyConstraint(
                        ['source_id'],
                        ['source.id'],
                    ), sa.PrimaryKeyConstraint('id'),
                    sa.UniqueConstraint('diff_id'))
Exemplo n.º 13
0
def upgrade():
    op.create_table(
        'source', sa.Column('id', sa.GUID(), nullable=False),
        sa.Column('repository_id', sa.GUID(), nullable=False),
        sa.Column('patch_id', sa.GUID(), nullable=True),
        sa.Column('revision_sha', sa.String(length=40), nullable=True),
        sa.Column('date_created', sa.DateTime(), nullable=True),
        sa.ForeignKeyConstraint(['patch_id'], ['patch.id']),
        sa.ForeignKeyConstraint(['repository_id'], ['repository.id']),
        sa.PrimaryKeyConstraint('id'))
    op.add_column('build', sa.Column('source_id', sa.GUID(), nullable=True))
    op.add_column('buildfamily',
                  sa.Column('source_id', sa.GUID(), nullable=True))
    op.create_index('idx_build_source_id', 'build', ['source_id'])
    op.create_index('idx_buildfamily_source_id', 'buildfamily', ['source_id'])
Exemplo n.º 14
0
def upgrade():
    connection = op.get_bind()

    logsources_table = table(
        'logsource',
        sa.Column('id', sa.GUID(), nullable=False),
        sa.Column('build_id', sa.GUID(), nullable=False),
        sa.Column('name', sa.String(64), nullable=True),
    )
    logchunks_table = table(
        'logchunk',
        sa.Column('source_id', sa.GUID(), nullable=False),
    )

    done = set()

    for logsource in connection.execute(logsources_table.select()):
        # migrate group to suite
        key = (logsource.build_id, logsource.name)
        if key in done:
            continue

        print("Checking LogSource %s - %s" %
              (logsource.build_id, logsource.name))
        query = logchunks_table.delete().where(
            logchunks_table.c.source_id.in_(
                select([logchunks_table]).where(
                    sa.and_(
                        logsources_table.c.build_id == logsource.build_id,
                        logsources_table.c.name == logsource.name,
                        logsources_table.c.id != logsource.id,
                    ), )))
        connection.execute(query)

        query = logsources_table.delete().where(
            sa.and_(
                logsources_table.c.build_id == logsource.build_id,
                logsources_table.c.name == logsource.name,
                logsources_table.c.id != logsource.id,
            ))

        connection.execute(query)

        done.add(key)

    op.create_unique_constraint('unq_logsource_key', 'logsource',
                                ['build_id', 'name'])
    op.drop_index('idx_logsource_build_id', 'logsource')
Exemplo n.º 15
0
def upgrade():
    op.add_column(
        'travels',
        sa.Column('traveller_data_id',
                  sa.GUID(),
                  sa.ForeignKey('traveller_data.id', ondelete='CASCADE'),
                  nullable=False))
Exemplo n.º 16
0
def upgrade():
    op.add_column(
        'employee_travel_history',
        sa.Column('inbound_trip_id',
                  sa.GUID(),
                  sa.ForeignKey('travels.id', ondelete='CASCADE'),
                  nullable=True))
def upgrade():
    op.create_table(
        'testartifact',
        sa.Column('id', sa.GUID(), nullable=False),
        sa.Column('test_id', sa.GUID(), nullable=False),
        sa.Column('name', sa.String(length=256), nullable=False),
        sa.Column('type', sa.Enum(), server_default='0', nullable=False),
        sa.Column('file', sa.FileStorage(), nullable=True),
        sa.Column('date_created', sa.DateTime(), nullable=True),
        sa.ForeignKeyConstraint(
            ['test_id'],
            ['test.id'],
        ),
        sa.PrimaryKeyConstraint('id'),
        sa.Index('idx_test_id', 'test_id'),
    )
Exemplo n.º 18
0
def upgrade():
    op.create_table('user', sa.Column('id', sa.GUID(), nullable=False),
                    sa.Column('email', sa.String(length=128), nullable=False),
                    sa.Column('is_admin', sa.Boolean(), nullable=False),
                    sa.Column('date_created', sa.DateTime(), nullable=True),
                    sa.PrimaryKeyConstraint('id'),
                    sa.UniqueConstraint('email'))
def upgrade():
    op.add_column(
        'jobplan',
        sa.Column('snapshot_image_id',
                  sa.GUID(),
                  sa.ForeignKey('snapshot_image.id', ondelete="RESTRICT"),
                  nullable=True))
Exemplo n.º 20
0
def upgrade():
    op.create_table(
        'testmessage',
        sa.Column('id', sa.GUID(), nullable=False),
        sa.Column('test_id', sa.GUID(), nullable=False),
        sa.Column('artifact_id', sa.GUID(), nullable=False),
        sa.Column('start_offset', sa.Integer(), nullable=False),
        sa.Column('length', sa.Integer(), nullable=False),
        sa.PrimaryKeyConstraint('id'),
        sa.ForeignKeyConstraint(['test_id'], ['test.id'], ondelete='CASCADE'),
        sa.ForeignKeyConstraint(['artifact_id'], ['artifact.id'],
                                ondelete='CASCADE'),
    )
    op.create_index('idx_testmessage_test_id',
                    'testmessage', ['test_id'],
                    unique=False)
Exemplo n.º 21
0
def upgrade():
    op.add_column('test', sa.Column('step_id', sa.GUID(), nullable=True))
    op.create_foreign_key('test_step_id_fkey',
                          'test',
                          'jobstep', ['step_id'], ['id'],
                          ondelete='CASCADE')
    op.create_index('idx_test_step_id', 'test', ['step_id'])
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table(
        'snapshot_image',
        sa.Column('id', sa.GUID(), nullable=False),
        sa.Column('snapshot_id', sa.GUID(), nullable=False),
        sa.Column('plan_id', sa.GUID(), nullable=False),
        sa.Column('job_id', sa.GUID(), nullable=True, unique=True),
        sa.Column('date_created', sa.DateTime(), nullable=False),
        sa.ForeignKeyConstraint(['job_id'], ['job.id'], ondelete='CASCADE'),
        sa.ForeignKeyConstraint(['plan_id'], ['plan.id'], ondelete='CASCADE'),
        sa.ForeignKeyConstraint(['snapshot_id'], ['snapshot.id'], ondelete='CASCADE'),
        sa.PrimaryKeyConstraint('id'),
        sa.UniqueConstraint('snapshot_id', 'plan_id', name='unq_snapshotimage_plan')
    )

    op.create_unique_constraint(None, 'snapshot', ['build_id'])
def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table('config',
    sa.Column('key', sa.String(length=255), nullable=False),
    sa.Column('value', sa.String(length=255), nullable=True),
    sa.PrimaryKeyConstraint('key')
    )
    op.create_table('group',
    sa.Column('id', sa.GUID(), autoincrement=False, nullable=False),
    sa.Column('name', sa.String(length=255), nullable=False),
    sa.Column('state', sa.String(length=255), nullable=True),
    sa.Column('created_at', sa.DateTime(), nullable=False),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('user',
    sa.Column('id', sa.GUID(), autoincrement=False, nullable=False),
    sa.Column('first_name', sa.String(length=255), nullable=False),
    sa.Column('last_name', sa.String(length=255), nullable=False),
    sa.Column('gender', sa.String(length=255), nullable=False),
    sa.Column('locale', sa.String(length=255), nullable=False),
    sa.Column('timezone', sa.String(length=255), nullable=False),
    sa.Column('facebook_id', sa.BigInteger(), nullable=False),
    sa.Column('last_interaction', sa.DateTime(), nullable=False),
    sa.Column('state', sa.String(length=255), nullable=True),
    sa.Column('language', sa.String(length=3), nullable=True),
    sa.Column('gid', sa.GUID(), nullable=False),
    sa.ForeignKeyConstraint(['gid'], ['group.id'], ),
    sa.PrimaryKeyConstraint('id'),
    sa.UniqueConstraint('facebook_id')
    )
    op.create_table('data',
    sa.Column('user', sa.GUID(), nullable=False),
    sa.Column('clz', sa.String(length=255), nullable=False),
    sa.Column('value', sa.Text(), nullable=True),
    sa.ForeignKeyConstraint(['user'], ['user.id'], ondelete='CASCADE'),
    sa.PrimaryKeyConstraint('user', 'clz')
    )
    op.create_table('log',
    sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
    sa.Column('user', sa.GUID(), nullable=False),
    sa.Column('direction', sa.String(length=1), nullable=True),
    sa.Column('message', sa.Text(), nullable=True),
    sa.Column('time', sa.DateTime(), nullable=False),
    sa.ForeignKeyConstraint(['user'], ['user.id'], ondelete='CASCADE'),
    sa.PrimaryKeyConstraint('id')
    )
Exemplo n.º 24
0
def downgrade():
    with op.batch_alter_table('employees') as bop:
        bop.drop_column('employee_spreadsheet_id')
        bop.add_column(
            sa.Column('user_id',
                      sa.GUID(),
                      sa.ForeignKey('users.id', ondelete='CASCADE'),
                      nullable=False))
Exemplo n.º 25
0
def upgrade():
    op.create_table(
        'itemsequence', sa.Column('parent_id', sa.GUID(), nullable=False),
        sa.Column('value', sa.Integer(), server_default='1', nullable=False),
        sa.PrimaryKeyConstraint('parent_id', 'value'))
    op.execute(NEXT_ITEM_VALUE_FUNCTION)
    op.execute(ADD_BUILD_SEQUENCES)
    op.execute(ADD_JOB_SEQUENCES)
def upgrade():
    op.create_table('buildmessage',
        sa.Column('id', sa.GUID(), nullable=False),
        sa.Column('build_id', sa.GUID(), nullable=False),
        sa.Column('text', sa.Text(), nullable=False),
        sa.Column('date_created', sa.DateTime(), nullable=False),
        sa.ForeignKeyConstraint(['build_id'], ['build.id'], ondelete='CASCADE'),
        sa.PrimaryKeyConstraint('id')
    )
    op.create_table('bazeltargetmessage',
        sa.Column('id', sa.GUID(), nullable=False),
        sa.Column('target_id', sa.GUID(), nullable=False),
        sa.Column('text', sa.Text(), nullable=False),
        sa.Column('date_created', sa.DateTime(), nullable=False),
        sa.ForeignKeyConstraint(['target_id'], ['bazeltarget.id'], ondelete='CASCADE'),
        sa.PrimaryKeyConstraint('id')
    )
def upgrade():
    op.add_column(
        'jobstep',
        sa.Column('replacement_id',
                  sa.GUID(),
                  sa.ForeignKey('jobstep.id', ondelete="CASCADE"),
                  unique=True,
                  nullable=True))
def upgrade():
    op.create_table(
        'buildseen', sa.Column('id', sa.GUID(), nullable=False),
        sa.Column('build_id', sa.GUID(), nullable=False),
        sa.Column('user_id', sa.GUID(), nullable=False),
        sa.Column('date_created', sa.DateTime(), nullable=False),
        sa.PrimaryKeyConstraint('id'),
        sa.UniqueConstraint('build_id', 'user_id',
                            name='unq_buildseen_entity'))
    op.create_foreign_key('buildseen_build_id_fkey',
                          'buildseen',
                          'build', ['build_id'], ['id'],
                          ondelete='CASCADE')
    op.create_foreign_key('buildseen_user_id_fkey',
                          'buildseen',
                          'user', ['user_id'], ['id'],
                          ondelete='CASCADE')
def upgrade():
    op.create_table(
        'artifact',
        sa.Column('id', sa.GUID(), nullable=False),
        sa.Column('job_id', sa.GUID(), nullable=False),
        sa.Column('step_id', sa.GUID(), nullable=False),
        sa.Column('project_id', sa.GUID(), nullable=False),
        sa.Column('name', sa.String(length=128), nullable=False),
        sa.Column('date_created', sa.DateTime(), nullable=True),
        sa.Column('data', sa.JSONEncodedDict(), nullable=True),
        sa.ForeignKeyConstraint(['job_id'], ['job.id'], ondelete='CASCADE'),
        sa.ForeignKeyConstraint(['project_id'], ['project.id'],
                                ondelete='CASCADE'),
        sa.ForeignKeyConstraint(['step_id'], ['jobstep.id'],
                                ondelete='CASCADE'),
        sa.PrimaryKeyConstraint('id'),
        sa.UniqueConstraint('step_id', 'name', name='unq_artifact_name'),
    )
Exemplo n.º 30
0
def downgrade():
    with op.batch_alter_table('traveller_data_errors') as bop:
        bop.add_column(sa.Column('row', sa.Integer(), nullable=False))
        bop.drop_column('travel_id')
        bop.add_column(
            sa.Column('traveller_data_id',
                      sa.GUID(),
                      sa.ForeignKey('traveller_data.id', ondelete='CASCADE'),
                      nullable=False))