{"_id":"@ridi/cql-builder","_rev":"50-d6362e405ef1881bac053dad88c4f7c4","name":"@ridi/cql-builder","dist-tags":{"latest":"1.0.4"},"versions":{"1.0.2":{"name":"@ridi/cql-builder","version":"1.0.2","keywords":["CQL","query","builder","Cassandra"],"author":{"name":"Kyungmi Koong","email":"kyungmi.k@ridi.com"},"license":"MIT","_id":"@ridi/cql-builder@1.0.2","maintainers":[{"name":"kyungmi","email":"purecolor85@gmail.com"}],"homepage":"https://github.com/ridi/cql-builder#readme","bugs":{"url":"https://github.com/ridi/cql-builder/issues"},"dist":{"shasum":"a109ec5db5b8900812cc8b9f239fe90d49128957","tarball":"https://registry.npmjs.org/@ridi/cql-builder/-/cql-builder-1.0.2.tgz","integrity":"sha512-ZWfC3MKl2mILMr1oRYhykVAC3TKs58L5aAh/DVjvhbdD0/NgixqQNOQBxNtRvmYl84ud2kd63XoU2DpJyvGTfA==","signatures":[{"sig":"MEUCIBLRv8a7W2Qzk5oQtSC5P6S8POzmt9TDnnw7SPHqYunGAiEA0ROf4zvvt0GvYyp5Wh1lBBHO2OR8keEbvFZi47zOf/4=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"jest":{"verbose":true,"transform":{"^.+\\.jsx?$":"babel-jest"},"collectCoverage":true,"coverageReporters":["clover","html"],"coveragePathIgnorePatterns":["/node_modules/","/tests/"]},"main":"dist/index.js","gitHead":"6b27bd705aed882981d1b32ea3b39cd7c060b601","scripts":{"lint":"eslint ./src","test":"jest --forceExit","build":"webpack"},"_npmUser":{"name":"kyungmi","email":"purecolor85@gmail.com"},"repository":{"url":"git+https://github.com/ridi/cql-builder.git","type":"git"},"_npmVersion":"5.5.1","description":"Cassandra CQL Builder","directories":{"test":"tests"},"_nodeVersion":"8.5.0","devDependencies":{"jest":"^21.0.0","eslint":"^4.5.0","webpack":"^3.5.5","babel-jest":"^21.0.0","babel-loader":"^7.1.1","@ridi/eslint-config":"*","babel-plugin-transform-es2015-modules-commonjs":"^6.24.0"},"_npmOperationalInternal":{"tmp":"tmp/cql-builder-1.0.2.tgz_1512615457375_0.37326982035301626","host":"s3://npm-registry-packages"}},"1.0.3":{"name":"@ridi/cql-builder","version":"1.0.3","keywords":["CQL","query","builder","Cassandra"],"author":{"name":"Kyungmi Koong","email":"kyungmi.k@ridi.com"},"license":"MIT","_id":"@ridi/cql-builder@1.0.3","maintainers":[{"name":"davin.ahn","email":"davin.ahn@ridi.com"},{"name":"devgrapher","email":"devgrapher@ridi.com"},{"name":"earus","email":"hc.kim@ridi.com"},{"name":"freekering","email":"freekering@gmail.com"},{"name":"heejae","email":"j132134@gmail.com"},{"name":"jh.park","email":"jh.park@ridi.com"},{"name":"kt.kang","email":"kt.kang@ridi.com"},{"name":"kyungmi","email":"purecolor85@gmail.com"},{"name":"mskims","email":"its@mskim.me"},{"name":"namenu","email":"namenu@gmail.com"},{"name":"ridi.krazijames","email":"krazijames@ridi.com"},{"name":"ridicorp","email":"developer@ridi.com"}],"homepage":"https://github.com/ridi/cql-builder#readme","bugs":{"url":"https://github.com/ridi/cql-builder/issues"},"dist":{"shasum":"f5e12b6f18b3aca4e3da7f3c24e2c1c1c556d04c","tarball":"https://registry.npmjs.org/@ridi/cql-builder/-/cql-builder-1.0.3.tgz","fileCount":9,"integrity":"sha512-fWDljpPkfAM/eg/3DW+McFrmBXxsqzAzucA5L48Yi6ahjHJaCTDfMmqAwI0rOI4PCh9LgIOh2EzHdlAAmju1aQ==","signatures":[{"sig":"MEQCIHG8W3b6p6cjzEcQmqV2V0gI2mgmn7j10IamLazWhbGAAiAu3wrqFJZrLYcLHcdNTBNUCOQIFCL3b5qcl6YiMiI01g==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":17744,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJbVwHwCRA9TVsSAnZWagAAmpoQAJXmxlZ9mzIE84RVwPN5\n4s24UAsVS4EbZNhKHW6G6EKHY9e+rl5wP0iBSvE4RZGmp3G1tjItVfWM33te\npXdu81ZaSIk4FMGm/ugCyvcYQn1XicYFDYf2NCfoPZn86cscOHpcKxFu5MRL\noXiH8OD1YXTlNORVyvo9x/F4bNpz1FLpvKgTUzbEBXD5wA5N/u1pfHimQPUn\n+3lTCm8FjkUz/Gs/sWO6f5WZHjoPnK+P8i0iVdJmUWg8DvZoJB7qZbqA8JmN\neF/+Wm5VtraiDywUuBWt23+1pMGC3Xer9TFwFZ9ABBDcnLq3MkiFez7+KPsZ\n1Of2xZTbVUqMOx+VaTYHZ+N/g09Tu0I7WMEDIs6Sk/cD/Y8jE1pFTWUxTPIH\nsVXRlY31jW3Ay0Xs0zQz6Lg9GhZOnSYo7becZRjE6GXgXPPQP2kf7pl91RMT\nylRzrrZ2vKjcRWKBikEaB0Q2jDMGTMRZrrPzEQ8Pm+OEGXsuYRlE7VvDuJZr\nr8fRmvRPY9oruG5EP/xSSxHVUBg7D15LUUWMXywb9uK/eiCBAfmEDQrDFDov\n/Z+TjEY9iDS94C2dU0r+Uz7WCSm1wDwkQXZViZinVqsg4FA+tsnHjwozqKIU\n0LPt/uhdTKzdQFeGe/WLlvowdQtXiz4BY+AZS/0Y4KMzN9WNcVMetu4wzfJs\nd1tP\r\n=zn9g\r\n-----END PGP SIGNATURE-----\r\n"},"jest":{"verbose":true,"transform":{"^.+\\.jsx?$":"babel-jest"},"collectCoverage":true,"coverageReporters":["clover","html"],"coveragePathIgnorePatterns":["/node_modules/","/tests/"]},"main":"dist/index.js","gitHead":"8ace45e4498f82e86e5379a877abc27d146214d6","scripts":{"lint":"eslint ./src","test":"jest --forceExit","build":"webpack"},"_npmUser":{"name":"kyungmi","email":"purecolor85@gmail.com"},"repository":{"url":"git+https://github.com/ridi/cql-builder.git","type":"git"},"_npmVersion":"6.1.0","description":"Cassandra CQL Builder","directories":{"test":"tests"},"_nodeVersion":"10.0.0","_hasShrinkwrap":false,"devDependencies":{"jest":"^21.0.0","eslint":"^4.5.0","webpack":"^3.5.5","babel-jest":"^21.0.0","babel-loader":"^7.1.1","@ridi/eslint-config":"*","babel-plugin-transform-es2015-modules-commonjs":"^6.24.0"},"_npmOperationalInternal":{"tmp":"tmp/cql-builder_1.0.3_1532428784722_0.28251695904629703","host":"s3://npm-registry-packages"}},"1.0.4":{"name":"@ridi/cql-builder","version":"1.0.4","keywords":["CQL","query","builder","Cassandra"],"author":{"name":"Kyungmi Koong","email":"kyungmi.k@ridi.com"},"license":"MIT","_id":"@ridi/cql-builder@1.0.4","maintainers":[{"name":"davin.ahn","email":"davin.ahn@ridi.com"},{"name":"devgrapher","email":"devgrapher@ridi.com"},{"name":"earus","email":"hc.kim@ridi.com"},{"name":"freekering","email":"freekering@gmail.com"},{"name":"heejae","email":"j132134@gmail.com"},{"name":"jh.park","email":"jh.park@ridi.com"},{"name":"kt.kang","email":"kt.kang@ridi.com"},{"name":"kyungmi","email":"purecolor85@gmail.com"},{"name":"mskims","email":"its@mskim.me"},{"name":"namenu","email":"namenu@gmail.com"},{"name":"ridi.krazijames","email":"krazijames@ridi.com"},{"name":"ridicorp","email":"developer@ridi.com"}],"homepage":"https://github.com/ridi/cql-builder#readme","bugs":{"url":"https://github.com/ridi/cql-builder/issues"},"dist":{"shasum":"4eaf5245aee4d30a5be6063b45aec286f9b5906f","tarball":"https://registry.npmjs.org/@ridi/cql-builder/-/cql-builder-1.0.4.tgz","fileCount":9,"integrity":"sha512-WxRKq/cG8YZ6xw2ZvSJIoXySO2lsfCa0jOwMRT5us9tQkoLhhAdY98cUY6xdF3V+d7V0JWULC6rfmGRMugqlsQ==","signatures":[{"sig":"MEUCIE4WWVGY6le/itxRLRbXusdXToNAA7sDUTQ3Q6dDLGR9AiEAsvBE5z0KBvkreeHsjHtlT+ctERFwGtsB/76EVFsGQUY=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":18279,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJcGI8oCRA9TVsSAnZWagAAevAP/jwdQRHiqJ0J+16iWekD\nD58C5cqvCMrWrlfKnnLGltyW8fnnb0PON/sqdnnSFym9Yq/IjRvM8a6+ZA5N\nKPdoTDKec2Ijw+qAW5AmQdE6kOuCiunoUqkuLA77AngV+cRW9rhQT+fx9aKZ\nYoeX0yE8+xa2/Gx8Xghh2pY0EVWMH9W2+jPRMkJFxwlIC4BAYMtGxiwEjUuq\nwujk9vDqe8zF2LaWbw340nTFhcPk/cgZxQtwvQo/6eSA9Ufv9TZ/BmGfP3k1\nZfiDbTcd4TQUmRP351OZRSuOcfShOMNg79/vq6isca0FnBt8EfjwNbGN1Fw6\nga4UDW4h7pAQaFYhHJYOuZqnfQNmTf7O+iFVi/THnETL8l7X64m89Tpg8xj0\n60LJrms2MwsEGrmKykfK9EtyJNEiH04BrwUOhBnP09ch7/2JOinaYCBe69Cz\nApcIexoJgha+23FjoEecW9BmosmhtbgEmsD9DmjPCnDxb0HyC1cLH3t2Dxsg\nfnrfYAB0vlHZOAxJmIRVQlF5FCJ6R+bCMXU50Z2GNQIo4vl1vgkRACrhOpRC\nidIm/lexdDO8hy3rIQY93EPWpJe0hnHH6w8V5d/Budi4gU4zIh2O+EvGVvIn\nK4YJl5xvx8CeBFyfzjdm3vxSooU2eobXXD5Mczz9ENk82sMkj00hmxaL4mwt\ndtoz\r\n=jXs+\r\n-----END PGP SIGNATURE-----\r\n"},"jest":{"verbose":true,"transform":{"^.+\\.jsx?$":"babel-jest"},"collectCoverage":true,"coverageReporters":["clover","html"],"coveragePathIgnorePatterns":["/node_modules/","/tests/"]},"main":"dist/index.js","gitHead":"f3bb812bd2a271828efe9f1aaef9bfa2e7012db1","scripts":{"lint":"eslint ./src","test":"jest --forceExit","build":"webpack"},"_npmUser":{"name":"kyungmi","email":"purecolor85@gmail.com"},"repository":{"url":"git+https://github.com/ridi/cql-builder.git","type":"git"},"_npmVersion":"6.4.1","description":"Cassandra CQL Builder","directories":{"test":"tests"},"_nodeVersion":"10.11.0","_hasShrinkwrap":false,"devDependencies":{"jest":"^21.0.0","eslint":"^4.5.0","webpack":"^3.5.5","babel-jest":"^21.0.0","babel-loader":"^7.1.1","@ridi/eslint-config":"*","babel-plugin-transform-es2015-modules-commonjs":"^6.24.0"},"_npmOperationalInternal":{"tmp":"tmp/cql-builder_1.0.4_1545113383600_0.2255288544269689","host":"s3://npm-registry-packages"}}},"time":{"created":"2017-12-07T02:57:38.197Z","modified":"2026-07-01T06:20:37.114Z","1.0.2":"2017-12-07T02:57:38.197Z","1.0.3":"2018-07-24T10:39:44.797Z","1.0.4":"2018-12-18T06:09:43.774Z"},"bugs":{"url":"https://github.com/ridi/cql-builder/issues"},"author":{"name":"Kyungmi Koong","email":"kyungmi.k@ridi.com"},"license":"MIT","homepage":"https://github.com/ridi/cql-builder#readme","keywords":["CQL","query","builder","Cassandra"],"repository":{"url":"git+https://github.com/ridi/cql-builder.git","type":"git"},"description":"Cassandra CQL Builder","maintainers":[{"email":"davin.ahn@ridi.com","name":"davin.ahn"},{"email":"developer@ridi.com","name":"ridicorp"},{"email":"junhee.han@ridi.com","name":"ridi-junhee"},{"email":"nsa06031@gmail.com","name":"mando212"},{"email":"hw.choi@ridi.com","name":"hw.choi"},{"email":"ys.yoon@ridi.com","name":"ys.yoon"}],"readme":"# cql-builder\n\n[![npm](https://img.shields.io/npm/v/@ridi/cql-builder.svg)](https://www.npmjs.com/package/@ridi/cql-builder)\n[![Build Status](https://travis-ci.org/ridi/cql-builder.svg?branch=master)](https://travis-ci.org/ridi/cql-builder)\n[![Greenkeeper badge](https://badges.greenkeeper.io/ridi/cql-builder.svg)](https://greenkeeper.io/)\n\nSimple Cassandra CQL Builder in Javascript\n\n## Installation\n\n```\n$ npm install --save @ridi/cql-builder\n```\n\n## Usage\n\n```javascript\nimport { Insert, Select, Update, Delete, CqlBuilderError } from '@ridi/cql-builder';\n\nconst result = Select().table('test_table', 'test_keyspace').build();\n\n// Returns...\n// result.query = 'SELECT * FROM test_keyspace.test_table'\n// result.params = []\n```\n\n### Insert\n\nGenerate insert query\n\n```javascript\nconst cql = Insert()\n  .table('test_table', 'test_keyspace')\n  .value('column1', 1)\n  .option('TTL', 86400)\n  .option('TIMESTAMP', 12345678)\n  .build();\n\n// Returns...\n// cql.query = 'INSERT INTO test_keyspace.test_table (column1) VALUES (?) USING TTL ? AND TIMESTAMP ?'\n// cql.params = [1, 86400, 12345678]\n```\n\n#### Methods\n\n* InsertBuilder.table(table, keyspace)\n* InsertBuilder.value(field, value)\n* InsertBuilder.option(option, value)\n\n### Select\n\nGenerate select query\n\n```javascript\nconst cql = Select()\n    .table('test_table', 'test_keyspace')\n    .field(['column1', 'column2'])\n    .field('column3')\n    .where('key1 = ?', 1000)\n    .where('key2 > ?', 2000)\n    .limit(5000)\n    .order('key1 DESC')\n    .where('key3 IN (?, ?)', 3000, 4000)\n    .option('TTL', 86400)\n    .filtering()\n    .build();\n\n// Returns...\n// cql.query = 'SELECT column1, column2, column3 FROM test_keyspace.test_table WHERE key1 = ? AND key2 > ? AND key3 IN (?, ?) ORDER BY key1 DESC LIMIT ? ALLOW FILTERING'\n// cql.params = [1000, 2000, 3000, 4000, 5000]\n```\n\n#### Methods\n\n* SelectBuilder.table(table, keyspace)\n* SelectBuilder.field(field)\n* SelectBuilder.where(where, values)\n* SelectBuilder.order(order)\n* SelectBuilder.limit(limit)\n* SelectBuilder.filtering(filtering = true)\n\n### Update\n\nGenerate update query\n\n```javascript\nconst cql = Update()\n  .table('test_table')\n  .set('column1', 1)\n  .where('key1 = ?', 'a')\n  .option('TTL', 3000)\n  .upsert(true)\n  .build();\n\n// Returns...\n// cql.query = 'UPDATE test_table USING TTL ? SET column1 = ? WHERE key1 = ?'\n// cql.params = [3000, 1, 'a']\n```\n\n#### Methods\n\n* UpdateBuilder.table(table, keyspace)\n* UpdateBuilder.set(field, value)\n* UpdateBuilder.where(where, values)\n* UpdateBuilder.upsert(upsert)\n* UpdateBuilder.option(option, value)\n\n### Delete\n\nGenerate delete query\n\n```javascript\nconst cql = Delete()\n  .table('test_table')\n  .where('key1 = ?', 'a')\n  .field(['column1', 'column2'])\n  .option('TIMESTAMP', 12345678)\n  .build();\n\n// Returns...\n// cql.query = 'DELETE column1, column2 FROM test_table USING TIMESTAMP ? WHERE key1 = ?'\n// cql.params = [12345678, 'a']\n```\n#### Methods\n\n* DeleteBuilder.table(table, keyspace)\n* DeleteBuilder.field(field)\n* DeleteBuilder.where(where, values)\n* DeleteBuilder.option(option, value)\n\n## Development\n\n```\n$ git clone git@github.com:ridi/cql-builder.git\n$ cd cql-builder\n$ npm install\n```\n\n### Build\n\nWebpack build using Babel (Not required in development.) \n\n```\n$ npm run build\n```\n\n### Test\n\nTests using Jest\n\n```\n$ npm test\n```\n","readmeFilename":"README.md"}