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);
}
