bookshelf-paranoia

const Knex = require('knex'); const Bookshelf = require('bookshelf'); // Mock Knex setup for demonstration const knex = Knex({ client: 'sqlite3', connection: { filename: ':memory:' }, useNullAsDefault: true }); const bookshelf = Bookshelf(knex); // Add the plugin bookshelf.plugin(require('bookshelf-paranoia')); // Define a model with soft delete enabled const User = bookshelf.Model.extend({ tableName: 'users', softDelete: true, idAttribute: 'id' }); async function runExample() { try { // Create users table if it doesn't exist await knex.schema.hasTable('users').then(exists => { if (!exists) { return knex.schema.createTable('users', table => { table.increments('id').primary(); table.string('name'); table.timestamp('deleted_at'); // Default field for soft delete }); } }); // Insert a user const newUser = await User.forge({ name: 'Alice' }).save(); console.log('Created user:', newUser.toJSON()); // Soft delete the user await newUser.destroy(); console.log('Soft-deleted user.'); // Try to fetch the user (should return null as it's soft-deleted) const fetchedUser = await User.forge({ id: newUser.id }).fetch(); console.log('Fetched user after soft-delete (should be null):', fetchedUser ? fetchedUser.toJSON() : 'null'); // Fetch the user, including soft-deleted records const fetchedWithDeleted = await User.forge({ id: newUser.id }).fetch({ withDeleted: true }); console.log('Fetched user withDeleted: ', fetchedWithDeleted.toJSON()); console.log('Deleted at timestamp:', fetchedWithDeleted.get('deleted_at')); // Perform a hard delete (bypassing soft delete) const userToHardDelete = await User.forge({ name: 'Bob' }).save(); console.log('Created user for hard delete:', userToHardDelete.toJSON()); await userToHardDelete.destroy({ hardDelete: true }); console.log('Hard-deleted user.'); const fetchedHardDeleted = await User.forge({ id: userToHardDelete.id }).fetch({ withDeleted: true }); console.log('Fetched hard-deleted user (should be null):', fetchedHardDeleted ? fetchedHardDeleted.toJSON() : 'null'); } catch (error) { console.error('Error during example run:', error); } finally { await knex.destroy(); } } runExample();