insert_todo.js

// Use Sequelize to insert a new row in the todo table
// Enter your code below
import { Sequelize, DataTypes } from "sequelize";

// 1. Establish the connection using your working port
const sequelize = new Sequelize("mysql://root:secret@localhost:3307/practice");

// 2. Define the Todo model so the script knows what "Todo" means
const Todo = sequelize.define("Todo", {
  title: {
    type: DataTypes.STRING,
    allowNull: false
  },
  completed: {
    type: DataTypes.BOOLEAN,
    defaultValue: false
  }
});

// 3. Wrap your execution logic in an async block
async function run() {
  try {
    // Sync model with database (creates table if it doesn't exist)
    await sequelize.sync();

    // YOUR ASSIGNMENT CODE GOES HERE:
    const newTodo = await Todo.create({ 
      title: "Finish Sequelize Assignment", 
      completed: false 
    });
    
    console.log("Successfully inserted todo:", newTodo.toJSON());

  } catch (error) {
    console.error("Error executing script:", error);
  } finally {
    // Always close the connection when done
    await sequelize.close();
  }
}

run();