js-data-sql - npm Package Compare versions

Comparing version 0.11.9 to 0.11.10

package.json

 {
   "name": "js-data-sql",
   "description": "Postgres/MySQL/MariaDB/SQLite3 adapter for js-data.",
-  "version": "0.11.9",
+  "version": "0.11.10",
   "homepage": "http://www.js-data.io/docs/dssqladapter",
@@ -31,6 +31,12 @@ "repository": {
     "build": "webpack --config webpack.config.js --progress --colors",
-    "mocha": "mocha --timeout 20000 --reporter dot mocha.start.js test/*.spec.js",
+    "mocha-mysql": "DB_CLIENT=mysql DB_USER=root mocha --timeout 20000 --reporter dot mocha.start.js test/*.spec.js",
+    "mocha-pg": "DB_CLIENT=pg mocha --timeout 20000 --reporter dot mocha.start.js test/*.spec.js",
+    "mocha-all": "npm run mocha-mysql && npm run mocha-pg",
     "cover": "istanbul cover --hook-run-in-context node_modules/mocha/bin/_mocha -- --timeout 20000 --reporter dot mocha.start.js test/*.spec.js",
     "test": "npm run lint && npm run build && npm run cover",
-    "ci": "npm run test && cat coverage/lcov.info | coveralls || true && cat ./coverage/lcov.info | codacy-coverage || true"
+    "ci": "npm run test && cat coverage/lcov.info | coveralls || true && cat ./coverage/lcov.info | codacy-coverage || true",
+    
+    "create-migration": "knex --cwd=test migrate:make",
+    "migrate-db": "knex --cwd=test migrate:latest",
+    "rollback-db": "knex --cwd=test migrate:rollback"
   },
@@ -37,0 +43,0 @@ "standard": {

README.md

@@ -81,2 +81,36 @@ <img src="https://raw.githubusercontent.com/js-data/js-data/master/js-data.png" alt="js-data logo" title="js-data" align="right" width="64" height="64" />
     - `DB_USER`: `ubuntu`
+  - You may use `docker`/`docker-compose` to create MySql and Postgres containers to test against
+    - `docker-compose up -d`
+      - Start containers named `js-data-sql-mysql` and `js-data-sql-pg`
+    - MySQL
+      - Environment variables
+        - `DB_CLIENT` = `mysql` 
+        - `DB_USER` = `root`
+        - `DB_HOST` = `IP of docker-machine if not localhost`
+      - Populate schema
+        - `DB_CLIENT=mysql DB_USER=root npm run migrate-db`
+        - Also set `DB_HOST` if different from `localhost`
+      - Run tests
+      - `npm run mocha-mysql`
+        - Set `DB_HOST` if different from `localhost`
+      - Run cli
+        - `docker exec -it js-data-sql-mysql mysql circle_test`
+    - Postgres
+      - Environment variables
+        - `DB_CLIENT` = `pg` 
+        - `DB_USER` = `ubuntu`
+        - `DB_HOST` = `IP of docker-machine if not localhost`
+      - Populate schema
+        - `DB_CLIENT=pg npm run migrate-db`
+        - Also set `DB_HOST` if different from `localhost`
+      - Run tests
+        - `npm run mocha-pg`
+        - Also set `DB_HOST` if different from `localhost`
+      - `docker exec -it js-data-sql-pg psql -U ubuntu -d circle_test`
+        - Run cli
+    - All databases
+      - Run all tests against MySQL and Postgres
+        - `npm run mocha-all`
+        - Also set `DB_HOST` if different from `localhost`
+        
 1. Your code will be linted and checked for formatting, the tests will be run
@@ -83,0 +117,0 @@ 1. The `dist/` folder & files will be generated, do NOT commit `dist/*`! They

New 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

Uses eval

Supply chain risk

Package uses dynamic code execution (e.g., eval()), which is a dangerous practice. This can prevent the code from running in certain environments and increases the risk that the code may contain exploits or malicious behavior.

Found 2 instances in 1 package

Environment variable access

Supply chain risk

Package accesses environment variables, which may be a sign of credential stuffing or data theft.

Found 3 instances in 1 package

Long strings

Supply chain risk

Contains long string literals, which may be a sign of obfuscated or packed code.

Found 1 instance in 1 package

Improved metrics

Total package byte prevSize

309979

increased by668.64%

Number of package files

11

increased by10%

Lines of code

8454

increased by1281.37%

Number of lines in readme file

171

increased by24.82%

Worsened metrics

Number of low supply chain risk alerts

6

increased byInfinity%

Number of medium supply chain risk alerts

8

increased byInfinity%

No dependency changes