n8n-nodes-couchbase - npm Package Compare versions

Comparing version 0.1.3 to 0.1.4

dist/nodes/CouchbaseNode/CouchbaseNode.node.js

@@ -52,2 +52,8 @@ "use strict";
                         {
+                            name: 'Query',
+                            value: 'query',
+                            description: 'Query document in couchbase',
+                            action: 'Query document in couchbase',
+                        },
+                        {
                             name: 'Read',
@@ -133,13 +139,16 @@ value: 'find',
                 {
-                    displayName: 'Insert Json',
-                    name: 'myDocument',
-                    type: 'json',
+                    displayName: 'Run Query',
+                    name: 'query',
+                    type: 'string',
                     displayOptions: {
                         show: {
-                            operation: [''],
+                            operation: ['query'],
                         },
                     },
+                    typeOptions: {
+                        rows: 5,
+                    },
                     default: '',
-                    placeholder: 'Placeholder value',
-                    description: 'The description text',
+                    placeholder: 'e.g. SELECT * FROM users WHERE name="Michael"',
+                    description: 'The N1QL query to execute',
                 },
@@ -162,4 +171,6 @@ ],
         let item4;
+        let item5;
         let myDocument;
         let myNewValue;
+        let myNewQuery;
         let readJson;
@@ -170,2 +181,3 @@ for (let itemIndex = 0; itemIndex < items.length; itemIndex++) {
             try {
+                myNewQuery = this.getNodeParameter('query', itemIndex, '');
                 myNewValue = this.getNodeParameter('myValue', itemIndex, '');
@@ -215,2 +227,15 @@ myDocument = this.getNodeParameter('myDocument', itemIndex, '');
                 }
+                else if (operation === 'query') {
+                    const queryResult = await bucket
+                        .scope(myScope)
+                        .query(myNewQuery);
+                    console.log('Query Results:');
+                    queryResult.rows.forEach((row) => {
+                        console.log(row);
+                    });
+                    readJson = JSON.stringify(queryResult.rows);
+                    console.log('Get Result in String:', readJson);
+                    item5 = items[itemIndex];
+                    item5.json[''] = queryResult.rows;
+                }
             }
@@ -217,0 +242,0 @@ catch (error) {

dist/package.json

 {
     "name": "n8n-nodes-couchbase",
-    "version": "0.1.3",
+    "version": "0.1.4",
     "description": "N8N Node to add, get, update, delete and import data to couchbase",
@@ -5,0 +5,0 @@ "keywords": [

package.json

 {
   "name": "n8n-nodes-couchbase",
-  "version": "0.1.3",
+  "version": "0.1.4",
   "description": "N8N Node to add, get, update, delete and import data to couchbase",
@@ -5,0 +5,0 @@ "keywords": [

README.md

 N8N Nodes Couchbase
 
-The Couchbase node allows you to automate documents in Couchbase. n8n has built-in support for a wide range of Couchbase features, including executing, inserting, updating, removing, and finding documents. n8n is a free and source-available workflow automation platform.
+The Couchbase node allows you to automate documents in Couchbase. n8n has built-in support for a wide range of Couchbase features, including executing, inserting, updating, removing, importing, querying and finding documents. n8n is a free and source-available workflow automation platform.
 
@@ -13,3 +13,2 @@ Use this connector
 
-
 For more information on installing community nodes, visit the Community nodes docs page.
@@ -22,4 +21,5 @@
     		•	Update documents
-    		•	Remove documents
+    		•	Delete documents
     		•	Import documents
+    		•	Query documents
 
@@ -26,0 +26,0 @@

New alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Fixed alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Improved metrics

Total package byte prevSize

146818

increased by1.35%

Lines of code

528

increased by4.97%

No dependency changes