{"_id":"iquery","_rev":"35-35c6ca0ab0a82d83e7a33707bc3b4601","name":"iquery","description":"Generate your where condition SQL","dist-tags":{"latest":"0.0.2"},"versions":{"0.0.1":{"name":"iquery","version":"0.0.1","description":"Generate your where condition SQL","main":"index.js","scripts":{"test":"mocha -R spec"},"repository":{"type":"git","url":"git://github.com/JacksonTian/sql.git"},"devDependencies":{"should":"*","mocha":"*","jscover":"*"},"keywords":["SQL","WHERE"],"author":{"name":"Jackson Tian"},"license":"MIT","readmeFilename":"README.md","directories":{"test":"test"},"dependencies":{},"readme":"iQuery [![Build Status](https://travis-ci.org/JacksonTian/iquery.png?branch=master)](https://travis-ci.org/JacksonTian/iquery)\n=====\n\nselect * from table where {}\n\n","_id":"iquery@0.0.1","dist":{"shasum":"c55fd1f400683cd1cd82b15bd71c200e69edd635","tarball":"https://registry.npmjs.org/iquery/-/iquery-0.0.1.tgz","integrity":"sha512-vQ5Y0Y+nMaOkh1MNo/PxhmacrtFwiR4Y/AwA8M9a0Pq3hNfSc4xeEf2RnHa95U245mljyKg/HBvmRFdPHxWjKA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIDQBJYDYDDea7sXDpMQM34mFztUjwbHWoYBWXRJq2yGIAiEAruUMYFW3CcRIaNkwJzE8F3gclz4ArtrsQWMdqZt4B70="}]},"_npmVersion":"1.1.65","_npmUser":{"name":"jacksontian","email":"shyvo1987@gmail.com"},"maintainers":[{"name":"jacksontian","email":"shyvo1987@gmail.com"}]},"0.0.2":{"name":"iquery","version":"0.0.2","description":"Generate your where condition SQL","main":"index.js","scripts":{"test":"mocha -R spec"},"repository":{"type":"git","url":"git://github.com/JacksonTian/iquery.git"},"devDependencies":{"should":"*","mocha":"*","jscover":"*"},"keywords":["SQL","WHERE"],"author":{"name":"Jackson Tian"},"license":"MIT","readmeFilename":"README.md","directories":{"test":"test"},"dependencies":{},"readme":"iQuery [![Build Status](https://travis-ci.org/JacksonTian/iquery.png?branch=master)](https://travis-ci.org/JacksonTian/iquery)\n=====\n## CRUD\n### SELECT\nRequire:\n\n```\nvar select = require('iquery').select;\n```  \nUsage:\n\n```\nselect('a, b, c, d')\n  .from('table')\n  .where('e = f')\n  .groupBy('g')\n  .orderBy('a')\n  .limit(0, 100)\n  .toString();\n// =>\nSELECT a, b, c, d\n  FROM table\n  WHERE e = f\n  GROUP BY g\n  ORDER BY a\n  LIMIT 0, 100\n```\n\n#### select from\n```\nselect('*')\n  .from('table')\n  .toString();\n// OR\nselect()\n  .from('table')\n  .toString();\n// =>\nSELECT * FROM table\n\nselect('a, b, c, d')\n  .from('table')\n  .toString();\n// =>\nSELECT a, b, c, d FROM table\n\nselect(['a', 'b', 'c', 'd'])\n  .from('table')\n  .toString();\n// =>\nSELECT a, b, c, d FROM table\n```\n\n#### where\n```\nselect('*')\n  .from('table')\n  .where('a = b')\n  .toString();\n// =>\nSELECT * FROM table WHERE a = b\n```\n[More where condition]()\n\n#### groupBy\n```\nselect('*')\n  .from('table')\n  .groupBy('c')\n  .toString();\n// =>\nSELECT * FROM table GROUP BY c\n\nselect('*')\n  .from('table')\n  .groupBy('c, d')\n  .toString();\n// =>\nSELECT * FROM table GROUP BY c, d\n```\n\n#### orderBy\n```\nselect('*')\n  .from('table')\n  .orderBy('d DESC')\n  .toString();\n// =>\nSELECT * FROM table ORDER BY d DESC\n```\n[More orderBy case]()\n\n#### limit\n```\nselect('*')\n  .from('table')\n  .limit(100)\n  .toString();\n// =>\nSELECT * FROM table LIMIT 0, 100\n\nselect('*')\n  .from('table')\n  .limit(100, 200)\n  .toString();\n// =>\nSELECT * FROM table LIMIT 100, 200\n```\n\n### Update\nTODO\n### Delete\nTODO\n### Insert\nTODO\n\n## Where/Find\nRequire:\n\n```\nvar Where = require('iquery').Where;\nvar where = new Where();\nvar where = new Where('a = b');\n// a = b\nselect('*').from('table').where(where).toString();\n// =>\nSELECT * FROM table WHERE a = b\n```\n### and\n```\nwhere.and({a: 'b'}).toString();\n// a = :b\nwhere.and({a: 'b', c: 'd'}).toString();\n// a = :b AND c = :d\nwhere.and({a: 'b', c: 'd', e: 'f'}).toString();\n// a = :b AND c = :d AND e = :f\n// Chain\nwhere.and({a: 'b'}).and({c: 'd'}).toString();\n// a = :b AND c = :d\n```\n### or\n```\nwhere.or({a: 'b'}).toString();\n// a = :b\nwhere.or({a: 'b', c: 'd'}).toString();\n// a = :b OR c = :d\nwhere.and({a: 'b', c: 'd', e: 'f'}).toString();\n// a = :b OR c = :d OR e = :f\n// Chain\nwhere.or({a: 'b'}).or({c: 'd'}).toString();\n// a = :b OR c = :d\n```\n### complex\n```\nwhere.and({a: 'b', c: 'd'}).or({e: 'f', g: 'h'}).toString();\n// a = :b AND c = :d OR e = :f OR g = :h\n```\n\n#### a and b or c\n```\nwhere.and({a: 'b', c: 'd'}).or({e: 'f'}).toString();\n// a = :b AND c = :d OR e = :f\n```\n#### a and (b or c)\n__bracket__\n\n```\nwhere.and({a: 'b'}).and(new Where().or({c: 'd', e: 'f'}).bracket()).toString();\n// a = :b AND (c = :d OR e = :f)\n```\n","_id":"iquery@0.0.2","dist":{"shasum":"8642098bf773c1922979596006ee943f8f00826d","tarball":"https://registry.npmjs.org/iquery/-/iquery-0.0.2.tgz","integrity":"sha512-RMQJjjDkaitTDTK7mXsV6TE4Vr13j46XERHa9Dv0gqa7d8dhk9VLgN94G9B9B8t5K7r8afBuF7iRLVx4NvCJZQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCxEr8l6yG1ka/+88fNK3NmsXDAp0+lzQHozyokCTRH4QIhANTRpX2328xz58f4G5Ou3FQ/szSJOexuisY4GXdjE/4l"}]},"_npmVersion":"1.1.65","_npmUser":{"name":"jacksontian","email":"shyvo1987@gmail.com"},"maintainers":[{"name":"jacksontian","email":"shyvo1987@gmail.com"}]}},"readme":"iQuery [![Build Status](https://travis-ci.org/JacksonTian/iquery.png?branch=master)](https://travis-ci.org/JacksonTian/iquery)\n=====\n\nselect * from table where {}\n\n","maintainers":[{"name":"jacksontian","email":"shyvo1987@gmail.com"}],"time":{"modified":"2022-06-19T02:29:48.263Z","created":"2012-12-27T08:56:58.988Z","0.0.1":"2012-12-27T08:57:02.548Z","0.0.2":"2012-12-27T21:00:44.221Z"},"author":{"name":"Jackson Tian"},"repository":{"type":"git","url":"git://github.com/JacksonTian/iquery.git"}}