AdonisJs 5V: How to save data using fill({...}).related('...').saveMany([...])

[andre-ab]

I have two tables that are from M to M, so there is a third table.
employee, specialty and employee_has_specialty
I want to insert data using related like this:

const employee = new Employee()
await employee
        .fill({
          onoff: data.onoff,
          name: data.name,
          date_birth: data.dataBirth,
          company_idcompany: idCompany,
        })
     .related('employeeHasSpecialty')
     .saveMany(specialtydate)

Error: --> TypeError: row.save is not a function
or

  await employee
        .fill({
          onoff: data.onoff,
          name: data.name,
          date_birth: data.dataBirth,
          company_idcompany: idCompany,
        })
          .related('specialties')
        .saveMany(specialtydate)

Error --> TypeError: one.save is not a function
where specialty is a Json array with the data for specialty

in the Employee Model.ts file, I have a relationship
one to many
code:

@hasMany(() => EmployeeHasSpecialty, {
    foreignKey: 'employee_idemployee',
  })
  public employeeHasSpecialty: HasMany<typeof EmployeeHasSpecialty>

and from many to many
code:

 @manyToMany(() => Specialty, {
    localKey: 'idemployee',
    pivotForeignKey: 'employee_idemployee',
    relatedKey: 'idspecialty',
    pivotRelatedForeignKey: 'specialty_idspecialty',
    pivotTable: 'employee_has_specialty',
  })

the EmployeeHasSpecialty.ts file
This is where the data from the third relationship table is located

How can I insert using the "related" and "saveMany" relationship?

[ekimkael]

Hello Andre,
in your Model you just have make it like that:

@manyToMany(() => Specialty, { pivotTable: 'employee_has_specialty' })
public specialities: ManyToMany<typeof Specialty>

and in your Controller you'll have to save first then attach specialities like this:

const employee = new Employee()
const payload = await request.validate(EmployeeValidator)
// or the way you get your data

const newEmployee = await employee.fill(payload).save()
await newEmployee.related('specialities').attach(payload.specialities)

in the update method make sure to detach before attach

const employee = await Employee.findOrFail(params.id)
const payload = await request.validate(EmployeeValidator)
// or the way you get your data

await employee.merge(payload).save()
await employee.related('specialities').detach()
await employee.related('specialities').attach(payload.specialities)

Hope it helps

[andre-ab]

Thank you for the informations.