count_rows.js

import { Sequelize, DataTypes } from "sequelize";

const sequelize = new Sequelize("mysql://root:secret@localhost:3307/practice");
const Todo = sequelize.define("Todo", {
  title: { type: DataTypes.STRING, allowNull: false },
  completed: { type: DataTypes.BOOLEAN, defaultValue: false }
});

async function run() {
  try {
    await sequelize.sync();

    // Count all rows matching specific criteria
    const completedCount = await Todo.count({ where: { completed: true } });
    
    console.log(`Total completed tasks: ${completedCount}`);
  } catch (error) {
    console.error("Error:", error);
  } finally {
    await sequelize.close();
  }
}

run();