def __init__(self):
# get the user configuration of db info:
user_config = Config()
user_db_param = user_config.get_config_db_info()
self.db_host = user_db_param['host']
self.db_port = user_db_param['port']
self.db_user = user_db_param['user']
self.db_pass = user_db_param['pass']
def __init__(self):
#get the user configuration of db info:
user_config = Config()
user_db_param = user_config.get_config_db_info()
self.db_host = user_db_param['host']
self.db_port = user_db_param['port']
self.db_user = user_db_param['user']
self.db_pass = user_db_param['pass']
#create db if not exists
self.str_db_k_data = 'db_k_data' #k_data database
self.create_db(self.str_db_k_data)
self.str_db_history_data = 'db_history_data' #history_data database
self.create_db(self.str_db_history_data)
self.str_db_investment_data = 'db_investment_data' #investment database
self.create_db(self.str_db_investment_data)
#stock classification database
self.str_db_stock_classification = 'db_stock_class' #stock classification database
self.create_db(self.str_db_stock_classification)
#consolidated bs (year) database
self.str_db_consolidated_bs_year = 'db_consolidated_bs_year'
self.create_db(self.str_db_consolidated_bs_year)
#consolidated bs (season) database
self.str_db_consolidated_bs_season = 'db_consolidated_bs_season'
self.create_db(self.str_db_consolidated_bs_season)
#consolidated pl(year) database
self.str_db_consolidated_pl_year = 'db_consolidated_pl_year'
self.create_db(self.str_db_consolidated_pl_year)
#consolidated pl(season) database
self.str_db_consolidated_pl_season = 'db_consolidated_pl_season'
self.create_db(self.str_db_consolidated_pl_season)
#consolidated cash(year) database
self.str_db_consolidated_cash_year = 'db_consolidated_cash_year'
self.create_db(self.str_db_consolidated_cash_year)
#consolidated cash(season) database
self.str_db_consolidated_cash_season = 'db_consolidated_cash_season'
self.create_db(self.str_db_consolidated_cash_season)
#create table
self.table_creator = Table_creator()
