public void Complex() { using (var container = new RhetosTestContainer()) { container.Resolve <ISqlExecuter>().ExecuteSql(new[] { "DELETE FROM TestLogging.Complex", "DELETE FROM TestLogging.Simple", }); var repository = container.Resolve <Common.DomRepository>(); var id = Guid.NewGuid(); var simple = new TestLogging.Simple { ID = Guid.NewGuid() }; repository.TestLogging.Simple.Insert(new[] { simple }); var complex = new TestLogging.Complex { bi = new byte[] { 1, 2, 3 }, bo = true, da = new DateTime(2001, 2, 3), t = new DateTime(2001, 2, 3, 4, 5, 6), de = 123.4567m, g = Guid.NewGuid(), ls = "abc", m = 11.22m, rID = simple.ID }; repository.TestLogging.Complex.Insert(new[] { complex }); complex.ls = "def"; repository.TestLogging.Complex.Update(new[] { complex }); repository.TestLogging.Complex.Delete(new[] { complex }); var ids = new Guid?[] { simple.ID, complex.ID }; var ins = repository.Common.Log.Query().Where(log => log.TableName == "TestLogging.Complex" && log.Action == "Insert" && ids.Contains(log.ItemId)).Single(); var upd = repository.Common.Log.Query().Where(log => log.TableName == "TestLogging.Complex" && log.Action == "Update" && ids.Contains(log.ItemId)).Single(); var del = repository.Common.Log.Query().Where(log => log.TableName == "TestLogging.Complex" && log.Action == "Delete" && ids.Contains(log.ItemId)).Single(); Assert.AreEqual("", ins.Description); Assert.AreEqual(@"<PREVIOUS ls=""abc"" />", upd.Description); Console.WriteLine(del.Description); var description = del.Description.Split(' ').OrderBy(x => x).ToList(); Assert.AreEqual(@"/>", description[0]); Assert.AreEqual(@"<PREVIOUS", description[1]); Assert.AreEqual(@"bi=""0x010203""", description[2]); Assert.AreEqual(@"bo=""1""", description[3]); Assert.AreEqual(@"da=""2001-02-03""", description[4]); Assert.IsTrue(new Regex(@"^de=""123\.45670*""$").IsMatch(description[5]));// optional additional zeros Assert.AreEqual(@"g=""" + SqlUtility.GuidToString(complex.g.Value) + @"""", description[6]); Assert.AreEqual(@"ls=""def""", description[7]); Assert.AreEqual(@"m=""11.2200""", description[8]); Assert.AreEqual(@"rID=""" + SqlUtility.GuidToString(simple.ID) + @"""", description[9]); Assert.IsTrue(new Regex(@"^t=""2001-02-03T04:05:06(.0+)?""$").IsMatch(description[10]));// optional milliseconds } }
public void Complex() { using (var container = new RhetosTestContainer()) { container.Resolve<ISqlExecuter>().ExecuteSql(new[] { "DELETE FROM TestLogging.Complex", "DELETE FROM TestLogging.Simple", }); var repository = container.Resolve<Common.DomRepository>(); var id = Guid.NewGuid(); var simple = new TestLogging.Simple { ID = Guid.NewGuid() }; repository.TestLogging.Simple.Insert(new[] { simple }); var complex = new TestLogging.Complex { bi = new byte[] { 1, 2, 3 }, bo = true, da = new DateTime(2001, 2, 3), t = new DateTime(2001, 2, 3, 4, 5, 6), de = 123.4567m, g = Guid.NewGuid(), ls = "abc", m = 11.22m, r = simple }; repository.TestLogging.Complex.Insert(new[] { complex }); complex.ls = "def"; repository.TestLogging.Complex.Update(new[] { complex }); repository.TestLogging.Complex.Delete(new[] { complex }); var ids = new Guid?[] { simple.ID, complex.ID }; var ins = repository.Common.Log.Query().Where(log => log.TableName == "TestLogging.Complex" && log.Action == "Insert" && ids.Contains(log.ItemId)).Single(); var upd = repository.Common.Log.Query().Where(log => log.TableName == "TestLogging.Complex" && log.Action == "Update" && ids.Contains(log.ItemId)).Single(); var del = repository.Common.Log.Query().Where(log => log.TableName == "TestLogging.Complex" && log.Action == "Delete" && ids.Contains(log.ItemId)).Single(); Assert.AreEqual("", ins.Description); Assert.AreEqual(@"<PREVIOUS ls=""abc"" />", upd.Description); Console.WriteLine(del.Description); var description = del.Description.Split(' ').OrderBy(x => x).ToList(); Assert.AreEqual(@"/>", description[0]); Assert.AreEqual(@"<PREVIOUS", description[1]); Assert.AreEqual(@"bi=""0x010203""", description[2]); Assert.AreEqual(@"bo=""1""", description[3]); Assert.AreEqual(@"da=""2001-02-03""", description[4]); Assert.IsTrue(new Regex(@"^de=""123\.45670*""$").IsMatch(description[5]));// optional additional zeros Assert.AreEqual(@"g=""" + SqlUtility.GuidToString(complex.g.Value) + @"""", description[6]); Assert.AreEqual(@"ls=""def""", description[7]); Assert.AreEqual(@"m=""11.2200""", description[8]); Assert.AreEqual(@"rID=""" + SqlUtility.GuidToString(simple.ID) + @"""", description[9]); Assert.IsTrue(new Regex(@"^t=""2001-02-03T04:05:06(.0+)?""$").IsMatch(description[10]));// optional millisconds } }