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(): ### 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(): ### 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")
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')