dare

import Dare from 'dare'; import mysql from 'mysql2/promise'; // or 'pg' for PostgreSQL // Configure your database connection const dbconn = mysql.createPool({ host: process.env.DB_HOST ?? 'localhost', user: process.env.DB_USER ?? 'root', password: process.env.DB_PASSWORD ?? '', database: process.env.DB_NAME ?? 'testdb' }); // Initiate Dare instance, specifying the database engine const dare = new Dare({ engine: 'mysql:8.0' // or 'postgres:16' }); // Define the handler for database requests dare.execute = async (request) => { console.log('Executing SQL:', request.sql, request.values); const [rows] = await dbconn.query(request.sql, request.values); // For DML operations, return an object with insertId/affectedRows if (request.type !== 'select') { return { insertId: rows.insertId, affectedRows: rows.affectedRows }; } return rows; }; async function runExample() { try { // Make a request to get a user const user = await dare.get('users', ['id', 'name', {emailAddress: 'email'}], {id: 1}); if (user) { console.log(`User found: ${user.name} with email ${user.emailAddress}`); } else { console.log('User not found.'); } // Example of an insert operation const insertResult = await dare.post('users', { name: 'Jane Doe', email: 'jane.doe@example.com' }); console.log(`Inserted user with ID: ${insertResult.insertId}`); } catch (error) { console.error('Dare operation failed:', error.message); } finally { await dbconn.end(); // Close the database connection pool } } runExample();