public void testOrderByClauseUnspecified() { var transformer = new StandardPagingTransformer(5, 10, null); var parser = new DomaSqlParser("select * from emp"); var ex = Assert.Throws <SqlTransformException>(() => transformer.Transform(parser.Parse())); ex.IsNotNull(); ex.MessageId.Is(ExceptionMessageId.Esp2201); }
public void testLimitOnly() { var expected = "select * from ( select temp_.*, row_number() over( order by temp_.id ) as esp_rownumber_ from ( select emp.id from emp ) as temp_ ) as temp2_ where esp_rownumber_ <= 10"; var transformer = new StandardPagingTransformer(-1, 10, null); var parser = new DomaSqlParser("select emp.id from emp order by emp.id"); var node = transformer.Transform(parser.Parse()); var parameters = new List <ParameterEmulator>(); var builder = new DomaSqlBuilder(node, parameters, _config); var result = builder.Build(); result.ParsedSql.Is(expected); }
internal virtual ISqlNode ToPagingSqlNode(ISqlNode node, long offset, long limit, string rowNumberColumn) { var transformer = new StandardPagingTransformer(offset, limit, rowNumberColumn); return(transformer.Transform(node)); }