Sequelize + MySQL Project

A complete Node.js project demonstrating Sequelize ORM with MySQL database integration.

Quick Start

1. Setup Database

1. Start XAMPP and ensure MySQL is running
2. Open phpMyAdmin (usually at http://localhost/phpmyadmin)
3. Create a new database named sequelize_test

2. Install Dependencies

npm install

3. Configure Environment

Copy .env.example to .env and update the database settings:

cp .env.example .env

Update .env with your MySQL settings:

DB_HOST=localhost
DB_USER=root
DB_PASSWORD=your_password
DB_NAME=sequelize_test
DB_PORT=3306

4. Initialize Database

node init.js

This will:

• Create the UserActivities table
• Insert initial sample data
• Display the created records

Project Files

File	Description
db.js	Sequelize setup and UserActivity model definition
init.js	Creates table and inserts initial data
insertRandom.js	Inserts random data every 10 seconds
insertRandomAdvanced.js	Bonus: Advanced version with 50 record limit
queryAll.js	Displays all records with statistics

Usage Examples

Create Initial Data

node init.js

Insert Random Data Continuously

node insertRandom.js

• Adds random user activity every 10 seconds
• Shows data summary every 30 seconds
• Press Ctrl+C to stop

View All Records

node queryAll.js

Bonus: Advanced Random Insertion

node insertRandomAdvanced.js

Same as insertRandom.js but stops at 50 records

Database Schema

UserActivity Table

Column	Type	Description
id	INTEGER	Primary key (auto-increment)
name	STRING	User name (required)
activity	STRING	Activity type (required)
createdAt	DATETIME	Record creation time
updatedAt	DATETIME	Last update time