Sequelize: Check if table exist and empty

Question

I want check a table and if table is empty create a record.

my code:

module.exports = (sequelize, DataTypes) => {
    const About = sequelize.define("About",
        {
            id: {
                type: DataTypes.BIGINT,
                autoIncrement: true,
                allowNull: false,
                primaryKey: true,
            },
            title: DataTypes.STRING(150),
            content: DataTypes.TEXT("medium"),
        },
        {
            freezeTableName: true,
            timestamps: false,
        },
    );

    About.findAll()
    .then(about => {
        if (about.length === 0) {
            About.create({
                title: "About Us",
                content: "Lorem ipsum dolor sit amet...",
            });
        }
    });

    return About;
};

But when table doesn't exist I get this error:

Executing (default): SELECT id, title, content FROM About AS About;

Unhandled rejection SequelizeDatabaseError: Table 'mydb.about' doesn't exist

how can I handle this issue?

Take a look at [usage-of-mysqls-if-exists](https://stackoverflow.com/questions/5528854/usage-of-mysqls-if-exists) — B001ᛦ, Apr 22 '20 at 11:12
you can try to call describeTable of QueryInterface (to get QI call getQueryInterface in sequelize) to get information about a table. — Anatoly, Apr 22 '20 at 16:53

score 2 · Accepted Answer · edited Aug 29 '20 at 20:12

I finally found the answer to my problem.

I added .sync() and create table before find. Both of .findOrCreate() and .findAll() is working.

module.exports = (sequelize, DataTypes) => {
    const About = sequelize.define("About",
        {
            title: DataTypes.STRING(150),
            content: DataTypes.TEXT("medium"),
        },
        {
            freezeTableName: true,
            timestamps: false,
        },
    );

    About.sync();

    About.findOrCreate({
        where: {id: 1},
        defaults: {
            title: "About Us",
            content: "Lorem ipsum dolor sit amet...",
        },
    });

    return About;
};

Sequelize: Check if table exist and empty

1 Answers1