{"_id":"node-sql-reader","_rev":"4-b2f826bc1581c3ba52ef4cf75c982cb9","name":"node-sql-reader","dist-tags":{"latest":"0.1.3"},"versions":{"0.1.0":{"name":"node-sql-reader","version":"0.1.0","description":"Library to parse pure sql file or sql string in to queries array","main":"dist/index.js","types":"dist/index.d.ts","scripts":{"prepublish":"npm run build","test":"test","build":"npm run clean && tsc","clean":"rimraf ./dist"},"repository":{"type":"git","url":"git+https://github.com/Halynsky/node-sql-reader.git"},"keywords":["sql","parser","reader"],"author":{"name":"Taras Halynskyi"},"license":"ISC","bugs":{"url":"https://github.com/Halynsky/node-sql-reader/issues"},"homepage":"https://github.com/Halynsky/node-sql-reader#readme","dependencies":{},"devDependencies":{"typescript":"4.1.2","@types/node":"12.12.6","rimraf":"3.0.2"},"gitHead":"4a067ae41a29ecaab90702dc8076aa4caad328ff","_id":"node-sql-reader@0.1.0","_nodeVersion":"12.16.1","_npmVersion":"6.14.8","dist":{"integrity":"sha512-sLLoa9HdIZlof3d3IqRU1tVO2cB67FAkPkV7FXK7yyrp4dgHbHysuntwRFTxv2huTkGnSr+feCntFvRWeL8Txw==","shasum":"df227979c0187762bcbe42a79b593989ea07c52f","tarball":"https://registry.npmjs.org/node-sql-reader/-/node-sql-reader-0.1.0.tgz","fileCount":11,"unpackedSize":11274,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJfuSiXCRA9TVsSAnZWagAAiPMP/irQwVSRndMK3T2bYHZk\nGE7mg4Wq4xPM2MHkNrpZS3i+TD/5glBPh36YNRiWKawrnR8bizgpWiFTXr7R\neMcDuFywiyQecjuF6Ueg0ONLlVoXkAvNds6cJ6qydCkNEydDs9PM+3DQgriv\nHhGYze5gDAdqdwdkFCujv5YZQoUJafQYcJhV3RUUWX0ymgJ+rC6DvAjEE98R\nqoEfRRbpnyFoEcDO1kZe8+Klq10ZnGedtb6zDuF6oXP2RTRxs1kWq0t/gmwZ\n4QmxkpK2O0T5ll+4fANMiGJiwXRsIAtc0P38oUzBIlELzjyaTupJ7c5jq4PT\nTtahBkrrpY20q9tcSi/DjTB/tN0WfDX2Yc8QsZLytGfkIR23Kqkda6NAGxhN\nsm8UoltN6m0HzNDv4TiYy2QpZRob/8a9Xh5lkvQ1Jb3uaSLDz0KbgvYKt8gf\n/d2S+jkhVUpIh0qrBsGibzUcb/H4lYb0+S/v6vvCPR+m2h+GxnMJQ6+Q6n88\n9YKslTVOI+RNRB3nRwmepGIk/0lDV5eCeK8V/0arYtyOa7atHIUhT4nnJLPW\nqsIk+UQb6hkEypUCcwGOCupSBKgPbh6aiN3jlKhtu6//sSFrCV0KGvqAhSLl\ngmkYXNW723g0+S2rSiet+DDp5+B7jTMq5bGpVB0nbT88e1ZmXnZ2PwQ7zCBE\neCqF\r\n=Y0DI\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCswFv+eAjqWSewI4q56EIu6mk/NTmCdQrKtflgDKJLpQIhAIY+/S7LVWoEeanZWSBwWZs52Fnr53hup7gIPyn657hO"}]},"_npmUser":{"name":"halynskyi","email":"off.bk90@gmail.com"},"directories":{},"maintainers":[{"name":"halynskyi","email":"off.bk90@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/node-sql-reader_0.1.0_1605970070875_0.6566514155274588"},"_hasShrinkwrap":false},"0.1.1":{"name":"node-sql-reader","version":"0.1.1","description":"Library to parse pure sql file or sql string in to queries array","main":"dist/index.js","types":"dist/index.d.ts","scripts":{"prepublish":"npm run build","test":"test","build":"npm run clean && tsc","clean":"rimraf ./dist"},"repository":{"type":"git","url":"git+https://github.com/Halynsky/node-sql-reader.git"},"keywords":["sql","file","parser","reader"],"author":{"name":"Taras Halynskyi"},"license":"ISC","bugs":{"url":"https://github.com/Halynsky/node-sql-reader/issues"},"homepage":"https://github.com/Halynsky/node-sql-reader#readme","dependencies":{},"devDependencies":{"typescript":"4.1.2","@types/node":"12.12.6","rimraf":"3.0.2"},"gitHead":"709e1d88831904a749ab228019b08264ece8c376","_id":"node-sql-reader@0.1.1","_nodeVersion":"12.16.1","_npmVersion":"6.14.8","dist":{"integrity":"sha512-Ml/YRtO+7nllYy3i8/uE0xnVnk4ygredpGzn9w05jXsOBxvo33v9up0XOD4c0m9RlUxBdCufZZ51wxs5oo45WQ==","shasum":"f7d123e9375f93d9c57210c243903d54d76b0f54","tarball":"https://registry.npmjs.org/node-sql-reader/-/node-sql-reader-0.1.1.tgz","fileCount":11,"unpackedSize":11204,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJfuSpLCRA9TVsSAnZWagAA9+wP/0HPGM+9R1IjT9MR6HRB\nern5yP2AwhvqWBa5WevwU4xflbyA7F/H2V5EB5N3DX2l8SSyb+Xu7Ey5hbDz\nO0tR0Tq+RA6LhnQcXOE02j3Pp6e35jrvsufOOtbyaaAziT0EcxCt1wt6Z81d\nPw+ycNjgads92pmpYf/GA4FYh2Pzq3AQKH673ItDyamTxS+z9Nc3A0RwLfTF\nqzWdkm3gM+8gVZ8yFuJa9XnKHdBJeHrUlkDBM1ZHLpNKmoi4xcKswv1nNkSP\nIXXwXeIFgPyqBH6QVjGcEmCeWN6f5iWlVQGfV4MLvUC+YO24kq107c8WGc3d\nswAuvjKhSrj7nyuBz+r2JGvYnHgA4oQa25RLErmomxjHrh7XGbVdfly8Kj6k\nD0q1EjlHZ//4KJWGd51lhFMnxsMO4beJOaz8AR9vMf8aWMFx/XaSZBFfbdOB\nMTbBxC7DxnPbPkk+XlUFtahfaQIhbwwnDQOTQbgDC07OmBH3Kx6l5c53X/BO\nTkUA8vKAntRWvDIQmdYp5sm+It8NnwDkya0JP2tK+xutbFW26dVfbmBkm7wh\nbm3sLml8KMLzxnqxTknVGBpyUzYX4HPl+UE13+ERdNQoFc3zr9lK82xKNURL\nEpKc9xM3haWKHCUa3vUspObg8ptj9B8s/bNYDU6/3pPXXdHuO4eruWHiN9M5\nhv2L\r\n=VMxi\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCWG5jrybfEKzWFCcT/DySm0cRucGdNKVu7vMDzqrMpNAIhAMWdIAQfHM3NVjqt0JvnlafWHu9oc7wHBzFjtINTt8xv"}]},"_npmUser":{"name":"halynskyi","email":"off.bk90@gmail.com"},"directories":{},"maintainers":[{"name":"halynskyi","email":"off.bk90@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/node-sql-reader_0.1.1_1605970507093_0.14621421334504414"},"_hasShrinkwrap":false},"0.1.2":{"name":"node-sql-reader","version":"0.1.2","description":"Library to parse pure sql file or sql string in to queries array","main":"dist/index.js","types":"dist/index.d.ts","scripts":{"prepublish":"npm run build","test":"echo \"Error: no test specified\" && exit 1","build":"npm run clean && tsc","clean":"rimraf ./dist"},"repository":{"type":"git","url":"git+https://github.com/Halynsky/node-sql-reader.git"},"keywords":["sql","file","parser","reader"],"author":{"name":"Taras Halynskyi"},"license":"ISC","bugs":{"url":"https://github.com/Halynsky/node-sql-reader/issues"},"homepage":"https://github.com/Halynsky/node-sql-reader#readme","dependencies":{},"devDependencies":{"typescript":"4.1.2","@types/node":"12.12.6","rimraf":"3.0.2"},"gitHead":"3df7559348c96e4c044cd7a8fe608aa20c3c5d97","_id":"node-sql-reader@0.1.2","_nodeVersion":"12.16.1","_npmVersion":"6.14.8","dist":{"integrity":"sha512-oIZl5aU6lhvLXpvvffKcu4BNTs0XAedznGfSHUMCbNjgRLPkzUJcTJL/vpOIGz+GvzHlkzhTotGE1igIpUlx5g==","shasum":"8f2a3984f4d385ed17c937a6152663da2f67f954","tarball":"https://registry.npmjs.org/node-sql-reader/-/node-sql-reader-0.1.2.tgz","fileCount":11,"unpackedSize":11186,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJfuiryCRA9TVsSAnZWagAA3jsP/0qCPa8htTSrjd3s3Xln\n0DZtYtU0zdxG5TLZXWxErIcnINotBMVtoCTstLu0w27L/O7FZ9kKcGQa1YHZ\nPJJkf86p864Bm6dIOGlRaPpZVyoSoPbEny+HKJ1yFK/2I1vU575MSA1DaAZH\n01s02stnSE19KF+UOLGNXWAivlVIcP3llOA/0i+vei1UdoIqEZVbtKBzU33N\nBW6zx8ssS9DzGfGFK34+LA5rKZQCxiw+Ye44NrBzZUE2dLTdkf6fVvd6Yd7T\n4pvCzETCb6YXiIogRu89xvzwTtRMR1ZMuxKVCf7JHlagnC0olbY0UFqabK/u\nD2SHbAnI6wIjmaBeU3uPhZXBFo0+oIByZJs27ADXytsOonhJ7aYgFpA9CVYc\nHgLmV5mUutQGZ5JVd48NN48R52kE9wLudvKp7cReiTAdOwmr3QMYqp4KNrfN\nkHoCYRg0O1VZTw0wXV7Ch+7/qsAb5xs2FSRKnOgYC3wio5Igx8cAxoz0FBui\nXNO9CPRdhxwzipc0UHFd16/wjg8NpegeZ2D7zkU/U55B98/ZVjWhRVE64RPd\n2QfiFlbEVa6hR4pXwD0k1Evbtxes60oXeSjJyrl7ujasXk0meVbY0Sx1AUAc\nJNyd7kTDUSIssG22xGoFR4IdC712uann5YZrVHsjTiFlcKTXDOAnIjZTe217\nftsi\r\n=tY9o\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQD7K7rOD7IZUV1up3ON0CJUkbiCRJ8sz4ayxwwOkqfriAIhANmA9s1uzjOHI45BufSv+etQvMrRxruvbMfh6HZtla/I"}]},"_npmUser":{"name":"halynskyi","email":"off.bk90@gmail.com"},"directories":{},"maintainers":[{"name":"halynskyi","email":"off.bk90@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/node-sql-reader_0.1.2_1606036209537_0.400881311600771"},"_hasShrinkwrap":false},"0.1.3":{"name":"node-sql-reader","version":"0.1.3","description":"Library to parse pure sql file or sql string in to queries array","main":"dist/index.js","types":"dist/index.d.ts","scripts":{"prepublishOnly":"npm run test && npm run build","test":"ts-mocha test test/**/*.spec.ts","build":"npm run clean && tsc","clean":"rimraf ./dist"},"repository":{"type":"git","url":"git+https://github.com/Halynsky/node-sql-reader.git"},"keywords":["sql","file","parser","reader"],"author":{"name":"Taras Halynskyi"},"license":"ISC","bugs":{"url":"https://github.com/Halynsky/node-sql-reader/issues"},"homepage":"https://github.com/Halynsky/node-sql-reader#readme","dependencies":{},"devDependencies":{"@types/node":"12.12.6","@types/mocha":"8.0.4","@types/chai":"4.2.14","@types/expect":"24.3.0","typescript":"4.1.2","rimraf":"3.0.2","mocha":"8.2.1","ts-mocha":"8.0.0","chai":"4.2.0","chai-like":"1.1.1"},"gitHead":"106c3fe69e39d241aa530d17c91f69eb8169ac1a","_id":"node-sql-reader@0.1.3","_nodeVersion":"12.16.1","_npmVersion":"6.14.8","dist":{"integrity":"sha512-fV5kHBoi4fKrEYyCpOmKhHU0OFCGBeM7ovQAsKQCl+ftZRbgQIDkdcdanz07wIqBnv2Ypbf5Z+lzrqpSBWA/3w==","shasum":"59cbbb7275e933b1290d09da3c6fba75f89d6f6d","tarball":"https://registry.npmjs.org/node-sql-reader/-/node-sql-reader-0.1.3.tgz","fileCount":18,"unpackedSize":17217,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJf1kPyCRA9TVsSAnZWagAABmMQAJ7t1Ze1TBXq47yXHeZq\n4XUg1HlVC74gMG1F63p7edvq4i0x3bwXnT7ujgMd8Wjk+27o28RFmEFi2323\n4sY73fPthHOPN1wWE6aZdKJh85BTeHCf1RtLPrQYFO4gOy9wrn0ThVGw4+HU\nFZ1qojMfUdNMvF2FLGRYWPc7HA+xTgifudJt0QOEH9JgfxymOpCu9dwznjvX\nedc8ezwKJMj8TH5SBhc44NqKTgpWNj9T5jQAQ7zdIk80jAphSRYfGkiKCtUu\nzQSW+DDSdodEnm4/21ss7ZFVf+S1sfmc3ymmLtZxHBuOwFVWva0Ij5dg0/PR\nA81ZbAI3fHtSyBu0OprfaZ0iZ3oCu6aZGyvIvSQbZ52JdhU8MxCJYgWko/Py\ncssw835XUDtkXwy97oZrvG0uUwvCsmgL+Qx/8aXX1KwDesUfizEXmqv8BXSp\ny86AJDYbPPQ8V+auBsUT2VzPnAOG58gfMT7uvKxqssux1+SjzJLDG6zMsDlt\njn3+hv/SKXV2LzEkMHJqeLjPQdWTJYXIPyH+PTO/t5Dm9eemKeXLNvt7/xRD\nHh3yr1ED8JvHRWNitTCh7LeljZmgsUxVbYm2cG4Ku/y6GQoPBQibbeeJiE+e\nwdew/KglOsIkvOeeKkt354PUlfEKUpJsouRPD8uRvsOHNgDHolXgkb5qEdYg\nE/ZU\r\n=dAS1\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIHMf6r6kICOdi3o1cXNfUS4iel4N4SKLAQ6DW5gmMGEcAiBTXI/CpDZ8mwiAcJ82ROsF8n5NvEMuquaMKEBUXXwQWw=="}]},"_npmUser":{"name":"halynskyi","email":"off.bk90@gmail.com"},"directories":{},"maintainers":[{"name":"halynskyi","email":"off.bk90@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/node-sql-reader_0.1.3_1607877618084_0.8999925356181309"},"_hasShrinkwrap":false}},"time":{"created":"2020-11-21T14:47:50.874Z","0.1.0":"2020-11-21T14:47:51.027Z","modified":"2022-05-11T05:09:18.160Z","0.1.1":"2020-11-21T14:55:07.295Z","0.1.2":"2020-11-22T09:10:09.705Z","0.1.3":"2020-12-13T16:40:18.242Z"},"maintainers":[{"name":"halynskyi","email":"off.bk90@gmail.com"}],"description":"Library to parse pure sql file or sql string in to queries array","homepage":"https://github.com/Halynsky/node-sql-reader#readme","keywords":["sql","file","parser","reader"],"repository":{"type":"git","url":"git+https://github.com/Halynsky/node-sql-reader.git"},"author":{"name":"Taras Halynskyi"},"bugs":{"url":"https://github.com/Halynsky/node-sql-reader/issues"},"license":"ISC","readme":"# node-sql-reader\r\nThis library can parse pure sql file or sql string in to queries array.  \r\nThe main use case that made me to create this library was inability of [TypeOrm](https://typeorm.io) to run sql file.\r\nI needed to run sql file with test data each time when I restart a server to get same starting test data.  \r\n\r\n## Install\r\n```\r\nnpm install node-sql-reader\r\n```\r\n\r\n## Usage\r\n\r\n### test_data.sql\r\n```sql\r\nINSERT INTO users (email, password, name) VALUES ('dummy1@somemail.com', 'hashed_password1', 'dummy1');\r\nINSERT INTO users (email, password, name) VALUES ('dummy2@somemail.com', 'hashed_password2', 'dummy2');\r\nINSERT INTO users (email, password, name) VALUES ('dummy3@somemail.com', 'hashed_password3', 'dummy3');\r\n```\r\n\r\n### TestDataInitializer.ts\r\n```ts\r\nimport { SqlReader } from 'node-sql-reader'\r\nimport * as path from 'path';\r\n\r\nexport class TestDataInitializer {\r\n    initTestData() {\r\n        let queries = SqlReader.readSqlFile(path.join(__dirname, \"../database/test_data.sql\"))\r\n        for (let query of queries) {\r\n            // replace it with your query runner\r\n            SomeQuerryRunner.runQuerry(query)\r\n        }\r\n    }\r\n}\r\n\r\n/*\r\nqueries array:\r\n[\r\n   \"INSERT INTO users (email, password, name) VALUES ('dummy1@somemail.com', 'hashed_password1', 'dummy1')\",\r\n   \"INSERT INTO users (email, password, name) VALUES ('dummy2@somemail.com', 'hashed_password2', 'dummy2')\",\r\n   \"INSERT INTO users (email, password, name) VALUES ('dummy3@somemail.com', 'hashed_password3', 'dummy3')\",\r\n]\r\n*/\r\n```\r\n\r\n## API\r\n* `parseSqlString(sqlString: string): string[]`  \r\nParse all queries from sql string. Returns array of queries.\r\n* `readSqlFile(filePath: string): string[]`  \r\nReads all queries from file. Returns array of queries.\r\n* `runSqlFile(filepath: string, runnerFn: (query: string) => void)`  \r\nParse all queries from sql file and runs runnerFn for each of them.\r\n* `runSqlFileAsync(filepath: string, runnerFn: (query: string) => Promise<any>): Promise<any>`  \r\nParse all queries from sql file and runs runnerFn for each of them. Has an async version.\r\n\r\n## Features requests / bugs\r\nFeature requests and bugs on [github](https://github.com/Halynsky/node-sql-reader)\r\n","readmeFilename":"README.md"}