src/snac/server/database/SQL.php
/**
     * Insert otherID record
     *
     * Insert an ID from records that were merged into this constellation. For the sake of convention, we put
     * the SQL columns in the same order as the function args.
     *
     * @param string[] $vhInfo associative list with keys: version, ic_id
     *
     * @param int $id The id of this record, otherid.id
     *
     * @param string $text The text of the SameAs object.
     *
     * @param integer $typeID Vocabulary id foreign key for the type of this otherID. Probably the ids for
     * MergedRecord, viafID. From the SameAs object.
     *
     * @param string $uri The URI of the other record, probably the SNAC ARK as a URI/URL. From the SameAs
     * object.
     *
     */
Insert otherID record
Insert an ID from records that were merged into this constellation. For the sake of convention, we put
the SQL columns in the same order as the function args.

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

@param int $id The id of this record, otherid.id

@param string $text The text of the SameAs object.

@param integer $typeID Vocabulary id foreign key for the type of this otherID. Probably the ids for
MergedRecord, viafID. From the SameAs object.

@param string $uri The URI of the other record, probably the SNAC ARK as a URI/URL. From the SameAs
object.
Insert otherID record Insert an ID from records that were merged into this constellation . For the sake of convention we put the SQL columns in the same order as the function args . @param string [] $vhInfo associative list with keys : version ic_id @param int $id The id of this record otherid . id @param string $text The text of the SameAs object . @param integer $typeID Vocabulary id foreign key for the type of this otherID . Probably the ids for MergedRecord viafID . From the SameAs object . @param string $uri The URI of the other record probably the SNAC ARK as a URI / URL . From the SameAs object .
public function insertOtherID($vhInfo, $id, $text, $typeID, $uri)
    {
        if (! $id)
        {
            $id = $this->selectID();
        }
        $qq = 'insert_other_id';
        $this->sdb->prepare($qq,
                            'insert into otherid
                            (version, ic_id, id, text, type, uri)
                            values
                            ($1, $2, $3, $4, $5, $6)');
        $result = $this->sdb->execute($qq,
                                      array($vhInfo['version'],
                                            $vhInfo['ic_id'],
                                            $id,
                                            $text,
                                            $typeID,
                                            $uri));
        $this->sdb->deallocate($qq);
        return $id;
    }
public function insertOtherID ( $ vhInfo , $ id , $ text , $ typeID , $ uri ) { if ( ! $ id ) { $ id = $ this -> selectID ( ) ; } $ qq = 'insert_other_id' ; $ this -> sdb -> prepare ( $ qq , 'insert into otherid
                            (version, ic_id, id, text, type, uri)
                            values
                            ($1, $2, $3, $4, $5, $6)' ) ; $ result = $ this -> sdb -> execute ( $ qq , array ( $ vhInfo [ 'version' ] , $ vhInfo [ 'ic_id' ] , $ id , $ text , $ typeID , $ uri ) ) ; $ this -> sdb -> deallocate ( $ qq ) ; return $ id ; }
Insert otherID record
 Insert an ID from records that were merged into this constellation.
Insert otherID record Insert an ID from records that were merged into this constellation .