/ var / www / html / greenpreneurs / api / controllers / [ HOME SHELL ]

Name	Size	Permission
admin.dashboard.controller.js	12.23 KB	-rw-r--r--
auth.controller.js	5.83 KB	-rw-r--r--
blog.controller.js	5.49 KB	-rw-r--r--
event.controller.js	1.43 KB	-rw-r--r--
homePage.controller.js	1.33 KB	-rw-r--r--
individualBlog.controller.js	4.96 KB	-rw-r--r--
user.controller.js	4.33 KB	-rw-r--r--
user.dashboard.controller.js	6.88 KB	-rw-r--r--

Code Editor : event.controller.js

import pool from "../config/db.js";

// ✅ Get a list of events with pagination
export const getEvents = async (req, res) => {
    const limit = parseInt(req.query.limit) || 10; // Default limit of 10 if not provided
    const offset = parseInt(req.query.offset) || 0; // Default offset of 0 if not provided

try {
        const eventQuery = 'SELECT * FROM Event LIMIT ? OFFSET ?';
        const results = await pool.query(eventQuery, [limit, offset]);
        console.log("Event", results[0]);
        return res.status(200).json({ events: results[0] });
    } catch (error) {
        console.error('Error fetching events:', error);
        return res.status(500).json({ error: 'Database query error' });
    }
};

// ✅ Get details of a specific event by EID
export const getIndividualEvent = async (req, res) => {
    const { EID } = req.body;

if (!EID) {
        return res.status(400).json({ error: 'EID is required' });
    }

try {
        const eventQuery = 'SELECT * FROM Event WHERE EID = ?';
        const results = await pool.query(eventQuery, [EID]);

if (results.length === 0) {
            return res.status(404).json({ error: 'Event not found' });
        }

return res.status(200).json({ event: results[0] });
    } catch (error) {
        console.error('Error fetching event:', error);
        return res.status(500).json({ error: 'Database query error' });
    }
};

Urban Research Lab

The Urban Research Lab (URL) at IIIT-Delhi was established in 2020, during a time when the pandemic brought the complexities of urban life more visible than ever. What started as an initiative by faculty and students has grown into a collaborative space for critically exploring and reimagining the urban questions through research, dialogue, and interdisciplinary engagement.

${this.title}

Code Editor : event.controller.js

Urban Research Lab