public void testLimitOnly() { var expected = "select * from emp order by emp.id limit 10 offset 0"; var transformer = new SqlitePagingTransformer(-1, 10, null); var parser = new DomaSqlParser("select * 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 override ISqlNode ToPagingSqlNode(ISqlNode node, long offset, long limit, string rowNumberColumn) { var transformer = new SqlitePagingTransformer(offset, limit, rowNumberColumn); return(transformer.Transform(node)); }