Method getTables

src/database-engines/sqlite-engine.ts:151–176

()

  }

  async getTables(): Promise<string[]> {
    try {
      const db = this.getConnection();
      if (!db) {
        return Promise.reject('Cannot connect to database')
      }

      return new Promise<string[]>((resolve, reject) => {
        const query = `SELECT name FROM sqlite_master WHERE type='table' AND name NOT LIKE 'sqlite_%' ORDER BY name`;

        db.all(query, (err, rows: any[]) => {
          if (err) {
            reportError(`SQLite get tables error: ${err}`);
            reject(err);
            return;
          }

          const tableNames = rows.map(row => row.name);
          resolve(tableNames);
        });
      });
    } catch (err) {
      reportError(`SQLite get tables error: ${err}`);
      return [];
    }
  }

  async getColumns(table: string): Promise<Column[]> {
    try {