C# SqlLogSpy.GetWholeLog方法代码示例

		public void CanOverrideStringEnumGetValue()
		{
		    string paramPrefix = ((DriverBase) Sfi.ConnectionProvider.Driver).NamedPrefix;
			using (ISession s = OpenSession())
			using (ITransaction tx = s.BeginTransaction())
			{
				using (SqlLogSpy ls = new SqlLogSpy())
				{
					Person person = new Person() { Sex = Sex.Male };
					s.Save(person);

					string log = ls.GetWholeLog();
					Assert.IsTrue(log.Contains(paramPrefix + "p0 = 'M'"));
				}

				using (SqlLogSpy ls = new SqlLogSpy())
				{
					Person person =
						s.CreateQuery("from Person p where p.Sex = :personSex")
							.SetParameter("personSex", Sex.Female)
							.UniqueResult<Person>();

					Assert.That(person, Is.Null);

					string log = ls.GetWholeLog();
					Assert.IsTrue(log.Contains(paramPrefix + "p0 = 'F'"));
				}

				tx.Rollback();
			}
		}

		public void WhenPersistShouldNotFetchUninitializedCollection()
		{
			var companyId = CreateScenario();

			//Now in a second transaction i remove the address and persist Company: for a cascade option the Address will be removed
			using (var sl = new SqlLogSpy())
			{
				using (ISession session = sessions.OpenSession())
				{
					using (ITransaction tx = session.BeginTransaction())
					{
						var company = session.Get<Company>(companyId);
						company.Addresses.Count().Should().Be.EqualTo(1);
						company.RemoveAddress(company.Addresses.First()).Should().Be.EqualTo(true);

						//now this company will be saved and deleting the address.
						//BUT it should not try to load the BanckAccound collection!
						session.Persist(company);
						tx.Commit();
					}
				}
				var wholeMessage = sl.GetWholeLog();
				wholeMessage.Should().Not.Contain("BankAccount");
			}

			Cleanup(companyId);
		}

		public void DeleteWithoutUpdateVersion()
		{
			using (ISession s = OpenSession())
			using (ITransaction t = s.BeginTransaction())
			{
				s.Save(new ObjectA { Bs = new List<ObjectB> { new ObjectB(), new ObjectB() } });
				t.Commit();
			}

			using (var ls = new SqlLogSpy())
			{
				using (ISession s = OpenSession())
				using (ITransaction t = s.BeginTransaction())
				{
					var a = s.CreateCriteria<ObjectA>().UniqueResult<ObjectA>();
					s.Delete(a);
					t.Commit();
				}
				string wholeLog = ls.GetWholeLog();
				Assert.That(wholeLog, Is.Not.StringContaining("UPDATE ObjectA"));
				Assert.That(wholeLog, Is.StringContaining("UPDATE ObjectB"),"should create orphans");
			}

			using (ISession s = OpenSession())
			using (ITransaction t = s.BeginTransaction())
			{
				s.CreateQuery("delete from ObjectB").ExecuteUpdate();
				s.CreateQuery("delete from ObjectA").ExecuteUpdate();
				t.Commit();
			}
		}

 public void ComparisonToConstantShouldBeInnerJoin()
 {
     using (var sqlLog = new SqlLogSpy())
     using (var session = OpenSession())
     {
         session.Query<MyBO>().Where(b => b.BO1.I1 == 1).ToList();
         var log = sqlLog.GetWholeLog();
         Assert.AreEqual(0, CountOuterJoins(log));
         Assert.AreEqual(1, CountInnerJoins(log));
     }
 }

 public void EqualsNullShouldBeOuterJoin()
 {
     using (var sqlLog = new SqlLogSpy())
     using (var session = OpenSession())
     {
         session.Query<MyBO>().Where(b => b.BO1.BO2 == null).ToList();
         var log = sqlLog.GetWholeLog();
         Assert.AreEqual(1, CountOuterJoins(log));
         Assert.AreEqual(0, CountInnerJoins(log));
     }
 }

		public void SelectAllAnimalsShouldPerformJoins()
		{
			using (var session = OpenSession())
			using (session.BeginTransaction())
			{
				using (var spy = new SqlLogSpy())
				{
					var list = session.CreateQuery("from Animal").List<Animal>();
					var count = list.Count();
					Assert.AreEqual(3, count);
					Assert.Greater(1, spy.GetWholeLog().Split(new[] {"inner join"}, StringSplitOptions.None).Count());
				}
			}
		}

		public void Bug()
		{
			using (ISession s = OpenSession())
			{
				long? filter = null;
				using (var ls = new SqlLogSpy())
				{
					s.CreateQuery(@"SELECT c FROM xchild c WHERE (:filternull = true OR c.Parent.A < :filterval)")
						.SetParameter("filternull", !filter.HasValue)
						.SetParameter("filterval", filter.HasValue ? filter.Value : 0).List<xchild>();
					var message = ls.GetWholeLog();
					Assert.That(message, Text.Contains("xchild0_.ParentId=xparent1_.Id and (@p0=1 or xparent1_.A<@p1)"));
				}
			}
		}

		public void ShouldNotContainJoinWhereNotRequired()
		{
			using (var session = OpenSession())
			{
				using (var ls = new SqlLogSpy())
				{
					ICriteria criteria = session.CreateCriteria(typeof(Entity1));
					criteria.CreateAlias("Entities2", "ent2", JoinType.InnerJoin);
					criteria.List<Entity1>();
					var sql = ls.GetWholeLog();
					var rx = new Regex(@"\bjoin\b");
					Assert.That(rx.Matches(sql).Count, Is.EqualTo(1));
				}
			}
		}

		public void Bug()
		{
			using (ISession s = OpenSession())
			{
				long? filter = null;
				using (var ls = new SqlLogSpy())
				{
					s.CreateQuery(@"SELECT c FROM xchild c WHERE (:filternull = true OR c.Parent.A < :filterval)")
						.SetParameter("filternull", !filter.HasValue)
						.SetParameter("filterval", filter.HasValue ? filter.Value : 0).List<xchild>();
					var message = ls.GetWholeLog();
				    string paramPrefix = ((DriverBase) Sfi.ConnectionProvider.Driver).NamedPrefix;
					Assert.That(message, Is.StringContaining("xchild0_.ParentId=xparent1_.Id and (" + paramPrefix + "p0=" + Dialect.ToBooleanValueString(true) + " or xparent1_.A<" + paramPrefix + "p1)"));
				}
			}
		}

		public void CanCahceDynamicLinq()
		{
			//dynamic orderby clause
			var users = db.Users
						  .Cacheable()
						  .Fetch(x => x.Role)
						  .OrderBy("RegisteredAt");

			users
			  .ToList();

			using (var log = new SqlLogSpy())
			{
				users.ToList();
				Assert.IsNullOrEmpty(log.GetWholeLog());
			}
		}

		public void SaveCanOverrideStringEnumGetValue()
		{
			var paramPrefix = ((DriverBase) Sfi.ConnectionProvider.Driver).NamedPrefix;
			using (var ls = new SqlLogSpy())
			{
				using (var s = OpenSession())
				using (var t = s.BeginTransaction())
				{
					var person = new Person { Sex = Sex.Male };
					s.Save(person);

					t.Commit();
				}
				
				var log = ls.GetWholeLog();
				Assert.That(log.Contains(paramPrefix + "p0 = 'M'"), Is.True);
			}
		}

		public void WhenQueryConstantNotEqualToMemberThenDoesNotUseTheCaseConstructor()
		{
			using (new Scenario(Sfi))
			{
				using (var session = OpenSession())
				{
					using (var sqls = new SqlLogSpy())
					{
						Assert.That(session.Query<MyClass>().Where(x => x.Alive != false).ToList(), Has.Count.EqualTo(1));
						Assert.That(caseClause.Matches(sqls.GetWholeLog()).Count, Is.EqualTo(0));
					}
					using (var sqls = new SqlLogSpy())
					{
						Assert.That(session.Query<MyClass>().Where(x => true != x.Alive).ToList(), Has.Count.EqualTo(1));
						Assert.That(caseClause.Matches(sqls.GetWholeLog()).Count, Is.EqualTo(0));
					}
				}
			}
		}

		public void ReadCanOverrideStringEnumGetValue()
		{
			var paramPrefix = ((DriverBase) Sfi.ConnectionProvider.Driver).NamedPrefix;
			using (var ls = new SqlLogSpy())
			{
				using (var s = OpenSession())
				using (s.BeginTransaction())
				{
					var person = s.CreateQuery("from Person p where p.Sex = :personSex")
						.SetParameter("personSex", Sex.Female)
						.UniqueResult<Person>();

					Assert.That(person, Is.Null);
				}
			   
				string log = ls.GetWholeLog();
				Assert.IsTrue(log.Contains(paramPrefix + "p0 = 'F'"));
			}
		}

		public void WhenQueryConstantNotEqualToMemberThenDoesNotUseTheCaseConstructor()
		{
			using (new Scenario(Sfi))
			{
				using (var session = OpenSession())
				{
					using (var sqls = new SqlLogSpy())
					{
						session.Query<MyClass>().Where(x => x.Alive != false).Should().Have.Count.EqualTo(1);
						caseClause.Matches(sqls.GetWholeLog()).Count.Should().Be(0);
					}
					using (var sqls = new SqlLogSpy())
					{
						session.Query<MyClass>().Where(x => true != x.Alive).Should().Have.Count.EqualTo(1);
						caseClause.Matches(sqls.GetWholeLog()).Count.Should().Be(0);
					}
				}
			}
		}

		public void TheJoinShouldBeOptional()
		{
			FillDb();
			int criteriaCount;

			using (ISession session = OpenSession())
			{
				using (var ls = new SqlLogSpy())
				{
					ICriteria c = session.CreateCriteria(typeof(TestClass));
					IList<TestClass> retvalue = c.List<TestClass>();
					Assert.That(ls.GetWholeLog(), Is.Not.StringContaining("join"));
					criteriaCount = retvalue.Count;
				}
			}
			Assert.That(criteriaCount, Is.EqualTo(1));

			Cleanup();
		}