src/snac/server/database/SQL.php
/**
     * Insert Resource Language
     *
     * Insert (updated or new) version of the given language for a resource
     *
     * @param int $resourceID The resource ID
     * @param int $resourceVersion The resource version
     * @param int $id The id for this language (if null, one will be generated)
     * @param int $languageID The language ID from the vocabulary table
     * @param int $scriptID The script ID from the vocabulary table
     * @param string $vocabularySource The source for this vocab term
     * @param string $note The descriptive note for this language
     * @param boolean $is_deleted Whether Resource Language is deleted
     * @return int The ID for the language just written
     */
Insert Resource Language
Insert (updated or new) version of the given language for a resource


Insert Resource Language Insert ( updated or new ) version of the given language for a resource
public function insertResourceLanguage($resourceID, $resourceVersion, $id, $languageID, $scriptID, $vocabularySource, $note, $is_deleted)
    {
        if (! $id)
        {
            $id = $this->selectResourceID();
        }
        $qq = 'insert_resource_language';
        $this->sdb->prepare($qq,
                            'insert into resource_language
                            (resource_id, version, id, language_id, script_id, vocabulary_source, note, is_deleted)
                            values
                            ($1, $2, $3, $4, $5, $6, $7, $8)');
        $eArgs = array($resourceID,
                       $resourceVersion,
                       $id,
                       $languageID,
                       $scriptID,
                       $vocabularySource,
                       $note,
                       $this->sdb->boolToPg($is_deleted));
        $result = $this->sdb->execute($qq, $eArgs);
        $this->sdb->deallocate($qq);
        return $id;
    }
public function insertResourceLanguage ( $ resourceID , $ resourceVersion , $ id , $ languageID , $ scriptID , $ vocabularySource , $ note , $ is_deleted ) { if ( ! $ id ) { $ id = $ this -> selectResourceID ( ) ; } $ qq = 'insert_resource_language' ; $ this -> sdb -> prepare ( $ qq , 'insert into resource_language
                            (resource_id, version, id, language_id, script_id, vocabulary_source, note, is_deleted)
                            values
                            ($1, $2, $3, $4, $5, $6, $7, $8)' ) ; $ eArgs = array ( $ resourceID , $ resourceVersion , $ id , $ languageID , $ scriptID , $ vocabularySource , $ note , $ this -> sdb -> boolToPg ( $ is_deleted ) ) ; $ result = $ this -> sdb -> execute ( $ qq , $ eArgs ) ; $ this -> sdb -> deallocate ( $ qq ) ; return $ id ; }
Insert Resource Language
 Insert (updated or new) version of the given language for a resource
Insert Resource Language Insert ( updated or new ) version of the given language for a resource