{"_id":"jungles-data-postgres","_rev":"42-3751c8e21c9e8e93137feb419eedbbef","name":"jungles-data-postgres","description":"Data for Jungles using Postgresql","dist-tags":{"latest":"3.0.0"},"versions":{"1.0.0":{"author":{"name":"Geert Pasteels","email":"geert.pasteels@gmail.com"},"name":"jungles-data-postgres","description":"Data for Jungles using Postgresql","version":"1.0.0","keywords":["jungles","data","postgresql"],"dependencies":{"underscore":"~1.3.3","kwery":"*","slug":"~0.2.2","pg":"~0.8.1"},"devDependencies":{"eql":"0.0.4"},"readme":"# Jungles Data Postgresql\n\n## API\n\n### Setup\n\n```js\nvar data = require('jungles-data-postgres')({\n  user: 'james',\n  password: '1234',\n  database: 'jungles',\n  host: '127.0.0.1'\n});\n\ndata.setup(); // Creates table called instances\n```\n\n### Find\n\n```js\nvar result = data.find(<query object>);\n\nresult.many(function (response) {\n  // Always called\n  // response: Array (can be empty)\n});\n\nresult.one(function (response) {\n  // called when there is atleast one result\n  // { id, name, path, arrange, sort, ..data.. }\n});\n\nresult.empty(function () { \n  // called when result is empty\n});\n\nresult.error(function (error) {\n  // error\n});\n```\n\n### Remove\n\n```js\nvar result = data.remove(<query object>);\n\nresult.success(function () { });\n```\n\n### Save (create, update)\n\n```js\n// Create\nvar result = data.save({ type: 'product', parent: 0, name: 'snowboard', arrange: '0' });\nresult.success(function () {});\n```\nThese fields are required to create. Extra fields get json stringified and added to the data column.\n\n```js\n// Update\nvar result = data.save({ id: 1, name: 'skateboard' });\nresult.success(function () {});\n```\n\nBecause there is an id it knows it's an update.\n\n### Tree\n\n```js\nvar result = data.tree(<query object>); \n\nresult.success(function (tree) { });\n```\n\n#### Structure\n\n```js\n{\n  id: 1,\n  name: 'snowboard',\n  path: '/snowboard',\n  type: 'product',\n  sort: '/0',\n  arrange: 0,\n  children: [\n    {\n      id: 2,\n      name: 'tags',\n      path: '/snowboard/tags',\n      type: 'tags',\n      sort: '/0/0',\n      arrange: 0,\n\n      children: [\n        {\n          id: 3,\n          name: 'red',\n          path: '/snowboard/tags/red',\n          type: 'tag',\n          sort: '/0/0/0',\n          arrange: 0,\n        }\n      ]\n    }\n  ]\n}\n```\n\n### Query object examples\n\n```js\n{ id: 5} \n// SELECT * FROM instances where id = 5;\n\n{ path: /.*/ } \n// SELECT * FROM instance WHERE path ~ .*;\n\n{ path: /.*/, id: 5 } \n// SELECT * FROM instances WHERE path ~ .* and id = 5;\n```\n\n## Test\n\nmocha.js and should.js is needed. Tests are run against a real database so you need to have postgresql. Check specs/db for database settings.\n\n```js\nmake test\n```\n","_id":"jungles-data-postgres@1.0.0","dist":{"shasum":"f2227dbab885859f869782946ef9284a46f1f69a","tarball":"https://registry.npmjs.org/jungles-data-postgres/-/jungles-data-postgres-1.0.0.tgz","integrity":"sha512-4uuZih1xmeu87gt4IYRVQoAa81ktfIApU2EpDzdzdGLYWEfLNCaC6w6T0dEiW+nrPDhp1cEs+I9k+Nd5Fpmy/A==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIByBcanl5LzX3xOdiEfRTfzeKzqLt4F2ckkWJFcLiSUbAiA//KpHW+09ZTrCB6r7n1CEyYQt3ljR1EoYZAQ/mP5f1w=="}]},"maintainers":[{"name":"enome","email":"geert.pasteels@gmail.com"}],"directories":{}},"1.2.0":{"author":{"name":"Geert Pasteels","email":"geert.pasteels@gmail.com"},"name":"jungles-data-postgres","description":"Data for Jungles using Postgresql","version":"1.2.0","keywords":["jungles","data","postgresql"],"dependencies":{"underscore":"~1.3.3","kwery":"*","slug":"~0.2.2","pg":"~0.8.1"},"devDependencies":{"eql":"0.0.4"},"readme":"# Jungles Data Postgres\n\n## Setup\n\n```js\nvar data = require('jungles-data-postgres')({\n  user: 'james',\n  password: '1234',\n  database: 'jungles',\n  host: '127.0.0.1'\n});\n\ndata.setup(); // Creates table called instances\n```\n\n## API\n\n[Data API](http://github.com/Enome/jungles-data)\n\n## Postgres specific\n\nQuery objects get translated.\n\n```js\n{ id: 5} \n// SELECT * FROM instances where id = 5;\n\n{ path: /.*/ } \n// SELECT * FROM instance WHERE path ~ .*;\n\n{ path: /.*/, id: 5 } \n// SELECT * FROM instances WHERE path ~ .* and id = 5;\n```\n\n## Test\n\nmocha.js and should.js is needed. Tests are run against a real database so you need to have postgresql. Check specs/db for database settings.\n\n```js\nmake test\n```\n","_id":"jungles-data-postgres@1.2.0","dist":{"shasum":"50e16d6cdfa90a95c381745a0c3bb7743f25dcee","tarball":"https://registry.npmjs.org/jungles-data-postgres/-/jungles-data-postgres-1.2.0.tgz","integrity":"sha512-emwVI+ByRztHzKMHUgEgqoRAazoE1eVJeKvsMB9PYTV4FMkTBA8PNYYaDFLKetuf2BgLuYTq8p1JqKdRPu6PVQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQD31gusEURqg/Glo5vG+gUU2Uamb069cCoW41Og5xddYAIhAJdvbeO8mtAtdUga0w6TPTJtwLJpvMQcBOkA13D8Vi8s"}]},"maintainers":[{"name":"enome","email":"geert.pasteels@gmail.com"}],"directories":{}},"1.2.1":{"author":{"name":"Geert Pasteels","email":"geert.pasteels@gmail.com"},"name":"jungles-data-postgres","description":"Data for Jungles using Postgresql","version":"1.2.1","keywords":["jungles","data","postgresql"],"dependencies":{"underscore":"~1.3.3","kwery":"*","slug":"~0.2.2","pg":"~0.8.1"},"devDependencies":{"eql":"0.0.4"},"readme":"# Jungles Data Postgres\n\n## Setup\n\n```js\nvar data = require('jungles-data-postgres')({\n  user: 'james',\n  password: '1234',\n  database: 'jungles',\n  host: '127.0.0.1'\n});\n\ndata.setup(); // Creates table called instances\n```\n\n## API\n\n[Data API](http://github.com/Enome/jungles-data)\n\n## Postgres specific\n\nQuery objects get translated.\n\n```js\n{ id: 5} \n// SELECT * FROM instances where id = 5;\n\n{ path: /.*/ } \n// SELECT * FROM instance WHERE path ~ .*;\n\n{ path: /.*/, id: 5 } \n// SELECT * FROM instances WHERE path ~ .* and id = 5;\n```\n\n## Test\n\nmocha.js and should.js is needed. Tests are run against a real database so you need to have postgresql. Check specs/db for database settings.\n\n```js\nmake test\n```\n","_id":"jungles-data-postgres@1.2.1","dist":{"shasum":"2dbe4617d3caafb58df789b3e96cc04e3c6056ff","tarball":"https://registry.npmjs.org/jungles-data-postgres/-/jungles-data-postgres-1.2.1.tgz","integrity":"sha512-DZO81briJpf5oEY+lBpG8OoFBjt/Ow5YOzmHt6MEeLnkchCBq379pabMFBrAelX9/QhE/XHXNtGpHHJWYrdHqA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCICc4wkFpzDV8B7/oO6iqR4wBpb1jqz7cqPde9NCSB/9IAiAq+RhxIx+loI+JxcdIYFtL4m/X3ebxnshtpTTrsM/Siw=="}]},"maintainers":[{"name":"enome","email":"geert.pasteels@gmail.com"}],"directories":{}},"1.3.0":{"author":{"name":"Geert Pasteels","email":"geert.pasteels@gmail.com"},"name":"jungles-data-postgres","description":"Data for Jungles using Postgresql","version":"1.3.0","keywords":["jungles","data","postgresql"],"dependencies":{"underscore":"~1.3.3","kwery":"*","slug":"~0.2.2","pg":"~0.8.1"},"devDependencies":{"eql":"0.0.4"},"readme":"# Jungles Data Postgres\n\n## Setup\n\n```js\nvar data = require('jungles-data-postgres')({\n  user: 'james',\n  password: '1234',\n  database: 'jungles',\n  host: '127.0.0.1'\n});\n\ndata.setup(); // Creates table called instances\n```\n\n## API\n\n[Data API](http://github.com/Enome/jungles-data)\n\n## Postgres specific\n\nQuery objects get translated.\n\n```js\n{ id: 5} \n// SELECT * FROM instances where id = 5;\n\n{ path: /.*/ } \n// SELECT * FROM instance WHERE path ~ .*;\n\n{ path: /.*/, id: 5 } \n// SELECT * FROM instances WHERE path ~ .* and id = 5;\n```\n\n## Test\n\nmocha.js and should.js is needed. Tests are run against a real database so you need to have postgresql. Check specs/db for database settings.\n\n```js\nmake test\n```\n","_id":"jungles-data-postgres@1.3.0","dist":{"shasum":"54acb3d94752990944c47c68bec4f44b29f22497","tarball":"https://registry.npmjs.org/jungles-data-postgres/-/jungles-data-postgres-1.3.0.tgz","integrity":"sha512-3y/uBv5OSa6giubVr4YPXx9z9Zxuq2UH8E8UXbUtJ5RSU2t3NVhUBYwLs1ooAR2PvFmGJCniZnouyYwAaAuX2w==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDr2eFxI5sCDjH9a8CFU/hURffhpzL5IpYY2d+XDq3aYwIhAK6uE7FgaOa7T/4SR9+i/UglHJNvue75ZCG09pbi4qq4"}]},"maintainers":[{"name":"enome","email":"geert.pasteels@gmail.com"}],"directories":{}},"2.0.0":{"author":{"name":"Geert Pasteels","email":"geert.pasteels@gmail.com"},"name":"jungles-data-postgres","description":"Data for Jungles using Postgresql","version":"2.0.0","keywords":["jungles","data","postgresql"],"dependencies":{"underscore":"~1.3.3","kwery":"*","slug":"~0.2.2","pg":"~0.8.1","jungles-data":"~1.1.0"},"readme":"# Jungles Data Postgres (Out of date)\n\n## Setup\n\n```js\nvar data = require('jungles-data-postgres')({\n  user: 'james',\n  password: '1234',\n  database: 'jungles',\n  host: '127.0.0.1'\n});\n\ndata.setup(); // Creates table called instances\n```\n\n## API\n\n[Data API](https://github.com/Enome/jungles/tree/master/data)\n\n## Postgres specific\n\nQuery objects get translated.\n\n```js\n{ id: 5} \n// SELECT * FROM instances where id = 5;\n\n{ path: /.*/ } \n// SELECT * FROM instance WHERE path ~ .*;\n\n{ path: /.*/, id: 5 } \n// SELECT * FROM instances WHERE path ~ .* and id = 5;\n```\n\n## Test\n\nmocha.js and should.js is needed. Tests are run against a real database so you need to have postgresql. Check specs/db for database settings.\n\n```js\nmake test\n```\n","_id":"jungles-data-postgres@2.0.0","dist":{"shasum":"8bf14db3b6056b156ee9f11e9ff177fea7e6259b","tarball":"https://registry.npmjs.org/jungles-data-postgres/-/jungles-data-postgres-2.0.0.tgz","integrity":"sha512-LVTd9RFk0sjffeARXtP1AlxYEo5DB+OaxWWkl8svwLnAfkUKswsHGNFJXTUGWjYKZbJUakGDzLM7uYzgx5p58g==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCae0jVLOewmEPO7hu+h4+RvJz/EQiwztgClOUxC7WmVAIhAKbMc2OsFTozbZSmbAdIKIAyUFH42fvjB/Wek+3Or+g+"}]},"maintainers":[{"name":"enome","email":"geert.pasteels@gmail.com"}],"directories":{}},"2.0.1":{"author":{"name":"Geert Pasteels","email":"geert.pasteels@gmail.com"},"name":"jungles-data-postgres","description":"Data for Jungles using Postgresql","version":"2.0.1","keywords":["jungles","data","postgresql"],"dependencies":{"underscore":"~1.3.3","kwery":"*","slug":"~0.2.2","pg":"~0.8.7","jungles-data":"~1.1.0"},"readme":"# Jungles Data Postgres (Out of date)\n\n## Setup\n\n```js\nvar data = require('jungles-data-postgres')({\n  user: 'james',\n  password: '1234',\n  database: 'jungles',\n  host: '127.0.0.1'\n});\n\ndata.setup(); // Creates table called instances\n```\n\n## API\n\n[Data API](https://github.com/Enome/jungles/tree/master/data)\n\n## Postgres specific\n\nQuery objects get translated.\n\n```js\n{ id: 5} \n// SELECT * FROM instances where id = 5;\n\n{ path: /.*/ } \n// SELECT * FROM instance WHERE path ~ .*;\n\n{ path: /.*/, id: 5 } \n// SELECT * FROM instances WHERE path ~ .* and id = 5;\n```\n\n## Test\n\nmocha.js and should.js is needed. Tests are run against a real database so you need to have postgresql. Check specs/db for database settings.\n\n```js\nmake test\n```\n","readmeFilename":"README.md","_id":"jungles-data-postgres@2.0.1","dist":{"shasum":"e99d441396e231dbeddbb96210f560527fcfd2b5","tarball":"https://registry.npmjs.org/jungles-data-postgres/-/jungles-data-postgres-2.0.1.tgz","integrity":"sha512-nOqod+Vj5hOmCK/SKMdbDsOgnUjdAA+o+UnQI721osfKEdRB+vmn/tAAFWeGfO3tp7BUmV0D/C1rp3g3Xg0l0Q==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIEoZotQqhaMEu9kZBf+3KVrPi4UHnsosBO3oU8O3T7lPAiEAlBuxH4Th0UvIyRkvu6hpTCfzyhug4BBR5eMO535xL7E="}]},"_npmVersion":"1.1.65","_npmUser":{"name":"enome","email":"geert.pasteels@gmail.com"},"maintainers":[{"name":"enome","email":"geert.pasteels@gmail.com"}],"directories":{}},"2.1.0":{"author":{"name":"Geert Pasteels","email":"geert.pasteels@gmail.com"},"name":"jungles-data-postgres","description":"Data for Jungles using Postgresql","version":"2.1.0","keywords":["jungles","data","postgresql"],"dependencies":{"underscore":"~1.3.3","kwery":"*","slug":"~0.2.2","pg":"~0.8.7","jungles-data":"~1.2.0"},"readme":"# Jungles Data Postgres (Out of date)\n\n## Setup\n\n```js\nvar data = require('jungles-data-postgres')({\n  user: 'james',\n  password: '1234',\n  database: 'jungles',\n  host: '127.0.0.1'\n});\n\ndata.setup(); // Creates table called instances\n```\n\n## API\n\n[Data API](https://github.com/Enome/jungles/tree/master/data)\n\n## Postgres specific\n\nQuery objects get translated.\n\n```js\n{ id: 5} \n// SELECT * FROM instances where id = 5;\n\n{ path: /.*/ } \n// SELECT * FROM instance WHERE path ~ .*;\n\n{ path: /.*/, id: 5 } \n// SELECT * FROM instances WHERE path ~ .* and id = 5;\n```\n\n## Test\n\nmocha.js and should.js is needed. Tests are run against a real database so you need to have postgresql. Check specs/db for database settings.\n\n```js\nmake test\n```\n","readmeFilename":"README.md","_id":"jungles-data-postgres@2.1.0","dist":{"shasum":"e7a34da7950839e2b85f0a20df87cac5a42d3b83","tarball":"https://registry.npmjs.org/jungles-data-postgres/-/jungles-data-postgres-2.1.0.tgz","integrity":"sha512-LNZ6lmS6hZ2PcAnSk/3jbOH4137c0YUkbUY5b+BeJnSLs52sHI/4jsjD6h34r745sHTqaDf8Rb/0jq+3CStU9A==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQD0ZibpJrLHtYO0LOkCHiuH8Vyo1dX520Q6Ccz6JIiXNwIgejnJcTeC4fRWnR9WEdKfpmcYBgFR6LDSKqwF4DfmjXM="}]},"_from":".","_npmVersion":"1.2.15","_npmUser":{"name":"enome","email":"geert.pasteels@gmail.com"},"maintainers":[{"name":"enome","email":"geert.pasteels@gmail.com"}],"directories":{}},"2.1.1":{"author":{"name":"Geert Pasteels","email":"geert.pasteels@gmail.com"},"name":"jungles-data-postgres","description":"Data for Jungles using Postgresql","version":"2.1.1","keywords":["jungles","data","postgresql"],"dependencies":{"underscore":"~1.3.3","kwery":"*","slug":"~0.2.2","pg":"~0.8.7","jungles-data":"~1.2.0"},"readme":"# Jungles Data Postgres (Out of date)\n\n## Setup\n\n```js\nvar data = require('jungles-data-postgres')({\n  user: 'james',\n  password: '1234',\n  database: 'jungles',\n  host: '127.0.0.1'\n});\n\ndata.setup(); // Creates table called instances\n```\n\n## API\n\n[Data API](https://github.com/Enome/jungles/tree/master/data)\n\n## Postgres specific\n\nQuery objects get translated.\n\n```js\n{ id: 5} \n// SELECT * FROM instances where id = 5;\n\n{ path: /.*/ } \n// SELECT * FROM instance WHERE path ~ .*;\n\n{ path: /.*/, id: 5 } \n// SELECT * FROM instances WHERE path ~ .* and id = 5;\n```\n\n## Test\n\nmocha.js and should.js is needed. Tests are run against a real database so you need to have postgresql. Check specs/db for database settings.\n\n```js\nmake test\n```\n","readmeFilename":"README.md","_id":"jungles-data-postgres@2.1.1","dist":{"shasum":"b47495dbef9fdf7562818552b8115d90461b09e1","tarball":"https://registry.npmjs.org/jungles-data-postgres/-/jungles-data-postgres-2.1.1.tgz","integrity":"sha512-b3+YApfb3oUg5GV5F/iBMgWuIms/UkSwfuDQGQ28w5hUoUcxWN8ROfWJsRwVunco8qpzjEcOYFdaifgwTmQDog==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCICGPDmdrb8Qs3sA4MjK+4VrfKJDsfZGiZ+u5PuCd8rkVAiA7ENGvnPYZIcPmmE6Ln0nboOB1go0pQ9CeMzwaI8n0xg=="}]},"_from":".","_npmVersion":"1.2.15","_npmUser":{"name":"enome","email":"geert.pasteels@gmail.com"},"maintainers":[{"name":"enome","email":"geert.pasteels@gmail.com"}],"directories":{}},"3.0.0":{"author":{"name":"Geert Pasteels","email":"geert.pasteels@gmail.com"},"name":"jungles-data-postgres","description":"Data for Jungles using Postgresql","version":"3.0.0","keywords":["jungles","data","postgresql"],"dependencies":{"underscore":"~1.3.3","kwery":"*","slug":"~0.2.2","pg":"~0.8.7","jungles-data":"2.0.0","async":"~0.2.8"},"readme":"# Jungles Data Postgres (Out of date)\n\n## Setup\n\n```js\nvar data = require('jungles-data-postgres')({\n  user: 'james',\n  password: '1234',\n  database: 'jungles',\n  host: '127.0.0.1'\n});\n\ndata.setup(); // Creates table called instances\n```\n\n## API\n\n[Data API](https://github.com/Enome/jungles/tree/master/data)\n\n## Postgres specific\n\nQuery objects get translated.\n\n```js\n{ id: 5}               // SELECT * FROM instances where id = 5;\n{ path: /.*/ }         // SELECT * FROM instance WHERE path ~ .*;\n{ path: /.*/, id: 5 }  // SELECT * FROM instances WHERE path ~ .* and id = 5;\n```\n\n## Test\n\nmocha.js and should.js is needed. Tests are run against a real database which your can start with `vagrant up`.\n\n```js\nmake test\n```\n","readmeFilename":"README.md","_id":"jungles-data-postgres@3.0.0","dist":{"shasum":"f47cd862218f2c0004fc86d6827ea933651f81df","tarball":"https://registry.npmjs.org/jungles-data-postgres/-/jungles-data-postgres-3.0.0.tgz","integrity":"sha512-nOPnDXfuK3VJszgJfB7aXKe7wlFdg43ZZL8dpgQraxCJI/y/kmG/9miHkgGIRvxJ90dZkFI6RTG4Hi12R0p/0Q==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCpxCXdqFq4hW2iNhnv5IwVHbHXIgIdbvqfuJW9PewiBwIhALhmtz/j4PfsO8t7VVrzuliW0elcxuoLjj67tFT+w3m9"}]},"_from":"data-postgres","_npmVersion":"1.2.15","_npmUser":{"name":"enome","email":"geert.pasteels@gmail.com"},"maintainers":[{"name":"enome","email":"geert.pasteels@gmail.com"}]}},"readme":"# Jungles Data Postgresql\n\n## API\n\n### Setup\n\n```js\nvar data = require('jungles-data-postgres')({\n  user: 'james',\n  password: '1234',\n  database: 'jungles',\n  host: '127.0.0.1'\n});\n\ndata.setup(); // Creates table called instances\n```\n\n### Find\n\n```js\nvar result = data.find(<query object>);\n\nresult.many(function (response) {\n  // Always called\n  // response: Array (can be empty)\n});\n\nresult.one(function (response) {\n  // called when there is atleast one result\n  // { id, name, path, arrange, sort, ..data.. }\n});\n\nresult.empty(function () { \n  // called when result is empty\n});\n\nresult.error(function (error) {\n  // error\n});\n```\n\n### Remove\n\n```js\nvar result = data.remove(<query object>);\n\nresult.success(function () { });\n```\n\n### Save (create, update)\n\n```js\n// Create\nvar result = data.save({ type: 'product', parent: 0, name: 'snowboard', arrange: '0' });\nresult.success(function () {});\n```\nThese fields are required to create. Extra fields get json stringified and added to the data column.\n\n```js\n// Update\nvar result = data.save({ id: 1, name: 'skateboard' });\nresult.success(function () {});\n```\n\nBecause there is an id it knows it's an update.\n\n### Tree\n\n```js\nvar result = data.tree(<query object>); \n\nresult.success(function (tree) { });\n```\n\n#### Structure\n\n```js\n{\n  id: 1,\n  name: 'snowboard',\n  path: '/snowboard',\n  type: 'product',\n  sort: '/0',\n  arrange: 0,\n  children: [\n    {\n      id: 2,\n      name: 'tags',\n      path: '/snowboard/tags',\n      type: 'tags',\n      sort: '/0/0',\n      arrange: 0,\n\n      children: [\n        {\n          id: 3,\n          name: 'red',\n          path: '/snowboard/tags/red',\n          type: 'tag',\n          sort: '/0/0/0',\n          arrange: 0,\n        }\n      ]\n    }\n  ]\n}\n```\n\n### Query object examples\n\n```js\n{ id: 5} \n// SELECT * FROM instances where id = 5;\n\n{ path: /.*/ } \n// SELECT * FROM instance WHERE path ~ .*;\n\n{ path: /.*/, id: 5 } \n// SELECT * FROM instances WHERE path ~ .* and id = 5;\n```\n\n## Test\n\nmocha.js and should.js is needed. Tests are run against a real database so you need to have postgresql. Check specs/db for database settings.\n\n```js\nmake test\n```\n","maintainers":[{"name":"enome","email":"geert.pasteels@gmail.com"}],"time":{"modified":"2022-06-19T07:21:07.578Z","created":"2012-07-27T08:23:42.137Z","1.0.0":"2012-07-27T08:23:43.710Z","1.2.0":"2012-08-07T10:12:46.736Z","1.2.1":"2012-08-07T20:32:11.903Z","1.3.0":"2012-08-08T15:12:39.200Z","2.0.0":"2012-10-31T09:28:37.633Z","2.0.1":"2012-11-16T12:15:53.344Z","2.1.0":"2013-04-18T16:33:20.456Z","2.1.1":"2013-04-21T15:49:37.939Z","3.0.0":"2013-06-15T18:37:21.081Z"},"author":{"name":"Geert Pasteels","email":"geert.pasteels@gmail.com"},"users":{"fgribreau":true}}