def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'bit_performance_report', sa.Column('id', sa.Integer(), nullable=False), sa.Column('date', sa.DateTime(), nullable=True), sa.Column('year', sa.Integer(), nullable=True), sa.Column('month', sa.Integer(), nullable=True), sa.Column('day', sa.Integer(), nullable=True), sa.Column('name', sa.String(length=250), nullable=True), sa.Column('campaign_source', sa.String(length=250), nullable=True), sa.Column('campaign_name', sa.String(length=250), nullable=True), sa.Column('campaign_id', sa.String(length=250), nullable=True), sa.Column('clicks', sa.Integer(), nullable=True), sa.Column('clicks_unique', sa.Integer(), nullable=True), sa.Column('impressions', sa.Integer(), nullable=True), sa.Column('conversions', sa.Integer(), nullable=True), sa.Column('cost', sa.Numeric(precision=17, scale=5), nullable=True), sa.Column('breakdowns', postgresql.HSTORE(text_type=sa.Text()), nullable=True), sa.Column('measurements', postgresql.HSTORE(text_type=sa.Text()), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_bit_performance_report_breakdowns'), 'bit_performance_report', ['breakdowns'], unique=False) op.create_index(op.f('ix_bit_performance_report_campaign_id'), 'bit_performance_report', ['campaign_id'], unique=False) op.create_index(op.f('ix_bit_performance_report_campaign_name'), 'bit_performance_report', ['campaign_name'], unique=False) op.create_index(op.f('ix_bit_performance_report_campaign_source'), 'bit_performance_report', ['campaign_source'], unique=False) op.create_index(op.f('ix_bit_performance_report_date'), 'bit_performance_report', ['date'], unique=False) op.create_index(op.f('ix_bit_performance_report_day'), 'bit_performance_report', ['day'], unique=False) op.create_index(op.f('ix_bit_performance_report_month'), 'bit_performance_report', ['month'], unique=False) op.create_index(op.f('ix_bit_performance_report_name'), 'bit_performance_report', ['name'], unique=False) op.create_index(op.f('ix_bit_performance_report_year'), 'bit_performance_report', ['year'], unique=False)
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'Artist', sa.Column('past_shows', sa.ARRAY(postgresql.HSTORE(text_type=sa.Text())), nullable=True)) op.add_column('Artist', sa.Column('past_shows_count', sa.Integer(), nullable=True)) op.add_column( 'Artist', sa.Column('seeking_description', sa.String(length=1000), nullable=True)) op.add_column('Artist', sa.Column('seeking_venue', sa.Boolean(), nullable=True)) op.add_column( 'Artist', sa.Column('upcoming_shows', sa.ARRAY(postgresql.HSTORE(text_type=sa.Text())), nullable=True)) op.add_column( 'Artist', sa.Column('upcoming_shows_count', sa.Integer(), nullable=True)) op.add_column('Artist', sa.Column('website', sa.String(), nullable=True)) op.add_column('Venue', sa.Column('genres', sa.ARRAY(sa.String()), nullable=True)) op.add_column( 'Venue', sa.Column('past_shows', sa.ARRAY(postgresql.HSTORE(text_type=sa.Text())), nullable=True)) op.add_column('Venue', sa.Column('past_shows_count', sa.Integer(), nullable=True)) op.add_column( 'Venue', sa.Column('seeking_description', sa.String(length=1000), nullable=True)) op.add_column('Venue', sa.Column('seeking_talent', sa.Boolean(), nullable=True)) op.add_column( 'Venue', sa.Column('upcoming_shows', sa.ARRAY(postgresql.HSTORE(text_type=sa.Text())), nullable=True)) op.add_column( 'Venue', sa.Column('upcoming_shows_count', sa.Integer(), nullable=True)) op.add_column('Venue', sa.Column('website', sa.String(), nullable=True))
def upgrade(): op.drop_table('payout') op.drop_table('block') op.drop_table('transaction') op.drop_table('coin_transaction') #op.drop_table('one_minute_share') op.create_table('blob', sa.Column('key', sa.String(), nullable=False), sa.Column('data', postgresql.HSTORE(), nullable=True), sa.PrimaryKeyConstraint('key') ) op.create_table('transaction', sa.Column('txid', sa.String(), nullable=False), sa.Column('confirmed', sa.Boolean(), nullable=True), sa.Column('created_at', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('txid') ) #op.create_table('one_minute_share', # sa.Column('user', sa.String(), nullable=False), # sa.Column('minute', sa.DateTime(), nullable=False), # sa.Column('shares', sa.Integer(), nullable=True), # sa.PrimaryKeyConstraint('user', 'minute') # ) op.create_table('block', sa.Column('height', sa.Integer(), nullable=False), sa.Column('user', sa.String(), nullable=True), sa.Column('found_at', sa.DateTime(), nullable=True), sa.Column('time_started', sa.DateTime(), nullable=False), sa.Column('orphan', sa.Boolean(), nullable=True), sa.Column('mature', sa.Boolean(), nullable=True), sa.Column('shares_to_solve', sa.BigInteger(), nullable=True), sa.Column('total_value', sa.BigInteger(), nullable=True), sa.Column('transaction_fees', sa.BigInteger(), nullable=True), sa.Column('fees', sa.BigInteger(), nullable=True), sa.Column('bits', sa.String(length=8), nullable=False), sa.Column('last_share_id', sa.BigInteger(), nullable=True), sa.Column('processed', sa.Boolean(), nullable=True), sa.Column('hash', sa.String(), nullable=False), sa.ForeignKeyConstraint(['last_share_id'], ['share.id'], ), sa.PrimaryKeyConstraint('height') ) op.create_table('payout', sa.Column('id', sa.Integer(), nullable=False), sa.Column('blockheight', sa.Integer(), nullable=True), sa.Column('user', sa.String(), nullable=True), sa.Column('shares', sa.BigInteger(), nullable=True), sa.Column('amount', sa.BigInteger(), nullable=True), sa.Column('transaction_id', sa.String(), nullable=True), sa.ForeignKeyConstraint(['blockheight'], ['block.height'], ), sa.ForeignKeyConstraint(['transaction_id'], ['transaction.txid'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('user', 'blockheight') )
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'user_media_links', sa.Column('attributes', postgresql.HSTORE(text_type=Text()), server_default=sa.text(u"''::hstore"), autoincrement=False, nullable=False)) op.add_column( 'submission_media_links', sa.Column('attributes', postgresql.HSTORE(text_type=Text()), server_default=sa.text(u"''::hstore"), autoincrement=False, nullable=False)) op.add_column( 'media_media_links', sa.Column('attributes', postgresql.HSTORE(text_type=Text()), server_default=sa.text(u"''::hstore"), autoincrement=False, nullable=False))
def upgrade(): op.create_table( "import_file", sa.Column("id", sa.Integer(), nullable=False), sa.Column( "status", sa.Enum("UPLOADED", "PROCESSING", "DONE", "FAILED", name="importfilestatus"), nullable=False, ), sa.Column("filename", sa.String(), nullable=False), sa.Column("fields", postgresql.HSTORE(text_type=sa.Text()), nullable=False), sa.PrimaryKeyConstraint("id", name="pk_import_file"), ) op.create_table( "import_file_log", sa.Column("id", sa.Integer(), nullable=False), sa.Column("import_file_id", sa.Integer(), nullable=False), sa.Column( "timestamp", sa.TIMESTAMP(timezone=True), server_default=sa.text("now()"), nullable=False, ), sa.Column( "status", sa.Enum("UPLOADED", "PROCESSING", "DONE", "FAILED", name="importfilestatus"), nullable=False, ), sa.Column("message", sa.String(), nullable=True), sa.ForeignKeyConstraint( ["import_file_id"], ["import_file.id"], name="fk_import_file_log_import_file_id_import_file", ), sa.PrimaryKeyConstraint("id", name="pk_import_file_log"), )
def test_should_postgresql_hstore_convert(): assert get_field(postgresql.HSTORE()).type == graphene.JSONString
def upgrade(): ### commands auto generated by Alembic - please adjust! ### op.create_table('service', sa.Column('created', sa.DateTime(), nullable=True), sa.Column('last_modified', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=64), nullable=True), sa.Column('description', sa.Text(), nullable=True), sa.Column('logo_url', sa.String(length=128), nullable=True), sa.Column('website_url', sa.String(length=128), nullable=True), sa.Column('main_contact_name', sa.String(length=64), nullable=True), sa.Column('main_contact_phone', sa.String(length=32), nullable=True), sa.Column('has_screening_yn', sa.String(length=1), nullable=True), sa.Column('fpl_cutoff', sa.Integer(), nullable=True), sa.Column('uninsured_only_yn', sa.String(length=1), nullable=True), sa.Column('medicaid_ineligible_only_yn', sa.String(length=1), nullable=True), sa.Column('residence_requirement_yn', sa.String(length=1), nullable=True), sa.Column('time_in_area_requirement_yn', sa.String(length=1), nullable=True), sa.Column('last_modified_by_id', sa.Integer(), nullable=True), sa.Column('created_by_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True), sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True), sa.PrimaryKeyConstraint('id') ) op.create_table('role', sa.Column('created', sa.DateTime(), nullable=True), sa.Column('last_modified', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=64), nullable=True), sa.Column('description', sa.String(length=255), nullable=True), sa.Column('default', sa.Boolean(), nullable=True), sa.Column('last_modified_by_id', sa.Integer(), nullable=True), sa.Column('created_by_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True), sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name') ) op.create_index(op.f('ix_role_default'), 'role', ['default'], unique=False) op.create_table('patient', sa.Column('created', sa.DateTime(), nullable=True), sa.Column('last_modified', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('full_name', sa.String(length=128), nullable=True), sa.Column('first_name', sa.String(length=64), nullable=True), sa.Column('middle_name', sa.String(length=64), nullable=True), sa.Column('last_name', sa.String(length=64), nullable=True), sa.Column('dob', sa.Date(), nullable=True), sa.Column('ssn', sa.String(length=11), nullable=True), sa.Column('email', sa.String(length=64), nullable=True), sa.Column('gender', sa.String(length=2), nullable=True), sa.Column('transgender', sa.String(length=3), nullable=True), sa.Column('race', sa.String(length=16), nullable=True), sa.Column('race_other', sa.String(length=32), nullable=True), sa.Column('ethnicity', sa.String(length=32), nullable=True), sa.Column('languages', sa.String(length=64), nullable=True), sa.Column('languages_other', sa.String(length=64), nullable=True), sa.Column('has_interpreter_yn', sa.String(length=1), nullable=True), sa.Column('education_level', sa.String(length=16), nullable=True), sa.Column('marital_status', sa.String(length=16), nullable=True), sa.Column('veteran_yn', sa.String(length=1), nullable=True), sa.Column('housing_status', sa.String(length=16), nullable=True), sa.Column('housing_status_other', sa.String(length=32), nullable=True), sa.Column('time_in_area', sa.String(length=16), nullable=True), sa.Column('city_or_county_of_residence', sa.String(length=64), nullable=True), sa.Column('temp_visa_yn', sa.String(length=1), nullable=True), sa.Column('has_transport_yn', sa.String(length=1), nullable=True), sa.Column('student_status', sa.String(length=16), nullable=True), sa.Column('employment_status', sa.String(length=16), nullable=True), sa.Column('years_unemployed', sa.Integer(), nullable=True), sa.Column('months_unemployed', sa.Integer(), nullable=True), sa.Column('employment_changes', sa.String(length=32), nullable=True), sa.Column('spouse_employment_status', sa.String(length=16), nullable=True), sa.Column('spouse_years_unemployed', sa.Integer(), nullable=True), sa.Column('spouse_months_unemployed', sa.Integer(), nullable=True), sa.Column('spouse_employment_changes', sa.String(length=16), nullable=True), sa.Column('years_at_current_employer', sa.String(length=32), nullable=True), sa.Column('spouse_years_at_current_employer', sa.String(length=32), nullable=True), sa.Column('last_healthcare', sa.String(length=128), nullable=True), sa.Column('insurance_status', sa.String(length=32), nullable=True), sa.Column('coverage_type', sa.String(length=32), nullable=True), sa.Column('coverage_type_other', sa.String(length=32), nullable=True), sa.Column('has_prescription_coverage_yn', sa.String(length=1), nullable=True), sa.Column('has_vcc', sa.String(length=1), nullable=True), sa.Column('has_pcp_yn', sa.String(length=1), nullable=True), sa.Column('has_psychiatrist_yn', sa.String(length=1), nullable=True), sa.Column('wants_psychiatrist_yn', sa.String(length=1), nullable=True), sa.Column('eligible_insurance_types', sa.String(length=64), nullable=True), sa.Column('applied_for_vets_benefits_yn', sa.String(length=1), nullable=True), sa.Column('eligible_for_vets_benefits_yn', sa.String(length=1), nullable=True), sa.Column('applied_for_medicaid_yn', sa.String(length=1), nullable=True), sa.Column('denied_medicaid_yn', sa.String(length=1), nullable=True), sa.Column('medicaid_date_effective', sa.Date(), nullable=True), sa.Column('applied_for_ssd_yn', sa.String(length=1), nullable=True), sa.Column('ssd_date_effective', sa.Date(), nullable=True), sa.Column('care_due_to_accident_yn', sa.String(length=1), nullable=True), sa.Column('accident_work_related_yn', sa.String(length=1), nullable=True), sa.Column('recently_lost_insurance_yn', sa.String(length=1), nullable=True), sa.Column('head_of_household_yn', sa.String(length=1), nullable=True), sa.Column('filed_taxes_yn', sa.String(length=1), nullable=True), sa.Column('claimed_as_dependent_yn', sa.String(length=1), nullable=True), sa.Column('how_food_and_shelter', sa.String(length=128), nullable=True), sa.Column('how_other_expenses', sa.String(length=128), nullable=True), sa.Column('last_modified_by_id', sa.Integer(), nullable=True), sa.Column('created_by_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True), sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True), sa.PrimaryKeyConstraint('id') ) op.create_table('document_image', sa.Column('created', sa.DateTime(), nullable=True), sa.Column('last_modified', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('patient_id', sa.Integer(), nullable=True), sa.Column('file_name', sa.String(length=64), nullable=True), sa.Column('file_description', sa.String(length=64), nullable=True), sa.Column('data_full', sa.LargeBinary(), nullable=True), sa.Column('data_large', sa.LargeBinary(), nullable=True), sa.Column('data_small', sa.LargeBinary(), nullable=True), sa.Column('last_modified_by_id', sa.Integer(), nullable=True), sa.Column('created_by_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True), sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True), sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_table('employer', sa.Column('created', sa.DateTime(), nullable=True), sa.Column('last_modified', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('patient_id', sa.Integer(), nullable=True), sa.Column('employer_name', sa.String(length=64), nullable=True), sa.Column('phone_number', sa.String(length=32), nullable=True), sa.Column('employee', sa.String(length=16), nullable=True), sa.Column('start_date', sa.Date(), nullable=True), sa.Column('last_modified_by_id', sa.Integer(), nullable=True), sa.Column('created_by_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True), sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True), sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_table('emergency_contact', sa.Column('created', sa.DateTime(), nullable=True), sa.Column('last_modified', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('patient_id', sa.Integer(), nullable=True), sa.Column('full_name', sa.String(length=64), nullable=True), sa.Column('relationship', sa.String(length=64), nullable=True), sa.Column('phone_number', sa.String(length=32), nullable=True), sa.Column('last_modified_by_id', sa.Integer(), nullable=True), sa.Column('created_by_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True), sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True), sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_table('referral_permission', sa.Column('created', sa.DateTime(), nullable=True), sa.Column('last_modified', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('from_service_id', sa.Integer(), nullable=True), sa.Column('to_service_id', sa.Integer(), nullable=True), sa.Column('last_modified_by_id', sa.Integer(), nullable=True), sa.Column('created_by_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True), sa.ForeignKeyConstraint(['from_service_id'], ['service.id'], ), sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True), sa.ForeignKeyConstraint(['to_service_id'], ['service.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_table('address', sa.Column('created', sa.DateTime(), nullable=True), sa.Column('last_modified', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('patient_id', sa.Integer(), nullable=True), sa.Column('address1', sa.String(length=64), nullable=True), sa.Column('address2', sa.String(length=64), nullable=True), sa.Column('city', sa.String(length=64), nullable=True), sa.Column('state', sa.String(length=2), nullable=True), sa.Column('zip_code', sa.String(length=10), nullable=True), sa.Column('address_description', sa.String(length=64), nullable=True), sa.Column('address_description_other', sa.String(length=64), nullable=True), sa.Column('last_modified_by_id', sa.Integer(), nullable=True), sa.Column('created_by_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True), sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True), sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_table('service_referral_email', sa.Column('created', sa.DateTime(), nullable=True), sa.Column('last_modified', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('service_id', sa.Integer(), nullable=True), sa.Column('email', sa.String(length=64), nullable=True), sa.Column('last_modified_by_id', sa.Integer(), nullable=True), sa.Column('created_by_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True), sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True), sa.ForeignKeyConstraint(['service_id'], ['service.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id') ) op.create_table('service_location', sa.Column('created', sa.DateTime(), nullable=True), sa.Column('last_modified', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('service_id', sa.Integer(), nullable=True), sa.Column('name', sa.String(length=64), nullable=True), sa.Column('contact_name', sa.String(length=64), nullable=True), sa.Column('phone_number', sa.String(length=32), nullable=True), sa.Column('address', sa.String(length=64), nullable=True), sa.Column('latitude', sa.Float(), nullable=True), sa.Column('longitude', sa.Float(), nullable=True), sa.Column('last_modified_by_id', sa.Integer(), nullable=True), sa.Column('created_by_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True), sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True), sa.ForeignKeyConstraint(['service_id'], ['service.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id') ) op.create_table('sliding_scale', sa.Column('created', sa.DateTime(), nullable=True), sa.Column('last_modified', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('service_id', sa.Integer(), nullable=True), sa.Column('scale_name', sa.String(length=64), nullable=True), sa.Column('fpl_low', sa.Float(), nullable=True), sa.Column('fpl_high', sa.Float(), nullable=True), sa.Column('last_modified_by_id', sa.Integer(), nullable=True), sa.Column('created_by_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True), sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True), sa.ForeignKeyConstraint(['service_id'], ['service.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id') ) op.create_table('household_member', sa.Column('created', sa.DateTime(), nullable=True), sa.Column('last_modified', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('patient_id', sa.Integer(), nullable=True), sa.Column('full_name', sa.String(length=64), nullable=True), sa.Column('dob', sa.Date(), nullable=True), sa.Column('ssn', sa.String(length=11), nullable=True), sa.Column('relationship', sa.String(length=32), nullable=True), sa.Column('last_modified_by_id', sa.Integer(), nullable=True), sa.Column('created_by_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True), sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True), sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_table('phone_number', sa.Column('created', sa.DateTime(), nullable=True), sa.Column('last_modified', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('patient_id', sa.Integer(), nullable=True), sa.Column('phone_number', sa.String(length=32), nullable=True), sa.Column('number_description', sa.String(length=64), nullable=True), sa.Column('number_description_other', sa.String(length=64), nullable=True), sa.Column('primary_yn', sa.String(length=1), nullable=True), sa.Column('last_modified_by_id', sa.Integer(), nullable=True), sa.Column('created_by_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True), sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True), sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_table('app_user', sa.Column('created', sa.DateTime(), nullable=True), sa.Column('last_modified', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('email', sa.String(length=64), nullable=True), sa.Column('password', sa.String(length=128), nullable=True), sa.Column('authenticated', sa.Boolean(), nullable=True), sa.Column('active', sa.Boolean(), nullable=True), sa.Column('confirmed_at', sa.DateTime(), nullable=True), sa.Column('last_login_at', sa.DateTime(), nullable=True), sa.Column('current_login_at', sa.DateTime(), nullable=True), sa.Column('last_login_ip', sa.String(length=16), nullable=True), sa.Column('current_login_ip', sa.String(length=16), nullable=True), sa.Column('login_count', sa.Integer(), nullable=True), sa.Column('service_id', sa.Integer(), nullable=True), sa.Column('full_name', sa.String(length=64), nullable=True), sa.Column('phone_number', sa.String(length=32), nullable=True), sa.Column('patient_id', sa.Integer(), nullable=True), sa.Column('last_modified_by_id', sa.Integer(), nullable=True), sa.Column('created_by_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True), sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True), sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ), sa.ForeignKeyConstraint(['service_id'], ['service.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id') ) op.create_table('income_source', sa.Column('created', sa.DateTime(), nullable=True), sa.Column('last_modified', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('patient_id', sa.Integer(), nullable=True), sa.Column('source', sa.String(length=64), nullable=True), sa.Column('monthly_amount', sa.Integer(), nullable=True), sa.Column('last_modified_by_id', sa.Integer(), nullable=True), sa.Column('created_by_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True), sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True), sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_table('service_translation', sa.Column('id', sa.Integer(), nullable=False), sa.Column('service_id', sa.Integer(), nullable=True), sa.Column('language_code', sa.String(length=16), nullable=True), sa.Column('description', sa.Text(), nullable=True), sa.ForeignKeyConstraint(['service_id'], ['service.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id') ) op.create_table('patient_screening_result', sa.Column('created', sa.DateTime(), nullable=True), sa.Column('last_modified', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('patient_id', sa.Integer(), nullable=True), sa.Column('service_id', sa.Integer(), nullable=True), sa.Column('eligible_yn', sa.String(length=1), nullable=True), sa.Column('sliding_scale_id', sa.Integer(), nullable=True), sa.Column('notes', sa.Text(), nullable=True), sa.Column('last_modified_by_id', sa.Integer(), nullable=True), sa.Column('created_by_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True), sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True), sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ), sa.ForeignKeyConstraint(['service_id'], ['service.id'], ), sa.ForeignKeyConstraint(['sliding_scale_id'], ['sliding_scale.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_table('roles_users', sa.Column('created', sa.DateTime(), nullable=True), sa.Column('last_modified', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('app_user_id', sa.Integer(), nullable=True), sa.Column('role_id', sa.Integer(), nullable=True), sa.Column('last_modified_by_id', sa.Integer(), nullable=True), sa.Column('created_by_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['app_user_id'], ['app_user.id'], ), sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True), sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True), sa.ForeignKeyConstraint(['role_id'], ['role.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_table('sliding_scale_fee', sa.Column('created', sa.DateTime(), nullable=True), sa.Column('last_modified', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('sliding_scale_id', sa.Integer(), nullable=True), sa.Column('name', sa.String(length=128), nullable=True), sa.Column('price_absolute', sa.Integer(), nullable=True), sa.Column('price_percentage', sa.Integer(), nullable=True), sa.Column('last_modified_by_id', sa.Integer(), nullable=True), sa.Column('created_by_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True), sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True), sa.ForeignKeyConstraint(['sliding_scale_id'], ['sliding_scale.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id') ) op.create_table('patient_referral', sa.Column('created', sa.DateTime(), nullable=True), sa.Column('last_modified', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('patient_id', sa.Integer(), nullable=True), sa.Column('from_app_user_id', sa.Integer(), nullable=True), sa.Column('to_service_id', sa.Integer(), nullable=True), sa.Column('status', sa.String(length=9), nullable=True), sa.Column('notes', sa.Text(), nullable=True), sa.Column('last_modified_by_id', sa.Integer(), nullable=True), sa.Column('created_by_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True), sa.ForeignKeyConstraint(['from_app_user_id'], ['app_user.id'], ), sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True), sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ), sa.ForeignKeyConstraint(['to_service_id'], ['service.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_table('action_log', sa.Column('id', sa.Integer(), nullable=False), sa.Column('transaction_id', sa.Integer(), nullable=True), sa.Column('action_timestamp', sa.DateTime(), nullable=True), sa.Column('table_name', sa.String(length=64), nullable=True), sa.Column('row_id', sa.Integer(), nullable=True), sa.Column('app_user_id', sa.Integer(), nullable=True), sa.Column('action', sa.String(length=1), nullable=True), sa.Column('row_data', postgresql.HSTORE(), nullable=True), sa.Column('changed_fields', postgresql.HSTORE(), nullable=True), sa.ForeignKeyConstraint(['app_user_id'], ['app_user.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_table('unsaved_form', sa.Column('created', sa.DateTime(), nullable=True), sa.Column('last_modified', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('app_user_id', sa.Integer(), nullable=True), sa.Column('patient_id', sa.Integer(), nullable=True), sa.Column('page_name', sa.String(length=128), nullable=True), sa.Column('form_json', postgresql.JSON(), nullable=True), sa.Column('last_modified_by_id', sa.Integer(), nullable=True), sa.Column('created_by_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['app_user_id'], ['app_user.id'], ), sa.ForeignKeyConstraint(['created_by_id'], ['app_user.id'], name='fk_created_by_id', use_alter=True), sa.ForeignKeyConstraint(['last_modified_by_id'], ['app_user.id'], name='fk_last_modified_by_id', use_alter=True), sa.ForeignKeyConstraint(['patient_id'], ['patient.id'], ), sa.PrimaryKeyConstraint('id') )
def test_should_postgresql_hstore_convert(): assert_column_conversion(postgresql.HSTORE(), JSONString)
def test_get_field_type_can_map_pg_hstore_column(self): column = sqa.Column(postgresql.HSTORE()) field = field_mapping.get_field_type(column) self.assertTrue(issubclass(field, CharMappingField))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'role', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=80), nullable=True), sa.Column('description', sa.String(length=255), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name')) op.create_table('scrape', sa.Column('id', sa.Integer(), nullable=False), sa.Column('start_date', sa.DateTime(), nullable=True), sa.Column('end_date', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table('uri', sa.Column('id', sa.Integer(), nullable=False), sa.Column('raw', sa.String(), nullable=False), sa.Column('last_checked', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('raw')) op.create_table( 'user', sa.Column('id', sa.Integer(), nullable=False), sa.Column('username', sa.String(length=100), nullable=True), sa.Column('email', sa.String(length=255), nullable=False), sa.Column('password', sa.String(length=255), nullable=True), sa.Column('first_name', sa.String(length=255), nullable=False), sa.Column('last_name', sa.String(length=255), nullable=False), sa.Column('institution', sa.String(length=255), nullable=False), sa.Column('active', sa.Boolean(), nullable=True), sa.Column('approved', sa.Boolean(), nullable=True), sa.Column('confirmed_at', sa.DateTime(), nullable=True), sa.Column('date_created', sa.DateTime(), nullable=True), sa.Column('last_updated', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'), sa.UniqueConstraint('username')) op.create_table( 'error', sa.Column('id', sa.Integer(), nullable=False), sa.Column('uri_id', sa.Integer(), nullable=False), sa.Column('scrape_id', sa.Integer(), nullable=False), sa.Column('origin', sa.Integer(), nullable=False), sa.Column('provider', sa.Integer(), nullable=False), sa.Column('description', sa.String(length=100), nullable=True), sa.Column('last_successful_scrape_at', sa.DateTime(), nullable=False), sa.ForeignKeyConstraint( ['scrape_id'], ['scrape.id'], ), sa.ForeignKeyConstraint( ['uri_id'], ['uri.id'], ), sa.PrimaryKeyConstraint('id')) op.create_table('event', sa.Column('id', sa.Integer(), nullable=False), sa.Column('uri_id', sa.Integer(), nullable=False), sa.Column('subject_id', sa.String(), nullable=False), sa.Column('origin', sa.Integer(), nullable=False), sa.Column('created_at', sa.DateTime(), nullable=False), sa.Column('is_deleted', sa.Boolean(), nullable=True), sa.ForeignKeyConstraint( ['uri_id'], ['uri.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('uri_id', 'subject_id')) op.create_table( 'metric', sa.Column('id', sa.Integer(), nullable=False), sa.Column('uri_id', sa.Integer(), nullable=False), sa.Column('data', postgresql.HSTORE(text_type=sa.Text()), nullable=True), sa.Column('last_updated', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint( ['uri_id'], ['uri.id'], ), sa.PrimaryKeyConstraint('id')) op.create_table('roles_users', sa.Column('user_id', sa.Integer(), nullable=False), sa.Column('role_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ['role_id'], ['role.id'], ), sa.ForeignKeyConstraint( ['user_id'], ['user.id'], ), sa.PrimaryKeyConstraint('user_id', 'role_id')) op.create_table('uris_users', sa.Column('uri_id', sa.Integer(), nullable=False), sa.Column('user_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ['uri_id'], ['uri.id'], ), sa.ForeignKeyConstraint( ['user_id'], ['user.id'], ), sa.PrimaryKeyConstraint('uri_id', 'user_id')) op.create_table('url', sa.Column('id', sa.Integer(), nullable=False), sa.Column('url', sa.String(), nullable=True), sa.Column('uri_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ['uri_id'], ['uri.id'], ), sa.PrimaryKeyConstraint('id')) op.create_table( 'raw_event', sa.Column('id', sa.Integer(), nullable=False), sa.Column('event_id', sa.Integer(), nullable=False), sa.Column('scrape_id', sa.Integer(), nullable=False), sa.Column('external_id', sa.String(), nullable=True), sa.Column('origin', sa.Integer(), nullable=False), sa.Column('provider', sa.Integer(), nullable=False), sa.Column('created_at', sa.DateTime(), nullable=False), sa.Column('reason_for_deletion', sa.String(), nullable=True), sa.ForeignKeyConstraint( ['event_id'], ['event.id'], ), sa.ForeignKeyConstraint( ['scrape_id'], ['scrape.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('external_id'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('guild', sa.Column('colourme_roles', postgresql.ARRAY(sa.BigInteger()), server_default='{}', nullable=True)) op.add_column('guild', sa.Column('settings', postgresql.HSTORE(text_type=sa.Text()), server_default='', nullable=False))
def upgrade(): op.execute("CREATE EXTENSION IF NOT EXISTS hstore") op.create_table( "session", sa.Column("id", sa.Integer(), nullable=False), sa.Column("name", sa.String(), nullable=False), sa.PrimaryKeyConstraint("id", name="pk_session"), ) op.create_table( "export_template", sa.Column("id", sa.Integer(), nullable=False), sa.Column( "row_type", sa.Enum("EXTERNAL_OBJECT", "OBJECT_LINK", name="exportrowtype"), nullable=False, ), sa.Column( "external_object_type", postgresql.ENUM( "PERSON", "MOVIE", "EPISODE", "SERIES", name="externalobjecttype", create_type=False, ), nullable=False, ), sa.Column("fields", postgresql.JSONB(astext_type=sa.Text()), nullable=True), sa.PrimaryKeyConstraint("id", name="pk_export_template"), ) op.create_table( "export_factory", sa.Column("id", sa.Integer(), nullable=False), sa.Column("name", sa.String(), nullable=False), sa.Column("export_template_id", sa.Integer(), nullable=False), sa.Column( "iterator", sa.Enum("PLATFORMS", "GROUPS", "COUNTRIES", name="exportfilteriterator"), nullable=True, ), sa.Column("file_path_template", sa.String(), nullable=False), sa.Column("filters_template", postgresql.HSTORE(text_type=sa.Text()), nullable=False), sa.ForeignKeyConstraint( ["export_template_id"], ["export_template.id"], name="fk_export_factory_export_template_id_export_template", ), sa.PrimaryKeyConstraint("id", name="pk_export_factory"), ) op.create_table( "export_file", sa.Column("id", sa.Integer(), nullable=False), sa.Column( "status", sa.Enum("PROCESSING", "DONE", name="exportfilestatus"), server_default="PROCESSING", nullable=True, ), sa.Column("path", sa.String(), nullable=False), sa.Column("filters", postgresql.HSTORE(text_type=sa.Text()), nullable=False), sa.Column("export_template_id", sa.Integer(), nullable=True), sa.Column("export_factory_id", sa.Integer(), nullable=True), sa.Column("session_id", sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ["export_factory_id"], ["export_factory.id"], name="fk_export_file_export_factory_id_export_factory", ), sa.ForeignKeyConstraint( ["export_template_id"], ["export_template.id"], name="fk_export_file_export_template_id_export_template", ), sa.ForeignKeyConstraint(["session_id"], ["session.id"], name="fk_export_file_session_id_session"), sa.PrimaryKeyConstraint("id", name="pk_export_file"), ) op.create_table( "session_scrap", sa.Column("session_id", sa.Integer(), nullable=False), sa.Column("scrap_id", sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ["scrap_id"], ["scrap.id"], name="fk_session_scrap_scrap_id_scrap", onupdate="CASCADE", ondelete="CASCADE", ), sa.ForeignKeyConstraint( ["session_id"], ["session.id"], name="fk_session_scrap_session_id_session", onupdate="CASCADE", ondelete="CASCADE", ), sa.PrimaryKeyConstraint("session_id", "scrap_id", name="pk_session_scrap"), )