public void Parse_WhenQueryWithDatePassedIn_ExpectParsedCorrectly() { // Arrange IDynamicQueryParser queryParser = new DynamicQueryParser(); // Act var stopwatch = Stopwatch.StartNew(); var query = queryParser.Parse <TestEntity>("where::Name:[2018-01-01T00:00:00,*] as datetime orderby::age asc page::1,10"); stopwatch.Stop(); // Assert this.WriteTimeElapsed(stopwatch); }
public void Build_WhenQueryInWithCountCte_ExpectSqlBuilt() { // Arrange var dynamicQueryParser = new DynamicQueryParser(); var query1 = dynamicQueryParser.Parse <TestEntity>("select::ColumnId,Name,Age where::column_id:1 and Name:bob and Age:[18,32}orderby::column_id asc page::1,10"); // Act var stopwatch = Stopwatch.StartNew(); var sqlEntity = query1.CreateSqlQuery().From("users").Build(); stopwatch.Stop(); // Assert this.WriteTimeElapsed(stopwatch); Console.WriteLine(sqlEntity.Sql); }
public void Parse_WhenWherePartOfQuery_ExpectParsedCorrectly() { // Arrange IDynamicQueryParser queryParser = new DynamicQueryParser(); // Act var stopwatch = Stopwatch.StartNew(); var query = queryParser.Parse <TestEntity>("where::Name:\"test name\" and age:[10,25]"); stopwatch.Stop(); // Assert this.WriteTimeElapsed(stopwatch); Assert.That(query.OrderByNodes, Is.Null); Assert.That(query.PageNode, Is.Null); }
public void Parse_WhenNoWhere_ExpectNoWhereOnQueryQuery() { // Arrange IDynamicQueryParser queryParser = new DynamicQueryParser(); // Act var stopwatch = Stopwatch.StartNew(); var query = queryParser.Parse <TestEntity>("orderby::age asc page::1,10"); stopwatch.Stop(); // Assert this.WriteTimeElapsed(stopwatch); Assert.That(query.WhereNode, Is.Null); Assert.That(query.OrderByNodes, Is.Not.Null); Assert.That(query.PageNode, Is.Not.Null); }
public void Parse_WhenEmptyString_ExpectNullQuery() { // Arrange IDynamicQueryParser queryParser = new DynamicQueryParser(); // Act var stopwatch = Stopwatch.StartNew(); var query = queryParser.Parse <TestEntity>(string.Empty); stopwatch.Stop(); // Assert this.WriteTimeElapsed(stopwatch); Assert.That(query.WhereNode, Is.Null); Assert.That(query.OrderByNodes, Is.Null); Assert.That(query.PageNode, Is.Null); }
public void Parse_WhenQueryPassedIn_ExpectParsedCorrectly() { // Arrange IDynamicQueryParser queryParser = new DynamicQueryParser(); // Act var stopwatch = Stopwatch.StartNew(); var query = queryParser.Parse <TestEntity>("where::Name:\"test name\" and age:asdorderby::age asc page::1,10"); stopwatch.Stop(); query.Where(new WhereNode { Statement = new WhereStatement { Value = EqualsNode.CreateEquals("test", "bob") } }); query.Where("val:bob"); // Assert this.WriteTimeElapsed(stopwatch); }