Example #1
0
def __get_insertStat_ModelStatsTable_Statement(resp_word_ID, model_ID, model_score, stat_variance, stat_count):
	table = 'T_MODEL_STATISTICS'
	columns = ['int_word_rsp_var_id', 'int_model_id', 'flt_model_score', 'flt_score_variance', 'int_score_count']
	values = [resp_word_ID, model_ID, model_score, stat_variance, stat_count]
	return DB_util.generateInsertStatement(table, columns, values)
Example #2
0
def __get_insertStat_DataStatsTable_Statement(resp_data_ID, pred_data_ID, pred_feature_importance, stat_variance, stat_count):
	table = 'T_DATA_STATISTICS'
	columns = ['int_data_rsp_var_id', 'int_data_prd_var_id', 'adj_prd_feature_importance', 'flt_feat_imp_variance', 'int_feat_imp_count']
	values = [resp_data_ID, pred_data_ID, pred_feature_importance, stat_variance, stat_count]
	return DB_util.generateInsertStatement(table, columns, values)
Example #3
0
def __get_insertWordPoint_WordHistoryTable_Statement(seriesID, date, value):
	table = 'T_WORD_HISTORY'
	columns = ['int_word_master_id', 'dt_date_time', 'flt_word_value']
	values = [seriesID, date, value]
	return DB_util.generateInsertStatement(table, columns, values)
Example #4
0
def __get_insert_WordSeriesID_Statement(seriesName):
	table = 'T_WORD_SERIES'
	columns = ['int_word_series_name']
	values = [seriesName]
	return DB_util.generateInsertStatement(table, columns, values)
Example #5
0
def __get_insertDataPoint_DataHistoryTable_Statement(seriesID, date, value, interpolated, forecast):
	table = 'T_DATA_HISTORY'
	columns = ['int_data_series_ID', 'dt_date_time', 'flt_data_value', 'bool_is_interpolated', 'bool_is_forecast']
	values = [seriesID, date, value, int(interpolated), int(forecast)]
	return DB_util.generateInsertStatement(table, columns, values)
Example #6
0
def __get_insert_DataSeriesID_Metadata(seriesID):
	table = 'T_DATA_SERIES_METADATA'
	columns = ['int_data_series_ID']
	values = [seriesID]
	return DB_util.generateInsertStatement(table, columns, values)
Example #7
0
def __get_insert_DataSeriesID_Statement(name, ticker):
	table = 'T_DATA_SERIES'
	columns = ['txt_data_name', 'txt_data_ticker']
	values = [name, ticker]
	return DB_util.generateInsertStatement(table, columns, values)