var mysql = require("mysql2");
const moment = require('moment');
var con = mysql.createConnection({
    host: "shardauniversity.cluster-c8m5zlhotfbm.ap-south-1.rds.amazonaws.com",
    user: "alumni_user",
    password: "Ar$niuDB&123",
    database: "alumni_db"
});

const currentDate = new Date();

const date = moment(currentDate).utcOffset('+05:30').format('YYYY-MM-DD');
const time = moment(currentDate).utcOffset('+05:30').format('HH:mm');

con.connect(function (err) {
    if (err) throw err;
    console.log("Connected!");
    let query = `SELECT * FROM alumni_db.tbl_alum_event where event_start_date <= '${date}' AND event_start_time <= '${time}' AND status != 'Expired'`;
    con.query(query, function (err, result) {
        if (err) throw err;
        if (result?.length > 0) {
            for (let i = 0; i < result?.length; i++) {
                con.query("UPDATE alumni_db.tbl_alum_event SET status=? WHERE event_id = ?", [(result[i].event_end_date >= date && result[i].event_end_time >= time ? "Running" : "Expired"), result[i].event_id], function (err, result) {
                    if (err) throw err;
                    else {
                        console.log("Event Status Updated Successfully");
                    }
                });
            }
        } else {
            console.log("There is no data to update");
        }
    });
});