node-sql-parser - npm Package Compare versions

Comparing version 4.0.1 to 4.0.2

ast/postgresql.ts

@@ -540,3 +540,3 @@
 
-export type table_base = { type: 'dual' } | { expr: union_stmt; as?: alias_clause; } | { type: 'expr'; expr: expr; as?: alias_clause; } | table_name & { as?: alias_clause; };
+export type table_base = { type: 'dual' } | { expr: value_clause; as?: alias_clause; } | { expr: union_stmt | value_clause; as?: alias_clause; } | { type: 'expr'; expr: expr; as?: alias_clause; } | table_name & { expr: expr, repeatable: literal_numeric; as?: alias_clause;} | table_name & { as?: alias_clause; };
 
@@ -888,2 +888,4 @@
 
+
+
 export type cast_expr = {
@@ -890,0 +892,0 @@ as?: alias_clause,

lib/tables.js

@@ -42,3 +42,4 @@ (function (global, factory) {
       expr,
-      schema
+      schema,
+      tablesample
     } = tableInfo;
@@ -48,7 +49,24 @@ const database = (0, _util.identifierToSql)(db);
     let tableName = table && (0, _util.identifierToSql)(table);
-    if (expr && expr.type === 'values') tableName = `(${(0, _util.commonOptionConnector)('VALUES', _insert.valuesToSQL, expr.values)})`;
+
+    if (expr && expr.type === 'values') {
+      const {
+        parentheses,
+        values
+      } = expr;
+      const valueSQL = [parentheses && '(', '', parentheses && ')'];
+      valueSQL[1] = `${(0, _util.commonOptionConnector)('VALUES', _insert.valuesToSQL, values)}`;
+      tableName = valueSQL.filter(_util.hasVal).join('');
+    }
+
     if (expr && expr.type !== 'values') tableName = (0, _expr.exprToSQL)(expr);
     const str = [database, schemaStr, tableName].filter(_util.hasVal).join('.');
-    if (as) return `${str} AS ${(0, _util.identifierToSql)(as)}`;
-    return str;
+    const result = [str];
+
+    if (tablesample) {
+      const tableSampleSQL = ['TABLESAMPLE', (0, _expr.exprToSQL)(tablesample.expr), (0, _util.literalToSQL)(tablesample.repeatable)].filter(_util.hasVal).join(' ');
+      result.push(tableSampleSQL);
+    }
+
+    if (as) result.push('AS', (0, _util.identifierToSql)(as));
+    return result.join(' ');
   }
@@ -55,0 +73,0 @@ /**

package.json

 {
   "name": "node-sql-parser",
-  "version": "4.0.1",
+  "version": "4.0.2",
   "description": "simple node sql parser",
@@ -70,3 +70,3 @@ "main": "index.js",
     "cross-env": "^7.0.2",
-    "eslint": "^7.27.0",
+    "eslint": "^8.3.0",
     "eslint-config-airbnb-base": "^15.0.0",
@@ -73,0 +73,0 @@ "eslint-config-strict": "^14.0.1",

No alert changes

Improved metrics

Total package byte prevSize

39340426

0.25%

Lines of code

22981

0.26%

No dependency changes