def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table(u'signature_summary_graphics',
    sa.Column(u'report_date', sa.DATE(), nullable=False),
    sa.Column(u'signature_id', sa.INTEGER(), nullable=False),
    sa.Column(u'graphics_device_id', sa.INTEGER(), nullable=False),
    sa.Column(u'report_count', sa.INTEGER(), nullable=False),
    sa.PrimaryKeyConstraint(u'report_date', u'signature_id', u'graphics_device_id')
    )
    op.create_table(u'graphics_device',
    sa.Column(u'graphics_device_id', sa.INTEGER(), nullable=False),
    sa.Column(u'vendor_hex', sa.TEXT(), nullable=True),
    sa.Column(u'adapter_hex', sa.TEXT(), nullable=True),
    sa.Column(u'vendor_name', sa.TEXT(), nullable=True),
    sa.Column(u'adapter_name', sa.TEXT(), nullable=True),
    sa.PrimaryKeyConstraint(u'graphics_device_id')
    )
    ### end Alembic commands ###
    app_path=os.getcwd()
    procs = [
        'update_signature_summary.sql'
        , 'backfill_graphics_devices.sql'
        , 'update_graphics_devices.sql'
    ]
    for myfile in [app_path + '/socorro/external/postgresql/raw_sql/procs/' + line for line in procs]:
        with open(myfile, 'r') as file:
            op.execute(file.read())
    fix_permissions(op, 'graphics_device')
    fix_permissions(op, 'signature_summary_graphics')
Beispiel #2
0
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table(
        u'crash_adu_by_build_signature',
        sa.Column(u'crash_adu_by_build_signature_id',
                  sa.INTEGER(),
                  nullable=False),
        sa.Column(u'signature_id', sa.INTEGER(), nullable=False),
        sa.Column(u'signature', citexttype.CitextType(), nullable=False),
        sa.Column(u'adu_date', sa.DATE(), nullable=False),
        sa.Column(u'build_date', sa.DATE(), nullable=False),
        sa.Column(u'buildid', sa.NUMERIC(), server_default='0',
                  nullable=False),
        sa.Column(u'crash_count',
                  sa.INTEGER(),
                  server_default='0',
                  nullable=False),
        sa.Column(u'adu_count',
                  sa.INTEGER(),
                  server_default='0',
                  nullable=False),
        sa.Column(u'os_name', citexttype.CitextType(), nullable=False),
        sa.Column(u'channel', citexttype.CitextType(), nullable=False),
        sa.PrimaryKeyConstraint(u'crash_adu_by_build_signature_id'))
    ### end Alembic commands ###
    load_stored_proc(op, [
        'backfill_crash_adu_by_build_signature.sql', 'backfill_matviews.sql',
        'update_crash_adu_by_build_signature.sql'
    ])
    fix_permissions(op, 'crash_adu_by_build_signature')
Beispiel #3
0
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table(
        u'signature_summary_graphics',
        sa.Column(u'report_date', sa.DATE(), nullable=False),
        sa.Column(u'signature_id', sa.INTEGER(), nullable=False),
        sa.Column(u'graphics_device_id', sa.INTEGER(), nullable=False),
        sa.Column(u'report_count', sa.INTEGER(), nullable=False),
        sa.PrimaryKeyConstraint(u'report_date', u'signature_id',
                                u'graphics_device_id'))
    op.create_table(
        u'graphics_device',
        sa.Column(u'graphics_device_id', sa.INTEGER(), nullable=False),
        sa.Column(u'vendor_hex', sa.TEXT(), nullable=True),
        sa.Column(u'adapter_hex', sa.TEXT(), nullable=True),
        sa.Column(u'vendor_name', sa.TEXT(), nullable=True),
        sa.Column(u'adapter_name', sa.TEXT(), nullable=True),
        sa.PrimaryKeyConstraint(u'graphics_device_id'))
    ### end Alembic commands ###
    app_path = os.getcwd()
    procs = [
        'update_signature_summary.sql', 'backfill_graphics_devices.sql',
        'update_graphics_devices.sql'
    ]
    for myfile in [
            app_path + '/socorro/external/postgresql/raw_sql/procs/' + line
            for line in procs
    ]:
        with open(myfile, 'r') as file:
            op.execute(file.read())
    fix_permissions(op, 'graphics_device')
    fix_permissions(op, 'signature_summary_graphics')
def upgrade():
    load_stored_proc(op, ['update_gccrashes.sql', 'backfill_gccrashes.sql',
                          'backfill_matviews.sql'])
    op.create_table(u'gccrashes',
        sa.Column(u'report_date', postgresql.TIMESTAMP(timezone=True), nullable=False),
        sa.Column(u'product_version_id', postgresql.INTEGER(), nullable=False),
        sa.Column(u'build', sa.NUMERIC(), nullable=True),
        sa.Column(u'is_gc_count', sa.INTEGER(), nullable=False)
    )
    fix_permissions(op, 'gccrashes')
def upgrade():
    load_stored_proc(op, ["update_gccrashes.sql", "backfill_gccrashes.sql", "backfill_matviews.sql"])
    op.create_table(
        u"gccrashes",
        sa.Column(u"report_date", postgresql.TIMESTAMP(timezone=True), nullable=False),
        sa.Column(u"product_version_id", postgresql.INTEGER(), nullable=False),
        sa.Column(u"build", sa.NUMERIC(), nullable=True),
        sa.Column(u"is_gc_count", sa.INTEGER(), nullable=False),
    )
    fix_permissions(op, "gccrashes")
