dbinfoz

import { getDatabaseAdapter } from 'dbinfoz'; import type { DatabaseConfig, DatabaseAdapter } from 'dbinfoz'; // Configuration for a SQLite database. Replace with your actual database details. const sqliteConfig: DatabaseConfig = { filename: process.env.SQLITE_DB_PATH ?? './mydb.sqlite', }; // Configuration for a PostgreSQL database. Remember to install 'pg' separately. const postgresConfig: DatabaseConfig = { host: process.env.PG_DB_HOST ?? 'localhost', user: process.env.PG_DB_USER ?? 'yourUsername', database: process.env.PG_DB_NAME ?? 'yourDatabase', password: process.env.PG_DB_PASSWORD ?? 'yourPassword', port: parseInt(process.env.PG_DB_PORT ?? '5432', 10), }; // Choose your database type and config const type: 'sqlite' | 'postgres' = 'sqlite'; // or 'postgres', 'mysql', 'mssql' const config = type === 'sqlite' ? sqliteConfig : postgresConfig; // Use appropriate config (async () => { let dbAdapter: DatabaseAdapter | null = null; try { dbAdapter = getDatabaseAdapter(type, config); console.log(`Connected to ${type} database.`); // List tables const tables = await dbAdapter.listTables(); console.log('Tables:', tables); // Example: Get schema for a specific table (if it exists) if (tables.length > 0) { const firstTable = tables[0]; console.log(`Schema for table '${firstTable}':`); const schema = await dbAdapter.getTableSchema(firstTable); console.log(schema); } // Run a custom query (example: create a table for sqlite if not exists) if (type === 'sqlite') { await dbAdapter.runQuery('CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT);'); console.log('Checked/created users table.'); } } catch (error: any) { console.error('Error:', error.message); } finally { // Some adapters (like SQLite) might have a 'close' method if (dbAdapter && typeof (dbAdapter as any).close === 'function') { await (dbAdapter as any).close(); console.log('Database connection closed.'); } } })();