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"),
)