Beispiel #6
0
def upgrade():
    op.create_table(
        u'raw_update_channels',
        sa.Column(u'update_channel', sa.TEXT(), nullable=False),
        sa.Column(u'product_name', sa.TEXT(), nullable=False),
        sa.Column(u'version', sa.TEXT(), nullable=False),
        sa.Column(u'build', sa.NUMERIC(), nullable=False),
        sa.Column(u'first_report',
                  postgresql.TIMESTAMP(timezone=True),
                  nullable=False),
        sa.PrimaryKeyConstraint(u'update_channel', u'product_name', u'version',
                                u'build'))
    fix_permissions(op, 'raw_update_channels')

    op.create_table(
        u'update_channel_map',
        sa.Column(u'update_channel', sa.TEXT(), nullable=False),
        sa.Column(u'productid', sa.TEXT(), nullable=False),
        sa.Column(u'version_field', sa.TEXT(), nullable=False),
        sa.Column(u'rewrite', jsontype.JsonType(), nullable=False),
        sa.PrimaryKeyConstraint(u'update_channel', u'productid',
                                u'version_field'))
    fix_permissions(op, 'update_channel_map')

    op.execute("""
        INSERT INTO update_channel_map
        (update_channel, productid, version_field, rewrite)
        VALUES
        ('nightly',
         '{3c2e2abc-06d4-11e1-ac3b-374f68613e61}',
         'B2G_OS_Version',
         '{"Android_Manufacturer": "ZTE",
           "Android_Model": "roamer2",
           "Android_Version": "15(REL)",
           "B2G_OS_Version": "1.0.1.0-prerelease",
           "BuildID":
                ["20130621133927", "20130621152332",
                 "20130531232151", "20130617105829",
                 "20130724040538"],
            "ProductName": "B2G",
            "ReleaseChannel": "nightly",
            "Version": "18.0",
            "rewrite_to": "release-zte"}'
        )
    """)

    # nothing depends on this yet in stored procs
    op.add_column(u'reports_clean',
                  sa.Column(u'update_channel', sa.TEXT(), nullable=True))

    load_stored_proc(op, [
        'update_raw_update_channel.sql', 'backfill_raw_update_channel.sql',
        'backfill_matviews.sql'
    ])
def upgrade():
    op.create_table(u'raw_update_channels',
        sa.Column(u'update_channel', sa.TEXT(), nullable=False),
        sa.Column(u'product_name', sa.TEXT(), nullable=False),
        sa.Column(u'version', sa.TEXT(), nullable=False),
        sa.Column(u'build', sa.NUMERIC(), nullable=False),
        sa.Column(u'first_report', postgresql.TIMESTAMP(timezone=True), nullable=False),
        sa.PrimaryKeyConstraint(u'update_channel', u'product_name', u'version', u'build')
    )
    fix_permissions(op, 'raw_update_channels')

    op.create_table(u'update_channel_map',
        sa.Column(u'update_channel', sa.TEXT(), nullable=False),
        sa.Column(u'productid', sa.TEXT(), nullable=False),
        sa.Column(u'version_field', sa.TEXT(), nullable=False),
        sa.Column(u'rewrite', jsontype.JsonType(), nullable=False),
        sa.PrimaryKeyConstraint(u'update_channel', u'productid', u'version_field')
    )
    fix_permissions(op, 'update_channel_map')

    op.execute("""
        INSERT INTO update_channel_map
        (update_channel, productid, version_field, rewrite)
        VALUES
        ('nightly',
         '{3c2e2abc-06d4-11e1-ac3b-374f68613e61}',
         'B2G_OS_Version',
         '{"Android_Manufacturer": "ZTE",
           "Android_Model": "roamer2",
           "Android_Version": "15(REL)",
           "B2G_OS_Version": "1.0.1.0-prerelease",
           "BuildID":
                ["20130621133927", "20130621152332",
                 "20130531232151", "20130617105829",
                 "20130724040538"],
            "ProductName": "B2G",
            "ReleaseChannel": "nightly",
            "Version": "18.0",
            "rewrite_to": "release-zte"}'
        )
    """)

    # nothing depends on this yet in stored procs
    op.add_column(u'reports_clean', sa.Column(u'update_channel', sa.TEXT(), nullable=True))

    load_stored_proc(op, ['update_raw_update_channel.sql',
                          'backfill_raw_update_channel.sql',
                          'backfill_matviews.sql'])
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table(u'crash_adu_by_build_signature',
    sa.Column(u'crash_adu_by_build_signature_id', sa.INTEGER(), nullable=False),
    sa.Column(u'signature_id', sa.INTEGER(), nullable=False),
    sa.Column(u'signature', citexttype.CitextType(), nullable=False),
    sa.Column(u'adu_date', sa.DATE(), nullable=False),
    sa.Column(u'build_date', sa.DATE(), nullable=False),
    sa.Column(u'buildid', sa.NUMERIC(), server_default='0', nullable=False),
    sa.Column(u'crash_count', sa.INTEGER(), server_default='0', nullable=False),
    sa.Column(u'adu_count', sa.INTEGER(), server_default='0', nullable=False),
    sa.Column(u'os_name', citexttype.CitextType(), nullable=False),
    sa.Column(u'channel', citexttype.CitextType(), nullable=False),
    sa.PrimaryKeyConstraint(u'crash_adu_by_build_signature_id')
    )
    ### end Alembic commands ###
    load_stored_proc(op, ['backfill_crash_adu_by_build_signature.sql',
                          'backfill_matviews.sql',
                          'update_crash_adu_by_build_signature.sql'])
    fix_permissions(op, 'crash_adu_by_build_signature')
def upgrade():
    fix_permissions(op, 'crontabber')
    fix_permissions(op, 'crontabber_log')
def upgrade():
    fix_permissions(op, 'crontabber')
    fix_permissions(op, 'crontabber_log')