commit 70c799e21d295d45bc707afa03bb3c42a5547923
author Nickolay Ponomarev <asqueella@gmail.com> Sun Jan 20 18:18:19 2019 +0300
committer Nickolay Ponomarev <asqueella@gmail.com> Sun Jan 20 19:30:13 2019 +0300
tree 1b8038ad0e3455ba3bc1567e76b5031de3d5dd19
parent 9441f9c5d84f117b21a72a35a2123e99c3df7980

Use verified() in the remaining PG-specific tests

tests/sqlparser_postgres.rs

diff --git a/tests/sqlparser_postgres.rs b/tests/sqlparser_postgres.rs
index cd44bd0..6b6598c 100644
--- a/tests/sqlparser_postgres.rs
+++ b/tests/sqlparser_postgres.rs
@@ -33,9 +33,7 @@
 #[test]
 fn parse_simple_insert() {
     let sql = String::from("INSERT INTO customer VALUES(1, 2, 3)");
-    let ast = parse_sql(&sql);
-    assert_eq!(sql, ast.to_string());
-    match ast {
+    match verified(&sql) {
         ASTNode::SQLInsert {
             table_name,
             columns,
@@ -60,9 +58,7 @@
 #[test]
 fn parse_common_insert() {
     let sql = String::from("INSERT INTO public.customer VALUES(1, 2, 3)");
-    let ast = parse_sql(&sql);
-    assert_eq!(sql, ast.to_string());
-    match ast {
+    match verified(&sql) {
         ASTNode::SQLInsert {
             table_name,
             columns,
@@ -87,9 +83,7 @@
 #[test]
 fn parse_complex_insert() {
     let sql = String::from("INSERT INTO db.public.customer VALUES(1, 2, 3)");
-    let ast = parse_sql(&sql);
-    assert_eq!(sql, ast.to_string());
-    match ast {
+    match verified(&sql) {
         ASTNode::SQLInsert {
             table_name,
             columns,
@@ -121,9 +115,7 @@
 #[test]
 fn parse_insert_with_columns() {
     let sql = String::from("INSERT INTO public.customer (id, name, active) VALUES(1, 2, 3)");
-    let ast = parse_sql(&sql);
-    assert_eq!(sql, ast.to_string());
-    match ast {
+    match verified(&sql) {
         ASTNode::SQLInsert {
             table_name,
             columns,
@@ -173,8 +165,7 @@
             last_update timestamp without time zone DEFAULT now() NOT NULL,
             active integer NOT NULL)",
     );
-    let ast = parse_sql(&sql);
-    match ast {
+    match parse_sql(&sql) {
         ASTNode::SQLCreateTable { name, columns } => {
             assert_eq!("public.customer", name);
             assert_eq!(10, columns.len());
@@ -270,9 +261,7 @@
          use_metric boolean DEFAULT true\
          )",
     );
-    let ast = parse_sql(&sql);
-    assert_eq!(sql, ast.to_string());
-    match ast {
+    match verified(&sql) {
         ASTNode::SQLCreateTable { name, columns } => {
             assert_eq!("bazaar.settings", name);
 
@@ -301,10 +290,7 @@
          ALTER TABLE bazaar.address \
          ADD CONSTRAINT address_pkey PRIMARY KEY (address_id)",
     );
-    let ast = parse_sql(&sql);
-    println!("ast: {:?}", ast);
-    assert_eq!(sql, ast.to_string());
-    match ast {
+    match verified(&sql) {
         ASTNode::SQLAlterTable { name, .. } => {
             assert_eq!(name, "bazaar.address");
         }
@@ -317,10 +303,7 @@
     let sql = String::from("\
     ALTER TABLE public.customer \
         ADD CONSTRAINT customer_address_id_fkey FOREIGN KEY (address_id) REFERENCES public.address(address_id)");
-    let ast = parse_sql(&sql);
-    assert_eq!(sql, ast.to_string());
-    println!("ast: {:?}", ast);
-    match ast {
+    match verified(&sql) {
         ASTNode::SQLAlterTable { name, .. } => {
             assert_eq!(name, "public.customer");
         }
@@ -391,10 +374,6 @@
     ast
 }
 
-fn parses_to(from: &str, to: &str) {
-    assert_eq!(to, &parse_sql(from).to_string())
-}
-
 fn parse_sql(sql: &str) -> ASTNode {
     debug!("sql: {}", sql);
     let mut parser = parser(sql);