def get_institution(npi):
db_config = DbConfig()
connection = psycopg2.connect(host=db_config.host,
database='healthcare2',
user=db_config.user,
password=db_config.password)
institution_repository = InstitutionRepository(connection)
results = institution_repository.get(npi)
connection.close()
return Response(json.dumps({'items': results}),
mimetype='application/json')
def get_provider_address_by_npi(npi):
db_config = DbConfig()
connection = psycopg2.connect(host=db_config.host,
database='healthcare2',
user=db_config.user,
password=db_config.password)
provider_address_repository = ProviderAddressRepository(connection)
results = provider_address_repository.get_by_npi(npi)
connection.close()
return Response(json.dumps({'items': results}),
mimetype='application/json')
def get_all_zipcodes():
limit = request.args.get('limit', 100)
offset = request.args.get('offset', 0)
db_config = DbConfig()
connection = psycopg2.connect(host=db_config.host,
database='healthcare2',
user=db_config.user,
password=db_config.password)
zipcode_repository = ZipCodeRepository(connection)
results = zipcode_repository.get_all(limit, offset)
connection.close()
return Response(json.dumps({'items': results}),
mimetype='application/json')
def get_zipcode(zipcode):
db_config = DbConfig()
connection = psycopg2.connect(host=db_config.host,
database='healthcare2',
user=db_config.user,
password=db_config.password)
zipcode_repository = ZipCodeRepository(connection)
provider_repository = ProviderRepository(connection)
results = zipcode_repository.get(zipcode)
hcp_results = provider_repository.get_by_zipcode(zipcode)
connection.close()
return Response(json.dumps({
'items': results,
'providers': hcp_results
}),
mimetype='application/json')
def zip_code_view(zipcode):
db_config = DbConfig()
connection = psycopg2.connect(host=db_config.host,
database='healthcare2',
user=db_config.user,
password=db_config.password)
zipcode_repository = ZipCodeRepository(connection)
provider_repository = ProviderRepository(connection)
institution_repository = InstitutionRepository(connection)
zipcode_results = zipcode_repository.get(zipcode)
hcp_results = provider_repository.get_by_zipcode(zipcode, limit=20)
hco_results = institution_repository.get_by_zipcode(zipcode, limit=20)
connection.close()
return render_template('zipcode_view.html',
zipcode=zipcode_results,
providers=hcp_results,
institutions=hco_results)
def institution_view(npi):
db_config = DbConfig()
connection = psycopg2.connect(host=db_config.host,
database='healthcare2',
user=db_config.user,
password=db_config.password)
institution_repository = InstitutionRepository(connection)
institution_address_repository = InstitutionAddressRepository(connection)
medicare_repository = MedicareRepository(connection)
hco_result = institution_repository.get(npi)
hco_address_result = institution_address_repository.get_by_npi(npi)
medicare_results = medicare_repository.get_by_npi(npi)
connection.close()
return render_template('institution_view.html',
institution=hco_result[0],
addresses=hco_address_result,
medicare=medicare_results)
def provider_view(npi):
db_config = DbConfig()
connection = psycopg2.connect(host=db_config.host,
database='healthcare2',
user=db_config.user,
password=db_config.password)
provider_repository = ProviderRepository(connection)
provider_address_repository = ProviderAddressRepository(connection)
medicare_repository = MedicareRepository(connection)
hcp_result = provider_repository.get(npi)
hcp_address_result = provider_address_repository.get_by_npi(npi)
medicare_results = medicare_repository.get_by_npi(npi)
connection.close()
return render_template('provider_view.html',
provider=hcp_result[0],
addresses=hcp_address_result,
medicare=medicare_results)