Knex Columns with Foreign Key Constraints

Question

Is it possible to truncate a table with foreign key constraints to delete all rows in other tables?

I do not see the documentation to go to the knex('tableName').truncate() method.

Answer 1

I did not find a built-in way to do this, so I just go into raw mode:

  knex.raw('TRUNCATE TABLE users, products CASCADE') 

You can also set this automatically in your migrations:

 exports.up = function(knex) { return knex.schema.createTable('users_products', (t) => { t.uuid('id').primary().defaultTo(knex.raw('uuid_generate_v4()')); t.uuid('user_id').notNullable().references('id').inTable('users').onDelete('CASCADE'); t.uuid('product_id').notNullable().references('id').inTable('products').onDelete('CASCADE'); }); }; 

Answer 2

Knexjs now has a truncate() method.

 knex('accounts').truncate() Outputs: truncate `accounts` 

May not work for all cases, but should be fine for basic truncation needs.