Skip to content

Llibrary for deleting all rows from a given list of DB tables, using knex

License

Notifications You must be signed in to change notification settings

kibertoad/knex-tablecleaner

Repository files navigation

knex-tablecleaner

npm version npm downloads Coverage Status

Simple library for deleting all rows from a given list of DB tables. Tables are cleaned sequentially in a given order, to avoid foreign key constraint violations.

Example usage:

const tableCleaner = require('knex-tablecleaner');
const knex = require('../db'); // pre-initialized instance of knex

const defaultTablesToClean = [
  'orders',
  'users'
];

function cleanDb(tablesToClean = defaultTablesToClean) {
  return tableCleaner.cleanTables(knex, tablesToClean);
}

module.exports = {
  cleanDb,
};

Parameters

function cleanTables(knex, tableNames, verboseLog = false) accepts following parameters:

  • knex - pre-initialized knex instance that will be used for accessing the database;
  • tableNames - either a string with a table name, or an array of strings with table names;
  • verboseLog - if set to true, will log a list of tables being cleaned and the completion log messages.

About

Llibrary for deleting all rows from a given list of DB tables, using knex

Resources

License

Stars

Watchers

Forks

Packages

No packages published