classql - npm Package Compare versions

Comparing version 0.1.5 to 0.1.6

CHANGELOG.md

@@ -0,1 +1,5 @@
+#0.1.6
+
+* Added count method
+
 #0.1.5
@@ -2,0 +6,0 @@

dist/on.d.ts

@@ -46,2 +46,8 @@ import 'reflect-metadata';
     delete(wheres: any): Promise<any>;
+    /**
+     * Count items by where clause
+     * @param wheres
+     * @return promised returned query
+     */
+    count(wheres: any): Promise<any>;
 }

dist/on.js

@@ -112,4 +112,19 @@ "use strict";
     }
+    /**
+     * Count items by where clause
+     * @param wheres
+     * @return promised returned query
+     */
+    count(wheres) {
+        return __awaiter(this, void 0, void 0, function* () {
+            if (!wheres)
+                throw new Error(exports.errors.where);
+            let statement = 'SELECT COUNT(*) AS count FROM ' + this.table;
+            statement = helpers_1.mapWhereClause(statement, wheres);
+            const data = yield this.db.query(statement);
+            return data.count;
+        });
+    }
 }
 exports.Query = Query;
 //# sourceMappingURL=on.js.map

package.json

 {
   "name": "classql",
-  "version": "0.1.5",
+  "version": "0.1.6",
   "main": "dist/index.js",
@@ -5,0 +5,0 @@ "bugs": "https://github.com/sorakthunly/classql/issues",

README.md

@@ -98,2 +98,7 @@ # classql
 
+
+/** COUNT */
+// Returns the number of result counted e.g. 12
+await db.on(UserAccount).count({ name: 'John' });
+
 ```

src/on.ts

@@ -115,2 +115,16 @@ const mysql = require('promise-mysql');
   }
+
+  /**
+   * Count items by where clause
+   * @param wheres
+   * @return promised returned query
+   */
+  public async count(wheres: any): Promise<any> {
+    if (!wheres) throw new Error(errors.where);
+
+     let statement = 'SELECT COUNT(*) AS count FROM ' + this.table;
+     statement = mapWhereClause(statement, wheres);
+     const data = await this.db.query(statement);
+     return data.count;
+  }
 }

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

48862

increased by3.3%

Lines of code

1022

increased by3.34%

Number of lines in readme file

104

increased by5.05%

No dependency changes