public function testNotes() { $this->object->setLoadState(KVDthes_Term::LS_NOTES); $this->object->setLoadState(KVDthes_Term::LS_REL); $this->object->setLoadState(KVDthes_Term::LS_MATCH); $this->object->setScopeNote('SN'); $this->object->setHistoryNote('HN'); $this->object->setIndexingNote('IN'); $this->object->setSourceNote('SoN'); $this->assertEquals('SN', $this->object->getScopeNote()); $this->assertEquals('HN', $this->object->getHistoryNote()); $this->assertEquals('IN', $this->object->getIndexingNote()); $this->assertEquals('SoN', $this->object->getSourceNote()); }
/** * insertNotes * * @param KVDthes_Term $term * @return void */ protected function insertNotes(KVDthes_Term $term) { $sql = sprintf('INSERT INTO %s.notes ( thesaurus_id, term_id, scope_note, source_note, indexing_note, history_note ) VALUES ( %s, ?, ?, ?, ?, ?)', $this->parameters['schema'], $this->parameters['thesaurus_id']); $stmt = $this->conn->prepare($sql); $stmt->bindValue(1, $term->getId(), PDO::PARAM_INT); $stmt->bindValue(2, $term->getScopeNote(), PDO::PARAM_STR); $stmt->bindValue(3, $term->getSourceNote(), PDO::PARAM_STR); $stmt->bindValue(4, $term->getIndexingNote(), PDO::PARAM_STR); $stmt->bindValue(5, $term->getHistoryNote(), PDO::PARAM_STR); $stmt->execute(); return $term; }