How do you query a table with a schema in Sequelize.js?

Question

I have a table called 'wallets' in the 'dbo' schema of my postgresql database. When I try to query it I get the error:

Executing (default): SELECT "wallets_id", "confirmed_balance", "unconfirmed_balance", "created_at", "updated_at" FROM "dbo.wallets" AS "dbo.wallets";
Unhandled rejection SequelizeDatabaseError: relation "dbo.wallets" does not exist

This is my code:

get_dbo__wallets() : any {
    const options = this.getDatabaseDefaultOptions('dbo.wallets');
    const entity : types.IObjectWithStringKey = {};
    entity['wallets_id'] = {type: Sequelize.UUID, primaryKey: true, allowNull : false};
    entity['confirmed_balance'] = Sequelize.BIGINT;
    entity['unconfirmed_balance'] = Sequelize.BIGINT;
    return this._db.define('dbo.wallets', entity, options);
}

getDatabaseDefaultOptions(tableName : string) : types.IObjectWithStringKey {
    const options : types.IObjectWithStringKey = {};
    options['timestamps'] = true;
    options['createdAt'] = 'created_at';
    options['updatedAt'] = 'updated_at';
    options['underscored'] = false;

    options['paranoid'] = false;
    options['deletedAt'] = false;

    options['freezeTableName'] = true;
    options['tableName'] = tableName;
    return options;
}

//and then I call:  get_dbo__wallets().all()

What should I change in the model definition to set the schema name correctly?

Answer 1

You can add the schema to the table definition using the options object:

options['schema'] = 'dbo';

I found this by stepping into the query creation code at runtime - it doesn't appear to be in the documentation. I've opened a Sequelize bug to address this: https://github.com/sequelize/sequelize/issues/5864