database-utils

const { SqlDriver } = require('database-utils'); const sqlDriver = new SqlDriver(); // Example 1: Basic SELECT query let sql = sqlDriver .parameters() .select('*') .from('user') .where('id', 5) .get(); console.log('Generated SQL (Example 1):', sql); // Expected: select * from user where id = 5 // Example 2: SELECT query with parameterized values (demonstrating getQuerySql for prepared statements) let parameterizedSql = sqlDriver .parameters() .select('*') .from('products') .where('category', 'Electronics') .where('price', '>', 100) .getQuerySql(); let query = parameterizedSql[0]; let params = parameterizedSql[1]; console.log('\nGenerated SQL (Example 2 - Query):', query); // Expected: select * from products where category = ? and price > ? console.log('Generated SQL (Example 2 - Parameters):', params); // Expected: ['Electronics', 100] // Note: This library only builds SQL strings; it does not connect to or execute queries against a database. // You would typically pass these generated SQL strings and parameters to an actual database driver (e.g., 'mysql2' or 'pg'). // Example: Illustrating an intended (but potentially unimplemented/buggy) ORM-like interaction /* const { ORM } = require('database-utils'); const MyModel = new ORM('my_table'); async function runOrmExample() { try { // Assuming a 'find' method would exist, but this is highly speculative const data = await MyModel.find({ id: 1 }); console.log('\nORM-like find result:', data); // Or perhaps a 'create' method const newRecord = await MyModel.create({ name: 'Test', value: 123 }); console.log('ORM-like create result:', newRecord); } catch (error) { console.error('\nError during ORM-like operation:', error.message); } } runOrmExample(); */