Merge branch 'devel' of github.com:nim-lang/Nim into devel

2 files changed, 310 insertions, 0 deletions

diff --git a/tests/stdlib/somesql.sql b/tests/stdlib/somesql.sql
new file mode 100644
index 000000000..285f93cec
--- /dev/null
+++ b/tests/stdlib/somesql.sql
@@ -0,0 +1,298 @@
+create table anon40(
+  anon41 anon42 primary key default anon43(),
+  anon44 text unique not null,
+  anon45 text unique not null,
+  anon46 text not null,
+  anon47 text not null,
+  anon48 text default null,
+  anon49 text default null,
+  anon50 text default null,
+  anon51 text default null,
+  anon52 text default null,
+  anon53 text default null,
+  anon54 text default null,
+  anon55 text default null,
+  anon56 text default null,
+  anon57 text default null,
+  anon58 text default null,
+  anon59 text default null,
+  anon60 text default null,
+  anon61 text default null,
+  anon62 varchar(30) default null,
+  anon63 varchar(30) default null);
+create table anon64(
+  anon41 serial  primary key,
+  anon65 varchar(30) not null unique,
+  anon46 varchar(30) not null,
+  anon66 varchar(30) not null,
+  anon47 varchar(30) not null,
+  anon67 text not null,
+  anon55 varchar(30) not null unique,
+  anon68 varchar(30) default 'o',
+  anon69 boolean default true,
+  anon70 int not null  references anon40(anon41));
+create table anon71(
+  anon72 varchar(30) not null  primary key,
+  anon73 varchar(30) not null unique,
+  anon70 int not null  references anon40(anon41));
+create table anon74(
+  anon72 varchar(30) not null  primary key,
+  anon73 varchar(30) not null unique,
+  anon75 varchar(30) not null,
+  anon70 int not null references anon40(anon41),
+  foreign key(anon75) references anon71(anon72));
+create table anon76(
+  anon41 serial  primary key,
+  anon72 varchar(30) not null unique,
+  anon73 varchar(30) not null unique,
+  anon77 varchar(30) not null,
+  anon70 int not null  references anon40(anon41),
+  foreign key(anon77) references anon74(anon72));
+create table anon78(
+  anon41 serial  primary key,
+  anon72 varchar(30) not null unique,
+  anon73 varchar(30) not null unique,
+  anon79 int not null,
+  anon80 varchar(30) default null,
+  anon81 int not null,
+  anon69 boolean not null default true,
+  anon70 int not null  references anon40(anon41),
+  foreign key(anon79) references anon78(anon41),
+  foreign key(anon81) references anon76(anon41));
+create table anon82(
+  anon41 serial  primary key,
+  anon72 varchar(30) not null unique,
+  anon73 text not null unique,
+  anon79 int not null,
+  anon80 text default null,
+  anon83 varchar(30) not null default 'd',
+  anon84 decimal default 0.00,
+  anon69 boolean not null default true,
+  anon85 decimal default 0.00,
+  anon86 decimal default 0.00,
+  anon87 decimal default 0.00,
+  anon70 int not null  references anon40(anon41),
+  foreign key(anon79) references anon78(anon41));
+create table anon88(
+  anon41 serial  primary key,
+  anon72 varchar(30) not null unique,
+  anon80 text default '',
+  anon69 boolean not null default true,
+  anon70 int not null  references anon40(anon41));
+create table anon89(
+  anon90 int not null  primary key,
+  anon91 anon92 default 0.00,
+  anon93 varchar(30),
+  anon69 boolean not null default true,
+  anon70 int not null  references anon40(anon41),
+  foreign key(anon90) references anon82(anon41));
+create table anon94(
+  anon41 serial  primary key,
+  anon73 text unique not null,
+  anon80 text default null,
+  anon69 boolean not null default true,
+  anon70 int not null  references anon40(anon41));
+create table anon95(
+  anon41 serial  primary key,
+  anon73 text unique not null,
+  anon96 int not null  references anon94(anon41),
+  anon80 text default null,
+  anon69 boolean not null default true,
+  anon70 int not null  references anon40(anon41));
+create table anon97(
+  anon41 serial  primary key,
+  anon73 text unique not null,
+  anon98 int not null  references anon95(anon41),
+  anon80 text default null,
+  anon69 boolean not null default true,
+  anon70 int not null  references anon40(anon41));
+create table anon99(
+  anon41 serial  primary key,
+  anon73 varchar(30) unique not null,
+  anon100 varchar(30) default null,
+  anon101 anon102 default 0,
+  anon103 varchar(30) default 'g',
+  anon104 int not null,
+  anon105 decimal not null default 1,
+  anon69 boolean not null default true,
+  anon70 int not null  references anon40(anon41));
+create table anon106(
+  anon107 varchar(30) default 'g',
+  anon108 int  references anon99(anon41) not null,
+  anon109 decimal default 1,
+  anon110 int  references anon99(anon41) not null,
+  anon70 int not null  references anon40(anon41));
+create table anon111(
+  anon41 serial  primary key,
+  anon112 text unique not null,
+  anon73 text unique not null,
+  anon113 anon102  references anon97(anon41) not null,
+  anon114 varchar(30) not null,
+  anon115 int not null  references anon88(anon41),
+  anon116 int not null  references anon82(anon41),
+  anon117 int not null  references anon82(anon41),
+  anon118 int not null  references anon82(anon41),
+  anon119 int not null  references anon82(anon41),
+  anon120 int not null  references anon82(anon41),
+  anon121 int not null  references anon82(anon41),
+  anon122 int  references anon99(anon41) not null,
+  anon123 decimal default 0.00,
+  anon124 decimal default 0.00,
+  anon69 boolean default true,
+  anon70 int not null  references anon40(anon41));
+create table anon125(
+  anon41 serial  primary key,
+  anon126 int  references anon111(anon41) not null,
+  anon80 text not null,
+  anon127 varchar(30) not null,
+  anon128 decimal default 0.00,
+  anon129 decimal default 0,
+  anon130 decimal default 0,
+  anon131 decimal default 0,
+  anon132 decimal default 0,
+  anon133 decimal default 0.00,
+  anon134 decimal default 0.00,
+  anon135 decimal default 0.00,
+  anon70 int not null  references anon40(anon41),  constraint anon136 check anon137(anon126, anon127, anon129));
+create table anon138(
+  anon41 serial  primary key,
+  anon126 int  references anon111(anon41) not null,
+  anon80 text not null,
+  anon127 varchar(30) not null,
+  anon139 date not null,
+  anon129 decimal default 0,
+  anon130 decimal default 0,
+  anon131 decimal default 0,
+  anon132 decimal default 0,
+  anon70 int not null  references anon40(anon41),  constraint anon136 check anon137(anon127, anon129));
+create table anon140(
+  anon41 serial  primary key,
+  anon141 text unique not null,
+  anon46 text default null,
+  anon47 text default null,
+  anon57 varchar(30) default null,
+  anon142 text default null,
+  anon51 text default null,
+  anon143 varchar(30) default null,
+  anon53 text default null,
+  anon54 text default null,
+  anon55 text default null,
+  anon45 text default null,
+  anon69 boolean default true,
+  anon70 int not null  references anon40(anon41));
+create table anon144(
+  anon41 serial  primary key,
+  anon72 varchar(30) unique not null,
+  anon73 varchar(30) unique not null,
+  anon80 varchar(30) default null,
+  anon69 boolean default true,
+  anon70 int not null  references anon40(anon41));
+create table anon145(
+  anon41 serial  primary key,
+  anon72 varchar(30) unique not null,
+  anon73 varchar(30) unique not null,
+  anon146 int not null,
+  anon147 anon92 default 1,
+  anon148 anon92 default 9999999,
+  anon80 varchar(30) default null,
+  anon69 boolean default true,
+  anon149 int default 0,
+  anon150 int not null,
+  anon151 anon92 default 0,
+  anon70 int not null  references anon40(anon41),
+  foreign key(anon150) references anon82(anon41),
+  foreign key(anon146) references anon144(anon41));
+create table anon152(
+  anon41 serial  primary key,
+  anon73 varchar(30) not null unique,
+  anon153 varchar(30) not null unique,
+  anon80 text default null,
+  anon69 boolean not null default true,
+  anon70 int not null  references anon40(anon41));
+create table anon154(
+  anon41 serial  primary key not null,
+  anon155 int not null unique,
+  date date default anon156 not null,
+  anon157 anon102  references anon140(anon41) not null,
+  anon158 anon102  references anon64(anon41) not null,
+  anon159 decimal default 0 not null,
+  anon160 decimal default 0 not null,
+  anon161 decimal default 0 not null,
+  anon162 decimal default 0 not null,
+  anon163 decimal default 0 not null,
+  anon164 decimal default 0 not null,
+  anon165 decimal default 0.00,
+  anon166 decimal default 0 not null,
+  anon167 decimal default 0.00,
+  anon168 decimal default 0 not null,
+  anon169 boolean default false,
+  anon170 varchar(30) default 'ca',
+  anon171 varchar(30) default 'n',
+  anon172 varchar(30) not null default 'd',
+  anon173 decimal default 0.00,
+  anon174 decimal default 0.00,
+  anon175 int,
+  anon176 varchar(30) default null,
+  anon177 varchar(30) default '',
+  anon178 varchar(30) default null,
+  anon70 int not null  references anon40(anon41));
+create table anon179(
+  anon41 serial  primary key not null,
+  anon180 anon102  references anon154(anon41) not null,
+  anon181 int  references anon125(anon41) not null,
+  anon182 int  references anon82(anon41) not null,
+  anon122 int  references anon99(anon41) not null,
+  anon183 decimal not null,
+  anon184 decimal default 0.00,
+  anon174 decimal default 0,
+  anon160 decimal default 0.00,
+  anon185 decimal default 0,
+  anon162 decimal default 0.00,
+  anon186 decimal default 0,
+  anon163 decimal default 0.00,
+  anon187 decimal default 0,
+  anon164 decimal default 0.00,
+  anon188 decimal default 0,
+  anon161 decimal default 0.00,
+  anon189 decimal default 0.00,
+  anon168 decimal default 0.00,
+  anon190 decimal not null,
+  anon191 decimal default 0,
+  anon83 varchar(30) not null default 't',
+  anon192 decimal default 0,
+  anon193 decimal not null,
+  anon194 decimal not null,
+  anon70 int not null  references anon40(anon41));
+create table anon195(
+  anon41 serial not null,
+  anon196 int not null,
+  anon175 char not null,
+  anon90 int not null  references anon82,
+  anon165 decimal default 0.00,
+  anon70 int not null  references anon40(anon41),  primary key(anon196, anon175));
+create table anon197(
+  anon41 serial not null,
+  anon196 int not null,
+  anon175 char not null,
+  anon198 int not null,
+  anon189 decimal default 0.00,
+  anon199 varchar(30) default null,
+  anon200 varchar(30) default null,
+  anon70 int not null  references anon40(anon41),
+  primary key(anon196, anon175),
+  foreign key(anon198) references anon145(anon41));
+create table anon201(
+  anon41 serial  primary key,
+  anon202 varchar(30) not null,
+  anon203 varchar(30) not null,
+  anon204 varchar(30) not null,
+  anon205 varchar(30) not null,
+  anon206 boolean default null,
+  anon70 int not null  references anon40(anon41));
+create table anon207(
+  anon41 serial  primary key,
+  anon208 varchar(30) not null,
+  anon209 varchar(30) not null,
+  anon204 varchar(30) default null,
+  anon70 int not null  references anon40(anon41));
+
diff --git a/tests/stdlib/tsqlparser.nim b/tests/stdlib/tsqlparser.nim
new file mode 100644
index 000000000..4a7b2f7d7
--- /dev/null
+++ b/tests/stdlib/tsqlparser.nim
@@ -0,0 +1,12 @@
+discard """
+  output: '''true'''
+"""
+
+# Just check that we can parse 'somesql' and render it without crashes.
+
+import parsesql, streams, os
+
+var tree = parseSql(newFileStream(getAppDir() / "somesql.sql"), "somesql")
+discard renderSql(tree)
+
+echo "true"