/** * Delete the log with the specified name. * * @param string $logName * * @throws object LoggingException An exception with one of the * following messages defined in org.osid.logging.LoggingException * may be thrown: {@link * org.osid.logging.LoggingException#UNIMPLEMENTED UNIMPLEMENTED}, * {@link org.osid.logging.LoggingException#OPERATION_FAILED * OPERATION_FAILED}, {@link * org.osid.logging.LoggingException#CONFIGURATION_ERROR * CONFIGURATION_ERROR}, {@link * org.osid.logging.LoggingException#PERMISSION_DENIED * PERMISSION_DENIED}, {@link * org.osid.logging.LoggingException#UNKNOWN_NAME UNKNOWN_NAME} * * @access public */ function deleteLog($logName) { $log = $this->getLogForWriting($logName); $log = null; $dbc = Services::getService("DatabaseManager"); // get the entry Ids $query = new SelectQuery(); $query->addColumn("id"); $query->addTable("log_entry"); $query->addWhere("log_name = '" . addslashes($logName) . "'"); $result = $dbc->query($query, $this->_dbIndex); $entryIds = array(); while ($result->hasMoreRows()) { $entryIds[] = "'" . addslashes($result->field("id")) . "'"; $result->advanceRow(); } $result->free(); // delete the agent keys $query = new DeleteQuery(); $query->setTable("log_agent"); $query->addWhere("fk_entry IN (" . implode(", ", $entryIds) . ")"); $dbc->query($query, $this->_dbIndex); // delete the node keys $query->setTable("log_node"); $dbc->query($query, $this->_dbIndex); // delete the entries $query = new DeleteQuery(); $query->setTable("log_entry"); $query->addWhere("log_name = '" . addslashes($logName) . "'"); $dbc->query($query, $this->_dbIndex); }
/** * Remove a student from the roster. * * @param object Id $agentId * * @throws object CourseManagementException An exception * with one of the following messages defined in * org.osid.coursemanagement.CourseManagementException may be * thrown: {@link * org.osid.coursemanagement.CourseManagementException#OPERATION_FAILED * OPERATION_FAILED}, {@link * org.osid.coursemanagement.CourseManagementException#PERMISSION_DENIED * PERMISSION_DENIED}, {@link * org.osid.coursemanagement.CourseManagementException#CONFIGURATION_ERROR * CONFIGURATION_ERROR}, {@link * org.osid.coursemanagement.CourseManagementException#UNIMPLEMENTED * UNIMPLEMENTED}, {@link * org.osid.coursemanagement.CourseManagementException#NULL_ARGUMENT * NULL_ARGUMENT}, {@link * org.osid.coursemanagement.CourseManagementException#UNKNOWN_ID * UNKNOWN_ID} * * @access public */ function removeStudent(Id $agentId) { $dbManager = Services::getService("DatabaseManager"); $query = new DeleteQuery(); $query->setTable('cm_enroll'); $query->addWhere("fk_cm_section='" . addslashes($this->_id->getIdString()) . "'"); $query->addWhere("fk_student_id='" . addslashes($agentId->getIdString()) . "'"); $dbManager->query($query); }
/** * Delete the specified CourseGradeRecord by Id. courseGradeRecordId * * @param object Id $courseGradeRecordId * * @throws object CourseManagementException An exception * with one of the following messages defined in * org.osid.coursemanagement.CourseManagementException may be * thrown: {@link * org.osid.coursemanagement.CourseManagementException#OPERATION_FAILED * OPERATION_FAILED}, {@link * org.osid.coursemanagement.CourseManagementException#PERMISSION_DENIED * PERMISSION_DENIED}, {@link * org.osid.coursemanagement.CourseManagementException#CONFIGURATION_ERROR * CONFIGURATION_ERROR}, {@link * org.osid.coursemanagement.CourseManagementException#UNIMPLEMENTED * UNIMPLEMENTED}, {@link * org.osid.coursemanagement.CourseManagementException#NULL_ARGUMENT * NULL_ARGUMENT}, {@link * org.osid.coursemanagement.CourseManagementException#UNKNOWN_ID * UNKNOWN_ID} * * @access public */ function deleteCourseGradeRecord(Id $courseGradeRecordId) { ArgumentValidator::validate($courseGradeRecordId, ExtendsValidatorRule::getRule("Id"), true); $dbManager = Services::getService("DatabaseManager"); $query = new DeleteQuery(); $query->setTable('cm_grade_rec'); $query->addWhere("id=" . addslashes($courseGradeRecordId->getIdString())); $dbManager->query($query); }
/** * Remove the mapping between AuthNTokens and an Agent * * @param object AgentTokenMapping $mapping * @return void * @access public * @since 3/9/05 */ function deleteMapping(AgentTokenMapping $mapping) { $this->_checkConfig(); $dbc = Services::getService("DatabaseManager"); $dbc->beginTransaction($this->_dbId); $agentId = $mapping->getAgentId(); $authNTokens = $mapping->getTokens(); $typeKey = $this->_getTypeKey($mapping->getAuthenticationType()); // Delete the mapping. $query = new DeleteQuery(); $query->setTable($this->_mappingTable); $query->addWhere("agent_id='" . addslashes($agentId->getIdString()) . "'"); $query->addWhere("token_identifier='" . addslashes($authNTokens->getIdentifier()) . "'", _AND); $query->addWhere("fk_type='" . addslashes($typeKey) . "'", _AND); $result = $dbc->query($query, $this->_dbId); // Delete the type if nothing is referencing it. $query = new SelectQuery(); $query->addTable($this->_mappingTable); $query->addColumn("COUNT(*)", "count"); $query->addWhere("fk_type='" . addslashes($typeKey) . "'"); $result = $dbc->query($query, $this->_dbId); if ($result->getNumberOfRows() == 0) { $query = new DeleteQuery(); $query->addTable($this->_typeTable); $query->addWhere("id='" . addslashes($typeKey) . "'"); $result = $dbc->query($query, $this->_dbId); } $result->free(); $dbc->commitTransaction($this->_dbId); }
/** * Remove a Topic for this CanonicalCourse. * * @param string $topic * * @throws object CourseManagementException An exception * with one of the following messages defined in * org.osid.coursemanagement.CourseManagementException may be * thrown: {@link * org.osid.coursemanagement.CourseManagementException#OPERATION_FAILED * OPERATION_FAILED}, {@link * org.osid.coursemanagement.CourseManagementException#PERMISSION_DENIED * PERMISSION_DENIED}, {@link * org.osid.coursemanagement.CourseManagementException#CONFIGURATION_ERROR * CONFIGURATION_ERROR}, {@link * org.osid.coursemanagement.CourseManagementException#UNIMPLEMENTED * UNIMPLEMENTED}, {@link * org.osid.coursemanagement.CourseManagementException#NULL_ARGUMENT * NULL_ARGUMENT} * * @access public */ function removeTopic($topic) { $dbManager = Services::getService("DatabaseManager"); $query = new DeleteQuery(); $query->setTable('cm_topics'); $query->addWhere("fk_cm_can='" . $this->_id->getIdString() . "'"); $query->addWhere("topic='" . addslashes($topic) . "'"); $dbManager->query($query); }
/** * Delete a Record. If the specified Record has content that is inherited * by other Records, those other Records will not be deleted, but they * will no longer have a source from which to inherit value changes. * * @param object Id $recordId * * @throws object RepositoryException An exception with one of * the following messages defined in * org.osid.repository.RepositoryException may be thrown: {@link * org.osid.repository.RepositoryException#OPERATION_FAILED * OPERATION_FAILED}, {@link * org.osid.repository.RepositoryException#PERMISSION_DENIED * PERMISSION_DENIED}, {@link * org.osid.repository.RepositoryException#CONFIGURATION_ERROR * CONFIGURATION_ERROR}, {@link * org.osid.repository.RepositoryException#UNIMPLEMENTED * UNIMPLEMENTED}, {@link * org.osid.repository.RepositoryException#NULL_ARGUMENT * NULL_ARGUMENT}, {@link * org.osid.repository.RepositoryException#UNKNOWN_ID UNKNOWN_ID} * * @access public */ function deleteRecord(Id $recordId) { $record = $this->getRecord($recordId); $structure = $record->getRecordStructure(); $structureId = $structure->getId(); // If this is a schema that is hard coded into our implementation, create // a record for that schema. if (in_array($structureId->getIdString(), array_keys($this->_repository->_builtInTypes))) { // Delete all of the Parts for the record $parts = $record->getParts(); while ($parts->hasNext()) { $part = $parts->next(); $record->deletePart($part->getId()); } // Delete the relation for the record. $dbHandler = Services::getService("DatabaseManager"); $query = new DeleteQuery(); $query->setTable("dr_asset_record"); $myId = $this->getId(); $query->addWhere("fk_asset = '" . $myId->getIdString() . "'"); $query->addWhere("fk_record = '" . $recordId->getIdString() . "'"); $result = $dbHandler->query($query, $this->_dbIndex); } else { $recordMgr = Services::getService("RecordManager"); $record = $recordMgr->fetchRecord($recordId->getIdString(), RECORD_FULL); // Check if the record is part of other record sets (assets via inheretance) $myId = $this->getId(); $setsContaining = $recordMgr->getRecordSetIDsContaining($record); $myRecordSet = $recordMgr->fetchRecordSet($myId->getIdString()); // If this is the last asset referencing this record, delete it. $idManager = Services::getService('Id'); if (count($setsContaining) == 1 && $myId->isEqual($idManager->getId($setsContaining[0]))) { $myRecordSet->removeRecord($record); $myRecordSet->commit(TRUE); $record->delete(); $record->commit(TRUE); } else { $myRecordSet = $recordMgr->fetchRecordSet($myId->getIdString()); $myRecordSet->removeRecord($record); $myRecordSet->commit(TRUE); } } $this->updateModificationDate(); }
/** * Delete the DMRecord Set and any records that are referenced only by this record * set and not shared with other record sets. * * @param int $id The Id of the set to delete. * @param optional boolean $prune If TRUE will make sure that the Records are removed * from the database. * @return void * @access public * @since 10/6/04 */ function deleteRecordSet($id, $prune = false) { ArgumentValidator::validate($id, StringValidatorRule::getRule()); $recordSet = $this->fetchRecordSet($id); $recordSet->loadRecords($prune ? RECORD_FULL : RECORD_NODATA); // Delete the records in the set. $records = $recordSet->getRecords(); foreach (array_keys($records) as $key) { $record = $records[$key]; // Only delete records if they are not shared with other sets. $setsContaining = $this->getRecordSetIDsContaining($record); if (count($setsContaining) == 1 && $setsContaing[0] == $id) { $this->deleteRecord($record->getID(), $prune); } } // Delete the set from the database $query = new DeleteQuery(); $query->setTable("dm_record_set"); $query->addWhere("id = '" . addslashes($id) . "'"); $dbHandler = Services::getService("DatabaseManager"); $result = $dbHandler->query($query, DATAMANAGER_DBID); $this->_recordSetCache[$id] = NULL; unset($this->_recordSetCache[$id]); }
/** * Update the value for this Part. * * @param object mixed $value (original type: java.io.Serializable) * * @throws object RepositoryException An exception with one of * the following messages defined in * org.osid.repository.RepositoryException may be thrown: {@link * org.osid.repository.RepositoryException#OPERATION_FAILED * OPERATION_FAILED}, {@link * org.osid.repository.RepositoryException#PERMISSION_DENIED * PERMISSION_DENIED}, {@link * org.osid.repository.RepositoryException#CONFIGURATION_ERROR * CONFIGURATION_ERROR}, {@link * org.osid.repository.RepositoryException#UNIMPLEMENTED * UNIMPLEMENTED}, {@link * org.osid.repository.RepositoryException#NULL_ARGUMENT * NULL_ARGUMENT} * * @access public */ function updateValue($value) { if (!is_null($value)) { ArgumentValidator::validate($value, StringValidatorRule::getRule()); } // Store the name in the object in case its asked for again. $this->_value = $value; // then write it to the database. $dbHandler = Services::getService("DatabaseManager"); // Delete the row if we are setting the value to null if (is_null($value)) { $query = new DeleteQuery(); $query->setTable("dr_file_data"); $query->addWhere("fk_file = '" . $this->_recordId->getIdString() . "'"); $dbHandler->query($query, $this->_configuration->getProperty("database_index")); $this->_asset->updateModificationDate(); return; } // Check to see if the name is in the database // Check to see if the data is in the database $query = new SelectQuery(); $query->addTable("dr_file_url"); $query->addColumn("COUNT(*) as count"); $query->addWhere("fk_file = '" . $this->_recordId->getIdString() . "'"); $result = $dbHandler->query($query, $this->_configuration->getProperty("database_index")); // If it already exists, use an update query. if ($result->field("count") > 0) { $query = new UpdateQuery(); $query->setTable("dr_file_url"); $query->setColumns(array("url")); $query->setValues(array("'" . addslashes($value) . "'")); $query->addWhere("fk_file = '" . $this->_recordId->getIdString() . "'"); } else { $query = new InsertQuery(); $query->setTable("dr_file_url"); $query->setColumns(array("fk_file", "url")); $query->setValues(array("'" . $this->_recordId->getIdString() . "'", "'" . addslashes($value) . "'")); } $result->free(); // run the query $dbHandler->query($query, $this->_configuration->getProperty("database_index")); $this->_asset->updateModificationDate(); }
/** * * Remove a previously added Agent commitment for this ScheduleItem. * * WARNING: NOT IN OSID -- Will likely be added in v3 * * @param object Id $agentId * * @throws object SchedulingException An exception with one of * the following messages defined in * org.osid.scheduling.SchedulingException may be thrown: {@link * org.osid.scheduling.SchedulingException#OPERATION_FAILED * OPERATION_FAILED}, {@link * org.osid.scheduling.SchedulingException#PERMISSION_DENIED * PERMISSION_DENIED}, {@link * org.osid.scheduling.SchedulingException#CONFIGURATION_ERROR * CONFIGURATION_ERROR}, {@link * org.osid.scheduling.SchedulingException#UNIMPLEMENTED * UNIMPLEMENTED}, {@link * org.osid.scheduling.SchedulingException#UNKNOWN_ID UNKNOWN_ID}, * {@link org.osid.scheduling.SchedulingException#UNKNOWN_TYPE * UNKNOWN_TYPE} * * @access public */ function removeAgentCommitment(Id $agentId) { $dbHandler = Services::getService("DBHandler"); $query = new DeleteQuery(); $query->setTable('sc_commit'); $query->addWhere("fk_sc_item='" . addslashes($this->_id->getIdString()) . "'"); $query->addWhere("fk_agent_id='" . addslashes($agentId->getIdString()) . "'"); $res = $dbHandler->query($query); if ($res->getNumberOfRows() == 0) { print "<b>Warning!</b> Agent with Id [" . $agentId->getIdString() . "] is not added to ScheduleItem " . $this->getdisplayName() . " [" . $this->_id->getIdString() . "] yet. Do not delete agents that are not added."; } }
/** * Delete a ScheduleItem by unique Id. * * @param object Id $scheduleItemId * * @throws object SchedulingException An exception with one of * the following messages defined in * org.osid.scheduling.SchedulingException may be thrown: {@link * org.osid.scheduling.SchedulingException#OPERATION_FAILED * OPERATION_FAILED}, {@link * org.osid.scheduling.SchedulingException#PERMISSION_DENIED * PERMISSION_DENIED}, {@link * org.osid.scheduling.SchedulingException#CONFIGURATION_ERROR * CONFIGURATION_ERROR}, {@link * org.osid.scheduling.SchedulingException#UNIMPLEMENTED * UNIMPLEMENTED}, {@link * org.osid.scheduling.SchedulingException#NULL_ARGUMENT * NULL_ARGUMENT}, {@link * org.osid.scheduling.SchedulingException#UNKNOWN_ID UNKNOWN_ID} * * @access public */ function deleteScheduleItem(Id $scheduleItemId) { $dbHandler = Services::getService("DBHandler"); $query = new DeleteQuery(); $query->setTable('sc_item'); $query->addWhere("id=" . addslashes($scheduleItemId->getIdString())); $dbHandler->query($query); $query2 = new DeleteQuery(); $query2->setTable('sc_commit'); $query2->addWhere("fk_sc_item=" . addslashes($scheduleItemId->getIdString())); $dbHandler->query($query); }
/** * Add a PartStructureId for which Tags should be auto-generated, in the * given repository * * @param object Id $repositoryId * @return void * @access public * @since 11/21/06 */ function removePartStructureIdForTagGeneration($repositoryId, $partStructureId) { // Delete it into the database $query = new DeleteQuery(); $query->setTable('tag_part_map'); $query->addWhere("fk_repository='" . addslashes($repositoryId->getIdString()) . "'"); $query->addWhere("fk_partstruct='" . addslashes($partStructureId->getIdString()) . "'"); $dbc = Services::getService("DatabaseManager"); $result = $dbc->query($query, $this->getDatabaseIndex()); // Remove it from the cache if (isset($this->_cache) && isset($this->_cache[$repositoryId->getIdString()])) { for ($i = 0; $i < count($this->_cache[$repositoryId->getIdString()]); $i++) { if ($partStructureId->isEqual($this->_cache[$repositoryId->getIdString()][$i])) { unset($this->_cache[$repositoryId->getIdString()][$i]); } } } }
/** * Remove an authoritative value. * * WARNING: NOT in OSID * * @param object $value * @return void * @access public * @since 4/25/06 */ function removeAuthoritativeValue($value) { if ($this->isAuthoritativeValue($value)) { // remove the object from our objects array if (isset($this->_authoritativeValueObjects[$value->asString()])) { unset($this->_authoritativeValueObjects[$value->asString()]); } // Remove the string from our strings array unset($this->_authoritativeValueStrings[array_search($value->asString(), $this->_authoritativeValueStrings)]); // Remove the value from our database $query = new DeleteQuery(); $query->setTable('dr_authoritative_values'); $id = $this->getId(); $query->addWhere("fk_partstructure = '" . addslashes($id->getIdString()) . "'"); $query->addWhere("fk_repository = '" . addslashes($this->_repositoryId->getIdString()) . "'"); $query->addWhere("value = '" . addslashes($value->asString()) . "'"); $dbc = Services::getService("DBHandler"); $configuration = $this->manager->_configuration; $dbc->query($query, $configuration->getProperty('database_index')); } }
/** * Remove an Asset for this CourseOffering. * * @param object Id $assetId * * @throws object CourseManagementException An exception * with one of the following messages defined in * org.osid.coursemanagement.CourseManagementException may be * thrown: {@link * org.osid.coursemanagement.CourseManagementException#OPERATION_FAILED * OPERATION_FAILED}, {@link * org.osid.coursemanagement.CourseManagementException#PERMISSION_DENIED * PERMISSION_DENIED}, {@link * org.osid.coursemanagement.CourseManagementException#CONFIGURATION_ERROR * CONFIGURATION_ERROR}, {@link * org.osid.coursemanagement.CourseManagementException#UNIMPLEMENTED * UNIMPLEMENTED}, {@link * org.osid.coursemanagement.CourseManagementException#NULL_ARGUMENT * NULL_ARGUMENT}, {@link * org.osid.coursemanagement.CourseManagementException#UNKNOWN_ID * UNKNOWN_ID} * * @access public */ function removeAsset(Id $assetId) { $dbManager = Services::getService("DatabaseManager"); $query = new DeleteQuery(); $query->setTable('cm_assets'); $query->addWhere("fk_course_id='" . $this->_id->getIdString() . "'"); $query->addWhere("fk_asset_id='" . addslashes($assetId->getIdString()) . "'"); $dbManager->query($query); }
/** * Remove all Items from the set. * @access public * @return void */ function removeAllItems() { parent::removeAllItems(); // Remove the item from the database $query = new DeleteQuery(); $query->setTable("sets"); $query->addWhere("id='" . addslashes($this->_setId->getIdString()) . "'"); $dbHandler = Services::getService("DatabaseManager"); $dbHandler->query($query, $this->_dbIndex); }
/** * Delete all properties associated with an object * This is here partially to preserve the option of using non-editable agents * If that ceases to be an issue, this more properly belongs in * HarmoniEditableAgent.class * * @param string $object_id_string * @return boolean * @access public */ function deleteAllProperties($object_id_string) { $dbHandler = Services::getService("DBHandler"); //create a query to remove all properties associated with $object_id_string $query = new DeleteQuery(); $query->setTable("agent_properties"); $query->addWhere("fk_object_id='{$object_id_string}'"); $result = $dbHandler->query($query, $this->_dbIndex); return $result ? true : false; }
/** * Deletes the components for the property from the db * * @param object StyleProperty $sp * @return void * @access public * @since 4/26/06 */ function deleteComponentsForProperty($sp) { $dbHandler = Services::getService("DatabaseManager"); $id = $sp->getId(); $idValue = $id->getIdString(); $query = new DeleteQuery(); $query->setTable($this->_dbName . ".tm_style_component"); $query->addWhere("fk_property_id = {$idValue}"); $result = $dbHandler->query($query, $this->_dbIndex); }
/** * Tests the generateSQLQuery() without WHERE clause. */ function test() { // insert one row $query = new InsertQuery(); $query->setTable("test1"); $query->setColumns(array("value")); $query->addRowOfValues(array("'Spaceboy'")); $query->setAutoIncrementColumn("id", "test1_id_seq"); $result = $this->db->query($query); $lastId = $result->getLastAutoIncrementValue(); // insert it again, the id must have increased by one $result = $this->db->query($query); $this->assertIdentical($result->getNumberOfRows(), 1); $this->assertIdentical($result->getLastAutoIncrementValue(), $lastId + 1); // add several rows at the same time $query->addRowOfValues(array("'Astrogirl'")); $result = $this->db->query($query); $this->assertIdentical($result->getLastAutoIncrementValue(), $lastId + 3); // now insert in the other test table $query = new InsertQuery(); $query->setTable("test"); $query->setColumns(array("FK", "value")); $query->addRowOfValues(array($lastId, "'Ziggy'")); $query->addRowOfValues(array($lastId + 1, "'Lost in the Stars'")); $query->addRowOfValues(array($lastId + 2, "'Headstar'")); $query->addRowOfValues(array($lastId + 3, "'Stardust'")); $query->setAutoIncrementColumn("id", "test1_id_seq"); $result = $this->db->query($query); // join the inserted rows $query = new SelectQuery(); $query->addTable("test1"); $query->addTable("test", INNER_JOIN, "test.FK = test1.id"); $query->addColumn("id", "dm86_id", "test"); $query->addColumn("FK", "dm86_fk", "test"); $query->addColumn("value", "dm86_value", "test"); $query->addColumn("id", "dm98_id", "test1"); $query->addColumn("value", "dm98_value", "test1"); $query->addWhere("test1.id >= " . $lastId); $result = $this->db->query($query); $this->assertIdentical($result->getNumberOfRows(), 4); $this->assertIdentical((int) $result->field("dm86_fk"), $lastId); $this->assertIdentical($result->field("dm86_value"), "Ziggy"); $this->assertIdentical((int) $result->field("dm98_id"), $lastId); $this->assertIdentical($result->field("dm98_value"), "Spaceboy"); $result->advanceRow(); $this->assertIdentical((int) $result->field("dm86_fk"), $lastId + 1); $this->assertIdentical($result->field("dm86_value"), "Lost in the Stars"); $this->assertIdentical((int) $result->field("dm98_id"), $lastId + 1); $this->assertIdentical($result->field("dm98_value"), "Spaceboy"); $result->advanceRow(); $this->assertIdentical((int) $result->field("dm86_fk"), $lastId + 2); $this->assertIdentical($result->field("dm86_value"), "Headstar"); $this->assertIdentical((int) $result->field("dm98_id"), $lastId + 2); $this->assertIdentical($result->field("dm98_value"), "Spaceboy"); $result->advanceRow(); $this->assertIdentical((int) $result->field("dm86_fk"), $lastId + 3); $this->assertIdentical($result->field("dm86_value"), "Stardust"); $this->assertIdentical((int) $result->field("dm98_id"), $lastId + 3); $this->assertIdentical($result->field("dm98_value"), "Astrogirl"); $result->free(); $query = new UpdateQuery(); $query->setTable("test1"); $query->setColumns(array("value")); $query->setValues(array("'I changed you MF!'")); $query->addWhere("id = " . $lastId); $result = $this->db->query($query); $this->assertIdentical($result->getNumberOfRows(), 1); $query = new SelectQuery(); $query->addTable("test1"); $query->addColumn("value"); $query->addWhere("test1.id = " . $lastId); $result = $this->db->query($query); $this->assertIdentical($result->getNumberOfRows(), 1); $this->assertIdentical($result->field("value"), "I changed you MF!"); $result->free(); $query = new DeleteQuery(); $query->setTable("test1"); $query->addWhere("id = " . $lastId); $result = $this->db->query($query); $this->assertIdentical($result->getNumberOfRows(), 1); $query = new SelectQuery(); $query->addTable("test1"); $query->addColumn("value"); $query->addWhere("test1.id = " . $lastId); $result = $this->db->query($query); $this->assertIdentical($result->getNumberOfRows(), 0); $result->free(); }
/** * removes the style collection from the theme, and the DB is called for * * @param boolean $removeFromDatabase whether to remove the data from the database * @param ref object StyleCollection $style the style * @return void * @access public * @since 5/16/06 */ function removeStyleCollection($style, $removeFromDatabase = false) { $guiManager = Services::getService("GUI"); $dbHandler = Services::getService('DBHandler'); $guiManager->deletePropertiesForCollection($style); if (is_object($style->_id)) { $id = $style->getId(); $idValue = $id->getIdString(); $query = new DeleteQuery(); $query->setTable($guiManager->_dbName . ".tm_style_collection"); $query->addWhere("fk_theme_id = {$idValue}"); $result = $dbHandler->query($query, $guiManager->_dbIndex); } unset($this->_styles[$style->getSelector()]); }
/** * Remove the tag everywhere where the current user has added it. * * @return void * @access public * @since 11/2/06 */ function removeAllMine() { $query = new DeleteQuery(); $query->setTable('tag'); $query->addWhere("tag.value='" . addslashes($this->getValue()) . "'"); $query->addWhere("tag.user_id='" . addslashes($this->getCurrentUserIdString()) . "'"); $dbc = Services::getService("DatabaseManager"); $dbc->query($query, $this->getDatabaseIndex()); }
/** * Delete a GradeRecord. The first two parameters are required, but the * third may be left null to dignify any Type * * @param object Id $gradableObjectId * @param object Id $agentId * @param object Type $GradeRecordType * * @throws object GradingException An exception with one of the * following messages defined in org.osid.grading.GradingException * may be thrown: {@link * org.osid.grading.GradingException#OPERATION_FAILED * OPERATION_FAILED}, {@link * org.osid.grading.GradingException#PERMISSION_DENIED * PERMISSION_DENIED}, {@link * org.osid.grading.GradingException#CONFIGURATION_ERROR * CONFIGURATION_ERROR}, {@link * org.osid.grading.GradingException#UNIMPLEMENTED UNIMPLEMENTED}, * {@link org.osid.grading.GradingException#NULL_ARGUMENT * NULL_ARGUMENT}, {@link * org.osid.grading.GradingException#UNKNOWN_ID UNKNOWN_ID} * * @access public */ function deleteGradeRecord(Id $gradableObjectId, Id $agentId, Type $GradeRecordType) { $dbManager = Services::getService("DatabaseManager"); $query = new DeleteQuery(); $query->setTable('gr_record'); $query->addWhere("fk_gr_gradable='" . addslashes($gradableObjectId->getIdString()) . "'"); $query->addWhere("fk_agent_id='" . addslashes($agentId->getIdString()) . "'"); if (!is_null($GradeRecordType)) { $query->addWhere("fk_gr_record_type='" . addslashes($this->_typeToIndex('record', $GradeRecordType)) . "'"); } $dbManager->query($query); }
/** * Delete the item and all tags for it. This should be done when deleting * the thing the item represents * * @param mixed $items This can be a single Item object, an TaggedItemIterator, * or an array of Item objects. * @return void * @access public * @since 11/2/06 */ function deleteItems($items) { $itemDbIds = array(); // array if (is_array($items)) { foreach (array_keys($items) as $key) { $itemDbIds[] = "'" . addslashes($items[$key]->getDatabaseId()) . "'"; } } else { if (method_exists($items, 'next')) { while ($items->hasNext()) { $item = $items->next(); $itemDbIds[] = "'" . addslashes($item->getDatabaseId()) . "'"; } } else { if (method_exists($items, 'getDatabaseId')) { $itemDbIds[] = "'" . addslashes($items->getDatabaseId()) . "'"; } else { throwError(new Error("Invalid parameter, {$items}, for \$items", "Tagging")); } } } if (!count($itemDbIds)) { return; } $dbc = Services::getService("DatabaseManager"); $query = new DeleteQuery(); $query->setTable('tag'); $query->addWhere("tag.fk_item IN (" . implode(", ", $itemDbIds) . ")"); $dbc->query($query, $this->getDatabaseIndex()); $query = new DeleteQuery(); $query->setTable('tag_item'); $query->addWhere("id IN (" . implode(", ", $itemDbIds) . ")"); $dbc->query($query, $this->getDatabaseIndex()); }
/** * Write the cache * * @return void * @access public * @since 2/13/06 */ function writeCache() { $dbc = Services::getService('DatabaseManager'); $query = new DeleteQuery(); $query->setTable('dr_resized_cache'); $query->addWhere("dr_resized_cache.fk_file = '" . addslashes($this->_id->getIdString()) . "'"); $query->addWhere("dr_resized_cache.size = '" . addslashes($this->_size) . "'"); $query->addWhere("dr_resized_cache.websafe = " . ($this->_websafe ? '1' : '0')); $dbc->query($query, $this->getDBIndex()); $query = new InsertQuery(); $query->setTable('dr_resized_cache'); $query->setColumns(array('fk_file', 'size', 'websafe', 'cache_time', 'fk_mime_type', 'data')); $values = array(); $values[] = "'" . addslashes($this->_id->getIdString()) . "'"; $values[] = "'" . addslashes($this->_size) . "'"; $values[] = $this->_websafe ? '1' : '0'; $values[] = "NOW()"; $imgProcessor = Services::getService("ImageProcessor"); if ($this->_websafe) { $this->_mimeType = $imgProcessor->getWebsafeFormat($this->_parts['MIME_TYPE']->getValue()); $values[] = $this->getMimeKey(); $values[] = "'" . addslashes($imgProcessor->getWebsafeData($this->_parts['MIME_TYPE']->getValue(), $this->_size, $this->_parts['FILE_DATA']->getValue())) . "'"; } else { $this->_mimeType = $imgProcessor->getResizedFormat($this->_parts['MIME_TYPE']->getValue()); $values[] = $this->getMimeKey(); $values[] = "'" . addslashes($imgProcessor->getResizedData($this->_parts['MIME_TYPE']->getValue(), $this->_size, $this->_parts['FILE_DATA']->getValue())) . "'"; } $query->addRowOfValues($values); $dbc->query($query, $this->getDBIndex()); }
/** * Update the value for this Part. * * @param object mixed $value (original type: java.io.Serializable) * * @throws object RepositoryException An exception with one of * the following messages defined in * org.osid.repository.RepositoryException may be thrown: {@link * org.osid.repository.RepositoryException#OPERATION_FAILED * OPERATION_FAILED}, {@link * org.osid.repository.RepositoryException#PERMISSION_DENIED * PERMISSION_DENIED}, {@link * org.osid.repository.RepositoryException#CONFIGURATION_ERROR * CONFIGURATION_ERROR}, {@link * org.osid.repository.RepositoryException#UNIMPLEMENTED * UNIMPLEMENTED}, {@link * org.osid.repository.RepositoryException#NULL_ARGUMENT * NULL_ARGUMENT} * * @access public */ function updateValue($value) { // ArgumentValidator::validate($value, StringValidatorRule::getRule()); $dbHandler = Services::getService("DatabaseManager"); // Delete the row if we are setting the value to null if (is_null($value)) { $query = new DeleteQuery(); $query->setTable("dr_file_data"); $query->addWhere("fk_file = '" . $this->_recordId->getIdString() . "'"); $dbHandler->query($query, $this->_configuration->getProperty("database_index")); $this->_asset->updateModificationDate(); return; } // Store the data in the object in case its asked for again. // $this->_data = $value; // Make sure that the dr_file row is inserted. $query = new InsertQuery(); $query->setTable("dr_file"); $query->addValue("id", $this->_recordId->getIdString()); try { $dbHandler->query($query, $this->_configuration->getProperty("database_index")); } catch (QueryDatabaseException $e) { // If an error is thrown inserting (because the file already exists) // ignore it. } $dbHandler->beginTransaction($this->_configuration->getProperty("database_index")); // Base64 encode the data to preserve it, // then write it to the database. // Check to see if the data is in the database $query = new SelectQuery(); $query->addTable("dr_file_data"); $query->addColumn("COUNT(*) as count"); $query->addWhere("fk_file = '" . $this->_recordId->getIdString() . "'"); $result = $dbHandler->query($query, $this->_configuration->getProperty("database_index")); // If it already exists, use an update query. if ($result->field("count") > 0) { $query = new UpdateQuery(); $query->setTable("dr_file_data"); $query->setColumns(array("data")); $query->setValues(array("'" . base64_encode($value) . "'")); $query->addWhere("fk_file = '" . $this->_recordId->getIdString() . "'"); } else { $query = new InsertQuery(); $query->setTable("dr_file_data"); $query->setColumns(array("fk_file", "data")); $query->setValues(array("'" . $this->_recordId->getIdString() . "'", "'" . base64_encode($value) . "'")); } $result->free(); // printpre($query); // printpre(MySQL_SQLGenerator::generateSQLQuery($query)); // run the query $dbHandler->query($query, $this->_configuration->getProperty("database_index")); // Update the size row. $query = new UpdateQuery(); $query->setTable("dr_file"); $query->addValue("size", strval(strlen($value))); $query->addWhereEqual("id", $this->_recordId->getIdString()); $dbHandler->query($query, $this->_configuration->getProperty("database_index")); $dbHandler->commitTransaction($this->_configuration->getProperty("database_index")); $this->_asset->updateModificationDate(); }
/** * Add tokens and associated Properties to the system. * * @param object AuthNTokens $authNTokens * @return void * @access public * @since 3/1/05 */ function deleteTokens($authNTokens) { ArgumentValidator::validate($authNTokens, ExtendsValidatorRule::getRule("AuthNTokens")); if (!$this->tokensExist($authNTokens)) { throwError(new Error("Token Deletion Error: " . "'" . $authNTokens->getUsername() . "' does not exist.", "SQLDatabaseAuthNMethod", true)); } else { $dbc = Services::getService("DatabaseManager"); $dbId = $this->_configuration->getProperty('database_id'); $authenticationTable = $this->_configuration->getProperty('authentication_table'); $usernameField = $this->_configuration->getProperty('username_field'); $passwordField = $this->_configuration->getProperty('password_field'); $query = new DeleteQuery(); $query->setTable($authenticationTable); $query->addWhere($usernameField . "='" . addslashes($authNTokens->getUsername()) . "'"); $result = $dbc->query($query, $dbId); } }