public void AvrServiceViewChartTest()
{
using (var wrapper = new AvrServiceClientWrapper(m_HostKeeper.CurrentServiceHostURL))
{
var receiver = new AvrCacheReceiver(wrapper);
AvrPivotViewModel view;
long layoutId = LayoutFormSave();
using (new StopwathTransaction("++++ GetView ++++"))
{
view = receiver.GetCachedView("xxx", layoutId, "ru");
}
Assert.IsNotNull(view);
Assert.IsNotNull(view.ViewData);
Assert.IsNotNull(view.ViewHeader);
ChartExportDTO chartBytes;
using (new StopwathTransaction("++++ GetChart ++++"))
{
var tableModel = new ChartTableModel(layoutId, "ru", ExportChartToJpgTests.CreateChartData(), null, DBChartType.chrBar,
null,
1000, 750);
chartBytes = receiver.ExportChartToJpg(tableModel);
}
Assert.IsNotNull(chartBytes);
Assert.IsNotNull(chartBytes.JpgBytes);
Assert.IsTrue(chartBytes.JpgBytes.Length > 0);
ExportTests.AssertJpeg(chartBytes.JpgBytes);
//File.WriteAllBytes("filexx.jpg", chartBytes);
}
}
public void SimpleQueryTest()
{
var facadeStub = new AVRFacadeStub(123);
var receiver = new AvrCacheReceiver(facadeStub);
AvrDataTable dataTable;
using (new StopwathTransaction("+++GetCachedQueryTable+++"))
{
CachedQueryResult result = receiver.GetCachedQueryTable(1, "en", false, string.Empty, new LayoutSilentValidatorWaiter());
dataTable = result.QueryTable;
Assert.IsNotNull(dataTable);
}
Assert.IsNotNull(dataTable);
Assert.AreEqual(54 * 2, dataTable.Columns.Count);
Assert.AreEqual(31, dataTable.Rows.Count);
var caseIdIndex = dataTable.Columns["sflHC_CaseID"].Ordinal;
AvrDataRowBase lastRow = dataTable.Rows.Find(r => Utils.Str(r[caseIdIndex]) == "HC1000031");
Assert.AreEqual(new DateTime(1990, 02, 01), lastRow[0]);
Assert.AreEqual(23, lastRow[1]);
Assert.AreEqual(DBNull.Value, lastRow[3]);
Assert.AreEqual("xxx", lastRow[4]);
Assert.AreEqual("Male", lastRow[6]);
Assert.AreEqual(DBNull.Value, lastRow[7]);
Assert.AreEqual(DateTime.Now.Year, ((DateTime)lastRow[50]).Year);
Assert.AreEqual(DateTime.Now.Year, lastRow[51]);
Assert.AreEqual(25460000000m, lastRow[52]);
Assert.AreEqual("Yes", lastRow[53]);
}
public void GetCachedQueryAndProcessTest()
{
const long queryId = 49539640000000;
const string lang = "en";
var facade = new AVRFacade(m_Container);
facade.InvalidateQueryCacheForLanguage(queryId, lang);
//first run
var receiver = new AvrCacheReceiver(facade);
CachedQueryResult result;
using (new StopwathTransaction("+++GetCachedQueryTable+++"))
{
result = receiver.GetCachedQueryTable(queryId, lang, false, string.Empty, new LayoutSilentValidatorWaiter());
}
Assert.IsNotNull(result);
Assert.AreEqual(m_FieldCount * 2, result.QueryTable.Columns.Count);
Assert.IsTrue(1500 < result.QueryTable.Rows.Count);
//second run
receiver = new AvrCacheReceiver(facade);
using (new StopwathTransaction("+++GetCachedQueryTable+++"))
{
result = receiver.GetCachedQueryTable(queryId, lang, false, string.Empty, new LayoutSilentValidatorWaiter());
}
Assert.IsNotNull(result);
Assert.AreEqual(m_FieldCount * 2, result.QueryTable.Columns.Count);
Assert.IsTrue(1500 < result.QueryTable.Rows.Count);
}
private CachedQueryResult QueryExecutor(long queryId, string lang, bool isArchive, string filter)
{
var receiver = new AvrCacheReceiver(new AVRFacade(m_Container));
var validatorWaiter = new LayoutSilentValidatorWaiter();
CachedQueryResult result = receiver.GetCachedQueryTable(queryId, lang, isArchive, filter, validatorWaiter);
return(result);
}
public void ExportChartToJpgTest()
{
var facadeStub = new AVRFacadeStub(123);
var receiver = new AvrCacheReceiver(facadeStub);
ChartExportDTO result;
using (new StopwathTransaction("+++ExportChartToJpg+++"))
{
result = receiver.ExportChartToJpg(new ChartTableModel(-1, "en", new DataTable(), null, null, null, 100, 100));
}
Assert.IsNotNull(result);
Assert.IsNotNull(result.JpgBytes);
ExportTests.AssertJpeg(result.JpgBytes);
}
public void GetCachedQueryTwiceFailTest()
{
const long queryId = 49539640000000;
const string lang = "en";
var facade = new AVRFacade(m_Container);
facade.InvalidateQueryCacheForLanguage(queryId, lang);
//first run
var receiver = new AvrCacheReceiver(facade);
receiver.GetCachedQueryTable(queryId, lang, false, string.Empty, new LayoutSilentValidatorWaiter());
receiver.GetCachedQueryTable(queryId, lang, false, string.Empty, new LayoutSilentValidatorWaiter());
}
public void LongQueryTest()
{
var facadeStub = new AVRFacadeStub(123, 200);
var receiver = new AvrCacheReceiver(facadeStub);
AvrDataTable dataTable;
using (new StopwathTransaction("+++GetCachedQueryTable+++"))
{
CachedQueryResult result = receiver.GetCachedQueryTable(1, "en", false, string.Empty, new LayoutSilentValidatorWaiter());
dataTable = result.QueryTable;
}
Assert.IsNotNull(dataTable);
Assert.AreEqual(54 * 2, dataTable.Columns.Count);
Assert.AreEqual(31 * 200, dataTable.Rows.Count);
}
public void AvrServiceViewSaveInvalidateTest()
{
using (var wrapper = new AvrServiceClientWrapper(m_HostKeeper.CurrentServiceHostURL))
{
var receiver = new AvrCacheReceiver(wrapper);
AvrPivotViewModel view;
long layoutId = LayoutFormSave();
using (new StopwathTransaction("++++ GetView ++++"))
{
view = receiver.GetCachedView("xxx", layoutId, "ru");
}
Assert.IsNotNull(view);
Assert.IsNotNull(view.ViewData);
Assert.IsNotNull(view.ViewHeader);
using (new StopwathTransaction("++++ InvalidateView ++++"))
{
wrapper.InvalidateViewCache(layoutId);
}
}
}
public void AvrServiceArchiveTest()
{
const long humQueryId = 49539640000000;
using (var wrapper = new AvrServiceClientWrapper(m_HostKeeper.CurrentServiceHostURL))
{
var receiver = new AvrCacheReceiver(wrapper);
AvrDataTable dataTable;
using (new StopwathTransaction("++++ Hum - GetCachedQueryTable - en 1"))
{
CachedQueryResult result = receiver.GetCachedQueryTable(humQueryId, "en", true,
string.Empty, new LayoutSilentValidatorWaiter());
Assert.IsNotNull(result);
dataTable = result.QueryTable;
}
Assert.IsNotNull(dataTable);
Assert.AreEqual(m_HumanFieldCount * 2, dataTable.Columns.Count);
Assert.IsTrue(1500 * 2 < dataTable.Rows.Count);
}
}
public void ViewReceiverTest()
{
var facadeStub = new AVRFacadeStub(123);
var receiver = new AvrCacheReceiver(facadeStub);
AvrPivotViewModel model;
using (new StopwathTransaction("+++GetCachedView+++"))
{
model = receiver.GetCachedView("xx", -1, "en");
}
Assert.IsNotNull(model);
Assert.IsNotNull(model.ViewHeader);
Assert.IsNotNull(model.ViewData);
string viewXmlNew = AvrViewSerializer.Serialize(model.ViewHeader);
Assert.AreEqual(SerializedViewStub.ViewXml, viewXmlNew);
string dataXmlNew = DataTableSerializer.Serialize(model.ViewData);
Assert.AreEqual(SerializedViewStub.DataXml, dataXmlNew);
}
public void AvrServiceFullProcessTest()
{
const long humQueryId = 49539640000000;
const long vetQueryId = 49542020000000;
using (var wrapper = new AvrServiceClientWrapper(m_HostKeeper.CurrentServiceHostURL))
{
AvrDataTable dataTable;
using (new StopwathTransaction("++++ Hum - GetCachedQueryTable - en 1"))
{
var receiver = new AvrCacheReceiver(wrapper);
receiver.GetCachedQueryTable(humQueryId, "en", false, string.Empty, new LayoutSilentValidatorWaiter());
}
using (new StopwathTransaction("++++ Hum - GetCachedQueryTable - ru"))
{
var receiver = new AvrCacheReceiver(wrapper);
receiver.GetCachedQueryTable(humQueryId, "ru", false, string.Empty, new LayoutSilentValidatorWaiter());
}
using (new StopwathTransaction("++++ Hum - GetCachedQueryTable - en 2"))
{
var receiver = new AvrCacheReceiver(wrapper);
CachedQueryResult result = receiver.GetCachedQueryTable(humQueryId, "en", false, string.Empty,
new LayoutSilentValidatorWaiter());
Assert.IsNotNull(result);
dataTable = result.QueryTable;
}
Assert.IsNotNull(dataTable);
Assert.AreEqual(m_HumanFieldCount * 2, dataTable.Columns.Count);
Assert.IsTrue(1500 < dataTable.Rows.Count);
using (new StopwathTransaction("++++ Vet - InvalidateQueryCache - en"))
{
wrapper.InvalidateQueryCacheForLanguage(vetQueryId, "en");
}
using (new StopwathTransaction("++++ Vet - GetCachedQueryTable - en 1"))
{
var receiver = new AvrCacheReceiver(wrapper);
receiver.GetCachedQueryTable(vetQueryId, "en", false, string.Empty, new LayoutSilentValidatorWaiter());
}
using (new StopwathTransaction("++++ Vet - GetCachedQueryTable - en 2"))
{
var receiver = new AvrCacheReceiver(wrapper);
CachedQueryResult result = receiver.GetCachedQueryTable(vetQueryId, "en", false, string.Empty,
new LayoutSilentValidatorWaiter());
Assert.IsNotNull(result);
dataTable = result.QueryTable;
}
Assert.IsNotNull(dataTable);
Assert.AreEqual(m_VetFieldCount * 2, dataTable.Columns.Count);
Assert.IsTrue(1000 < dataTable.Rows.Count);
}
using (var wrapper = new AvrServiceClientWrapper(m_HostKeeper.CurrentServiceHostURL))
{
using (new StopwathTransaction("++++ Hum - new Client - GetCachedQueryTable - en 1"))
{
var receiver = new AvrCacheReceiver(wrapper);
receiver.GetCachedQueryTable(humQueryId, "en", false, string.Empty, new LayoutSilentValidatorWaiter());
}
using (new StopwathTransaction("++++ Hum - new Client - GetCachedQueryTable - en 2"))
{
var receiver = new AvrCacheReceiver(wrapper);
receiver.GetCachedQueryTable(humQueryId, "en", false, string.Empty, new LayoutSilentValidatorWaiter());
}
}
}
