mg-dbop - npm Package Compare versions

Comparing version 0.0.12 to 0.0.13

dbOp.js

@@ -293,3 +293,8 @@ /**
   async count() {
-    const sql = "SELECT count(*) as t " + generateFromStatement(this.fromTables) + " " + this.whereSql;
+    let sql;
+    if ( this.selectSql.toLowerCase().indexOf(" distinct " ) != -1 ){
+      sql = "SELECT DISTINCT count(*) as t " + generateFromStatement(this.fromTables) + " " + this.whereSql;
+    }else {
+      sql = "SELECT count(*) as t " + generateFromStatement(this.fromTables) + " " + this.whereSql;
+    }
     const row = await this.dbConn.query(sql, this.values);
@@ -296,0 +301,0 @@ return (row == null || row.length == 0) ? 0 : row[0].t;

package.json

 {
   "name": "mg-dbop",
   "private" : false,
-  "version": "0.0.12",
+  "version": "0.0.13",
   "homepage": "https://github.com/MacLaurinGroup/dbOp",
@@ -6,0 +6,0 @@ "description": "Query builder, and validator, for MySQL and node that utilizes the underlying table to provide a level of checking",

readme.md

@@ -260,2 +260,4 @@ ## dbOp
 
+* 2019-04-08
+  * Fixed the count() ignoring a 'distinct' in the SELECT
 * 2019-03-30
@@ -262,0 +264,0 @@ * Added in setOptions() for cleaning up rows

No alert changes

Improved metrics

Total package byte prevSize

47741

increased by0.58%

Lines of code

770

increased by0.65%

Number of lines in readme file

283

increased by0.71%

No dependency changes