Method getChildren

src/tree/tableNode.ts:42–75

()

  }

  public async getChildren(): Promise<INode[]> {
    const connection = await Database.createConnection(this.connection);
    //config.get<boolean>("prettyPrintJSONfields") ? `.jsonb-field, .json-field { white-space: pre; }` : ``;
    const configSort = Global.Configuration.get<string>("tableColumnSortOrder");
    const sortOptions = {
      "db-order": 'a.attnum',
      "alpha": 'a.attname',
      "reverse-alpha": 'a.attname DESC'
    };
    if (!sortOptions[configSort]) sortOptions[configSort] = 'a.attnum';

    let tableSchema = this.schema ? this.schema : 'public';
    let query = SqlQueryManager.getVersionQueries(connection.pg_version);
    
    try {
      let res: QueryResult = null;

      // sorting is done via format - other fields through parameterized queries
      res = await connection.query(query.format(query.TableColumns, sortOptions[configSort]), [
        this.getQuotedTableName(),
        this.connection.database,
        tableSchema,
        this.table
      ])

      return res.rows.map<ColumnNode>(column => {
        return new ColumnNode(this.connection, this.table, column);
      });
    } catch(err) {
      return [new InfoNode(err)];
    } finally {
      await connection.end();
    }
  }
}