psy-db - npm Package Compare versions

Comparing version 1.0.1 to 1.0.2

package.json

 {
     "name": "psy-db",
-    "version": "1.0.1",
+    "version": "1.0.2",
     "author": "Armin Neische",
@@ -5,0 +5,0 @@ "main": "psyDb.js",

psyDb.js

@@ -189,4 +189,4 @@ /*
 
-                    sql = sql.substr(0, sql.length - 1);
-                    sql += ')';
+                    sql = sql.substr(0, sql.length - 1)
+                    sql += ') RETURNING *';
                     client = new Client({
@@ -199,3 +199,3 @@ connectionString: config.connStr
                                 client.end();
-                                resolve(res.rowCount);
+                                resolve(res.rows[0]);
                             })
@@ -202,0 +202,0 @@ .catch(err => {

test.js

@@ -16,3 +16,2 @@ /*
 var account = {
-    id: 1,
     companyname: 'PSYfiers AG',
@@ -28,13 +27,33 @@ users: [
 
-db.read({
+//db.read({
+//    table: 'accounts',
+//    query: {
+//        id: 1
+//    },
+//    resolve: {
+//        country_id: {table: 'countries', field: 'country', id: 'id'}
+//    }
+//}).then(data => {
+//    console.log(data);
+//}).catch(err => {
+//    console.log(err);
+//});
+
+
+
+db.create({
     table: 'accounts',
-    query: {
-        id: 1
+    entity: account,
+    resolve: {
+        country: {field: 'country_id', value: account.country.id}
     },
-    resolve: {
-        country_id: {table: 'countries', field: 'country', id: 'id'}
-    }
-}).then(data => {
-    console.log(data);
-}).catch(err => {
+    columns: {
+        companyname: 'company_name'
+    },
+    ignore: [
+        'users'
+    ]
+}).then((data => {
+        console.log(data);
+})).catch(err => {
     console.log(err);
@@ -45,47 +64,4 @@ });
 
-//db.create({
-//    table: 'accounts',
-//    entity: account,
-//    resolve: {
-//        country: {field: 'country_id', value: account.country.id}
-//    },
-//    columns: {
-//        companyname: 'company_name'
-//    },
-//    ignore: [
-//        'users'
-//    ]
-//}).then((data => {
-//    account['postcode'] = '1000';
-//    account['city'] = 'Neuchatel';
-//    account['street'] = 'Le Lac 101a';
-//
-//    db.update({
-//        table: 'accounts',
-//        entity: account,
-//        query: {
-//            id: account.id
-//        },
-//        resolve: {
-//            country: {field: 'country_id', value: account.country.id}
-//        },
-//        columns: {
-//            companyname: 'company_name'
-//        },
-//        ignore: [
-//            'users'
-//        ]
-//    }).then((data => {
-//        console.log(data);
-//    })).catch(err => {
-//        console.log(err);
-//    });
-//})).catch(err => {
-//    console.log(err);
-//});
 
 
-
-
-
 //db.create({
@@ -92,0 +68,0 @@ //    table: 'countries',

Fixed alerts

Major refactor

Supply chain risk

Package has recently undergone a major refactor. It may be unstable or indicate significant internal changes. Use caution when updating to versions that include significant changes.

Found 1 instance in 1 package

Improved metrics

Number of medium supply chain risk alerts

0

decreased by-100%

Worsened metrics

Total package byte prevSize

19792

decreased by-2.87%

Lines of code

461

decreased by-4.95%

No dependency changes