I am currently in the process of developing a discord bot, which includes 2 slash commands. One command is called /setup, used for adding the guildId and an adminChannel to a database. The other command is named /onduty, which is used for adding the user, onduty time, and offduty time to the database.
While the /setup command is working as expected, I have encountered issues with the /onduty command. My main problem lies in the model for the database table that handles times, specifically when trying to use the autoIncrement feature.
Below is my guild.js file:
import { Sequelize } from 'sequelize';
import { sequelize } from '../utils/database.js';
import { Time } from './times.js'
const Guild = sequelize.define('guilds', {
guildId: {
type: Sequelize.STRING,
primaryKey: true
},
adminChannel: {
type: Sequelize.STRING,
allowNull: true
}
});
Guild.hasMany(Time, {
foreignKey: 'guildId',
onUpdate: 'CASCADE',
onDelete: 'CASCADE'
})
Time.belongsTo(Guild, {foreignKey: 'guildId'});
export { Guild };
Here is my times.js file
import { Sequelize, DataTypes } from 'sequelize';
import { sequelize } from '../utils/database.js';
const Time = sequelize.define('times', {
id: {
type: Sequelize.INTEGER,
AutoIncrement: true,
primaryKey: true
},
guildId: {
type: Sequelize.STRING,
allowNull: false,
primaryKey: true,
references: {
model: 'guilds',
key: 'guildId',
}
},
user: {
type: Sequelize.STRING,
allowNull: false
},
onDutyTime: {
type: Sequelize.STRING,
allowNull: false
},
offDutyTime: {
type: Sequelize.STRING,
allowNull: true
},
});
export { Time };
Here is my sequelize database init file (database.js)
import { Sequelize } from 'sequelize';
const sequelize = new Sequelize('database', 'user', 'password', {
dialect: 'sqlite',
host: 'localhost',
storage: 'database.sqlite',
logging: true,
});
export {sequelize};
For a visual representation, here is an image of my database: database.sqlite file
When attempting to use AutoIncrement: true in my times.js file, I encountered the following output:
(node:42984) [SEQUELIZE0002] DeprecationWarning: The logging-option should be either a function or false. Default: console.log
...
Conversely, after using autoIncrement: true in my times.js file, I received the following error:
Error message due to syntax error
In summary, my expectation is to successfully implement the autoincrement feature on the id column within the database table.