src/snac/server/database/SQL.php
/**
    * select entity IDs
    *
    * These were originally ID values of external records for the same entity. DBUtils has code that adds an entityID to a
    * Constellation object.
    *
    * @param string[] $vhInfo associative list with keys: version, ic_id
    *
    * @return string[] Return an associative ist of otherid rows with keys: id, version, ic_id, text, uri,
    * type, link_type. otherid.type is an integer fk id from vocabulary, not that we need to concern
    * ourselves with that here.
    *
    */
select entity IDs
These were originally ID values of external records for the same entity. DBUtils has code that adds an entityID to a
Constellation object.

@param string[] $vhInfo associative list with keys: version, ic_id

@return string[] Return an associative ist of otherid rows with keys: id, version, ic_id, text, uri,
type, link_type. otherid.type is an integer fk id from vocabulary, not that we need to concern
ourselves with that here.
select entity IDs These were originally ID values of external records for the same entity . DBUtils has code that adds an entityID to a Constellation object . @param string [] $vhInfo associative list with keys : version ic_id @return string [] Return an associative ist of otherid rows with keys : id version ic_id text uri type link_type . otherid . type is an integer fk id from vocabulary not that we need to concern ourselves with that here .
public function selectEntityID($vhInfo)
    {
        $qq = 'sedid';
        $this->sdb->prepare($qq,
            'select
                    aa.id, aa.version, aa.ic_id, aa.text, aa.uri, aa.type
                from entityid as aa,
                    (select id,max(version) as version from entityid where version<=$1 and ic_id=$2 group by id) as bb
                where
                    aa.id = bb.id and
                    aa.version = bb.version order by id asc');
        $all = array();
        $result = $this->sdb->execute($qq, array($vhInfo['version'], $vhInfo['ic_id']));
        while($row = $this->sdb->fetchrow($result))
        {
            array_push($all, $row);
        }
        $this->sdb->deallocate($qq);
        return $all;
    }
public function selectEntityID ( $ vhInfo ) { $ qq = 'sedid' ; $ this -> sdb -> prepare ( $ qq , 'select
                    aa.id, aa.version, aa.ic_id, aa.text, aa.uri, aa.type
                from entityid as aa,
                    (select id,max(version) as version from entityid where version<=$1 and ic_id=$2 group by id) as bb
                where
                    aa.id = bb.id and
                    aa.version = bb.version order by id asc' ) ; $ all = array ( ) ; $ result = $ this -> sdb -> execute ( $ qq , array ( $ vhInfo [ 'version' ] , $ vhInfo [ 'ic_id' ] ) ) ; while ( $ row = $ this -> sdb -> fetchrow ( $ result ) ) { array_push ( $ all , $ row ) ; } $ this -> sdb -> deallocate ( $ qq ) ; return $ all ; }
select entity IDs
 These were originally ID values of external records for the same entity.
select entity IDs These were originally ID values of external records for the same entity .