internal void _LoadLookups(DbManagerProxy manager, Observation obj) { }
public IObject CreateFake(DbManagerProxy manager, IObject Parent, int?HACode = null) { return(_CreateNew(manager, Parent, HACode, null, null, true)); }
public IObject CreateWithParams(DbManagerProxy manager, IObject Parent, List <object> pars) { return(_CreateNew(manager, Parent, null, null, null)); }
public Lookup2Table CreateWithParamsT(DbManagerProxy manager, IObject Parent, List <object> pars) { return(_CreateNew(manager, Parent, null, null, null)); }
public bool Post(DbManagerProxy manager, IObject obj, bool bChildObject = false) { throw new NotImplementedException(); }
partial void Created(DbManagerProxy manager);
public void ReloadLookupItem(DbManagerProxy manager, string lookup_object) { }
private long _getNewId(DbManagerProxy manager, T obj) { return(getNewId(manager)); }
public RuleFunctionLookup CreateWithParamsT(DbManagerProxy manager, IObject Parent, List <object> pars) { return(_CreateNew(manager, Parent, null, null, null)); }
public void TestArchiveExistingTable() { using (var avrTran = new AvrDbTransaction()) { DbManagerProxy manager = avrTran.Manager; DbManager command = manager.SetCommand( @" DELETE FROM [dbo].[QueryCachePacket] where [idfQueryCache] = @idflQueryCache and ([idfQueryCachePacket] = @idflQueryCachePacket1 or [idfQueryCachePacket] = @idflQueryCachePacket2) DELETE FROM [dbo].[QueryCache] where [idfQueryCache] = @idflQueryCache and [strLanguage] = @strLanguage", manager.Parameter("idflQueryCache", 1), manager.Parameter("strLanguage", "en"), manager.Parameter("idflQueryCachePacket1", 1), manager.Parameter("idflQueryCachePacket2", 2) ); command.ExecuteNonQuery(); avrTran.CommitTransaction(); } Assert.IsNull(AvrDbHelper.GetQueryCacheId(2, "en", false)); Assert.AreEqual(0, AvrDbHelper.GetQueryCacheHeader(1, false, false).BinaryHeader.BinaryBody.Length); Assert.AreEqual(0, AvrDbHelper.GetQueryCachePacket(1, 0).BinaryBody.Length); var header = new byte[10000]; var packet = new byte[20000]; using (var avrTran = new AvrDbTransaction()) { DbManagerProxy manager = avrTran.Manager; DbManager command = manager.SetCommand( @" SET IDENTITY_INSERT [dbo].[QueryCachePacket] OFF SET IDENTITY_INSERT [dbo].[QueryCache] ON INSERT INTO [dbo].[QueryCache] ([idfQueryCache],[idfQuery],[strLanguage],[blbQuerySchema],[intQueryColumnCount],[datQueryRefresh],[datQueryCacheRequest],[blnUseArchivedData],[blnActualQueryCache]) VALUES (@idflQueryCache, @idflQuery, @strLanguage, @binHeaderCache, @intHeaderRowCount, GETDATE(), GETDATE(), 1, 1) SET IDENTITY_INSERT [dbo].[QueryCache] OFF SET IDENTITY_INSERT [dbo].[QueryCachePacket] ON INSERT INTO [dbo].[QueryCachePacket] ([idfQueryCachePacket],[idfQueryCache],[intQueryCachePacketNumber],[blbQueryCachePacket], [intTableRowCount],[blnArchivedData]) VALUES(@idflQueryCachePacket1, @idflQueryCache, 0, @binPacketCache, @intPacketRowCount, 0) INSERT INTO [dbo].[QueryCachePacket] ([idfQueryCachePacket],[idfQueryCache],[intQueryCachePacketNumber],[blbQueryCachePacket], [intTableRowCount],[blnArchivedData]) VALUES(@idflQueryCachePacket2, @idflQueryCache, 1, @binPacketCache, @intPacketRowCount, 1) SET IDENTITY_INSERT [dbo].[QueryCachePacket] OFF", manager.Parameter("idflQueryCache", 1), manager.Parameter("idflQuery", 2), manager.Parameter("strLanguage", "en"), manager.Parameter("idflQueryCachePacket1", 1), manager.Parameter("idflQueryCachePacket2", 2), manager.Parameter("binHeaderCache", header), manager.Parameter("binPacketCache", packet), manager.Parameter("intHeaderRowCount", 10), manager.Parameter("intPacketRowCount", 100) ); command.ExecuteNonQuery(); avrTran.CommitTransaction(); } Assert.AreEqual(1, AvrDbHelper.GetQueryCacheId(2, "en", false)); QueryTableHeaderDTO resultHeader = AvrDbHelper.GetQueryCacheHeader(1, false, false); Assert.AreEqual(10, resultHeader.BinaryHeader.RowCount); Assert.AreEqual(1, resultHeader.PacketCount); Assert.AreEqual(1, resultHeader.QueryCacheId); Assert.AreEqual(false, resultHeader.BinaryHeader.IsArchive); Assert.AreEqual(1, AvrDbHelper.GetQueryCacheId(2, "en", true)); resultHeader = AvrDbHelper.GetQueryCacheHeader(1, false, true); Assert.AreEqual(10, resultHeader.BinaryHeader.RowCount); Assert.AreEqual(2, resultHeader.PacketCount); Assert.AreEqual(1, resultHeader.QueryCacheId); Assert.AreEqual(true, resultHeader.BinaryHeader.IsArchive); QueryTablePacketDTO resultPacket1 = AvrDbHelper.GetQueryCachePacket(1, 0); Assert.AreEqual(20000, resultPacket1.BinaryBody.Length); Assert.AreEqual(false, resultPacket1.IsArchive); QueryTablePacketDTO resultPacket2 = AvrDbHelper.GetQueryCachePacket(1, 1); Assert.AreEqual(20000, resultPacket2.BinaryBody.Length); Assert.AreEqual(true, resultPacket2.IsArchive); }
public void TestExistingTable() { using (var avrTran = new AvrDbTransaction()) { DbManagerProxy manager = avrTran.Manager; DbManager command = manager.SetCommand( @" DELETE FROM [dbo].[QueryCachePacket] where [idfQueryCache] = @idflQueryCache and ([idfQueryCachePacket] = @idflQueryCachePacket1 or [idfQueryCachePacket] = @idflQueryCachePacket2) DELETE FROM [dbo].[QueryCache] where [idfQueryCache] = @idflQueryCache and [strLanguage] = @strLanguage", manager.Parameter("idflQueryCache", 1), manager.Parameter("strLanguage", "en"), manager.Parameter("idflQueryCachePacket1", 1), manager.Parameter("idflQueryCachePacket2", 2) ); command.ExecuteNonQuery(); avrTran.CommitTransaction(); } Assert.IsNull(AvrDbHelper.GetQueryCacheId(2, "en", false)); Assert.AreEqual(0, AvrDbHelper.GetQueryCacheHeader(1, false, false).BinaryHeader.BinaryBody.Length); Assert.AreEqual(0, AvrDbHelper.GetQueryCachePacket(1, 0).BinaryBody.Length); var header = new byte[10000]; for (int i = 0; i < header.Length; i++) { header[i] = (byte)i; } var packet = new byte[20000]; for (int i = 0; i < packet.Length; i++) { packet[i] = (byte)(i + 10); } using (var avrTran = new AvrDbTransaction()) { DbManagerProxy manager = avrTran.Manager; DbManager command = manager.SetCommand( @" SET IDENTITY_INSERT [dbo].[QueryCachePacket] OFF SET IDENTITY_INSERT [dbo].[QueryCache] ON INSERT INTO [dbo].[QueryCache] ([idfQueryCache],[idfQuery],[strLanguage],[blbQuerySchema],[intQueryColumnCount],[datQueryRefresh],[datQueryCacheRequest],[blnUseArchivedData],[blnActualQueryCache]) VALUES (@idflQueryCache, @idflQuery, @strLanguage, @binHeaderCache, @intHeaderRowCount, GETDATE(), GETDATE(), 1, 0) SET IDENTITY_INSERT [dbo].[QueryCache] OFF SET IDENTITY_INSERT [dbo].[QueryCachePacket] ON INSERT INTO [dbo].[QueryCachePacket] ([idfQueryCachePacket],[idfQueryCache],[intQueryCachePacketNumber],[blbQueryCachePacket], [intTableRowCount],[blnArchivedData]) VALUES(@idflQueryCachePacket1, @idflQueryCache, 0, @binPacketCache, @intPacketRowCount, 0) INSERT INTO [dbo].[QueryCachePacket] ([idfQueryCachePacket],[idfQueryCache],[intQueryCachePacketNumber],[blbQueryCachePacket], [intTableRowCount],[blnArchivedData]) VALUES(@idflQueryCachePacket2, @idflQueryCache, 1, @binPacketCache, @intPacketRowCount, 0) SET IDENTITY_INSERT [dbo].[QueryCachePacket] OFF", manager.Parameter("idflQueryCache", 1), manager.Parameter("idflQuery", 2), manager.Parameter("strLanguage", "en"), manager.Parameter("idflQueryCachePacket1", 1), manager.Parameter("idflQueryCachePacket2", 2), manager.Parameter("binHeaderCache", header), manager.Parameter("binPacketCache", packet), manager.Parameter("intHeaderRowCount", 10), manager.Parameter("intPacketRowCount", 100) ); command.ExecuteNonQuery(); avrTran.CommitTransaction(); } Assert.AreEqual(1, AvrDbHelper.GetQueryCacheId(2, "en", false, 7, true)); Assert.AreEqual(1, AvrDbHelper.GetQueryCacheId(new QueryCacheKey(2, "en", true), 7, true)); QueryTableHeaderDTO resultHeader = AvrDbHelper.GetQueryCacheHeader(1, false, false); Assert.AreEqual(10, resultHeader.BinaryHeader.RowCount); Assert.AreEqual(2, resultHeader.PacketCount); Assert.AreEqual(1, resultHeader.QueryCacheId); AssertAreArrayEqual(new ChunkByteArray(header), resultHeader.BinaryHeader.BinaryBody); Assert.AreEqual(20000, AvrDbHelper.GetQueryCachePacket(1, 0).BinaryBody.Length); Assert.AreEqual(20000, AvrDbHelper.GetQueryCachePacket(1, 1).BinaryBody.Length); Assert.AreEqual(0, AvrDbHelper.GetQueryCachePacket(1, 2).BinaryBody.Length); QueryTablePacketDTO resultPacket = AvrDbHelper.GetQueryCachePacket(1, 0); Assert.AreEqual(100, resultPacket.RowCount); AssertAreArrayEqual(new ChunkByteArray(packet), resultPacket.BinaryBody); DateTime dateTime = AvrDbHelper.GetQueryRefreshDateTime(1, "en"); Assert.IsTrue(DateTime.Now.Subtract(dateTime).Seconds < 2); AvrDbHelper.InvalidateQueryCache(2, "en"); Assert.IsNull(AvrDbHelper.GetQueryCacheId(2, "en", false)); Assert.IsNotNull(AvrDbHelper.GetQueryCacheId(2, "en", false, 7, true)); Assert.AreNotEqual(0, AvrDbHelper.GetQueryCacheHeader(1, false, false).BinaryHeader.BinaryBody.Length); Assert.AreNotEqual(0, AvrDbHelper.GetQueryCachePacket(1, 0).BinaryBody.Length); AvrDbHelper.DeleteQueryCache(2, "en", true); Assert.IsNull(AvrDbHelper.GetQueryCacheId(2, "en", false)); Assert.IsNotNull(AvrDbHelper.GetQueryCacheId(2, "en", false, 7, true)); }
internal void _LoadLookups(DbManagerProxy manager, CountryLookup obj) { }
internal void _LoadLookups(DbManagerProxy manager, RuleConstant obj) { }
public RuleConstant CreateNewT(DbManagerProxy manager, IObject Parent, int?HACode = null) { return(_CreateNew(manager, Parent, HACode, null, null)); }
internal void _LoadLookups(DbManagerProxy manager, OutbreakLookup obj) { }
internal void _LoadLookups(DbManagerProxy manager, RuleFunctionLookup obj) { }
public bool Validate(DbManagerProxy manager, IObject obj, bool bPostValidation, bool bChangeValidation, bool bDeepValidation, bool bRethrowException = false) { return(Validate(manager, obj as Lookup2Table, bPostValidation, bChangeValidation, bDeepValidation, bRethrowException)); }
public RuleFunctionLookup CreateNewT(DbManagerProxy manager, IObject Parent, int?HACode = null) { return(_CreateNew(manager, Parent, HACode, null, null)); }
partial void Loaded(DbManagerProxy manager);
public eidss.openapi.contract.PatientListItem ToContract(DbManagerProxy manager, eidss.model.Schema.PatientListItem m) { return(m == null ? null : Mapper.Map <eidss.openapi.contract.PatientListItem>(m)); }
public Lookup2Table CreateNewT(DbManagerProxy manager, IObject Parent, int?HACode = null) { return(_CreateNew(manager, Parent, HACode, null, null)); }
public model.Schema.PatientListItem ToModel(DbManagerProxy manager, eidss.model.Schema.PatientListItem m, eidss.openapi.contract.PatientListItem c) { throw new NotImplementedException(); }
internal void _LoadLookups(DbManagerProxy manager, Lookup2Table obj) { }
public List <PatientListItem> ToContract(DbManagerProxy manager, IList <model.Schema.PatientListItem> m) { return(m.Where(i => !i.IsMarkedToDelete) .Select(c => ToContract(manager, c)) .ToList()); }
public SmphBaseReferenceLookup CreateFakeT(DbManagerProxy manager, IObject Parent, int?HACode = null) { return(_CreateNew(manager, Parent, HACode, null, null, true)); }
public EditableList <model.Schema.PatientListItem> ToModel(DbManagerProxy manager, IObject parent, EditableList <model.Schema.PatientListItem> m, List <PatientListItem> c) { throw new NotImplementedException(); }
public SmphBaseReferenceLookup CreateWithParamsT(DbManagerProxy manager, IObject Parent, List <object> pars) { return(_CreateNew(manager, Parent, null, null, null)); }
public OutbreakLookup CreateFakeT(DbManagerProxy manager, IObject Parent, int?HACode = null) { return(_CreateNew(manager, Parent, HACode, null, null, true)); }
internal void _LoadLookups(DbManagerProxy manager, SmphBaseReferenceLookup obj) { }
public Observation CreateNewT(DbManagerProxy manager, IObject Parent, int?HACode = null) { return(_CreateNew(manager, Parent, HACode, null, null)); }