node-sql-parser - npm Package Compare versions

Comparing version 1.6.11 to 1.6.12

lib/command.js

@@ -12,2 +12,3 @@ "use strict";
 exports.setVarToSQL = setVarToSQL;
+exports.lockUnlockToSQL = lockUnlockToSQL;
 
@@ -71,2 +72,49 @@ var _util = require("./util");
   return `${action} ${val}`;
+}
+
+function pgLock(stmt) {
+  const {
+    lock_mode: lockMode,
+    nowait
+  } = stmt;
+  const lockInfo = [];
+
+  if (lockMode) {
+    const {
+      mode
+    } = lockMode;
+    lockInfo.push(mode.toUpperCase());
+  }
+
+  if (nowait) lockInfo.push(nowait.toUpperCase());
+  return lockInfo;
+}
+
+function lockUnlockToSQL(stmt) {
+  const {
+    type,
+    keyword,
+    tables
+  } = stmt;
+  const result = [type.toUpperCase(), (0, _util.toUpper)(keyword)];
+  if (type.toUpperCase() === 'UNLOCK') return result.join(' ');
+  const tableStmt = [];
+
+  for (const tableInfo of tables) {
+    const {
+      table,
+      lock_type: lockType
+    } = tableInfo;
+    const tableInfoTemp = [(0, _tables.tableToSQL)(table)];
+
+    if (lockType) {
+      const lockKeyList = ['prefix', 'type', 'suffix'];
+      tableInfoTemp.push(lockKeyList.map(key => (0, _util.toUpper)(lockType[key])).filter(_util.hasVal).join(' '));
+    }
+
+    tableStmt.push(tableInfoTemp.join(' '));
+  }
+
+  result.push(tableStmt.join(', '), ...pgLock(stmt));
+  return result.filter(_util.hasVal).join(' ');
 }

lib/sql.js

@@ -10,3 +10,3 @@ "use strict";
 
-const surportedTypes = ['select', 'delete', 'update', 'insert', 'drop', 'rename', 'truncate', 'call', 'use', 'alter', 'set', 'create'];
+const surportedTypes = ['select', 'delete', 'update', 'insert', 'drop', 'rename', 'truncate', 'call', 'use', 'alter', 'set', 'create', 'lock', 'unlock'];
 
@@ -13,0 +13,0 @@ function checkSupported(expr) {

lib/union.js

@@ -35,3 +35,5 @@ "use strict";
   call: _command.callToSQL,
-  set: _command.setVarToSQL
+  set: _command.setVarToSQL,
+  lock: _command.lockUnlockToSQL,
+  unlock: _command.lockUnlockToSQL
 };
@@ -38,0 +40,0 @@

package.json

 {
   "name": "node-sql-parser",
-  "version": "1.6.11",
+  "version": "1.6.12",
   "description": "simple node sql parser",
@@ -5,0 +5,0 @@ "main": "index.js",

No alert changes

Improved metrics

Total package byte prevSize

1489641

2.23%

Lines of code

52823

2.27%

No dependency changes