What is the process to generate tables that have changing names in Sequelize and TypeScript and retrieve data from them?

edit

The process to generate tables with changing names in Sequelize and TypeScript is as follows:

1. Define the table schema in a TS interface, including the table name as a property.

interface TableName {
    tableName: string;
    // define other table properties
}

1. Define a Sequelize model using the table schema interface.

const Model = sequelize.define<TableName, {}>(
    'tableName', 
    {// define table schema
});

1. Pass the table name as a parameter to the query.

Model.findAll({
    where: { 
        // define query criteria 
    }, 
    table: 'tableName' 
})

1. To retrieve data from the table using the Sequelize model or querying the database directly, use the table name property defined in the schema.

const result = await Model.findAll({
    where: { 
        // define query criteria 
    }, 
    table: 'tableName' 
});

Note that when using the Sequelize CLI to generate migrations, you can also pass a custom table name as a parameter.

npx sequelize-cli migration:generate --name create-customnamedTable --tableName customnamedTable