Soft deletes for Adonis 4.

SoftDeletes.js

// $ adonis  make:trait SoftDeletes

class SoftDeletes {
  register(Model, customOptions = {}) {
    const deletedAtColumn = customOptions.name || `${Model.table}.deleted_at`;

    Model.addGlobalScope(builder => {
      builder.whereNull(deletedAtColumn);
    }, 'adonis_soft_deletes');

    Model.queryMacro('withTrashed', () => {
      this.ignoreScopes('adonis_soft_deletes');
      return this;
    });

    Model.queryMacro('onlyTrashed', () => {
      this.ignoreScopes('adonis_soft_deletes');
      this.whereNotNull(deletedAtColumn);
      return this;
    });

    Model.prototype.delete = async () => {
      this[deletedAtColumn] = new Date();
      await this.save();
    };

    Model.prototype.restore = async () => {
      this[deletedAtColumn] = null;
      await this.save();
    };

    Model.prototype.forceDelete = async () => {
      await Model.query()
        .where(Model.primaryKey, this[Model.primaryKey])
        .ignoreScopes()
        .delete();
    };
  }
}

module.exports = SoftDeletes;

@andresilvagomez I think line 5 should be like below to support relationship query.

const deletedAtColumn = customOptions.name || `${Model.table}.deleted_at`;

@zahidmuhammadzaki right, I updated it, thanks !!!

This didn't work for me using Adonis 4.1... the arrow functions bind the this scope to the trait and not the model instance. Also the ${Model.table}.deleted_at breaks on Postgres, it probably could do with not understanding the connection grammar/dialects.

class SoftDeletes {
  register(Model, customOptions = {}) {
    const deletedAtColumn = customOptions.name || `deleted_at`;

    Model.addGlobalScope(builder => {
      builder.whereNull(deletedAtColumn);
    }, 'adonis_soft_deletes');

    Model.queryMacro('withTrashed', () => {
      this.ignoreScopes('adonis_soft_deletes');
      return this;
    });

    Model.queryMacro('onlyTrashed', () => {
      this.ignoreScopes('adonis_soft_deletes');
      this.whereNotNull(deletedAtColumn);
      return this;
    });

    Model.prototype.delete = async function () {
      this[deletedAtColumn] = new Date();
      await this.save();
    };

    Model.prototype.restore = async function () {
      this[deletedAtColumn] = null;
      await this.save();
    };

    Model.prototype.forceDelete = async function () {
      await Model.query()
        .where(Model.primaryKey, this[Model.primaryKey])
        .ignoreScopes()
        .delete();
    };
  }
}

module.exports = SoftDeletes;

The above worked better... but I've not tested relations.

I want to know. How to use softdelete?
I use the trait. Show the error.
this.save() is not a function.
Please instruct me. How to do that?
Thanks

This didn't work for me using Adonis 4.1... the arrow functions bind the this scope to the trait and not the model instance. Also the ${Model.table}.deleted_at breaks on Postgres, it probably could do with not understanding the connection grammar/dialects.

class SoftDeletes {
  register(Model, customOptions = {}) {
    const deletedAtColumn = customOptions.name || `deleted_at`;

    Model.addGlobalScope(builder => {
      builder.whereNull(deletedAtColumn);
    }, 'adonis_soft_deletes');

    Model.queryMacro('withTrashed', () => {
      this.ignoreScopes('adonis_soft_deletes');
      return this;
    });

    Model.queryMacro('onlyTrashed', () => {
      this.ignoreScopes('adonis_soft_deletes');
      this.whereNotNull(deletedAtColumn);
      return this;
    });

    Model.prototype.delete = async function () {
      this[deletedAtColumn] = new Date();
      await this.save();
    };

    Model.prototype.restore = async function () {
      this[deletedAtColumn] = null;
      await this.save();
    };

    Model.prototype.forceDelete = async function () {
      await Model.query()
        .where(Model.primaryKey, this[Model.primaryKey])
        .ignoreScopes()
        .delete();
    };
  }
}

module.exports = SoftDeletes;

The above worked better... but I've not tested relations.

Using Adonis 4.1; In my case, I changed the arrow function to a normal function and that's it

Model.prototype.delete = async function() {
      this[deletedAtColumn] = new Date();
      await this.save();
    };

    Model.prototype.restore = async function() {
      this[deletedAtColumn] = null;
      await this.save();
    };

I want to know. How to use softdelete?
I use the trait. Show the error.
this.save() is not a function.
Please instruct me. How to do that?
Thanks

Adonis Js 4.2

Model.prototype.delete = async function() {
      this[deletedAtColumn] = new Date();
      await this.save();
    };

    Model.prototype.restore = async function() {
      this[deletedAtColumn] = null;
      await this.save();
    };

It only works when you first search for the value and then delete it, if you do as the query below does not work.
"Bulk Deletes"

work:
let get = await Test_Softdelete.query().where('value', 10).first() if(get){ await get.delete() return get }
doesn't work with an array of data like fetch.
dont working:
await Test_Softdelete.query().where('value', 10).delete()