{"_id":"sql-summary","_rev":"13-71152622a691e1dd30bc5f0228aab272","name":"sql-summary","description":"Summarize any SQL query","dist-tags":{"latest":"1.0.1"},"versions":{"1.0.0":{"name":"sql-summary","version":"1.0.0","keywords":["sql","summary","query","log","logging","analyze"],"author":{"url":"https://twitter.com/wa7son","name":"Thomas Watson Steen","email":"w@tson.dk"},"license":"MIT","_id":"sql-summary@1.0.0","maintainers":[{"name":"watson","email":"w@tson.dk"}],"homepage":"https://github.com/watson/sql-summary","bugs":{"url":"https://github.com/watson/sql-summary/issues"},"dist":{"shasum":"39e3a51d8d85e46739836fc7d67d0654b173a39f","tarball":"https://registry.npmjs.org/sql-summary/-/sql-summary-1.0.0.tgz","integrity":"sha512-xyDDVHLKPouQIReiaOh18MUTtO/Umq0E27px7xZFcEi+cHfwQgoU2/yA2jim0BpU866gYh345aOzbc9Xn3jPDg==","signatures":[{"sig":"MEUCIQC8F5zKPGYsDzBVlHW4f/zYa8j0V8FfUfpkj0TGZ7taTwIgHcYThhLhlYOx+S7QbQSMUdU+aT8IwPEz7NxJ3pQpg9M=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"index.js","_from":".","_shasum":"39e3a51d8d85e46739836fc7d67d0654b173a39f","gitHead":"35e3b3d8e69faf8de5d85f100965bfd0ce45df01","scripts":{"test":"standard && node test.js"},"_npmUser":{"name":"watson","email":"w@tson.dk"},"repository":{"url":"https://github.com/watson/sql-summary.git","type":"git"},"_npmVersion":"1.4.28","coordinates":[55.6877023,12.5956371],"description":"Summarize any SQL query","directories":{},"dependencies":{},"devDependencies":{"standard":"^5.3.1"}},"1.0.1":{"name":"sql-summary","version":"1.0.1","keywords":["sql","summary","query","log","logging","analyze"],"author":{"url":"https://twitter.com/wa7son","name":"Thomas Watson Steen","email":"w@tson.dk"},"license":"MIT","_id":"sql-summary@1.0.1","maintainers":[{"name":"qard","email":"admin@stephenbelanger.com"},{"name":"watson","email":"w@tson.dk"}],"homepage":"https://github.com/elastic/sql-summary","bugs":{"url":"https://github.com/elastic/sql-summary/issues"},"dist":{"shasum":"a2dddb5435bae294eb11424a7330dc5bafe09c2b","tarball":"https://registry.npmjs.org/sql-summary/-/sql-summary-1.0.1.tgz","fileCount":6,"integrity":"sha512-IpCr2tpnNkP3Jera4ncexsZUp0enJBLr+pHCyTweMUBrbJsTgQeLWx1FXLhoBj/MvcnUQpkgOn2EY8FKOkUzww==","signatures":[{"sig":"MEYCIQCyJTz7lqTRJdTsg/rSbO0Z1K5qI1UP1Bgr4VAu1Z7fTgIhAKBjztSdJ8hBUlJXGjR3CixgmWqR4pl+2Kkcf2ybcnck","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":6876,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJbWD6ZCRA9TVsSAnZWagAA+VwP/ApFpYBTzYS3XnLX6DCI\nRbfLH052AQzRhtfjyXTUq6fx8BibhkIiTiNDH8/nwyv26zBcRDLVNFDGoex4\nPQaRqudzEXuBVguxhSkQhEvQmsOMeZkb2Rrrk+gIxh+D+FSXqyPxYBOgcCDt\nj6y8xTqnkL60b4OKEFLrozpw3rcaCnrqGrE6dkuwr1ABsbCaVZ8xyVTDlSYs\ns5T6KrHY5WjSSaQPQAJMQchNCC1SU7pc4sr/gZOQ+bcgDZ2UuGQuC2X4PjiV\nSaavYmcEXaiLQp+Kz1NnWgCn0gTWJKDaIVu0YqIRNWdGQJxy2rZaueks+h3A\n3uNTJtWSWSsaAORTWpoMXjjGhqr8GWu6j7e2Y5TXlgnnRKz5rbNZjS0rlZIt\n4v3RAcYXQhApWNwo4mELB+ytvwcvPS0WehZBlPFqzLcoLHSl62ldc0ko/yiM\n3pMlYNNUFm36OV2Uyb4UElVofYcJb/faPAVIByNtf7oi9bkxntE2a7/Hwp4u\nTsESif52D5R+qEtVFKiPmKapAqaOmR0LvpK7QcNZ9BMjucCjIW/GQxAg7TFf\nwESwAC9g8a7SbVxVwZGetfq0yRms6IOjksfCMmFELc+3N6SmaUeXTUX0At3+\nxx/oxyRUt36t3QOYYYEXI/d/X+RZq+S4e3LXKA4Mi46SguARsmnDHMwk5Pr/\n2LFI\r\n=8u+o\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","gitHead":"d218deaa658a046b332007fccb881a2169c35ec0","scripts":{"test":"standard && node test.js"},"_npmUser":{"name":"watson","email":"w@tson.dk"},"repository":{"url":"git+https://github.com/elastic/sql-summary.git","type":"git"},"_npmVersion":"6.2.0","coordinates":[55.778263,12.592376],"description":"Summarize any SQL query","directories":{},"_nodeVersion":"10.6.0","dependencies":{},"_hasShrinkwrap":false,"devDependencies":{"standard":"^11.0.1"},"_npmOperationalInternal":{"tmp":"tmp/sql-summary_1.0.1_1532509848489_0.7972313901134778","host":"s3://npm-registry-packages"}}},"time":{"created":"2015-10-16T20:29:03.422Z","modified":"2024-06-24T15:08:29.816Z","1.0.0":"2015-10-16T20:29:03.422Z","1.0.1":"2018-07-25T09:10:49.356Z"},"maintainers":[{"email":"trentm@gmail.com","name":"trentm"}],"author":{"url":"https://twitter.com/wa7son","name":"Thomas Watson Steen","email":"w@tson.dk"},"repository":{"url":"git+https://github.com/elastic/sql-summary.git","type":"git"},"keywords":["sql","summary","query","log","logging","analyze"],"license":"MIT","homepage":"https://github.com/elastic/sql-summary","bugs":{"url":"https://github.com/elastic/sql-summary/issues"},"readme":"# sql-summary\n\nSummarize any SQL query.\n\nThis JavaScript module will analyse an SQL query and return a very brief\nsummary string containing:\n\n- Main verb used (`SELECT`, `INSERT`, `UPDATE` etc.)\n- Potentially the type operated on (`TABLE`, `DATABASE` etc.)\n- The name of the primary table or database operated on\n\nFor example, if given the following SQL query:\n\n```sql\nSELECT col1, col2 FROM table_name WHERE id=1\n```\n\nThe following summary string is produced:\n\n```sql\nSELECT FROM table_name\n```\n\n[![npm](https://img.shields.io/npm/v/sql-summary.svg)](https://www.npmjs.com/package/sql-summary)\n[![Build status](https://travis-ci.org/elastic/sql-summary.svg?branch=master)](https://travis-ci.org/elastic/sql-summary)\n[![js-standard-style](https://img.shields.io/badge/code%20style-standard-brightgreen.svg?style=flat)](https://github.com/feross/standard)\n\n## Installation\n\n```\nnpm install sql-summary\n```\n\n## Usage\n\n```js\nvar sqlSummary = require('sql-summary')\n\nvar query = 'UPDATE table_name SET col1=1, col2=2 WHERE id=1'\n\nconsole.log('Running query:', sqlSummary(query)) // => 'Running query: UPDATE table_name'\ndb.query(query, function (err, result) {\n  // ...\n})\n```\n\n## Use-cases\n\n- In a web-server log output the type of queries used without going into\n  too much details about each query\n- Group similar queries operating on the same tables\n\n## License\n\n[MIT](https://github.com/elastic/sql-summary/blob/master/LICENSE)\n","readmeFilename":"README.md","users":{"flumpus-dev":true}}