database-js-ini

import { Connection } from 'database-js'; import * as fs from 'fs'; const iniContent = ` [SERVER] port=8080 host=localhost [DATABASE] type=sqlite filepath=/tmp/data.db `; const iniFilePath = './config.ini'; // Create a temporary INI file for the example fs.writeFileSync(iniFilePath, iniContent, 'utf8'); (async () => { let connection: Connection | null = null; try { // Connect using the database-js-ini protocol and specify the INI file path connection = new Connection(`database-js-ini:///${iniFilePath}`); // Query all properties from the [SERVER] section let statement = await connection.prepareStatement("SELECT port, host FROM SERVER"); let serverSettings = await statement.query(); console.log('Server Settings:', serverSettings); // Query all properties from the [DATABASE] section statement = await connection.prepareStatement("SELECT type, filepath FROM DATABASE"); let databaseSettings = await statement.query(); console.log('Database Settings:', databaseSettings); } catch (error) { console.error('An error occurred during INI file access:', error); } finally { if (connection) { await connection.close(); } // Clean up the temporary INI file if (fs.existsSync(iniFilePath)) { fs.unlinkSync(iniFilePath); } } })();