{"_id":"@derherrgammler/sqlimporter","_rev":"8-a1d9eff851322ee1bceb7791a2857f87","name":"@derherrgammler/sqlimporter","description":"A npm Module to execute .sql files with Nodejs.","dist-tags":{"latest":"0.1.3"},"versions":{"0.0.1":{"name":"@derherrgammler/sqlimporter","version":"0.0.1","description":"A npm Module to execute .sql files with Nodejs.","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"author":{"name":"DerHerrGammler"},"license":"MIT","dependencies":{"bluebird":"^3.5.1","mysql":"^2.15.0","path":"^0.12.7"},"devDependencies":{},"repository":{"type":"git","url":"git+https://github.com/DerHerrGammler/sqlimporter.git"},"bugs":{"url":"https://github.com/DerHerrGammler/sqlimporter/issues"},"homepage":"https://github.com/DerHerrGammler/sqlimporter#readme","gitHead":"f2379d8c003f1e22e6b7333e60da2362ef20fdc9","_id":"@derherrgammler/sqlimporter@0.0.1","_npmVersion":"5.5.1","_nodeVersion":"9.3.0","_npmUser":{"name":"derherrgammler","email":"herold_felix@web.de"},"dist":{"integrity":"sha512-yw/NQlW0G2l07aIKkiq5kIjyyED5FQBIOv1brjORS1lFyjlA1PCZTF+X94zBbNHz7TkQQLb9OligacassreLvQ==","shasum":"882eb7fe199dde959d3e03922d1f4321fb715812","tarball":"https://registry.npmjs.org/@derherrgammler/sqlimporter/-/sqlimporter-0.0.1.tgz","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIEMUicD6G2CM7bOI/lPNo+Pfj46UcSvDJHmS/l7fDVJxAiEA5QSqlcKQ0effaXQpU8nH7zABnNPyxbFOfdY/sTr9vDI="}]},"maintainers":[{"name":"derherrgammler","email":"herold_felix@web.de"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/sqlimporter-0.0.1.tgz_1517836153671_0.355055287014693"},"directories":{}},"0.0.2":{"name":"@derherrgammler/sqlimporter","version":"0.0.2","description":"A npm Module to execute .sql files with Nodejs.","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"author":{"name":"DerHerrGammler"},"license":"MIT","dependencies":{"bluebird":"^3.5.1","mysql":"^2.15.0","path":"^0.12.7"},"devDependencies":{},"repository":{"type":"git","url":"git+https://github.com/DerHerrGammler/sqlimporter.git"},"bugs":{"url":"https://github.com/DerHerrGammler/sqlimporter/issues"},"homepage":"https://github.com/DerHerrGammler/sqlimporter#readme","gitHead":"969a9a5ed2a93ede51a0fa2cd2ad41eef92cff1a","_id":"@derherrgammler/sqlimporter@0.0.2","_npmVersion":"5.5.1","_nodeVersion":"9.3.0","_npmUser":{"name":"derherrgammler","email":"herold_felix@web.de"},"dist":{"integrity":"sha512-Gy6zCbYU40J5nd1JLpXpAx14AU09jXRFx9LN+2TAJ/VLX4zWUqfKJRJTKof6KKFQ6jv3lRaf8u+RNtfCUqSfSA==","shasum":"223571b112cfdf0645bdb2e0363fc449f2ca6286","tarball":"https://registry.npmjs.org/@derherrgammler/sqlimporter/-/sqlimporter-0.0.2.tgz","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIBh1xZ6Pym+1m5XOhbPEgc8JH0zwoOA3xAEPKBvQCpj4AiAhKuM0LTKC00Jt/vHL3nGpbb3Ha3hWhdCrBUxsfooybg=="}]},"maintainers":[{"name":"derherrgammler","email":"herold_felix@web.de"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/sqlimporter-0.0.2.tgz_1517836358401_0.460115265334025"},"directories":{}},"0.0.3":{"name":"@derherrgammler/sqlimporter","version":"0.0.3","description":"A npm Module to execute .sql files with Nodejs.","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"author":{"name":"DerHerrGammler"},"license":"MIT","dependencies":{"bluebird":"^3.5.1","mysql":"^2.15.0","path":"^0.12.7"},"devDependencies":{},"repository":{"type":"git","url":"git+https://github.com/DerHerrGammler/sqlimporter.git"},"bugs":{"url":"https://github.com/DerHerrGammler/sqlimporter/issues"},"homepage":"https://github.com/DerHerrGammler/sqlimporter#readme","gitHead":"8dae8e6ae6b4c445de62d86cec00a31211b87d00","_id":"@derherrgammler/sqlimporter@0.0.3","_npmVersion":"5.5.1","_nodeVersion":"9.3.0","_npmUser":{"name":"derherrgammler","email":"herold_felix@web.de"},"dist":{"integrity":"sha512-5QwDMQmCv9NlKaLFwHFR24u4xlfRIAF7zAmRQS01q7hNGG+5ugkUfAR9iB5Z+ZMVs96GuDgVR7EiBPF/KNwT8w==","shasum":"8d6c5c0743788554cde5df7d7a37b1f7563ecd04","tarball":"https://registry.npmjs.org/@derherrgammler/sqlimporter/-/sqlimporter-0.0.3.tgz","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQClwhTtuSkXRVgFY+pg0hovPsMHgw60mUJs8Q36k8oUXQIhAOg9AwqGo2O5ONz35UJUmWgReB615XXmEYlaboeT7B1M"}]},"maintainers":[{"name":"derherrgammler","email":"herold_felix@web.de"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/sqlimporter-0.0.3.tgz_1517837499637_0.802553319837898"},"directories":{}},"0.0.4":{"name":"@derherrgammler/sqlimporter","version":"0.0.4","description":"A npm Module to execute .sql files with Nodejs.","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"author":{"name":"DerHerrGammler"},"license":"MIT","dependencies":{"bluebird":"^3.5.1","mysql":"^2.15.0","path":"^0.12.7"},"devDependencies":{},"repository":{"type":"git","url":"git+https://github.com/DerHerrGammler/sqlimporter.git"},"bugs":{"url":"https://github.com/DerHerrGammler/sqlimporter/issues"},"homepage":"https://github.com/DerHerrGammler/sqlimporter#readme","gitHead":"1275aa742c577cd7c4e5c09d6a10bb79e4a80666","_id":"@derherrgammler/sqlimporter@0.0.4","_npmVersion":"5.5.1","_nodeVersion":"9.3.0","_npmUser":{"name":"derherrgammler","email":"herold_felix@web.de"},"dist":{"integrity":"sha512-BdhBuIvyD3Nv0JUSMbBtrzPUodHxbhb3pAB7RANK3iE35aSWYj54RHgAlHG53l8cRAz9+VQQmNd7QcUFhJXXGQ==","shasum":"7cf8906630fe5b3b8e2b3df39ecb2f2695c18a2d","tarball":"https://registry.npmjs.org/@derherrgammler/sqlimporter/-/sqlimporter-0.0.4.tgz","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIACysd/IK8AdvZ3uEDlT/652RxPrY154n4Gp56yIQmj9AiEAyrZZ6VHlxacXF3b6ncZ45hoQWkoxhUZROtlvnipmwoc="}]},"maintainers":[{"name":"derherrgammler","email":"herold_felix@web.de"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/sqlimporter-0.0.4.tgz_1517838660353_0.23684561485424638"},"directories":{}},"0.0.5":{"name":"@derherrgammler/sqlimporter","version":"0.0.5","description":"A npm Module to execute .sql files with Nodejs.","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["mysql","nodejs","import","sqlfile","execute","file"],"author":{"name":"DerHerrGammler"},"license":"MIT","dependencies":{"bluebird":"^3.5.1","mysql":"^2.15.0","path":"^0.12.7"},"devDependencies":{},"repository":{"type":"git","url":"git://github.com/DerHerrGammler/sqlimporter.git"},"bugs":{"url":"https://github.com/DerHerrGammler/sqlimporter/issues"},"homepage":"https://github.com/DerHerrGammler/sqlimporter#readme","gitHead":"91ea8f811f27bdcc767a0fc7f6a41a824f0976a4","_id":"@derherrgammler/sqlimporter@0.0.5","_npmVersion":"5.5.1","_nodeVersion":"9.3.0","_npmUser":{"name":"derherrgammler","email":"herold_felix@web.de"},"dist":{"integrity":"sha512-WWW0k8cm32kO8YmMnnh9G6VG4zvlESJhhwrs1b0tTaGeVfjKodOQlBiSzVihcVszJGyvsmnJoMDgLqxuX9iB1w==","shasum":"aa56eccde31261d1398fa2bb2e285fee0e800c1b","tarball":"https://registry.npmjs.org/@derherrgammler/sqlimporter/-/sqlimporter-0.0.5.tgz","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIFKsDaRVIxIi5mZTWNqBShk34h3Fz/dv1cZjiNTGlwT2AiA530l6eZsMroYJsde1MNQrAICLmq0Jl6fV1m6AAclPAg=="}]},"maintainers":[{"name":"derherrgammler","email":"herold_felix@web.de"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/sqlimporter-0.0.5.tgz_1517905330993_0.07769125560298562"},"directories":{}},"0.1.0":{"name":"@derherrgammler/sqlimporter","version":"0.1.0","description":"A npm Module to execute .sql files with Nodejs.","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["mysql","nodejs","import","sqlfile","execute","file"],"author":{"name":"DerHerrGammler"},"license":"MIT","dependencies":{"bluebird":"^3.5.1","mysql":"^2.15.0","path":"^0.12.7"},"devDependencies":{},"repository":{"type":"git","url":"git://github.com/DerHerrGammler/sqlimporter.git"},"bugs":{"url":"https://github.com/DerHerrGammler/sqlimporter/issues"},"homepage":"https://github.com/DerHerrGammler/sqlimporter#readme","gitHead":"9aea4e16e7cb0c0ffea52fa7b57869d84fa141eb","_id":"@derherrgammler/sqlimporter@0.1.0","_npmVersion":"5.5.1","_nodeVersion":"9.3.0","_npmUser":{"name":"derherrgammler","email":"herold_felix@web.de"},"dist":{"integrity":"sha512-esqoc+niwra4UTiS6p2HNnd1e5eo7o6mHEphpGsYLHSjgizafxvnEp2iz91c5bSULh7nwc38s7pAeUfDsouZ2Q==","shasum":"19cd94423536e7ed2bdaf3ed47a94d2cb222d560","tarball":"https://registry.npmjs.org/@derherrgammler/sqlimporter/-/sqlimporter-0.1.0.tgz","fileCount":6,"unpackedSize":6097,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCeNdmGQLXoEYJ+4DRyN2dkhsPEnjMngnDvLZsl4AY36QIgR6/UZ6U8ZkKjoJhJuc9ZKrBwvq66wCrPSb7d+MdC/go="}]},"maintainers":[{"name":"derherrgammler","email":"herold_felix@web.de"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/sqlimporter_0.1.0_1518099954618_0.7673805348353386"},"_hasShrinkwrap":false},"0.1.3":{"name":"@derherrgammler/sqlimporter","version":"0.1.3","description":"A npm Module to execute .sql files with Nodejs.","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["mysql","nodejs","import","sqlfile","execute","file"],"author":{"name":"DerHerrGammler"},"license":"MIT","dependencies":{"bluebird":"^3.5.1","mysql":"^2.15.0","path":"^0.12.7"},"devDependencies":{},"repository":{"type":"git","url":"git://github.com/DerHerrGammler/sqlimporter.git"},"bugs":{"url":"https://github.com/DerHerrGammler/sqlimporter/issues"},"homepage":"https://github.com/DerHerrGammler/sqlimporter#readme","gitHead":"fc7a5320838f12633f174913dce7ffeb4e72f7b9","_id":"@derherrgammler/sqlimporter@0.1.3","_npmVersion":"5.5.1","_nodeVersion":"9.3.0","_npmUser":{"name":"derherrgammler","email":"herold_felix@web.de"},"dist":{"integrity":"sha512-ZQZDAiERl13pIc8soBsz26xqhmQUqNRAkQgzUwD8CJXK4uaoFJijZc2OJCOl5pwVhJtwLX34tAlnINp/zO0xBQ==","shasum":"211d488d47379409fa77f15abd07665a2ec36126","tarball":"https://registry.npmjs.org/@derherrgammler/sqlimporter/-/sqlimporter-0.1.3.tgz","fileCount":6,"unpackedSize":6342,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIAMsJHgax1eUS/O1VIxdq2j9RQg41N9Qg9vNUwYbAvwcAiAnbORXl5cZB1JOqmPmH93hrr9iRZb8VJnYxWPwjn0rXw=="}]},"maintainers":[{"name":"derherrgammler","email":"herold_felix@web.de"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/sqlimporter_0.1.3_1518185996163_0.5807843225077023"},"_hasShrinkwrap":false}},"readme":"# SQLImporter for Nodejs\r\n\r\nAn npm Modul. Node.js<br/>\r\nImport your *.sql files with multiple sql-statements to your MySQL database.\r\n\r\n### Installation to Node dependency\r\n\r\n1. Make shure that you have `sqlimporter` installed locally:\r\n```sh\r\nnpm i @derherrgammler/sqlimporter\r\n```\r\n\r\n2. Create *.sql file like my example.sql:\r\n```sql\r\n    /* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ *\\\r\n                        Database Recreation\r\n    \\* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ */\r\n\r\nDROP DATABASE IF EXISTS example;\r\nCREATE DATABASE example;\r\nUSE example;\r\n\r\n    /* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ *\\\r\n                        Tabblecreation\r\n    \\* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ */\r\n\r\nCREATE TABLE testtable (\r\n    `row1` CHAR(9) NOT NULL PRIMARY KEY,\r\n    `row2` VARCHAR(255) NOT NULL,\r\n    `row3` INT(11) NOT NULL\r\n);\r\n```\r\nYou have to undertstand that there can be Comments but ONLY multiline comments work aktually. I try to change this that also single line comments cna be used in the file.<br>\r\nIf you want a new Version with deleting also singleline comments please write a issue in GitHub!\r\n\r\n3. Require and usage:\r\n```js\r\nvar sqlimport = require(\"@derherrgammler/sqlimporter\");\r\nvar connConfig = {\r\n\thost\t    : 'localhost',\r\n\tuser\t    : 'root',\r\n\tpassword    : 'root'\r\n};\r\n\r\nsqlimport.config(connConfig);\r\n    .importFile(\"/example.sql\");\r\n```\r\n\r\n## Authors\r\n\r\n* **Felix Herold** - [DerHerrGammler](https://github.com/DerHerrGammler)\r\n\r\n## License\r\n\r\nThis project is licensed under the MIT License - see the [LICENSE](LICENSE) file for details\r\n","maintainers":[{"name":"derherrgammler","email":"herold_felix@web.de"}],"time":{"modified":"2022-04-05T03:48:35.549Z","created":"2018-02-05T13:09:14.539Z","0.0.1":"2018-02-05T13:09:14.539Z","0.0.2":"2018-02-05T13:12:39.359Z","0.0.3":"2018-02-05T13:31:40.554Z","0.0.4":"2018-02-05T13:51:01.205Z","0.0.5":"2018-02-06T08:22:11.899Z","0.1.0":"2018-02-08T14:25:55.314Z","0.1.3":"2018-02-09T14:19:56.775Z"},"homepage":"https://github.com/DerHerrGammler/sqlimporter#readme","repository":{"type":"git","url":"git://github.com/DerHerrGammler/sqlimporter.git"},"author":{"name":"DerHerrGammler"},"bugs":{"url":"https://github.com/DerHerrGammler/sqlimporter/issues"},"license":"MIT","readmeFilename":"README.md","keywords":["mysql","nodejs","import","sqlfile","execute","file"]}