HuasoFoundries / phpPgAdmin6

     *

     * @return \PHPPgAdmin\ADORecordSet recordset

     */

    public function getFtsConfigurationMap($ftscfg)

    {

        $c_schema = $this->_schema;

        $this->clean($c_schema);

        $this->fieldClean($ftscfg);

        $oidSet = $this->selectSet("SELECT c.oid

            FROM pg_catalog.pg_ts_config AS c

                LEFT JOIN pg_catalog.pg_namespace n ON (n.oid = c.cfgnamespace)

            WHERE c.cfgname = '{$ftscfg}'

                AND n.nspname='{$c_schema}'");

        $oid = $oidSet->fields['oid'];

        $sql = "

            SELECT

                (SELECT t.alias FROM pg_catalog.ts_token_type(c.cfgparser) AS t WHERE t.tokid = m.maptokentype) AS name,

                (SELECT t.description FROM pg_catalog.ts_token_type(c.cfgparser) AS t WHERE t.tokid = m.maptokentype) AS description,

                c.cfgname AS cfgname, n.nspname ||'.'|| d.dictname as dictionaries

            FROM

                pg_catalog.pg_ts_config AS c, pg_catalog.pg_ts_config_map AS m, pg_catalog.pg_ts_dict d,

                pg_catalog.pg_namespace n

            WHERE

                c.oid = {$oid}

                AND m.mapcfg = c.oid

                AND m.mapdict = d.oid

                AND d.dictnamespace = n.oid

            ORDER BY name

            ";

        return $this->selectSet($sql);

    }

    /**

     * Returns FTS parsers available.

     *

     * @return \PHPPgAdmin\ADORecordSet A recordset

     */

    public function getSequence($sequence)

    {

        $c_schema = $this->_schema;

        $this->clean($c_schema);

        $c_sequence = $sequence;

        $this->fieldClean($sequence);

        $this->clean($c_sequence);

        $sql = "

			SELECT c.relname AS seqname, s.*,

				pg_catalog.obj_description(s.tableoid, 'pg_class') AS seqcomment,

				u.usename AS seqowner, n.nspname

			FROM \"{$sequence}\" AS s, pg_catalog.pg_class c, pg_catalog.pg_user u, pg_catalog.pg_namespace n

			WHERE c.relowner=u.usesysid AND c.relnamespace=n.oid

				AND c.relname = '{$c_sequence}' AND c.relkind = 'S' AND n.nspname='{$c_schema}'

				AND n.oid = c.relnamespace";

        return $this->selectSet($sql);

    }

    /**

     * Creates a new sequence.