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)