simple-sql-parser

starlitcanopy/simple-sql-parser

Fork 0

Commit graph

6802aaef5a add simple create table support Jake Wheat 2015-08-01 23:16:26 +03:00
2938f642d3 fix to work on ghc 7.8.4, 7.6.3, plus small tweaks Jake Wheat 2015-08-01 21:13:37 +03:00
384bf5088f update changelog Jake Wheat 2015-08-01 20:29:42 +03:00
dfa84072dc start adding basic dml Jake Wheat 2015-08-01 20:26:00 +03:00
6fc8869f73 preparation for non-queries Jake Wheat 2015-08-01 18:08:54 +03:00
0f1f000ee5 add fixity experiment Jake Wheat 2015-08-01 15:58:45 +03:00
bbb793c160 small fixes Jake Wheat 2015-08-01 13:22:07 +03:00
900d19f4c1 use ppShow in tool Jake Wheat 2015-08-01 12:23:10 +03:00
913fce068b small fixes Jake Wheat 2015-08-01 12:13:53 +03:00
2df76e3095 add separate lexer Jake Wheat 2015-08-01 00:04:18 +03:00
1364c58534 use tasty for tests Jake Wheat 2015-07-31 12:45:51 +03:00
c156c5c34e update changelog Jake Wheat 2015-03-14 17:50:17 +02:00
43d81f969a update deps so it compiles with 7.4.2 Jake Wheat 2015-03-14 17:38:00 +02:00
37af90e364 Merge branch 'hanjoosten-master' Jake Wheat 2015-03-14 16:15:53 +02:00
2e6f2fc3f2 update changelog Jake Wheat 2015-03-14 16:15:37 +02:00
db00d50d92 Merge branch 'master' of https://github.com/hanjoosten/simple-sql-parser into hanjoosten-master Jake Wheat 2015-03-14 15:39:54 +02:00
dc5ca57124 Introduced QEComment, constructor, likewise the VEComment constructor Han Joosten 2015-03-14 14:28:05 +01:00
933964e074 Merge branch 'master' of https://github.com/hanjoosten/simple-sql-parser into hanjoosten-master Jake Wheat 2015-03-14 14:06:47 +02:00
258eff5298 Introduction of Comment in syntax, to facilitate comments in programatically generated SQL Han Joosten 2015-03-14 12:40:35 +01:00
3bf4fdbe52 notes Jake Wheat 2014-09-13 10:45:45 +03:00
ba331af24b move limit to only be reserved word in mysql dialect Jake Wheat 2014-06-28 15:43:30 +03:00
c1c514af35 example how to switch parsing and pretty printing depending on dialect Jake Wheat 2014-06-28 15:41:11 +03:00
7d63c8f8e5 start on dialect prototype code Jake Wheat 2014-06-27 12:19:15 +03:00
7914898cc8 update to accept latest mtl Jake Wheat 2014-06-20 12:27:23 +03:00
8996230093 make the typename and app parsers a bit more regular Jake Wheat 2014-05-12 22:06:29 +03:00
6c9a291930 refactor the filter parsing Jake Wheat 2014-05-10 10:02:16 +03:00
7f90318647 refactor the app/agg/window parsing Jake Wheat 2014-05-09 23:26:18 +03:00
4704ccc28e create separate module for generic parser combinator utility functions create separate module for the error formatting wrapper heavily refactor the typename parser to remove almost all trys, convert to applicative only, and left factor nicely other refactoring to use more idiomatic parsing and to convert to applicative only Jake Wheat 2014-05-09 21:37:09 +03:00
9ee2a1beab start reworking some of the combinators Jake Wheat 2014-05-07 21:53:24 +03:00
0248bb90b3 order by tests Jake Wheat 2014-04-21 14:16:45 +03:00
8cabf5abcf remove old 2003 tests add tests for sort specification Jake Wheat 2014-04-20 23:29:22 +03:00
d4a7656bde update changelog Jake Wheat 2014-04-20 23:18:58 +03:00
dbd48baaa1 rename LobTypeName to PrecLengthTypeName rename LobMultiplier and LobUnits to PrecMultiplier and PrecUnits remove support for limit syntax remove the unreserved keyword list since it isn't useful tests for row value constructors tests for table value constructors tests for query specifications tests for explicit table work on tests for setops,order by,offset,fetch and sort specification Jake Wheat 2014-04-20 23:14:55 +03:00
0d1e345262 work on from clause, group by and having tests in 2011 Jake Wheat 2014-04-20 22:10:55 +03:00
be79448414 update the reserved keywords to 2011 list Jake Wheat 2014-04-20 19:38:43 +03:00
9b2ba2fb36 remove ref typename for consistency support t and p multipliers in lob lengths update a few tests Jake Wheat 2014-04-20 19:24:03 +03:00
c50b3e7839 move across most tests from sql2003 to sql2011 plus add a few Jake Wheat 2014-04-20 17:03:32 +03:00
ccd0e6708f start new file for the sql 2011 tests based on the grammar from the draft standard Jake Wheat 2014-04-20 16:13:14 +03:00
d69f1752a5 start working on new sql 2011 tests Jake Wheat 2014-04-19 22:24:10 +03:00
7a7f4ba7aa work around for haddock refusal to parse literal comment lines with * in first character position get rid of code_units since these are not in sql2011 implement next value for parse the nullary functions with reserved names updates to the sql2003 file Jake Wheat 2014-04-19 21:17:19 +03:00
7057241974 add filter and within group aggregates Jake Wheat 2014-04-19 18:01:49 +03:00
59826ecce2 more docs in Parser.lhs Jake Wheat 2014-04-19 15:10:45 +03:00
ddfac442ab rename some functions in parser Jake Wheat 2014-04-19 13:22:11 +03:00
445c10a01d rearrange part of the parser file Jake Wheat 2014-04-19 13:10:46 +03:00
fdb90c0440 change collate and in chartype to be a list of names rearrange and add notes to the parser Jake Wheat 2014-04-19 12:47:25 +03:00
4fa21ceea8 get rid of the string overloads in the tests Jake Wheat 2014-04-19 11:45:45 +03:00
fea6e347bd change joins so natural is represented by separate field to on/using some fixes and tweaks to the reserved keyword handling, especially in the typename parser Jake Wheat 2014-04-19 11:18:29 +03:00
5d9a32a91d reserve most of the reserved keywords in the parser Jake Wheat 2014-04-19 00:18:15 +03:00
6b5a29c052 update docs Jake Wheat 2014-04-18 23:51:05 +03:00
7a84704516 implement reference type name (I think - cannot find any examples or explanation of what it means, didn't try reading the standard itself, just the grammar) Jake Wheat 2014-04-18 21:48:14 +03:00
3b86a06e5c implement complete interval literals Jake Wheat 2014-04-18 21:38:24 +03:00
f64632bbac support two double quotes in quoted identifier plus unicode quoted identifier syntax Jake Wheat 2014-04-18 21:09:46 +03:00
4e1a1da820 basic multiset support Jake Wheat 2014-04-18 20:50:24 +03:00
2ff8580dbf complete basic typename support Jake Wheat 2014-04-18 19:49:00 +03:00
fbdcacc604 modify basic typenames to support dotted names in the syntax add syntax for most of the other kinds of typenames add pretty printing for these todo: the parsing and the tests Jake Wheat 2014-04-18 17:55:56 +03:00
438e3383e4 fix/work around issues with the keywords parsing fix the infix and postfix keywords parsing minor refactoring Jake Wheat 2014-04-18 17:51:57 +03:00
b0f1e044b4 refactor some of the multi keyword/ multiword typename parsing Jake Wheat 2014-04-18 14:50:54 +03:00
247c7a26b7 improve error messages Jake Wheat 2014-04-18 12:28:05 +03:00
2cad424379 change the names in the ast to be lists so can support qualified names everywhere: TRSimple: replaces the TRQualified Iden App name AggregateApp name WindowApp name operator names (not sure if this is used in ansi sql) explicit table function in from clause Jake Wheat 2014-04-18 11:43:37 +03:00
3df87a3cf9 change set quantifier and sort direction to represent default separately Jake Wheat 2014-04-18 11:18:21 +03:00
c814cc9437 tweak to error message for reserved keyword as identifier add in some group by and order by tests Jake Wheat 2014-04-18 10:47:39 +03:00
2e44b7b968 update changelog Jake Wheat 2014-04-18 00:36:50 +03:00
37dca6596b support character set literals, e.g. N'stuff' support collate postfix operator support escape and uescape as postfix operators change the collate support in substring and trim which isn't a special case in the sql 2003 grammar anymore but just a normal collate postfix operator, the old code had the collation name as a string, but the new style is as an identifier Jake Wheat 2014-04-18 00:16:24 +03:00
211174cfb4 work on array constructors and expressions Jake Wheat 2014-04-17 22:57:33 +03:00
4cf84eba7b reenable commented test for quantified comparison predicates Jake Wheat 2014-04-17 22:46:21 +03:00
d38a5a743a move the typed literal parser around implement unique predicate, match predicate change the representation of quantified comparison predicates Jake Wheat 2014-04-17 22:35:43 +03:00
0d3f552ede move typed lit Jake Wheat 2014-04-17 21:42:07 +03:00
490c84b7f1 split typed literal parser from cast parser Jake Wheat 2014-04-17 21:27:54 +03:00
df1f948b5d left factor identifier and app parsers Jake Wheat 2014-04-17 21:05:47 +03:00
a296b1ec31 left factor terms which start with parens (scalar subquery, paren value expr/row ctors) Jake Wheat 2014-04-17 20:59:46 +03:00
d202458808 refactor the interval literal parser to not use try Jake Wheat 2014-04-17 20:53:16 +03:00
556f65ee22 refactor the join parsing to left factor and remove try refactor the string token parser to reduce use of try Jake Wheat 2014-04-17 20:46:16 +03:00
6720d3e3a3 add support for named host parameters Jake Wheat 2014-04-17 19:27:18 +03:00
19df6f18aa don't include unfinished tests in the test suite fix number literals to accept upper case E implement multi part string literals fix tests for string literals, typed literals, boolean literals and number literals in the sql 2003 tests Jake Wheat 2014-04-17 19:19:41 +03:00
488310ff6a add some big improvements to parse error messages change the parser to not attempt to parse the elements following 'from' unless there is a actual 'from' improve the symbol parser to try to deal with issues when symbols are next to eachother with no intervening whitespaces improve number literal parsing to fail if there are trailing letters or digits which aren't part of the number and aren't separated with whitespace add some code to start analysing the quality of parse error messages Jake Wheat 2014-04-17 18:32:41 +03:00
c48b057457 better sql 2003 todo list Jake Wheat 2014-04-16 22:37:18 +03:00
e40ea1ad52 update changelog Jake Wheat 2014-04-16 20:38:19 +03:00
dffd7b0d7a refactor more of the parser to update with ideas from the tutorial parser remove a huge number of 'try' calls in the parser rename some of the parser functions which used prefix s to nicer names Jake Wheat 2014-04-16 20:22:42 +03:00
89015144f9 change the ints in the syntax to be integers partially add buildExprParser hack to deal with some nested prefix and postfix unary operators add new file which starts going through the sql2003 grammar to try to create lots of examples for comprehensive testing of sql2003 support. replace the lexers with lexers from the tutorial project Jake Wheat 2014-04-16 18:58:17 +03:00
8b1fa81de7 fix bug in parsing default as all instead of distinct for set operations Jake Wheat 2014-04-15 13:47:34 +03:00
4989f5251b add Data and Typeable to the syntax Jake Wheat 2014-04-10 18:53:11 +03:00
da27d3147f commit hash for 0.3.1 Jake Wheat 2014-04-10 12:14:08 +03:00
79fde02d81 fix default for distinct/all in union in the pretty printer Jake Wheat 2014-04-09 18:31:14 +03:00
d8791e7725 Merge remote-tracking branch 'origin/master' Jake Wheat 2014-04-08 11:50:20 +03:00
59f8df8050 Merge remote-tracking branch 'soenkehahn/qualified_table_names' Jake Wheat 2014-01-22 22:16:04 +02:00
b385763341 merge Jake Wheat 2014-01-22 22:07:58 +02:00
2e91fb9e81 Allow qualified names ('schema.table') in from clauses Sönke Hahn 2014-01-22 15:54:14 +08:00
cc2b494465 remove unused dependency on haskell-src-exts Jake Wheat 2013-12-31 13:43:26 +02:00
fd42a3cd73 remove self dependency for SqlIndent exe in cabal Jake Wheat 2013-12-31 12:26:05 +02:00
9611885448 update changelog, small haddock fixes Jake Wheat 2013-12-31 12:20:07 +02:00
9e75fa9365 hlint Jake Wheat 2013-12-31 11:44:10 +02:00
7cf5275615 swap order in select lists so the expression comes first then the alias to match the order in the concrete syntax Jake Wheat 2013-12-31 11:31:00 +02:00
552d3f5383 use Parser type from Text.Parsec.String, make imports explicit Jake Wheat 2013-12-31 11:21:03 +02:00
9d8c1badbd give in and use the parsec buildExpressionParser for now jake 2013-12-31 11:02:26 +02:00
40c64c7631 rename qeFetch to qeFetchFirst Jake Wheat 2013-12-19 17:50:25 +02:00
a231c7e9f8 reformat some of the changelog Jake Wheat 2013-12-19 13:38:52 +02:00
df7e6f87da change pretty printer to output 'fetch first' instead of 'fetch next' Jake Wheat 2013-12-19 12:54:48 +02:00
692f8f84ad fixes to haddock and update changelog Jake Wheat 2013-12-19 12:15:05 +02:00
3b2730fd99 rename ScalarExpr -> ValueExpr which is slightly more standard, add notes on new fixity implementation Jake Wheat 2013-12-19 11:46:51 +02:00