X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=tests%2Ftest-syntax.lisp;h=bf647f1d789f8dce599d3e3deafbee990461ef20;hb=704367c500a9fac40e97663f794fa4042df1512a;hp=ea2f614a6a1804487cd91564f2e1e14669c8a8ae;hpb=89b40554349ff77e986d1c6f584b9c9a28cf36af;p=clsql.git diff --git a/tests/test-syntax.lisp b/tests/test-syntax.lisp index ea2f614..bf647f1 100644 --- a/tests/test-syntax.lisp +++ b/tests/test-syntax.lisp @@ -17,6 +17,7 @@ #.(clsql:locally-enable-sql-reader-syntax) + (setq *rt-syntax* '( @@ -62,7 +63,7 @@ (deftest :syntax/ident/5 (clsql:sql [foo "bar"]) - "FOO \"bar\"") + "FOO \"bar\"") (deftest :syntax/ident/6 (clsql:sql ["foo" bar]) @@ -73,6 +74,22 @@ "\"foo\".BAR") +(deftest :syntax/attribute/1 + (clsql:sql (clsql:sql-expression :table 'foo :attribute 'bar)) + "FOO.BAR") + +(deftest :syntax/attribute/2 + (clsql:sql (clsql:sql-expression :table 'foo :attribute "bar")) + "FOO.\"bar\"") + +(deftest :syntax/attribute/3 + (clsql:sql (clsql:sql-expression :table "foo" :attribute 'bar)) + "\"foo\".BAR") + +(deftest :syntax/attribute/4 + (clsql:sql (clsql:sql-expression :table "foo" :attribute "bar")) + "\"foo\".\"bar\"") + (deftest :syntax/subquery/1 (clsql:sql [any '(3 4)]) @@ -254,9 +271,9 @@ (deftest :syntax/group-by/2 (clsql:sql (clsql-sys::make-query [foo] [bar] [count [foo]] - :from [table] - :group-by '([foo] [bar]) - :order-by '([foo] [bar]))) + :from [table] + :group-by '([foo] [bar]) + :order-by '([foo] [bar]))) "SELECT FOO,BAR,COUNT(FOO) FROM TABLE GROUP BY FOO,BAR ORDER BY FOO,BAR") @@ -323,7 +340,7 @@ "SELECT COUNT(*) FROM EMP") -(deftest :syntax/expression1 +(deftest :syntax/expression/1 (clsql:sql (clsql:sql-operation 'select