odari-db-connector

A utility library for database connections.

Installation

npm install odari-db-connector

Usage

Database Connection

Use the DatabaseConnector class to connect to various database types.

import { DatabaseConnector } from 'odari-db-connector';

// MySQL connection
const mysqlConnector = new DatabaseConnector({
  type: 'mysql',
  host: 'localhost',
  port: 3306,
  database: 'mydb',
  user: 'root',
  password: 'password'
});

const mysqlConnection = await mysqlConnector.connect();

// PostgreSQL connection
const pgConnector = new DatabaseConnector({
  type: 'postgresql',
  host: 'localhost',
  port: 5432,
  database: 'mydb',
  user: 'postgres',
  password: 'password'
});

const pgConnection = await pgConnector.connect();

// MongoDB connection
const mongoConnector = new DatabaseConnector({
  type: 'mongodb',
  host: 'localhost',
  port: 27017,
  database: 'mydb',
  user: 'admin',
  password: 'password'
});

const mongoConnection = await mongoConnector.connect();

// SQL Server connection
const sqlServerConnector = new DatabaseConnector({
  type: 'sqlserver',
  server: 'localhost',
  port: 1433,
  database: 'mydb',
  user: 'sa',
  password: 'password'
});

const sqlServerConnection = await sqlServerConnector.connect();

// SQLite connection
const sqliteConnector = new DatabaseConnector({
  type: 'sqlite',
  filename: './database.db'
});

const sqliteConnection = await sqliteConnector.connect();

// Disconnect when done
await mysqlConnector.disconnect();