database-js2

const Connection = require('database-js2').Connection; const fs = require('fs'); const path = require('path'); const dbPath = path.join(__dirname, 'test.sqlite'); // Create a dummy SQLite database file if it doesn't exist if (!fs.existsSync(dbPath)) { fs.writeFileSync(dbPath, ''); } // Ensure the SQLite driver is installed: npm install database-js-sqlite // If using 'mysql' or 'postgres', install their respective drivers. const conn = new Connection(`sqlite:///${dbPath}`); async function runExample() { try { // Create a table if it doesn't exist await conn.prepareStatement("CREATE TABLE IF NOT EXISTS states (id INTEGER PRIMARY KEY, name TEXT)").query(); console.log("Table 'states' ensured."); // Insert some data await conn.prepareStatement("INSERT INTO states (name) VALUES (?)").query("California"); await conn.prepareStatement("INSERT INTO states (name) VALUES (?)").query("Texas"); await conn.prepareStatement("INSERT INTO states (name) VALUES (?)").query("Florida"); console.log("Data inserted."); // Query data with a prepared statement const statement = conn.prepareStatement("SELECT * FROM states WHERE name = ?"); const results = await statement.query("Texas"); console.log("Query Results for 'Texas':", results); // Close the connection await conn.close(); console.log("Connection closed. Example finished."); } catch (reason) { console.error("Error during example execution:", reason); if (conn) { try { await conn.close(); } catch (closeReason) { console.error("Error closing connection:", closeReason); } } } } runExample();