Is it possible to define indexes inside a model definition ?

[assaad97]

Hello, im using lucid with adonisJs 5, and im trying to define indexes inside my models, i don't want to do it via migrations since the database that im using is already populated.

[RomainLanz]

Hello @assaad97! 👋🏻

Unfortunately, it is not possible for a model to take into account whether a field has an index or not. However, even if your database is already populated, you can use migrations to add indexes to specific fields as needed.

Example:

import BaseSchema from '@ioc:Adonis/Lucid/Schema'

export default class extends BaseSchema {
  protected tableName = 'X'

  public async up() {
    this.schema.alterTable(this.tableName, (table) => {
      table.integer('type').notNullable().index().alter()
      table.index(['type', 'user_id'])
    })
  }

  public async down() {
    this.schema.alterTable(this.tableName, (table) => {
      table.integer('type').nullable().alter()
      table.dropIndex(['type', 'user_id'])
    })
  }
}