def __init__(self, table=None, recreate=False):
datamodel = Datamodel()
if table is None:
table, table_config = datamodel.zipcode_timeseries()
else:
_, table_config = datamodel.zipcode_timeseries()
self.time_series_postgres = self._initialize_postgres((table, table_config), recreate=recreate)
def __init__(self, recreate=False):
datamodel = Datamodel()
self.table, self.table_config = datamodel.population()
self.postgres = Postgresql(user_name='postgres',
password='******',
host='localhost',
port='5432',
db='TestProject')
self.postgres.initialize_table(self.table,
recreate=False,
**self.table_config)
self.googlegeo = GoogleGeo()
# myan: only get major cities data once per request
self.major_cities_postgres = Postgresql(user_name='postgres',
password='******',
host='localhost',
port='5432',
db='TestProject')
self.major_cities = self.major_cities_postgres.get(
"select * from TestMajorCities")
self.all_states = self.major_cities['state'].values
self.all_cities = self.major_cities['city'].values
self.all_lats = self.major_cities['lat'].values
self.all_lngs = self.major_cities['lng'].values
self.all_population = self.major_cities['population'].values
def __init__(self, table=None, recreate=False):
datamodel = Datamodel()
if table is None:
table, table_config = datamodel.zipcode_timeseries()
else:
_, table_config = datamodel.zipcode_timeseries()
self.time_series_postgres = self._initialize_postgres(
(table, table_config), recreate=recreate)
def __init__(self, key=None):
if key is None:
self.api_key = _get_great_schools_api_key()
else:
self.api_key = key
# myan: initialize postgresql
datamodel = Datamodel()
self.table, self.table_config = datamodel.great_schools()
self.postgres = Postgresql(user_name='postgres',
password='******',
host='localhost',
port='5432',
db='TestProject')
self.postgres.initialize_table(self.table, recreate=False, **self.table_config)
def __init__(self, min_price=150000, max_price=300000, top_percentage=0.25, top_max_num_entries=30):
self.MIN_PRICE = min_price
self.MAX_PRICE = max_price
self.TOP_PERCENTAGE = top_percentage
self.TOP_MAX_NUM_ENTRIES = top_max_num_entries
datamodel = Datamodel()
self.time_series_postgres = self._initialize_postgres(datamodel.zipcode_timeseries())
self.population_postgres = self._initialize_postgres(datamodel.population())
self.great_schools_postgres = self._initialize_postgres(datamodel.great_schools())
self.zipcode_timeseries = None
self.top_zipcodes_timeseries = None
self.rest_zipcodes_timeseries = None
self.top_zipcodes_school_data = None
self.top_zipcodes_population_data = None
self.all_months_timeseries = None
def __init__(self,recreate=False):
datamodel = Datamodel()
self.table, self.table_config = datamodel.population()
self.postgres = Postgresql(user_name='postgres',
password='******',
host='localhost',
port='5432',
db='TestProject')
self.postgres.initialize_table(self.table, recreate=False, **self.table_config)
self.googlegeo = GoogleGeo()
# myan: only get major cities data once per request
self.major_cities_postgres = Postgresql(user_name='postgres',
password='******',
host='localhost',
port='5432',
db='TestProject')
self.major_cities = self.major_cities_postgres.get("select * from TestMajorCities")
self.all_states = self.major_cities['state'].values
self.all_cities = self.major_cities['city'].values
self.all_lats = self.major_cities['lat'].values
self.all_lngs = self.major_cities['lng'].values
self.all_population = self.major_cities['population'].values
def __init__(self,
min_price=150000,
max_price=300000,
top_percentage=0.25,
top_max_num_entries=30):
self.MIN_PRICE = min_price
self.MAX_PRICE = max_price
self.TOP_PERCENTAGE = top_percentage
self.TOP_MAX_NUM_ENTRIES = top_max_num_entries
datamodel = Datamodel()
self.time_series_postgres = self._initialize_postgres(
datamodel.zipcode_timeseries())
self.population_postgres = self._initialize_postgres(
datamodel.population())
self.great_schools_postgres = self._initialize_postgres(
datamodel.great_schools())
self.zipcode_timeseries = None
self.top_zipcodes_timeseries = None
self.rest_zipcodes_timeseries = None
self.top_zipcodes_school_data = None
self.top_zipcodes_population_data = None
self.all_months_timeseries = None
