{"_id":"mocha-sql","_rev":"35-d35361f21ec8aab529ef094ca679790d","name":"mocha-sql","description":"mocha-sql\r =========","dist-tags":{"latest":"0.0.6"},"versions":{"0.0.0":{"name":"mocha-sql","version":"0.0.0","description":"mocha-sql\r =========","main":"lib","bin":{"db-apply":"bin/db-apply"},"scripts":{"test":"mocha"},"dependencies":{"commander":"~2.6.0","yargs":"~1.3.3","js-yaml":"~3.2.5","pg":"~4.2.0","async":"~0.9.0"},"devDependencies":{"mocha-ui-exports":"~0.2.2","mocha":"~1.20.1"},"license":"propriatry","repository":{"type":"git","url":"https://github.com/osher/mocha-sql"},"publishConfig":{"registry":"http://registry.npmjs.org"},"bugs":{"url":"https://github.com/osher/mocha-sql/issues"},"_id":"mocha-sql@0.0.0","dist":{"shasum":"b41d5880588b932b43b4ce74a214bc9ce356529a","tarball":"https://registry.npmjs.org/mocha-sql/-/mocha-sql-0.0.0.tgz","integrity":"sha512-asY6yAoYUzEcaNyrogSiR6RtbHaHakWVqWGaGCT7sU/QndJydsPlGbB8rtAOszdQ4E8aybBMAWEYNkdXNqolrQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIHu7AzlDspVsPItuw3V4ZqTTjF5Y8HQuFUBHj33FOfsCAiEA+hXQiwVvTiG+dFBEl3tujZZqfT2axwnH6vY9qwyYBbk="}]},"_from":".","_npmVersion":"1.3.11","_npmUser":{"name":"osher","email":"osher.filter@gmail.com"},"maintainers":[{"name":"osher","email":"osher.filter@gmail.com"}]},"0.0.1":{"name":"mocha-sql","version":"0.0.1","description":"mocha-sql\r =========","main":"lib","bin":{"db-apply":"bin/db-apply"},"scripts":{"test":"mocha"},"dependencies":{"commander":"~2.6.0","yargs":"~1.3.3","js-yaml":"~3.2.5","pg":"~4.2.0","async":"~0.9.0","diff":"~1.2.1"},"devDependencies":{"mocha-ui-exports":"~0.2.2","mocha":"~1.20.1"},"license":"propriatry","repository":{"type":"git","url":"https://github.com/osher/mocha-sql"},"publishConfig":{"registry":"http://registry.npmjs.org"},"bugs":{"url":"https://github.com/osher/mocha-sql/issues"},"_id":"mocha-sql@0.0.1","dist":{"shasum":"7e5ffa15589e56116f5d0b1611c70e12298d8020","tarball":"https://registry.npmjs.org/mocha-sql/-/mocha-sql-0.0.1.tgz","integrity":"sha512-qi8zcbdpyu0stNv4rfvmhQKX+Wv80ph/ZTapWkzUE1Z3Qj6N8n6osWd8XyZoXcB+4h8WRapnDOH7udtdlKR4Qg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDsYvyhrT1UuHXheAdDAIQ8F+M6udF6MZCYKwsuTq1itAIgDb+ueKnbKSC8Nx1UurWaIt+D9kvgfuB8EvtCSA3E20w="}]},"_from":".","_npmVersion":"1.3.11","_npmUser":{"name":"osher","email":"osher.filter@gmail.com"},"maintainers":[{"name":"osher","email":"osher.filter@gmail.com"}]},"0.0.2":{"name":"mocha-sql","version":"0.0.2","description":"mocha-sql\r =========","main":"lib","bin":{"db-apply":"bin/db-apply"},"scripts":{"test":"mocha"},"dependencies":{"commander":"~2.6.0","yargs":"~1.3.3","js-yaml":"~3.2.5","pg":"~4.2.0","async":"~0.9.0","diff":"~1.2.1","colors":"~1.0.3"},"devDependencies":{"mocha-ui-exports":"~0.2.2","mocha":"~1.20.1"},"license":"propriatry","repository":{"type":"git","url":"https://github.com/osher/mocha-sql"},"publishConfig":{"registry":"http://registry.npmjs.org"},"bugs":{"url":"https://github.com/osher/mocha-sql/issues"},"_id":"mocha-sql@0.0.2","dist":{"shasum":"4d538608b8420158f5e9651ea3120e39b705035e","tarball":"https://registry.npmjs.org/mocha-sql/-/mocha-sql-0.0.2.tgz","integrity":"sha512-VKsK72kSu9LlJtyxJKjqBaYerP3I189EJ5IhZY5Ixujbw8Svy1x7xrwQaR5+LEJ9Ek3gOuTTZoMFC9N8zEFWmQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCthhK4cf/NYM7A2LJA8T+atZwnCYzLOJFsnkMIaJsOPQIgIsdKI56FFF+KjNBYQO/UQfBE5bYVW2UgN6t84QTto6U="}]},"_from":".","_npmVersion":"1.3.11","_npmUser":{"name":"osher","email":"osher.filter@gmail.com"},"maintainers":[{"name":"osher","email":"osher.filter@gmail.com"}]},"0.0.3":{"name":"mocha-sql","version":"0.0.3","description":"mocha-sql\r =========","main":"lib","bin":{"db-apply":"bin/db-apply"},"scripts":{"test":"mocha"},"dependencies":{"commander":"~2.6.0","yargs":"~1.3.3","js-yaml":"~3.2.5","pg":"~4.2.0","async":"~0.9.0","diff":"~1.2.1","colors":"~1.0.3"},"devDependencies":{"mocha-ui-exports":"~0.2.2","mocha":"~1.20.1"},"license":"propriatry","repository":{"type":"git","url":"https://github.com/osher/mocha-sql"},"publishConfig":{"registry":"http://registry.npmjs.org"},"bugs":{"url":"https://github.com/osher/mocha-sql/issues"},"_id":"mocha-sql@0.0.3","dist":{"shasum":"39e31d72acdec16f0bb6a096d41a29028fe872f2","tarball":"https://registry.npmjs.org/mocha-sql/-/mocha-sql-0.0.3.tgz","integrity":"sha512-4Lg10csdRYbhRpQbHWifwfi7M51MOjNltosAj/E/z99y2GTlCvbaHgrVDlRfMrI3L92mq08hxjlBOeb4x974mw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCICKnr1tjZc4prtMl0OwDH9om1S/+VjzG+nv2MMkVHWb/AiEA8PCJpfIHP1yDoj1iiAEFRymik/3Z2LCJ3NoTFbyh6rY="}]},"_from":".","_npmVersion":"1.3.11","_npmUser":{"name":"osher","email":"osher.filter@gmail.com"},"maintainers":[{"name":"osher","email":"osher.filter@gmail.com"}]},"0.0.4":{"name":"mocha-sql","version":"0.0.4","description":"mocha-sql\r =========","main":"lib","bin":{"db-apply":"bin/db-apply"},"scripts":{"test":"mocha"},"dependencies":{"commander":"~2.6.0","yargs":"~1.3.3","js-yaml":"~3.2.5","pg":"~4.2.0","async":"~0.9.0","diff":"~1.2.1","colors":"~1.0.3"},"devDependencies":{"mocha-ui-exports":"~0.2.2","mocha":"~1.20.1"},"license":"propriatry","repository":{"type":"git","url":"https://github.com/osher/mocha-sql"},"publishConfig":{"registry":"http://registry.npmjs.org"},"bugs":{"url":"https://github.com/osher/mocha-sql/issues"},"_id":"mocha-sql@0.0.4","dist":{"shasum":"45779319f5d2657424eb96fe21d5b59896fb318b","tarball":"https://registry.npmjs.org/mocha-sql/-/mocha-sql-0.0.4.tgz","integrity":"sha512-IMWo95HMbU3PtPBTQH3kkAXyNT2AMXIViZPPyvPqFvx7cUdiZNo33w+kv8qMl4tFAPw3tsRqfwCupRrDWOjSog==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIElwytoi7iM4srSJO3Z1v3SxVKPWtXsm7CQ+L7iDAy8vAiEAgDx7vlxZvKnWy1y6y25Izunn1+3AF1oVBAiROS5aeqg="}]},"_from":".","_npmVersion":"1.3.11","_npmUser":{"name":"osher","email":"osher.filter@gmail.com"},"maintainers":[{"name":"osher","email":"osher.filter@gmail.com"}]},"0.0.6":{"name":"mocha-sql","version":"0.0.6","description":"mocha-sql\r =========","main":"lib","bin":{"db-apply":"bin/db-apply"},"scripts":{"test":"mocha"},"dependencies":{"commander":"~2.6.0","yargs":"~1.3.3","js-yaml":"~3.2.5","pg":"~4.2.0","async":"~0.9.0","diff":"~1.2.1","colors":"~1.0.3"},"devDependencies":{"mocha-ui-exports":"~0.2.2","mocha":"~1.20.1"},"license":"propriatry","repository":{"type":"git","url":"https://github.com/osher/mocha-sql"},"publishConfig":{"registry":"http://registry.npmjs.org"},"bugs":{"url":"https://github.com/osher/mocha-sql/issues"},"_id":"mocha-sql@0.0.6","dist":{"shasum":"685ff2d799a29e35cafca130c208d3fcdbe510e3","tarball":"https://registry.npmjs.org/mocha-sql/-/mocha-sql-0.0.6.tgz","integrity":"sha512-aKLyBw1h6I5/QGYe+i38r7AtK5t+m9F2P1BUgNNiueK6IJgPpGFmsZNDroKhrsSKfKs7OEnytJp23IJHt/LVOg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDGaj3wnA3dMKZnnBOuK8Dk5kUrhVXxNgrrUychV+neowIgXyS3gIFW4CQ0dpR6pobl5I/yO/eH933kLC0IYY6DZco="}]},"_from":".","_npmVersion":"1.3.11","_npmUser":{"name":"osher","email":"osher.filter@gmail.com"},"maintainers":[{"name":"osher","email":"osher.filter@gmail.com"}]}},"readme":"mocha-sql\r\n=========\r\n\r\nGoals:\r\n------\r\n1. simple readable suite files, aiming DBA & developers\r\n1. let them describe not only db-init/db-migrate/db-rollback flows, \r\n    but also support them to describe scanity tests for their moves.\r\n1. allow running the suites inside CI flows\r\n1. allow running the suites on production, the same way they passed in CI\r\n1. take advantage of Mocha's \r\n   * well-structured waterfall\r\n   * well handled startup / teardown hooks\r\n   * good looking `spec` reporter\r\n\r\n\r\nexposes  CLI commands:\r\n----------------------\r\n\r\n*db-apply*: \r\n  Synopsis: `db-apply <cmd> [options]`\r\n  runs the globaly installed mocha with ./cmd/<cmd>.js - expected on USER'S project\r\n\r\n`<cmd>`\r\n-------\r\n    By convention, user's project should support: \r\n     - init (for all DB projects, all versions)\r\n     - migrate (from version #2 and above )\r\n     - migrate-rollback (from version #2 and above )\r\n\r\nOptions\r\n-------\r\n -h, --host\r\n -p, --port\r\n -u, --user\r\n -w, --password\r\n -d, --database   (ignored on test context)\r\n\r\nNotes:\r\n======\r\nThe utility assumes you have [mocha] available - which means, \r\neither as dependency, or installed globally.\r\nThe utility assumes you have [mocha-ui-exports] as local dependency \r\n(it is being required as UI for mocha).\r\nThere's an issue on the road map to remove this dependency - we'll see about that...\r\n\r\n\r\n\r\nTODO / Roadmap\r\n==============\r\nIssues here listed not by priority...\r\n\r\n- connect to travis CI\r\n- start up WIKI & knowledgebase\r\n- add CLI command to create CI user\r\n- add CLI command to create boilerplate project\r\n- support DBs other than postgres\r\n- decouple from mocha-ui-exports: find a way to create suites directly from the YMAL\r\n\r\nContribute\r\n==========\r\nSure, that's why it's here! PRs, as usual.\r\nJust run the tests (whatever there are...)\r\n\r\n\r\nLisence\r\n=======\r\n\r\nMIT, and that's it :)\r\n\r\n","maintainers":[{"name":"osher","email":"osher.filter@gmail.com"}],"time":{"modified":"2022-06-20T01:45:13.615Z","created":"2015-01-18T15:00:35.887Z","0.0.0":"2015-01-18T15:00:38.213Z","0.0.1":"2015-01-20T16:53:52.989Z","0.0.2":"2015-01-25T08:08:17.493Z","0.0.3":"2015-01-28T16:43:17.606Z","0.0.4":"2015-01-28T16:51:35.181Z","0.0.5":"2015-01-28T17:28:08.356Z","0.0.6":"2015-01-28T17:32:12.033Z"},"readmeFilename":"README.md","repository":{"type":"git","url":"https://github.com/osher/mocha-sql"},"bugs":{"url":"https://github.com/osher/mocha-sql/issues"},"license":"propriatry"}