volos-mysql
Advanced tools
Comparing version 0.0.7 to 0.0.8
@@ -67,3 +67,3 @@ var http = require('http'); | ||
function (err) { | ||
handleError(req, resp, err, 400, '"prepareRequest" failed'); | ||
self.handleError(req, resp, err, 400, '"prepareRequest" failed'); | ||
dfd.reject(); | ||
@@ -70,0 +70,0 @@ }, |
{ | ||
"name": "volos-mysql", | ||
"version": "0.0.7", | ||
"version": "0.0.8", | ||
"description": "Volos MySQL Database Connector", | ||
@@ -8,3 +8,3 @@ "main": "mysqlConnector.js", | ||
"lodash": "^2.4.1", | ||
"volos-connectors-common": "^0.0.3", | ||
"volos-connectors-common": "^0.0.8", | ||
"mysql": "^2.4.0", | ||
@@ -11,0 +11,0 @@ "q": "^1.0.1" |
@@ -10,3 +10,3 @@ # Volos MySQL connector | ||
``` | ||
SELECT emp_name, emp_id FROM employees WHERE emp_id='jdoe' | ||
'SELECT idpeople FROM example.people' | ||
``` | ||
@@ -16,3 +16,3 @@ to a RESTful API that you could call like this: | ||
``` | ||
$ curl http://localhost:9089/employees/jdoe | ||
$ curl http://localhost:9089/people | ||
``` | ||
@@ -23,8 +23,27 @@ | ||
``` | ||
[ | ||
{ | ||
"emp_name": "Jane Doe", | ||
"emp_id": "jdoe" | ||
} | ||
] | ||
{ | ||
"action": "GET", | ||
"params": { | ||
"qp": {} | ||
}, | ||
"path": "/people", | ||
"url": "/people", | ||
"data": [ | ||
{ | ||
"idpeople": 0 | ||
}, | ||
{ | ||
"idpeople": 1 | ||
}, | ||
{ | ||
"idpeople": 2 | ||
} | ||
], | ||
"targetMetadata": {}, | ||
"timestamp": 1406238731690, | ||
"duration": 1576, | ||
"applicationName": "volos-mysql", | ||
"count": 3, | ||
"sql": "SELECT idpeople FROM example.people LIMIT 100" | ||
} | ||
``` | ||
@@ -35,13 +54,11 @@ | ||
``` | ||
'employees': { | ||
queryStringBasic: 'SELECT emp_name, emp_id FROM hr.employees', | ||
queryStringExpanded: 'SELECT * FROM hr.employees', | ||
idName: 'emp_id', | ||
queryParameters : { | ||
id: 'emp_id = \'{id}\'', | ||
name: 'emp_name = \'{name}\'', | ||
role: 'role = \'{role}\'', | ||
hire_date: 'hire_date = \'{hire_date}\'' | ||
'people': { | ||
queryStringBasic: 'SELECT idpeople FROM example.people', | ||
queryStringExpanded: 'SELECT * FROM example.people', | ||
idName: 'idpeople', | ||
queryParameters: { | ||
firstname: 'firstname = \'{firstname}\'', | ||
lastname: 'lastname = \'{lastname}\'' | ||
} | ||
} | ||
} | ||
``` | ||
@@ -53,10 +70,35 @@ | ||
``` | ||
[ | ||
{ | ||
"emp_id": "jdoe", | ||
"emp_name": "Jane Doe", | ||
"role": "Manager", | ||
"hire_date": "06-27-1978" | ||
} | ||
] | ||
{ | ||
"action": "GET", | ||
"params": { | ||
"qp": { | ||
"expand": "true" | ||
} | ||
}, | ||
"path": "/people", | ||
"url": "/people?expand=true", | ||
"data": [ | ||
{ | ||
"idpeople": 0, | ||
"firstname": "John", | ||
"lastname": "Doe" | ||
}, | ||
{ | ||
"idpeople": 1, | ||
"firstname": "Chris", | ||
"lastname": "Logan" | ||
}, | ||
{ | ||
"idpeople": 2, | ||
"firstname": "Susan", | ||
"lastname": "North" | ||
} | ||
], | ||
"targetMetadata": {}, | ||
"timestamp": 1406306063184, | ||
"duration": 894, | ||
"applicationName": "volos-mysql", | ||
"count": 11, | ||
"sql": "SELECT * FROM example.people LIMIT 100" | ||
} | ||
``` | ||
@@ -63,0 +105,0 @@ |
License Policy Violation
LicenseThis package is not allowed per your license policy. Review the package's license to ensure compliance.
Found 1 instance in 1 package
License Policy Violation
LicenseThis package is not allowed per your license policy. Review the package's license to ensure compliance.
Found 1 instance in 1 package
20788
351
+ Addedvolos-connectors-common@0.0.8(transitive)
- Removedvolos-connectors-common@0.0.3(transitive)