[V5] Lucid Update with UUID Primary Key not working

[CodeRogers]

Hello there,

I'm using UUID as Primary Key in the table, and when I try to update, I receive an error. I tried use an auto increment Primary Key, and it worked, but it's not what I need tho.

Model:

export default class Questao extends BaseModel {
  public static table = 'questao'
  public static selfAssignPrimaryKey = true

  @column({ columnName: 'id_questao', isPrimary: true })
  public id: string

  @column()
  public corpoQuestao: string

  @column.dateTime({ autoCreate: true })
  public createdAt?: DateTime

  @column.dateTime({ autoCreate: true, autoUpdate: true })
  public updatedAt?: DateTime

  @beforeCreate()
  public static async createUUID(questao: Questao) {
    questao.id = uuid()
  }
}

Controller:

export default class QuestaoController {
  public async update({ request, params: { id }, response }: HttpContextContract) {
    const questaoPayload = await request.validate(UpdateQuestao)
    try {
        const questao = await Questao.findOrFail(id)
        questao.merge(questaoPayload)
        await questao.save()
      } catch (error) {
        throw new Exception(`couldn't update questao with id: '${id}', error: ${error}`)
      }
    return response.noContent()
  }
}

Error:

Exception: ".where" expects value to be defined, but undefined is passed
    err: {
      "type": "Exception",
      "message": "couldn't update questao with id: '299dbf94-2cc6-4f23-ad46-2197266b1d78', error: Exception: \".where\" expects value to be defined, but undefined is passed",
      "stack":
          Exception: couldn't update questao with id: '299dbf94-2cc6-4f23-ad46-2197266b1d78', error: Exception: ".where" expects value to be defined, but undefined is passed
              at Object.update (/home/rogerio/Documentos/projetos/atividade-discursiva-api-v2/app/Services/QuestaoService.ts:21:13)
              at QuestaoController.update (/home/rogerio/Documentos/projetos/atividade-discursiva-api-v2/app/Controllers/Http/QuestaoController.ts:38:5)
              at Object.PreCompiler.runRouteHandler [as fn] (/home/rogerio/Documentos/projetos/atividade-discursiva-api-v2/node_modules/@adonisjs/http-server/build/src/Server/PreCompiler/index.js:47:31)
              at Server.handleRequest (/home/rogerio/Documentos/projetos/atividade-discursiva-api-v2/node_modules/@adonisjs/http-server/build/src/Server/index.js:108:13)
    }

Any feedback is appreciated!

[CodeRogers]

This error does not happen when I use a querybuilder like Knex provided by Database.knexQuery to perform the update passing the id as uuid of the table row

await Database.knexQuery().from('questao').update(questao).where('id_questao', id)

[RomainLanz]

Hey @RogVenancio! 👋🏻

Could you please share the code of your validator and log what is the content of questaoPayload?

[CodeRogers]

I only get the error when I set an UUID as primarykey, that is a string.
When I was using an auto increment primary key, it was working fine.

Validator:

export default class UpdateQuestaoValidator {
  constructor(protected ctx: HttpContextContract) {}

  public schema = schema.create({
    id_usuario: schema.number.optional([
      rules.unsigned(),
      rules.exists({ column: 'id_usuario', table: 'user' }),
    ]),
    corpo_questao: schema.string.optional({}, [rules.minLength(10)]),
    id_disciplina: schema.string.optional({}, [rules.minLength(3)]),
    nome_disciplina: schema.string.optional({}, [rules.minLength(3)]),
    palavras_chave: schema.array.optional().members(schema.string()),
  })
}

Log:

{
   "corpo_questao": "this is a corpo_questao"
}