Method getChildren

src/tree/schemaNode.ts:32–75

()

  }

  public async getChildren(): Promise<INode[]> {
    const connection = await Database.createConnection(this.connection);
    const configVirtFolders = Global.Configuration.get<Array<string>>("virtualFolders");

    try {
      const res = await connection.query(`
      SELECT
        c.relname as "name",
        (c.relkind IN ('r', 'f')) as is_table,
        (c.relkind = 'f') as is_foreign,
        n.nspname as "schema"
      FROM
        pg_catalog.pg_class c
        JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
      WHERE
        c.relkind in ('r', 'v', 'm', 'f')
        AND n.nspname = $1
        AND has_table_privilege(quote_ident(n.nspname) || '.' || quote_ident(c.relname), 'SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER') = true
      ORDER BY
        c.relname;`, [this.schemaName]);

      let childs = [];
      if (configVirtFolders != null)
      {
        if (configVirtFolders.indexOf("functions") !== -1) {
          childs.push(new FunctionFolderNode(this.connection, this.schemaName));
        }
      }
      // Append tables under virtual folders
      return childs.concat(res.rows.map<TableNode>(table => {
        return new TableNode(
          this.connection,
          table.name,
          table.is_table,
          table.is_foreign,
          table.schema
        );
      }));
    } catch(err) {
      return [new InfoNode(err)];
    } finally {
      await connection.end();
    }
  }
}