Can't import Sequelize models with TypeScript: Error: No Sequelize instance passed

Question

My user.model.ts is:

@Table
export class User extends Model<User> {
    @Column({ allowNull: false })
    firstName: string;

    @Column({ allowNull: false })
    lastName: string;
...

When I try to import it:

    const sequelize = new Sequelize(DB_CREDENTIALS_PARSED.database, DB_CREDENTIALS_PARSED.username, DB_CREDENTIALS_PARSED.password, { dialect: 'postgres' })
    const modelFile = require(path.join(modelPath, 'user.model')).User.init({ sequelize })

    console.log(modelFile)

I get an error: Error: No Sequelize instance passed

What am I doing wrong?

mousto090 · Accepted Answer · 2020-05-05 01:19:35Z

1

The sequelize instance must be passed in the second argument of the init method

const User = require(path.join(modelPath, 'user.model'));
const sequelize = new Sequelize(
    DB_CREDENTIALS_PARSED.database,
    DB_CREDENTIALS_PARSED.username,
    DB_CREDENTIALS_PARSED.password, {
        dialect: 'postgres'
    }
)
User.init(modelAttributesObject, { sequelize })

But as you are using the sequelize TypeScript, you can initialize your models with the instance

const User = require(path.join(modelPath, 'user.model'));
const sequelize = sequelize = new Sequelize({
    dialect: 'postgres',
    database: DB_CREDENTIALS_PARSED.database,
    username: DB_CREDENTIALS_PARSED.username,
    password: DB_CREDENTIALS_PARSED.database,
    models: [User]
});

answered May 5, 2020 at 1:19

mousto090

2,0391 gold badge15 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Shamoon Over a year ago

But isn't modelAttributesObject coming from my definition?

mousto090 Over a year ago

Yes it is, that is why you don't need the ìnit` method here as it require the attributes to be passed as first argument. Either you use the TypeScript version and passe models to sequelize instance or the Javascript version and use the init method

Shamoon Over a year ago

With the Typescript version, what about relationships?

mousto090 Over a year ago

"Relations can be described directly in the model" from the sequelize-typescript. See npmjs.com/package/sequelize-typescript#model-association

Shamoon Over a year ago

So as long as I include all the models, everything should just work?

|

Collectives™ on Stack Overflow

Can't import Sequelize models with TypeScript: Error: No Sequelize instance passed

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related