Add UpdateorCreate

[SnapnetDev]

Prerequisites

Why this feature is required (specific use-cases will be appreciated)?

This feature is required when you want to run a lucid query to update or create item in the database

Have you tried any other work arounds?

Yes , i have added a new function that enables be achieve this in

static async updateOrCreate (whereClause, payload, trx) {
if (!payload) {
payload = whereClause
}

/**
 * Find a row using where clause and update if exist
 */
const row = await this.query().where(whereClause).first()
if (row) {
  const update= this.query().where(whereClause).update(payload);
  return update;
}

/**
 * Otherwise create one
 */
return this.create(payload, trx)

}

Are you willing to work on it with little guidance?

Yes

[adailsonm]

Great relevance, congratulations on the suggestion.

[MZanggl]

Meanwhile, I have made this available through a model trait. https://github.com/MZanggl/adonis-lucid-update-or-create

[syntaxlexx]

Hi everyone. When is the new release incorporating this PR being released? Just being curious

[RomainLanz]

It's already released in the new version of AdonisJS (aka, the Preview of V5).