mysql-all-in-one

import { DataAccessObject } from 'mysql-all-in-one'; const dao = new DataAccessObject({ host: process.env.DB_HOST ?? 'localhost', user: process.env.DB_USER ?? 'root', password: process.env.DB_PASSWORD ?? '1234', port: Number(process.env.DB_PORT ?? 3306), database: process.env.DB_DATABASE ?? 'test_database' }); const main = async () => { try { // Example: Create a table if it doesn't exist await dao.query('CREATE TABLE IF NOT EXISTS my_table (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), age INT)'); console.log('Table my_table ensured.'); // Example: Insert data await dao.insert({ into: 'my_table', values: { name: 'Alice', age: 30 } }); await dao.insert({ into: 'my_table', values: { name: 'Bob', age: 24 } }); console.log('Inserted sample data.'); // Example: Select all rows const result = await dao.select({ from: 'my_table' }); console.log('All rows:', result); // Example: Select with a WHERE clause const specificResult = await dao.select({ from: 'my_table', where: { name: 'Alice' } }); console.log('Alice data:', specificResult); } catch (error) { console.error('Database operation failed:', error); } finally { // Disconnect if the DAO doesn't handle pooling internally (or if explicit close is needed) // The current DAO design maintains connection, explicit close might depend on `mysql2`'s pooling behavior. // For simple scripts, allowing process to exit is common. } }; main();