{"_id":"@synconset/knex-cleaner","_rev":"91-174fa6bd2b9745bca2ec46a58ff51b10","name":"@synconset/knex-cleaner","dist-tags":{"latest":"1.2.1"},"versions":{"1.2.1":{"name":"@synconset/knex-cleaner","version":"1.2.1","keywords":["knex","knexjs","bookshelf","bookselfjs"],"author":{"name":"Steven Ferguson","email":"steven.ferguson11@gmail.com"},"license":"MIT","_id":"@synconset/knex-cleaner@1.2.1","maintainers":[{"name":"thekiteeatingtree","email":"thekiteeatingtree@gmail.com"}],"contributors":[{"url":"https://github.com/jtwebman","name":"JT Turner"}],"homepage":"https://github.com/steven-ferguson/knex-cleaner#readme","bugs":{"url":"https://github.com/steven-ferguson/knex-cleaner/issues"},"dist":{"shasum":"cdb0ae8e504d0257992f18941ffd98c891d1f8fb","tarball":"https://registry.npmjs.org/@synconset/knex-cleaner/-/knex-cleaner-1.2.1.tgz","integrity":"sha512-49BkV/FedlfmAJ505bP70B1D3TWYM8utOJoS0vvsWMktvIZRXSzTkM4ATKeQJj2ylKnoUh4iyh04n8DQRAT09w==","signatures":[{"sig":"MEUCIEDiI2r+7jixQ45jEcOyPRSLJHnj90To8VjRPpnLs5L5AiEArzCBDXA68Ukl2NLdoHRn1/S+tyh5Z0AYPJnWdOKg0Qk=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/knex_cleaner.js","_from":".","_shasum":"cdb0ae8e504d0257992f18941ffd98c891d1f8fb","gitHead":"c784620a72259c2f70dedbc05d618da78976dec7","scripts":{"test":"./node_modules/mocha/bin/mocha"},"_npmUser":{"name":"thekiteeatingtree","email":"thekiteeatingtree@gmail.com"},"repository":{"url":"git://github.com/steven-ferguson/knex-cleaner.git","type":"git"},"_npmVersion":"3.10.9","description":"Database cleaner for Knex.js and bookshelf.js","directories":{},"_nodeVersion":"6.9.2","dependencies":{"lodash":"^3.5.0","bluebird":"^2.9.13"},"devDependencies":{"pg":"^4.3.0","chai":"3.5.x","knex":"^0.7.5","faker":"^2.1.2","mocha":"*","mysql":"^2.5.5","sqlite3":"^3.0.5","chai-as-promised":"5.3.x"},"_npmOperationalInternal":{"tmp":"tmp/knex-cleaner-1.2.1.tgz_1494526323257_0.6237787059508264","host":"packages-18-east.internal.npmjs.com"}}},"time":{"created":"2017-05-11T18:12:04.140Z","modified":"2026-05-20T07:25:20.727Z","1.2.1":"2017-05-11T18:12:04.140Z"},"bugs":{"url":"https://github.com/steven-ferguson/knex-cleaner/issues"},"author":{"name":"Steven Ferguson","email":"steven.ferguson11@gmail.com"},"license":"MIT","homepage":"https://github.com/steven-ferguson/knex-cleaner#readme","keywords":["knex","knexjs","bookshelf","bookselfjs"],"repository":{"url":"git://github.com/steven-ferguson/knex-cleaner.git","type":"git"},"description":"Database cleaner for Knex.js and bookshelf.js","contributors":[{"url":"https://github.com/jtwebman","name":"JT Turner"}],"maintainers":[{"email":"kmannam@ep.com","name":"kotes-sos"},{"email":"ppalavali@ep.com","name":"praveenpalavali"},{"email":"rrajasekharan@ep.com","name":"renjith-ep"},{"email":"prsingh@ep.com","name":"prsingh"},{"email":"ddunham@ep.com","name":"ddunhamep"},{"email":"nduggegowda@ep.com","name":"nesarahippla"},{"email":"rpowers@ep.com","name":"rpowers11"},{"email":"bsinha@ep.com","name":"bsinhaatep"},{"email":"mpawar@ep.com","name":"mpawar0910"},{"email":"nelson4183@gmail.com","name":"nelson4183"},{"email":"amahale@ep.com","name":"amahaleep"},{"email":"gjafrain@ep.com","name":"gouravep"},{"email":"bkumar@ep.com","name":"baleshkumar-ep"},{"email":"ssingasani@ep.com","name":"sivakrishna"},{"email":"rg@ep.com","name":"ravig-ep"}],"readme":"# knex-cleaner\nHelper library to clean a PostgreSQL, MySQL or SQLite3 database tables using Knex. Great for integration tests.\n\n###Installation\n```\nnpm install knex-cleaner\n```\n\n###Usage\n```javascript\nvar knexCleaner = require('knex-cleaner');\n\nvar knex = require('knex')({\n  client: 'mysql',\n  connection: {\n    host     : '127.0.0.1',\n    user     : 'your_database_user',\n    password : 'your_database_password',\n    database : 'myapp_test'\n  }\n});\n\nknexCleaner.clean(knex).then(function() {\n  // your database is now clean\n});\n\n// You can also use this in BookshelfJS\nvar bookshelf = require('bookshelf')(knex);\n\nknexCleaner.clean(bookshelf.knex).then(function() {\n\n});\n\n// You can also pass if it deletes the tables with delete instead of truncate\n// as well as a list of tables to ignore.\n\nvar options = {\n  mode: 'delete', // Valid options 'truncate', 'delete'\n  ignoreTables: ['Dont_Del_1', 'Dont_Del_2']\n}\n\nknexCleaner.clean(knex, options).then(function() {\n  // your database is now clean\n});\n```\nThe example above used MySQL but it has been tested on PostgreSQL and SQLite3.\n","readmeFilename":"README.md"}