/** * converts an object to insert/update data * * @return a comma separated string e.g. "a=1,b=2" */ public function getInsertData($doubleEscaped = false) { $values = ''; if ($this->status != null) { $this->addInsertData($values, 'CS_status', DBJson::mysql_real_escape_string($this->status)); } if ($this->course != null && $this->course->getId() != null) { $this->addInsertData($values, 'C_id', DBJson::mysql_real_escape_string($this->course->getId())); } if ($values != '') { $values = substr($values, 1); } return $doubleEscaped ? DBJson::mysql_real_escape_string($values) : $values; }
function test_getId() { $name = "Math"; $course_number = "662"; $test_course = new Course($name, $course_number); $test_course->save(); $result = $test_course->getId(); $this->assertEquals(true, is_numeric($result)); }
/** * This static method retrieves all the subjects for a course. * * @param Course $course * @return Criteria */ public static function retrieveForCourseCriteria(Course $course) { $c = new Criteria(); $c->add(CourseSubjectPeer::COURSE_ID, $course->getId()); $c->addJoin(CourseSubjectPeer::CAREER_SUBJECT_SCHOOL_YEAR_ID, CareerSubjectSchoolYearPeer::ID, Criteria::INNER_JOIN); $c->addJoin(CareerSubjectSchoolYearPeer::CAREER_SUBJECT_ID, CareerSubjectPeer::ID, Criteria::INNER_JOIN); $c->addJoin(CareerSubjectPeer::SUBJECT_ID, self::ID, Criteria::INNER_JOIN); $c->setDistinct(); return $c; }
function test_getId() { //Arrange $course_name = "Monster Literature"; $course_number = "ENG304"; $id = 1; $test_course = new Course($course_name, $course_number, $id); //Act $result = $test_course->getId(); //Assert $this->assertEquals($id, $result); }
/** * Remove a course subscription * * @param User $user * @param Course $course * @return boolean */ public function unSubscribe($user, $course) { try { $em = $this->getEntityManager(); $subscription = $em->getRepository('R4FSiteBundle:Subscription')->findOneBy(array('user' => $user->getId(), 'course' => $course->getId())); $em->remove($subscription); $em->flush(); return true; } catch (Exception $e) { return false; } }
function testFind() { $name = "History"; $course_number = "HIST100"; $test_course = new Course($name, $course_number); $test_course->save(); $name2 = "Math"; $course_number2 = "MATH100"; $test_course2 = new Course($name, $course_number); $test_course2->save(); $result = Course::find($test_course->getId()); $this->assertEquals($test_course, $result); }
function test_find() { $course_name = "History"; $course_number = "HIST 101"; $test_course = new Course($course_name, $course_number); $test_course->save(); $course_name2 = "Biology"; $course_number2 = "BIO 101"; $test_course2 = new Course($course_name2, $course_number2); $test_course2->save(); $result = Course::find($test_course->getId()); $this->assertEquals($test_course, $result); }
function test_find() { //Arrange $test_department = new Department("Biology", "346 Stupid Avenue"); $test_department->save(); $name = "History 0001"; $code = "HS001"; $test_course = new Course($name, $code, $test_department->getId()); $test_course->save(); $name2 = "Dogs 101"; $code2 = "DW101"; $test_course2 = new Course($name2, $code2, $test_department->getId()); $test_course2->save(); //Act $result = Course::find($test_course->getId()); //Assert $this->assertEquals($test_course, $result); }
function test_find() { //Arrange $course_name = "MTH101"; $crn = 1234; $id = null; $test_course = new Course($course_name, $crn, $id); $test_course->save(); $course_name2 = "HST202"; $crn2 = 5678; $test_course2 = new Course($course_name2, $crn2, $id); $test_course2->save(); //Act $id = $test_course->getId(); $result = Course::find($id); //Assert $this->assertEquals($test_course, $result); }
function test_find() { //Arrange $name = "High Times"; $code = "CHEM420"; $test_course = new Course($name, $code); $test_course->save(); $name2 = "Gavanese Jamelan"; $code2 = "MUSC69"; $test_course2 = new Course($name2, $code2); $test_course2->save(); //Act $result = Course::find($test_course->getId()); //Assert $this->assertEquals($test_course, $result); }
public function saveToDatabase() { if (isset($this->_infoArr) && isset($this->_mappingArr)) { $err = ""; $conn = Propel::getConnection(); $dt = date("Y-m-d, H:i:s"); $len = count($this->_infoArr); for ($i = 0; $i < $len; $i++) { $course = CoursePeer::retrieveByPK($this->_infoArr[$i]["courseCode"]); if (!isset($course)) { // new course found, save to db $course = new Course(); $course->setDescr($this->_infoArr[$i]["courseName"]); $course->setIsEng(1); $course->setDeptId(substr($this->_infoArr[$i]["courseCode"], 0, 3)); $course->setId($this->_infoArr[$i]["courseCode"]); $course->save($conn); } elseif ($course->getDescr() == $course->getId()) { // exam importer registers course description as course id // if we encounter this situation, amend it with the proper description $course->setDescr($this->_infoArr[$i]["courseName"]); $course->save($conn); } try { $instr = InstructorPeer::findInstructorByName($this->_infoArr[$i]["instrFirstName"], $this->_infoArr[$i]["instrLastName"], $conn); } catch (Exception $e) { if ($e->getCode() == 1) { // no instructor found $instr = new Instructor(); $instr->setFirstName($this->_infoArr[$i]["instrFirstName"]); $instr->setLastName($this->_infoArr[$i]["instrLastName"]); $instr->setDeptId($course->getDeptId()); $instr->save($conn); } else { // TODO: big problem, duplicate instructors found // log error and move on continue; } } // create CourseInstructorAssociation if it doesn't exist try { $assoc = CourseInstructorAssociationPeer::findForYearAndInstructorIdAndCourseId($this->_year, $course->getId(), $instr->getId(), $conn); } catch (Exception $e) { if ($e->getCode() == 1) { // create new object $assoc = new CourseInstructorAssociation(); $assoc->setYear($this->_year); $assoc->setCourseId($course->getId()); $assoc->setInstructorId($instr->getId()); $assoc->save($conn); } else { // TODO: big problem, duplicate assocs found // log error and move on continue; } } // we can now save the real rating data $ratingArr = $this->_ratingArr[$i]; foreach ($ratingArr as $fieldId => $data) { foreach ($data as $rating => $number) { $ratingObj = new AutoCourseRating(); $ratingObj->setFieldId($fieldId); $ratingObj->setRating($rating); $ratingObj->setNumber($number); $ratingObj->setImportDt($dt); $ratingObj->setCourseInsId($assoc->getId()); $ratingObj->save(); } } } } else { throw new Exception("readCsv method has not been called."); } }
/** * Declares an association between this object and a Course object. * * @param Course $v * @return CourseComment The current object (for fluent API support) * @throws PropelException */ public function setCourse(Course $v = null) { if ($v === null) { $this->setCourseId(NULL); } else { $this->setCourseId($v->getId()); } $this->aCourse = $v; // Add binding for other direction of this n:n relationship. // If this object has already been added to the Course object, it will not be re-added. if ($v !== null) { $v->addCourseComment($this); } return $this; }
function testDelete() { $name = "Math"; $date = '0000-00-00'; $id = null; $test_course = new Course($name, $id); $test_course->save(); $student_name = "Student1"; $course_id = $test_course->getId(); $test_student = new Student($student_name, $id, $date, $course_id); $test_student->save(); $test_student->addCourse($test_course); $test_student->delete(); $this->assertEquals([], $test_course->getStudents()); }
function testGetUnits() { $name = "John Doe"; $password = "******"; $email = "*****@*****.**"; $signed_in = 0; $test_user = new User($name, $password, $email, $signed_in); $test_user->save(); $course_title = "Literature"; $subject = "English"; $course_description = "Deconstructing English literature."; $user_id = $test_user->getId(); $test_course = new Course($course_title, $subject, $course_description, $user_id); $test_course->save(); $title2 = "Algebra"; $subject2 = "Math"; $description2 = "Introduction to algebraic equations."; $test_course2 = new Course($title2, $subject2, $description2, $user_id); $test_course2->save(); $unit_title = "Into the Wild"; $unit_description = "The life and death of Chris McCandless."; $course_id = $test_course->getId(); $test_unit = new Unit($unit_title, $unit_description, $course_id); $test_unit->save(); $result = $test_course->getUnits(); $this->assertEquals($test_unit, $result[0]); }
function testUpdate() { $course_name = "History"; $course_code = "HIST100"; $test_course = new Course($course_name, $course_code); $test_course->save(); //Creatin a course with values of History, HIST100, and id from database $new_course_name = "Math"; $new_course_code = "MATH100"; $new_course = new Course($new_course_name, $new_course_code, $test_course->getId()); //creating a new course with values of Math, MATH100, and id that matches test_course $test_course->update($new_course_name, $new_course_code); $this->assertEquals($test_course, $new_course); }
function testDelete() { //Arrange $name = "Math"; $date = '0000-00-00'; $id = 1; $test_course = new Course($name, $id); $test_course->save(); $student_name = "File reports"; $id2 = 2; $course_id = $test_course->getId(); $test_student = new Student($student_name, $id2, $date, $course_id); $test_student->save(); //Act $test_course->addStudent($test_student); $test_course->delete(); //Assert $this->assertEquals([], $test_student->getCourses()); }
function testFind() { //Arrange $name = "History"; $course_number = "HIST101"; $name2 = "English"; $course_number2 = "ENG500"; $test_course = new Course($name, $course_number); $test_course->save(); $test_course2 = new Course($name2, $course_number2); $test_course2->save(); //Act $result = Course::find($test_course->getId()); //Assert $this->assertEquals($test_course, $result); }
/** * Exclude object from result * * @param Course $course Object to remove from the list of results * * @return CourseQuery The current query, for fluid interface */ public function prune($course = null) { if ($course) { $this->addUsingAlias(CoursePeer::ID, $course->getId(), Criteria::NOT_EQUAL); } return $this; }
function test_getCourses() { //Arrange $name = "bob"; $date_of_enrollment = "2015-09-16"; $test_student = new Student($name, $date_of_enrollment); $test_student->save(); $name2 = "Psychology 101"; $course_number = "PSY101"; $test_course = new Course($name2, $course_number); $test_course->save(); $name3 = "Philosophy 101"; $course_number2 = "PHIL101"; $test_course2 = new Course($name3, $course_number2); $test_course2->save(); //Act $test_student->addCourse($test_course->getId()); $test_student->addCourse($test_course2->getId()); //Assert $result = $test_student->getCourses(); $this->assertEquals([$test_course, $test_course2], $result); }
function test_find() { //Arrange $course_name = "History"; $course_number = "HIST:111"; $id = 1; $test_course = new Course($course_name, $course_number, $id); $test_course->save(); $course_name2 = "Albebra"; $course_number2 = "MTH:112"; $id = 2; $test_course2 = new Course($course_name2, $course_number2, $id); $test_course2->save(); //Act $result = Course::find($test_course->getId()); //Assert $this->assertEquals($test_course, $result); }
function test_find() { //Arrange $title = "Intro to Typing: COM-91"; $teacher = "Ancient Raven"; $time = "TH 9PM-11PM"; $semester = "Fall"; $test_course = new Course($title, $teacher, $time, $semester); $test_course->save(); $title2 = "Intro to Ladders: SHOP-10"; $teacher2 = "Jeff Winger"; $time2 = "MWF 11AM-12PM"; $semester2 = "Spring"; $test_course2 = new Course($title2, $teacher2, $time2, $semester2); $test_course2->save(); //Act $result = Course::find($test_course->getId()); //Assert $this->assertEquals($test_course, $result); }
function testFind() { //Arrange $name = "Math"; $course_num = "101"; $id = 1; $test_course = new Course($name, $course_num, $id); $test_course->save(); $name2 = "English"; $course_num2 = "300"; $id2 = 2; $test_course2 = new Course($name2, $course_num2, $id2); $test_course2->save(); //Act $result = Course::find($test_course2->getId()); //Assert $this->assertEquals($test_course2, $result); }
function test_find() { //Arrange $name = "Philosophy"; $course_number = "PHIL101"; $name2 = "Pyschology"; $course_number2 = "PSY101"; $id = 1; $id2 = 2; $test_course = new Course($name, $course_number, $id); $test_course->save(); $test_course2 = new Course($name2, $course_number2, $id2); $test_course2->save(); //Act $result = Course::find($test_course->getId()); //Assert $this->assertEquals($test_course, $result); }
/** * Adds an object to the instance pool. * * Propel keeps cached copies of objects in an instance pool when they are retrieved * from the database. In some cases -- especially when you override doSelect*() * methods in your stub classes -- you may need to explicitly add objects * to the cache in order to ensure that the same objects are always returned by doSelect*() * and retrieveByPK*() calls. * * @param Course $value A Course object. * @param string $key (optional) key to use for instance map (for performance boost if key was already calculated externally). */ public static function addInstanceToPool(Course $obj, $key = null) { if (Propel::isInstancePoolingEnabled()) { if ($key === null) { $key = (string) $obj->getId(); } // if key === null self::$instances[$key] = $obj; } }
function testFind() { $name = "John Doe"; $password = "******"; $email = "*****@*****.**"; $signed_in = 0; $test_user = new User($name, $password, $email, $signed_in); $test_user->save(); $course_title = "Literature"; $subject = "English"; $course_description = "Deconstructing English literature."; $user_id = $test_user->getId(); $test_course = new Course($course_title, $subject, $course_description, $user_id); $test_course->save(); $unit_title = "Into the Wild"; $unit_description = "The life and death of Chris McCandless."; $course_id = $test_course->getId(); $test_unit = new Unit($unit_title, $unit_description, $course_id); $test_unit->save(); $lesson_title = "Into the Wild: Chapter 1"; $objective = "Students will read and discuss Chapter 1"; $materials = "Books, discussion packets, pencils"; $body = "Lorem ipsum etc etc blah blah blah blah..."; $unit_id = $test_unit->getId(); $test_lesson = new Lesson($lesson_title, $objective, $materials, $body, $unit_id); $test_lesson->save(); $lesson_title2 = "The Catcher in the Rye: Chapter 3"; $objective2 = "Students will read and discuss Chapter 3"; $materials2 = "Books, essay prompts, pens"; $body2 = "Blah blah blah etc etc lorem ipsum..."; $test_lesson2 = new Lesson($lesson_title2, $objective2, $materials2, $body, $unit_id); $test_lesson2->save(); $result = Lesson::find($test_lesson->getId()); $this->assertEquals($test_lesson, $result); }
} } // end if (!MULTIPROVIDER) if (isset($testerName)) { $tester_dh = AMA_DataHandler::instance(MultiPort::getDSN($testerName)); // setting of the global is needed to load the course object $GLOBALS['dh'] = $tester_dh; // load course $courseObj = new Course($course_id); $courseOK = false; if ($courseObj instanceof Course && $courseObj->isFull()) { // it it's public, go on and show contents $courseOK = $courseObj->getIsPublic(); if (!$courseOK && isset($_SESSION['sess_userObj']) && $_SESSION['sess_userObj'] instanceof ADALoggableUser) { // if it's not public, check if user is subscribed to course $instanceCheck = $tester_dh->get_course_instance_for_this_student_and_course_model($_SESSION['sess_userObj']->getId(), $courseObj->getId(), true); if (!AMA_DB::isError($instanceCheck) && is_array($instanceCheck) && count($instanceCheck) > 0) { $goodStatuses = array(ADA_STATUS_SUBSCRIBED, ADA_STATUS_COMPLETED, ADA_STATUS_TERMINATED); $instance = reset($instanceCheck); do { $courseOK = in_array($instance['status'], $goodStatuses); } while (($instance = next($instanceCheck)) !== false && !$courseOK); } } } // courseOK is true either if course is public or the user is subscribed to it if ($courseOK) { // select nome or empty string (whoever is not null) as title to diplay for the news $newscontent = $tester_dh->find_course_nodes_list(array("COALESCE(if(nome='NULL' OR ISNULL(nome ),NULL, nome), '')", "testo"), "tipo IN (" . ADA_LEAF_TYPE . "," . ADA_GROUP_TYPE . ") ORDER BY data_creazione DESC LIMIT " . $count, $course_id); // watch out: $newscontent is NOT associative $output = '';
function testFind() { $course_name = "Vampires"; $course_number = 1; $id = 1; $test_course = new Course($course_name, $course_number, $id); $test_course->save(); $course_name2 = "Discrete Math"; $course_number2 = 1; $id2 = 2; $test_course2 = new Course($course_name2, $course_number2, $id2); $test_course2->save(); $find_id = $test_course->getId(); $result = Course::find($find_id); $this->assertEquals($test_course, $result); }
public function dettacherImageFromPost(Course $course) { if (PostWP::hasPostPicture($course->getId())) { PostWP::deletePostPicture($course->getId()); } }
function test_GetAll() { $name = "Coding 101"; $enrollment_date = '0000-00-00'; $id = null; $test_course = new Course($name, $id); $test_course->save(); $student_name = "Aladdin"; $course_id = $test_course->getId(); $test_student = new Student($student_name, $id, $enrollment_date, $course_id); $test_student->save(); $student_name2 = "Jasmine"; $id2 = null; $course_id2 = $test_course->getId(); $test_student2 = new Student($student_name2, $id2, $enrollment_date, $course_id2); $test_student->save(); $result = Student::getAll(); $this->assertEquals(['test_student, $test_student2'], $result); }
function testFind() { //Arrange $name = "Coding 101"; $id = 1; $test_course = new Course($name, $id); $test_course->save(); $name2 = "Advanced Coding"; $id2 = 2; $test_course2 = new Course($name2, $id2); $test_course2->save(); //Act $result = Course::find($test_course->getId()); //Assert $this->assertEquals($test_course, $result); }