{"_id":"odata-v4-sql","_rev":"8-c2ca5caf1c516f761695c314c59418bd","name":"odata-v4-sql","description":"OData to SQL query compiler","dist-tags":{"latest":"0.1.2","jenkins":"0.1.1-jenkins-5"},"versions":{"0.1.0":{"name":"odata-v4-sql","version":"0.1.0","description":"OData to SQL query compiler","main":"lib/index.js","typings":"lib/index","directories":{"test":"test"},"scripts":{"build":"tsc","pretest":"npm run build","test":"mocha","pretdd":"npm run build","tdd":"mocha -w"},"repository":{"type":"git","url":"git+https://github.com/jaystack/odata-v4-sql.git"},"keywords":["OData","V4","sql"],"author":{"name":"JayStack"},"license":"MIT","bugs":{"url":"https://github.com/jaystack/odata-v4-sql/issues"},"homepage":"https://github.com/jaystack/odata-v4-sql#readme","dependencies":{"odata-v4-literal":"^0.1.0","odata-v4-parser":"0.1.13"},"devDependencies":{"chai":"^3.5.0","mocha":"^3.1.2","typescript":"^2.0.6"},"gitHead":"d84bb93efb0c94bd573d3733d110d281ce0e58b2","_id":"odata-v4-sql@0.1.0","_shasum":"66f08f6cb05d4b7c138cc6dc783b939f81c58774","_from":".","_npmVersion":"3.8.6","_nodeVersion":"6.3.0","_npmUser":{"name":"lazarv","email":"viktor.lazar@jaystack.com"},"dist":{"shasum":"66f08f6cb05d4b7c138cc6dc783b939f81c58774","tarball":"https://registry.npmjs.org/odata-v4-sql/-/odata-v4-sql-0.1.0.tgz","integrity":"sha512-V3aB9MthZOB917mTN+6UvGCb0eClV722SlAejItRHQYiETxTxBq/8S7KsB4Bacp/z9uZKUQdxERjfZZjQANDaQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCw2ecDbgrTnSt+QeKS59W3zIix5ylxW7piYjWKGNNZJQIgQhzV/gG4SpqkY+TE5jB95qJdgmrCzftTUtC7oJvXyJE="}]},"maintainers":[{"name":"lazarv","email":"viktor.lazar@jaystack.com"}],"_npmOperationalInternal":{"host":"packages-18-east.internal.npmjs.com","tmp":"tmp/odata-v4-sql-0.1.0.tgz_1479293107602_0.28640576149336994"}},"0.1.1":{"name":"odata-v4-sql","version":"0.1.1","description":"OData to SQL query compiler","main":"lib/index.js","typings":"lib/index","directories":{"test":"test"},"scripts":{"build":"tsc","pretest":"npm run build","test":"mocha","pretdd":"npm run build","tdd":"mocha -w"},"repository":{"type":"git","url":"git+https://github.com/jaystack/odata-v4-sql.git"},"keywords":["OData","V4","sql"],"author":{"name":"JayStack"},"license":"MIT","bugs":{"url":"https://github.com/jaystack/odata-v4-sql/issues"},"homepage":"https://github.com/jaystack/odata-v4-sql#readme","dependencies":{"odata-v4-literal":"^0.1.0","odata-v4-parser":"0.1.13"},"devDependencies":{"chai":"^3.5.0","mocha":"^3.1.2","typescript":"^2.0.6"},"gitHead":"d84bb93efb0c94bd573d3733d110d281ce0e58b2","_id":"odata-v4-sql@0.1.1","_shasum":"8da3c56ba8650d2a4b0e464b0c54b7839e1b237e","_from":".","_npmVersion":"3.8.6","_nodeVersion":"6.3.0","_npmUser":{"name":"lazarv","email":"viktor.lazar@jaystack.com"},"dist":{"shasum":"8da3c56ba8650d2a4b0e464b0c54b7839e1b237e","tarball":"https://registry.npmjs.org/odata-v4-sql/-/odata-v4-sql-0.1.1.tgz","integrity":"sha512-2BAzKLlTUrQV52tX20eZC9NpFngRxgvYKWVvSvKTxrEU5OdAycYXYFnHIFRd5ZmOyugt1zZGO6FdJJYPaRv/lw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDMk3llpLwE/W+3ULndx8rW3S+vHJ1ShvMeB0fIdcrb+AIhAOI6JvTPAZ9jw1FO2dQCPwuST3jB/XxYcUkRDKocz2ob"}]},"maintainers":[{"name":"lazarv","email":"viktor.lazar@jaystack.com"}],"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/odata-v4-sql-0.1.1.tgz_1479719595048_0.8876930177211761"}},"0.1.1-jenkins-5":{"name":"odata-v4-sql","version":"0.1.1-jenkins-5","description":"OData to SQL query compiler","main":"lib/index.js","typings":"lib/index","directories":{"test":"test"},"scripts":{"build":"tsc","pretest":"npm run build","test":"mocha","pretdd":"npm run build","tdd":"mocha -w"},"repository":{"type":"git","url":"git+https://github.com/jaystack/odata-v4-sql.git"},"keywords":["OData","V4","sql"],"author":{"name":"JayStack"},"license":"MIT","bugs":{"url":"https://github.com/jaystack/odata-v4-sql/issues"},"homepage":"https://github.com/jaystack/odata-v4-sql#readme","dependencies":{"odata-v4-literal":"^0.1.0","odata-v4-parser":"0.1.13"},"devDependencies":{"chai":"^3.5.0","mocha":"^3.1.2","typescript":"^2.5.1"},"gitHead":"42e585a310eff96b0a45f5ab9b8624178df3af1e","_id":"odata-v4-sql@0.1.1-jenkins-5","_npmVersion":"5.3.0","_nodeVersion":"8.2.1","_npmUser":{"name":"jaystack","email":"info@jaystack.com"},"dist":{"integrity":"sha512-1A5P94RUv9AQsV0fBcJ3u7X51DCvJPCbGbtye18U5Q4Zk3ULat1kCiw9Jr8f1n86kHJ+3vaUtRncMocm7rAlKQ==","shasum":"eb9a42bfc826a8290a37953fcce6d77367d46775","tarball":"https://registry.npmjs.org/odata-v4-sql/-/odata-v4-sql-0.1.1-jenkins-5.tgz","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIFv87HKit10kO4UXun545wlt9BQtzVrFBfFYGmSuaftnAiEAirEJt5oHLznEXMe63eXd17CVcKNxOpK+CCQkepYLEpE="}]},"maintainers":[{"name":"jaystack","email":"info@jaystack.com"},{"name":"lazarv","email":"viktor.lazar@jaystack.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/odata-v4-sql-0.1.1-jenkins-5.tgz_1503499171478_0.5783491926267743"}},"0.1.2":{"name":"odata-v4-sql","version":"0.1.2","description":"OData to SQL query compiler","main":"lib/index.js","typings":"lib/index","directories":{"test":"test"},"scripts":{"build":"tsc","pretest":"npm run build","test":"mocha","pretdd":"npm run build","tdd":"mocha -w","prepare":"npm run build"},"repository":{"type":"git","url":"git+https://github.com/jaystack/odata-v4-sql.git"},"keywords":["OData","V4","sql"],"author":{"name":"JayStack"},"license":"MIT","bugs":{"url":"https://github.com/jaystack/odata-v4-sql/issues"},"homepage":"https://github.com/jaystack/odata-v4-sql#readme","dependencies":{"odata-v4-literal":"^0.1.0","odata-v4-parser":"0.1.13"},"devDependencies":{"chai":"^3.5.0","mocha":"^3.1.2","typescript":"^2.5.1"},"gitHead":"b8675b24ea4971b12e3fa6ddfecff791e5e901c8","_id":"odata-v4-sql@0.1.2","_npmVersion":"6.1.0","_nodeVersion":"10.5.0","_npmUser":{"name":"lazarv","email":"viktor.lazar@jaystack.com"},"dist":{"integrity":"sha512-Y3S2N2C+W5pRlXsnuZBhGZ+ZlbkBxjjzwi8I6MKRmjpqil1BOs0YIUQWYCp70WmP/psp//hOJHpBRc8iFgomTg==","shasum":"6b5d10ac6dd89f2087093b7cefaa511ee7af9ea9","tarball":"https://registry.npmjs.org/odata-v4-sql/-/odata-v4-sql-0.1.2.tgz","fileCount":17,"unpackedSize":100220,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJbWJdvCRA9TVsSAnZWagAAh70P/A+GEv7OH3stW60srFdA\novig65kWKONmETpFpoG9kVjdpWn0v8FzCt30AGeDp8q/1E1CMBz032IBJJ3O\neqZa/mOpTYes6sMugZVEfSE4NqVchw2qeN0Teomsl4aHUbxPmORPPXIrRQYK\nMDMl9V7VyThxeZvu5oOhY8mPOTeIYsxHbYgc9q6PgkBFMXvtQVCq/mV4RppP\nOu5LcyP5cN28sutcfqOwqzLmzuSpyCU3V45bV64AEwsDyDTx1XKlF/f1oVM+\n0634nc6Llt0dOb+GucWPGPTH0pO2voNuq4zA2I+KjcgEtia51IBdRIQ1l8bS\n7L21tgDfoglOoiQvqkxZGHM/Mcg59D6UTvmH18/K2dUC817ojqXgNNRQ6aXC\nzd7Q9Ql5rmA2KePuLMTlDl5JdpsLWFGbmX4Dn048RDszv6zqZNMJQ7BPyX27\nCUZdSxuPi3eK8r1bZAVjXJcrzY099AcjjDoRJoOz4bKPu5kPZeU5ItDo/TjU\nxt5GlGycxcEPgxRMg3Uu7VJWTLhoHLynFiXK2uMwvsVW317ixlLn6WoWOvat\nuwtQTCaAmRCL/+HE9Sb8h39IBu+daNe7nPa8LXgYnlU1YNSSsHMrHBog/AEg\nJLKVRQUUPmwh6m7ZwP1Tavat1bzvl8NfKdH2oPMjvXmGy24neArDbe5QM3F+\nFWfW\r\n=Au4w\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCLd1cZMDYmgq1t9ssSJlZaDAwXa3otrOJxZ8OhQboz2QIhAOTN/V2hdvgNuFRkfpgs6mj07V6uK71XV8rYrPIufd2N"}]},"maintainers":[{"name":"jaystack","email":"info@jaystack.com"},{"name":"lazarv","email":"viktor.lazar@jaystack.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/odata-v4-sql_0.1.2_1532532591109_0.49279177623963344"},"_hasShrinkwrap":false}},"readme":"# OData V4 Service modules - SQL Connector\r\n\r\nService OData v4 requests from an SQL data store.\r\n\r\n## Synopsis\r\nThe OData V4 SQL Connector provides functionality to convert the various types of OData segments\r\ninto SQL query statements, that you can execute over an SQL database.\r\n\r\n## Potential usage scenarios\r\n\r\n- Create high speed, standard compliant data sharing APIs\r\n\r\n## Usage as server - TypeScript\r\n```javascript\r\nimport { createFilter } from 'odata-v4-sql'\r\n\r\n//example request:  GET /api/Users?$filter=Id eq 42\r\napp.get(\"/api/Users\", (req: Request, res: Response) => {\r\n    const filter = createFilter(req.query.$filter);\r\n    // request instance from mssql module\r\n    request.query(`SELECT * FROM Users WHERE ${filter.where}`, function(err, data){\r\n        res.json({\r\n        \t'@odata.context': req.protocol + '://' + req.get('host') + '/api/$metadata#Users',\r\n        \tvalue: data\r\n        });\r\n    });\r\n});\r\n```\r\n\r\nAdvanced TypeScript example available [here](https://raw.githubusercontent.com/jaystack/odata-v4-sql/master/src/example/sql.ts).\r\n\r\n## Usage ES5\r\n```javascript\r\nvar createFilter = require('odata-v4-sql').createFilter;\r\n\r\napp.get(\"/api/Users\", function(req, res) {\r\n    var filter = createFilter(req.query.$filter);\r\n    // request instance from mssql module\r\n    request.query(filter.from(\"Users\"), function(err, data){\r\n        res.json({\r\n        \t'@odata.context': req.protocol + '://' + req.get('host') + '/api/$metadata#Users',\r\n        \tvalue: data\r\n        });\r\n    });\r\n})\r\n```\r\n\r\n## Supported OData segments\r\n\r\n* $filter\r\n* $select\r\n* $skip\r\n* $top\r\n* $orderby\r\n* $expand","maintainers":[{"name":"jaystack","email":"info@jaystack.com"},{"name":"lazarv","email":"viktor.lazar@jaystack.com"}],"time":{"modified":"2022-06-22T18:58:19.839Z","created":"2016-11-16T10:45:08.182Z","0.1.0":"2016-11-16T10:45:08.182Z","0.1.1":"2016-11-21T09:13:17.204Z","0.1.1-jenkins-5":"2017-08-23T14:39:32.522Z","0.1.2":"2018-07-25T15:29:51.207Z"},"homepage":"https://github.com/jaystack/odata-v4-sql#readme","keywords":["OData","V4","sql"],"repository":{"type":"git","url":"git+https://github.com/jaystack/odata-v4-sql.git"},"author":{"name":"JayStack"},"bugs":{"url":"https://github.com/jaystack/odata-v4-sql/issues"},"license":"MIT","readmeFilename":"README.md"}