/// <summary>
/// Plot Width와 1:1의 Plot을 로드한다. 처음에 x축의 min/max가 파악되지 않았을때 사용된다
/// </summary>
/// <param name="db">db인터페이스</param>
/// <param name="table">테이블명</param>
/// <param name="header">칼럼명</param>
/// <param name="i">칼럼인덱스</param>
/// <param name="plotWidth">그려질 plot control의 width</param>
/// <returns></returns>
public static LineSeries fillPlotFrist(DBInterface db, string table, string header, int i, double plotWidth)
{
LineSeries a = new LineSeries();
string q = "SELECT TS, S{1} FROM {0} WHERE Q{1} <= {2} ORDER BY TS";
string s = string.Format(q, table, i, minQ(plotWidth));
DataTable r = db.getDataTable(s);
foreach (var row in r.AsEnumerable())
{
DateTime ts = DateTime.FromBinary(Convert.ToInt64(row["TS"]));
a.Points.Add(new DataPoint(DateTimeAxis.ToDouble(ts),
Convert.ToDouble(row[string.Format("S{0}", i)])));
}
return(a);
}
/*
* dbBaseScheme = "id BIGINT(20) unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY, " +
* "name VARCHAR(50) NOT NULL UNIQUE, " +
* "summary TINYTEXT, " +
* "algo TINYTEXT, " +
* "created DATETIME, " +
* "accessed DATETIME, " +
* "sensor TINYINT NOT NULL, " +
* "sensornames VARCHAR(255)";
*/
public void getTableInfo()
{
tableInfoList.Clear();
DataTable r = db.getDataTable(string.Format("SELECT * FROM {0}", Env.dbBaseName));
tableInfoList = new ObservableCollection <tableInfo>(
r.AsEnumerable().Select(row => new tableInfo {
id = Convert.ToInt64(row["id"]),
name = row.Field <string>("name"),
summary = row.Field <string>("summary"),
algo = row.Field <string>("algo"),
created = row.Field <DateTime>("created"),
accessed = row.Field <DateTime>("accessed"),
sensor = Convert.ToByte(row["sensor"]),
sensornames = row.Field <string>("sensornames")
}));
}
/// <summary>
/// 주어진 scale의 Plot을 로드한다. 바깥 영역은 1:1을 기준으로, 지정한 영역안에서는 scale에 맞게 로드한다.
/// </summary>
/// <param name="db"></param>
/// <param name="a"></param>
/// <param name="table"></param>
/// <param name="header"></param>
/// <param name="i"></param>
/// <param name="plotWidth"></param>
/// <param name="plotMin"></param>
/// <param name="plotMax"></param>
/// <param name="scale"></param>
public static void fillPlot(DBInterface db, LineSeries a, string table, string header, int i, double plotWidth, double plotMin, double plotMax, double scale)
{
long plotMinQ = DateTimeAxis.ToDateTime(plotMin).Ticks;
long plotMaxQ = DateTimeAxis.ToDateTime(plotMax).Ticks;
long plotRange = plotMaxQ - plotMinQ;
plotMinQ -= plotRange / 2;
plotMaxQ += plotRange / 2;
string q = "SELECT TS, S{1} FROM {0} WHERE Q{1} <= {2} OR (TS BETWEEN {3} AND {4} AND Q{1} <= {5}) ORDER BY TS";
string s = string.Format(q, table, i, minQ(plotWidth), plotMinQ, plotMaxQ, minQ(plotWidth * scale));
Debug.Print(s);
DataTable r = db.getDataTable(s);
foreach (var row in r.AsEnumerable())
{
DateTime ts = DateTime.FromBinary(Convert.ToInt64(row["TS"]));
a.Points.Add(new DataPoint(DateTimeAxis.ToDouble(ts),
Convert.ToDouble(row[string.Format("S{0}", i)])));
}
}
/// <summary>
/// Debug모드의 Plot data를 로드한다. 즉 Q값에 상관없이 모든 데이터 로드
/// </summary>
/// <param name="db">db인터페이스</param>
/// <param name="table">테이블명</param>
/// <param name="headers">칼럼명</param>
/// <returns></returns>
public static List <LineSeries> fillPlotDebug(DBInterface db, string table, string[] headers)
{
string q = "SELECT * FROM {0} ORDER BY TS";
string s = string.Format(q, table);
DataTable r = db.getDataTable(s);
List <LineSeries> ret = new List <LineSeries>();
foreach (var h in headers)
{
ret.Add(new LineSeries());
}
foreach (var row in r.AsEnumerable())
{
DateTime ts = DateTime.FromBinary(Convert.ToInt64(row["TS"]));
for (int i = 0; i < headers.Length; i++)
{
ret[i].Points.Add(new DataPoint(DateTimeAxis.ToDouble(ts),
Convert.ToDouble(row[string.Format("S{0}", i)])));
}
}
return(ret);
}
