${googleSheetsConfig.client_id}
${process.env.DB_USER}
`; res.send(html); }); app.get('/latebus/auth/callback', async (req, res) => { const code = req.query.code; // Get the authorization code from the query parameters // Exchange the authorization code for tokens const { tokens } = await oAuth2Client.getToken(code); oAuth2Client.setCredentials(tokens); // Redirect back to the homepage or wherever you want res.redirect('/'); }); //Fetch data from Google Sheets and update MySQL database app.get('/latebus/update', async (req, res) => { try { // Use the stored refresh token to refresh the access token if needed if (oAuth2Client.isTokenExpiring()) { const { tokens } = await oAuth2Client.refreshAccessToken(); oAuth2Client.setCredentials(tokens); } const access_token = oAuth2Client.credentials.access_token; const sheets = sheetsAPI({ version: 'v4', auth: access_token }); const response = await sheets.spreadsheets.values.get({ spreadsheetId: '1DuQLObIlPL1TQHY4Mk76xEve7j6qUsnOLCL0VnIr6HA', range: 'LateToday!A:E', }); const query = ` INSERT INTO LateToday (school_building_shortcode, route_number, running_late_minutes, date, time_logged, time_expired) VALUES ? ON DUPLICATE KEY UPDATE school_building_shortcode = VALUES(school_building_shortcode), route_number = VALUES(route_number), running_late_minutes = VALUES(running_late_minutes), date = VALUES(date), time_logged = VALUES(time_logged), time_expired = VALUES(time_expired) `; const values = rows.map(row => { return [ row[0], // School Building Shortcode row[1], // Route Number row[2], // Running Late (Minutes) row[3], // Date row[4], // Time Logged row[5] // Time Expired ]; }); dbPool.query(query, [values], (error, results) => { if (error) { console.error('Error inserting/updating data:', error); res.status(500).send('An error occurred while inserting/updating data.'); } else { // You might want to handle deletions here if applicable console.log('Data inserted/updated successfully.'); res.send('Data inserted/updated successfully.'); } }); } catch (error) { console.error('Error updating data:', error); res.status(500).send('An error occurred while updating data.'); } }); app.get('/latebus/latetoday', (req, res) => { const query = 'SELECT * FROM LateToday'; // Change if needed dbPool.getConnection((error, connection) => { if (error) { console.error('Error getting connection from pool:', error); res.status(500).json({ error: 'Internal Server Error' }); } else { connection.query(query, (error, results) => { connection.release(); // Release the connection back to the pool if (error) { console.error('Error fetching data from database:', error); res.status(500).json({ error: 'Internal Server Error' }); } else { res.json(results); } }); } }); }); app.get('/latebus', (req, res) => { res.send('Thank you for visiting the Late Bus page!'); }); app.listen(port, () => { console.log(`Server is running on port ${port}`); });