db2graphql - npm Package Compare versions

Comparing version 0.8.1 to 0.9.0

demo_mssql/connection.example.json

@@ -0,0 +0,0 @@ {

demo_mssql/index.js

@@ -0,0 +0,0 @@ const knex = require('knex');

demo_mssql/performance.js

@@ -0,0 +0,0 @@ /**

demo_mssql/queries.example.txt

@@ -0,0 +0,0 @@ # Create user

demo_mssql/test.txt

@@ -0,0 +0,0 @@

demo_mysql/connection.example.json

@@ -0,0 +0,0 @@ {

demo_mysql/index.js

@@ -0,0 +0,0 @@ const knex = require('knex');

demo_mysql/performance.js

@@ -0,0 +0,0 @@ /**

demo_mysql/queries.example.txt

@@ -0,0 +0,0 @@ # Create user

demo/connection.example.json

@@ -0,0 +0,0 @@ {

demo/index.js

@@ -0,0 +0,0 @@ const knex = require('knex');

demo/performance.js

@@ -0,0 +0,0 @@ /**

demo/queries.example.txt

@@ -0,0 +0,0 @@ # Create user

docstemplates/default/publish.js

@@ -0,0 +0,0 @@ const doop = require('jsdoc/util/doop');

docstemplates/default/README.md

@@ -0,0 +0,0 @@ The default template for JSDoc 3 uses: [the Taffy Database library](http://taffydb.com/) and the [Underscore Template library](http://underscorejs.org/).

docstemplates/default/static/scripts/linenumber.js

@@ -0,0 +0,0 @@ /*global document */

docstemplates/default/static/scripts/prettify/Apache-License-2.0.txt

@@ -0,0 +0,0 @@

docstemplates/default/static/scripts/prettify/lang-css.js

 PR.registerLangHandler(PR.createSimpleLexer([["pln",/^[\t\n\f\r ]+/,null," \t\r\n"]],[["str",/^"(?:[^\n\f\r"\\]|\\(?:\r\n?|\n|\f)|\\[\S\s])*"/,null],["str",/^'(?:[^\n\f\r'\\]|\\(?:\r\n?|\n|\f)|\\[\S\s])*'/,null],["lang-css-str",/^url\(([^"')]*)\)/i],["kwd",/^(?:url|rgb|!important|@import|@page|@media|@charset|inherit)(?=[^\w-]|$)/i,null],["lang-css-kw",/^(-?(?:[_a-z]|\\[\da-f]+ ?)(?:[\w-]|\\\\[\da-f]+ ?)*)\s*:/i],["com",/^\/\*[^*]*\*+(?:[^*/][^*]*\*+)*\//],["com",
 /^(?:<\!--|--\>)/],["lit",/^(?:\d+|\d*\.\d+)(?:%|[a-z]+)?/i],["lit",/^#[\da-f]{3,6}/i],["pln",/^-?(?:[_a-z]|\\[\da-f]+ ?)(?:[\w-]|\\\\[\da-f]+ ?)*/i],["pun",/^[^\s\w"']+/]]),["css"]);PR.registerLangHandler(PR.createSimpleLexer([],[["kwd",/^-?(?:[_a-z]|\\[\da-f]+ ?)(?:[\w-]|\\\\[\da-f]+ ?)*/i]]),["css-kw"]);PR.registerLangHandler(PR.createSimpleLexer([],[["str",/^[^"')]+/]]),["css-str"]);

docstemplates/default/static/scripts/prettify/prettify.js

@@ -0,0 +0,0 @@ var q=null;window.PR_SHOULD_USE_CONTINUATION=!0;

index.js

 var db2g = require('./src/db2g');
 module.exports = db2g;

package.json

 {
   "name": "db2graphql",
-  "version": "0.8.1",
+  "version": "0.9.0",
   "description": "Generate Graphql schema based on existing relational database",
@@ -40,4 +40,4 @@ "main": "index.js",
     "jsdoc": "^3.6.11",
-    "knex": "^0.21.7",
-    "mssql": "^8.1.2",
+    "knex": "^2.4.0",
+    "mssql": "^6.2.1",
     "mysql": "^2.18.1",
@@ -44,0 +44,0 @@ "nodemon": "^2.0.6",

README.md

@@ -350,7 +350,15 @@ <p align="center">
 
-## Collab
+## Contributions
 
-Anyone is free to collab :)
+Anyone is free to contribute!  
+If you need an easy-to-use environment, please run the following docker containers:
+```
+docker run --cap-add SYS_PTRACE -e 'ACCEPT_EULA=1' -e 'MSSQL_SA_PASSWORD=test' -p 1433:1433 --name azuresqledge -d mcr.microsoft.com/azure-sql-edge
+docker run --platform=linux/amd64 --name some-mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD= -d mysql:5.7
+docker run --name some-postgres -p 5432:5432 -e POSTGRES_PASSWORD= -d postgres:10.6
+```
 
+Please consider the azure-sql-edge container is because M1 Macs are not supported by the official mssql container.
+
 ## License
 MIT, what else?

src/adapters/mssql.js

@@ -0,0 +0,0 @@ const hash = require('string-hash-64');

src/adapters/mysql.js

@@ -81,2 +81,3 @@ const hash = require('string-hash-64');
         break;
+      case 'datetime':
       case 'timestamp with time zone':
@@ -509,2 +510,2 @@ case 'varchar':
 
-module.exports = Mysql;
+module.exports = Mysql;

src/adapters/postgres.js

@@ -0,0 +0,0 @@ const hash = require('string-hash-64');

src/db2g.js

@@ -0,0 +0,0 @@ const PostgreSQL = require('../src/adapters/postgres');

src/graphql/compiler.js

@@ -0,0 +0,0 @@ const utils = require('../utils/utils');

src/graphql/resolver.js

@@ -0,0 +0,0 @@ const utils = require('../utils/utils');

src/utils/utils.js

@@ -0,0 +0,0 @@

test/adapters/mssql.test.js

@@ -0,0 +0,0 @@ const MSSql = require('../../src/adapters/mssql');

test/adapters/mysql.test.js

@@ -0,0 +0,0 @@ const Mysql = require('../../src/adapters/mysql');

test/adapters/postgres.test.js

@@ -51,3 +51,3 @@ const PostgreSQL = require('../../src/adapters/postgres');
     await adapter.convertConditionToWhereClause(query, ['<=>', 'id', 1]);
-    
+
     // Close connection
@@ -81,3 +81,3 @@ db.destroy(() => {
     expect(/where/i.test(result.sql)).toBe(false);
-    
+
     // Close connection
@@ -105,3 +105,3 @@ db.destroy(() => {
     expect(result.bindings[0]).toBe(val);
-    
+
     // Close connection
@@ -138,3 +138,3 @@ await db.destroy();
     expect(/order/i.test(result.sql)).toBe(false);
-    
+
     // Close connection
@@ -153,3 +153,3 @@ db.destroy(() => {
     expect(Array.isArray(result.rows)).toBe(true);
-    
+
     // Close connection
@@ -188,3 +188,3 @@ db.destroy(() => {
     expect(Array.isArray(result)).toBe(true);
-    
+
     // Close connection
@@ -197,3 +197,3 @@ db.destroy(() => {
   test('it should return a total of items', async (done) => {
-    
+
     // Fixtures
@@ -214,3 +214,3 @@ const schema = { foo: [] };
     expect(typeof result).toBe("number");
-    
+
     // Close connection
@@ -246,3 +246,3 @@ db.destroy(() => {
     expect(typeof result).toBe("object");
-    
+
     // Close connection
@@ -255,3 +255,3 @@ db.destroy(() => {
   test('it should save one item and return it', async (done) => {
-    
+
     // Fixtures
@@ -268,3 +268,3 @@ const schema = { foo: [] };
     });
-    
+
     const adapter = new PostgreSQL(db, schema);
@@ -274,5 +274,5 @@ let result = await adapter.putItem('foo', { input: { bar: true }, _debug: true });
     expect(result.length).toBe(1);
-    result = await adapter.putItem('foo', { input: { id: result[0], bar: true }});
+    result = await adapter.putItem('foo', { input: { id: result[0].id, bar: true } });
     expect(typeof result).toBe("number");
-    
+
     // Close connection
@@ -294,3 +294,3 @@ db.destroy(() => {
     // Mock adapter query
-    adapter.query = async () => { return { rows: []} };
+    adapter.query = async () => { return { rows: [] } };
     const result = await adapter.getTables();
@@ -312,3 +312,3 @@ expect(result).toEqual([]);
     const adapter = new PostgreSQL();
-    const expected = [{ columnname: 'bar', ftableschema: 'public', ftablename: 'bar', fcolumnname: 'foo'}];
+    const expected = [{ columnname: 'bar', ftableschema: 'public', ftablename: 'bar', fcolumnname: 'foo' }];
     adapter.query = async () => ({ rows: expected });
@@ -333,3 +333,3 @@ const result = await adapter.getForeignKeys();
     // Mock adapter query
-    adapter.query = async () => { return { rows: []} };
+    adapter.query = async () => { return { rows: [] } };
     let result = await adapter.getPrimaryKey();
@@ -433,3 +433,3 @@ expect(result).toEqual(null);
     expect(result).toEqual(expected);
-    
+
     // Close connection
@@ -442,3 +442,3 @@ db.destroy(() => {
   test('it should return the complete database schema as json without excluded items', async (done) => {
-    
+
     // Fixtures
@@ -471,3 +471,3 @@ const expected = {
     expect(result).toEqual(expected);
-    
+
     // Close connection
@@ -474,0 +474,0 @@ db.destroy(() => {

test/connection_mssql.json

@@ -0,0 +0,0 @@ {

test/connection_mysql.json

@@ -0,0 +0,0 @@ {

test/connection.json

@@ -0,0 +0,0 @@ {

test/db2g.test.js

@@ -0,0 +0,0 @@ const db2g = require('../src/db2g');

test/graphql/compiler.test.js

@@ -0,0 +0,0 @@ const Compiler = require('../../src/graphql/compiler');

test/graphql/resolver.test.js

@@ -0,0 +0,0 @@ const Resolver = require('../../src/graphql/resolver');

test/utils/utils.test.js

@@ -0,0 +0,0 @@ const { toCamelCase } = require('../../src/utils/utils');

New alerts

New author

Supply chain risk

A new npm collaborator published a version of the package for the first time. New collaborators are usually benign additions to a project, but do indicate a change to the security surface area of a package.

Found 1 instance in 1 package

Improved metrics

Lines of code

5863

increased by0.03%

Number of lines in readme file

364

increased by2.25%

Worsened metrics

Total package byte prevSize

1516439

decreased by-1.24%

Number of medium supply chain risk alerts

1

increased byInfinity%

No dependency changes