Adonis 5: Table Prefix

[mastermunj]

I am trying to have table prefix as 'tbl_', however, it gives me following TypeScript error.

My Config:

pg: {
  client: 'pg',
  connection: {
    host: Env.get('DB_HOST', '127.0.0.1') as string,
    port: Number(Env.get('DB_PORT', 5432)),
    user: Env.get('DB_USER', 'lucid') as string,
    password: Env.get('DB_PASSWORD', 'lucid') as string,
    database: Env.get('DB_NAME', 'lucid') as string,
  },
  healthCheck: true,
  prefix: 'tbl_',
},

The Error:

Type '{ client: "pg"; connection: { host: string; port: number; user: string; password: string; database: string; }; healthCheck: true; prefix: string; }' is not assignable to type 'SqliteConfig | MysqlConfig | PostgreConfig | OracleConfig | MssqlConfig'.
  Object literal may only specify known properties, and 'prefix' does not exist in type 'PostgreConfig'.

Am I doing something wrong?

[thetutlage]

Where in the docs you read that you can prefix tables?

[mastermunj]

I read it in v4.1 docs at https://adonisjs.com/docs/4.1/database#_table_prefixing and thought it will be available for v5 as well.

[mastermunj]

So the alternative is to set will be?

public static table = 'tbl_brands';

[thetutlage]

If it's about just models, then you can also use the ORM config to prefix the table name. Open config/database.ts file

  orm: {
    getTableName(model) {
      return `prefix_${plural(snakeCase(model.name))}`
    },
  },

And then import the following package to pluralize and snake case the model name. (have to install them as well)

import { plural } from 'pluralize'
import { snakeCase } from 'snake-case'

[mastermunj]

Will this reflect into Model.table when used anywhere?

[thetutlage]

Yes it will

[mastermunj]

It works! Thank you.

[mastermunj]

For others, the answer is #1358 (reply in thread)