private string GetUpdateSQL(SeriesDataModel.TimeSeriesData input, SeriesDataModel.Point pt) { // MANUAL SQL string sqlString = "update " + input.series.tablename + " set value='" + pt.value + "' where datetime=" + "str_to_date('" + pt.datetime + "','%m/%d/%Y %r')"; return(sqlString); }
private string GetInsertSQL(SeriesDataModel.TimeSeriesData input, SeriesDataModel.Point pt) { // MANUAL SQL string sqlString = "insert into " + input.series.tablename + " (datetime,value,flag) values " + "(str_to_date('" + pt.datetime + "','%m/%d/%Y %r'),'" + pt.value + "','" + pt.flag + "')"; return(sqlString); }