Postgres::getFtsMappingByName PHP Method

getFtsMappingByName() public method

Return all information related to a given FTS configuration's mapping
public getFtsMappingByName ( $ftscfg, $mapping ) : FTS
$ftscfg The name of the FTS configuration
$mapping The name of the mapping
return FTS configuration information
    function getFtsMappingByName($ftscfg, $mapping)
    {
        $c_schema = $this->_schema;
        $this->clean($c_schema);
        $this->clean($ftscfg);
        $this->clean($mapping);
        $oidSet = $this->selectSet("SELECT c.oid, cfgparser\n\t\t\tFROM pg_catalog.pg_ts_config AS c\n\t\t\t\tLEFT JOIN pg_catalog.pg_namespace AS n ON n.oid = c.cfgnamespace\n\t\t\tWHERE c.cfgname = '{$ftscfg}'\n\t\t\t\tAND n.nspname='{$c_schema}'");
        $oid = $oidSet->fields['oid'];
        $cfgparser = $oidSet->fields['cfgparser'];
        $tokenIdSet = $this->selectSet("SELECT tokid\n\t\t\tFROM pg_catalog.ts_token_type({$cfgparser})\n\t\t\tWHERE alias = '{$mapping}'");
        $tokid = $tokenIdSet->fields['tokid'];
        $sql = "SELECT\n\t\t\t    (SELECT t.alias FROM pg_catalog.ts_token_type(c.cfgparser) AS t WHERE t.tokid = m.maptokentype) AS name,\n    \t            d.dictname as dictionaries\n\t\t\tFROM pg_catalog.pg_ts_config AS c, pg_catalog.pg_ts_config_map AS m, pg_catalog.pg_ts_dict d\n\t\t\tWHERE c.oid = {$oid} AND m.mapcfg = c.oid AND m.maptokentype = {$tokid} AND m.mapdict = d.oid\n\t\t\tLIMIT 1;";
        return $this->selectSet($sql);
    }
Postgres