Class SqliteEngine

src/database-engines/sqlite-engine.ts:7–599

import { buildWhereClause } from '../services/sql';

export class SqliteEngine implements DatabaseEngine {
  private db: Database | null = null;
  public dbPath: string;
  private inMemory: boolean;

  constructor(dbPath: string = ':memory:') {
    this.dbPath = dbPath;
    this.inMemory = dbPath === ':memory:';
  }

  getType(): KnexClient {
    return 'sqlite';
  }

  getFilename(): string {
    return this.dbPath;
  }

  getConnection(): CustomSqliteEngine | null {
    if (this.db) {
      return this.db as any as CustomSqliteEngine;
    }

    try {
      this.db = new Database(this.dbPath, (err) => {
        if (err) {
          throw new Error(String(err));
        }
      });

      return this.db as any as CustomSqliteEngine;
    } catch (err) {
      reportError(`SQLite connection error: ${err}`);
      return null;
    }

  }

  async isOkay(): Promise<boolean> {
    try {
      const db = this.getConnection();

      if (!db) {
        return false
      }

      if (this.inMemory) {
        return true
      }

      const stats = await stat(this.dbPath);
      const fileSizeGB = Math.round((stats.size / (1024 * 1024 * 1024) + Number.EPSILON) * 100) / 100; // Convert to GB and round to 2 decimal places
      const size = 5;

      if (fileSizeGB > size) {
        reportError(`Warning: SQLite database file size too big for database integrity check: ${fileSizeGB}GB. Maximum size is ${size}GB. Hence, database integrity not checked. File: ${this.dbPath}`);
        return true;
      }