db.js

// db.js
// Sequelize setup and UserActivity model definition
import { Sequelize, DataTypes } from "sequelize";
import { config } from "dotenv";

// Load environment variables from .env file
config();

// Create Sequelize instance with MySQL connection using environment variables
export const sequelize = new Sequelize(process.env.DB_NAME, process.env.DB_USER, process.env.DB_PASSWORD, {
  host: process.env.DB_HOST,
  port: process.env.DB_PORT,
  dialect: "mysql",
});

// Define UserActivity model - represents our database table
export const UserActivity = sequelize.define("UserActivity", {
  name: {
    type: DataTypes.STRING,
    allowNull: false, // Required field
  },
  activity: {
    type: DataTypes.STRING,
    allowNull: false, // Required field
  },
});

// Sync the model with the database (creates table if it doesn't exist)
sequelize.sync();