public void InsertIntoIntTable()
{
DateTime now = DateTime.Now;
string tagName = "MyMeasuredValue";
int tagValue = 12345678;
string remark = "Bla Bla";
int count = ValueTableWriter.SaveValueWhenConditionsAreMet(
new MeasuredValue()
{
Name = tagName,
TimeStamp = now,
Quality = OPCQuality.Good,
Value = tagValue,
Description = remark
}, CompressionCondition.GetNoCompressionCondition());
Assert.AreEqual(1, count);
count = ValueTableWriter.SaveValueWhenConditionsAreMet(
new MeasuredValue()
{
Name = tagName,
TimeStamp = now + new TimeSpan(0, 0, 0, 1, 1),
Quality = OPCQuality.Good,
Value = tagValue,
Description = remark
}, CompressionCondition.GetDefaultCondition());
Assert.AreEqual(0, count);
MeasuredValue mv = ValueTableWriter.ReadLastMeasuredValueFromLocalDB("MyMeasuredValue", TypeCode.Int32);
Assert.AreEqual(tagName, mv.Name);
TimeSpan sp = now - mv.TimeStamp;
// Datenbankgenauigkeit ist bei Datum nicht hoch genug
Assert.Greater(0.1, sp.TotalSeconds);
Assert.AreEqual(tagValue, mv.Value);
Assert.AreEqual(OPCQuality.Good, mv.Quality);
Assert.AreEqual(remark, mv.Description);
}
