Method getColumns

src/database-engines/sqlite-engine.ts:178–237

(table: string)

  }

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

      type TableColumn = { "type": string, name: string, notnull: number, pk: number }

      const columnsPromise = new Promise<TableColumn[]>((resolve, reject) => {
        db.all(`PRAGMA table_info(${this.escapeIdentifier(table)})`, (err, rows) => {
          if (err) {
            reportError(`SQLite get columns error: ${err}`);
            reject(err);
            return;
          }
          resolve(rows);
        });
      });

      // Get foreign key information
      const foreignKeysPromise = new Promise<any[]>((resolve, reject) => {
        db.all(`PRAGMA foreign_key_list(${this.escapeIdentifier(table)})`, (err, rows) => {
          if (err) {
            reportError(`SQLite get foreign keys error: ${err}`);
            reject(err);
            return;
          }
          resolve(rows);
        });
      });

      const [columns, foreignKeys] = await Promise.all([columnsPromise, foreignKeysPromise]);

      const editableColumnTypeNamesLowercase = this.getEditableColumnTypeNamesLowercase()

      return columns.map((column): Column => {
        const foreignKey = foreignKeys.find(fk => fk.from === column.name);

        const col: Column = {
          name: column.name,
          type: column.type,
          isNullable: column.notnull === 0,
          isPrimaryKey: column.pk > 0,
          isNumeric: this.getNumericColumnTypeNamesLowercase().includes(column.type.toLowerCase()),
          isPlainTextType: this.getPlainStringTypes().includes(column.type.toLowerCase()),
          isEditable: editableColumnTypeNamesLowercase.includes(column.type.toLowerCase()) || editableColumnTypeNamesLowercase.some(edtiableColumn => column.type.toLowerCase().startsWith(edtiableColumn)),
          foreignKey: foreignKey ? {
            table: foreignKey.table,
            column: foreignKey.to
          } : undefined
        }

        return col
      });
    } catch (err) {
      reportError(`SQLite get columns error: ${err}`);
      return [];