public function testDoInsert() { try { $c = new Criteria(); $c->setPrimaryTableName(BookTableMap::TABLE_NAME); $c->add(BookTableMap::AUTHOR_ID, 'lkhlkhj'); $c->doInsert(Propel::getServiceContainer()->getWriteConnection(BookTableMap::DATABASE_NAME)); $this->fail('Missing expected exception on BAD SQL'); } catch (PropelException $e) { $this->assertContains('[INSERT INTO `book` (`AUTHOR_ID`) VALUES (:p1)]', $e->getMessage(), 'SQL query is written in the exception message'); } }
public function testCombineCriterionOrLessSimple() { $this->c->addCond('cond1', "INVOICE.COST1", "1000", Criteria::GREATER_EQUAL); $this->c->addCond('cond2', "INVOICE.COST2", "2000", Criteria::LESS_EQUAL); $this->c->add("INVOICE.COST3", "8000", Criteria::GREATER_EQUAL); $this->c->combine(['cond1', 'cond2'], Criteria::LOGICAL_OR); $this->c->addOr("INVOICE.COST4", "9000", Criteria::LESS_EQUAL); $expect = $this->getSql("SELECT FROM INVOICE WHERE INVOICE.COST3>=:p1 AND ((INVOICE.COST1>=:p2 OR INVOICE.COST2<=:p3) OR INVOICE.COST4<=:p4)"); $expect_params = [['table' => 'INVOICE', 'column' => 'COST3', 'value' => '8000'], ['table' => 'INVOICE', 'column' => 'COST1', 'value' => '1000'], ['table' => 'INVOICE', 'column' => 'COST2', 'value' => '2000'], ['table' => 'INVOICE', 'column' => 'COST4', 'value' => '9000']]; $params = []; $result = $this->c->createSelectSql($params); $this->assertEquals($expect, $result); $this->assertEquals($expect_params, $params); }
public function testDoInsert() { $con = Propel::getServiceContainer()->getWriteConnection(BookTableMap::DATABASE_NAME); try { $c = new Criteria(); $c->setPrimaryTableName(BookTableMap::TABLE_NAME); $c->add(BookTableMap::AUTHOR_ID, 'lkhlkhj'); $db = Propel::getServiceContainer()->getAdapter($c->getDbName()); $c->doInsert($con); $this->fail('Missing expected exception on BAD SQL'); } catch (PropelException $e) { if ($db->isGetIdBeforeInsert()) { $this->assertContains($this->getSql('[INSERT INTO book (AUTHOR_ID,ID) VALUES (:p1,:p2)]'), $e->getMessage(), 'SQL query is written in the exception message'); } else { $this->assertContains($this->getSql('[INSERT INTO `book` (`AUTHOR_ID`) VALUES (:p1)]'), $e->getMessage(), 'SQL query is written in the exception message'); } } }
public function testDoSelectOrderByRank() { $c = new Criteria(); $c->add(SortableTable12TableMap::SCOPE_COL, 1); $objects = SortableTable12Query::doSelectOrderByRank($c)->getArrayCopy(); $oldRank = 0; while ($object = array_shift($objects)) { $this->assertTrue($object->getRank() > $oldRank); $oldRank = $object->getRank(); } $c = new Criteria(); $c->add(SortableTable12TableMap::SCOPE_COL, 1); $objects = SortableTable12Query::doSelectOrderByRank($c, Criteria::DESC)->getArrayCopy(); $oldRank = 10; while ($object = array_shift($objects)) { $this->assertTrue($object->getRank() < $oldRank); $oldRank = $object->getRank(); } }
/** * Performs a DELETE on the database, given a ModuleImage or Criteria object OR a primary key value. * * @param mixed $values Criteria or ModuleImage object or primary key or array of primary keys * which is used to create the DELETE statement * @param ConnectionInterface $con the connection to use * @return int The number of affected rows (if supported by underlying database driver). This includes CASCADE-related rows * if supported by native driver or if emulated using Propel. * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function doDelete($values, ConnectionInterface $con = null) { if (null === $con) { $con = Propel::getServiceContainer()->getWriteConnection(ModuleImageTableMap::DATABASE_NAME); } if ($values instanceof Criteria) { // rename for clarity $criteria = $values; } elseif ($values instanceof \Thelia\Model\ModuleImage) { // it's a model object // create criteria based on pk values $criteria = $values->buildPkeyCriteria(); } else { // it's a primary key, or an array of pks $criteria = new Criteria(ModuleImageTableMap::DATABASE_NAME); $criteria->add(ModuleImageTableMap::ID, (array) $values, Criteria::IN); } $query = ModuleImageQuery::create()->mergeWith($criteria); if ($values instanceof Criteria) { ModuleImageTableMap::clearInstancePool(); } elseif (!is_object($values)) { // it's a primary key, or an array of pks foreach ((array) $values as $singleval) { ModuleImageTableMap::removeInstanceFromPool($singleval); } } return $query->delete($con); }
/** * Build a Criteria object containing the values of all modified columns in this object. * * @return Criteria The Criteria object containing all modified values. */ public function buildCriteria() { $criteria = new Criteria(JaCategoriasTableMap::DATABASE_NAME); if ($this->isColumnModified(JaCategoriasTableMap::COL_ID)) { $criteria->add(JaCategoriasTableMap::COL_ID, $this->id); } if ($this->isColumnModified(JaCategoriasTableMap::COL_TITULO)) { $criteria->add(JaCategoriasTableMap::COL_TITULO, $this->titulo); } if ($this->isColumnModified(JaCategoriasTableMap::COL_SLUG)) { $criteria->add(JaCategoriasTableMap::COL_SLUG, $this->slug); } return $criteria; }
/** * Build a Criteria object containing the values of all modified columns in this object. * * @return Criteria The Criteria object containing all modified values. */ public function buildCriteria() { $criteria = new Criteria(ApplicationTableMap::DATABASE_NAME); if ($this->isColumnModified(ApplicationTableMap::COL_ID)) { $criteria->add(ApplicationTableMap::COL_ID, $this->id); } if ($this->isColumnModified(ApplicationTableMap::COL_STUDENT_ID)) { $criteria->add(ApplicationTableMap::COL_STUDENT_ID, $this->student_id); } if ($this->isColumnModified(ApplicationTableMap::COL_SUBJECT_ID)) { $criteria->add(ApplicationTableMap::COL_SUBJECT_ID, $this->subject_id); } if ($this->isColumnModified(ApplicationTableMap::COL_PERIOD_ID)) { $criteria->add(ApplicationTableMap::COL_PERIOD_ID, $this->period_id); } if ($this->isColumnModified(ApplicationTableMap::COL_SCHOOL_YEAR_ID)) { $criteria->add(ApplicationTableMap::COL_SCHOOL_YEAR_ID, $this->school_year_id); } if ($this->isColumnModified(ApplicationTableMap::COL_APPLICATION_DATE)) { $criteria->add(ApplicationTableMap::COL_APPLICATION_DATE, $this->application_date); } if ($this->isColumnModified(ApplicationTableMap::COL_EXAM_DATE)) { $criteria->add(ApplicationTableMap::COL_EXAM_DATE, $this->exam_date); } if ($this->isColumnModified(ApplicationTableMap::COL_EXAM_TIME)) { $criteria->add(ApplicationTableMap::COL_EXAM_TIME, $this->exam_time); } if ($this->isColumnModified(ApplicationTableMap::COL_EXAM_SCORE)) { $criteria->add(ApplicationTableMap::COL_EXAM_SCORE, $this->exam_score); } if ($this->isColumnModified(ApplicationTableMap::COL_CREATED_AT)) { $criteria->add(ApplicationTableMap::COL_CREATED_AT, $this->created_at); } if ($this->isColumnModified(ApplicationTableMap::COL_UPDATED_AT)) { $criteria->add(ApplicationTableMap::COL_UPDATED_AT, $this->updated_at); } return $criteria; }
/** * Build a Criteria object containing the values of all modified columns in this object. * * @return Criteria The Criteria object containing all modified values. */ public function buildCriteria() { $criteria = new Criteria(WishlistProductTableMap::DATABASE_NAME); if ($this->isColumnModified(WishlistProductTableMap::COL_WISHLIST_PRODUCT_ID)) { $criteria->add(WishlistProductTableMap::COL_WISHLIST_PRODUCT_ID, $this->wishlist_product_id); } if ($this->isColumnModified(WishlistProductTableMap::COL_WISHLIST_ID)) { $criteria->add(WishlistProductTableMap::COL_WISHLIST_ID, $this->wishlist_id); } if ($this->isColumnModified(WishlistProductTableMap::COL_PRODUCT_ID)) { $criteria->add(WishlistProductTableMap::COL_PRODUCT_ID, $this->product_id); } if ($this->isColumnModified(WishlistProductTableMap::COL_WISHLIST_PRODUCT_COMMENT)) { $criteria->add(WishlistProductTableMap::COL_WISHLIST_PRODUCT_COMMENT, $this->wishlist_product_comment); } if ($this->isColumnModified(WishlistProductTableMap::COL_CREATED_AT)) { $criteria->add(WishlistProductTableMap::COL_CREATED_AT, $this->created_at); } if ($this->isColumnModified(WishlistProductTableMap::COL_UPDATED_AT)) { $criteria->add(WishlistProductTableMap::COL_UPDATED_AT, $this->updated_at); } return $criteria; }
/** * Build a Criteria object containing the values of all modified columns in this object. * * @return Criteria The Criteria object containing all modified values. */ public function buildCriteria() { $criteria = new Criteria(EntityTypeTableMap::DATABASE_NAME); if ($this->isColumnModified(EntityTypeTableMap::COL_ID)) { $criteria->add(EntityTypeTableMap::COL_ID, $this->id); } if ($this->isColumnModified(EntityTypeTableMap::COL_NAME)) { $criteria->add(EntityTypeTableMap::COL_NAME, $this->name); } return $criteria; }
/** * Build a Criteria object containing the values of all modified columns in this object. * * @return Criteria The Criteria object containing all modified values. */ public function buildCriteria() { $criteria = new Criteria(SessionTableMap::DATABASE_NAME); if ($this->isColumnModified(SessionTableMap::COL_TOKEN)) { $criteria->add(SessionTableMap::COL_TOKEN, $this->token); } if ($this->isColumnModified(SessionTableMap::COL_USER_ID)) { $criteria->add(SessionTableMap::COL_USER_ID, $this->user_id); } if ($this->isColumnModified(SessionTableMap::COL_IP)) { $criteria->add(SessionTableMap::COL_IP, $this->ip); } if ($this->isColumnModified(SessionTableMap::COL_USER_AGENT)) { $criteria->add(SessionTableMap::COL_USER_AGENT, $this->user_agent); } if ($this->isColumnModified(SessionTableMap::COL_BROWSER)) { $criteria->add(SessionTableMap::COL_BROWSER, $this->browser); } if ($this->isColumnModified(SessionTableMap::COL_DEVICE)) { $criteria->add(SessionTableMap::COL_DEVICE, $this->device); } if ($this->isColumnModified(SessionTableMap::COL_OS)) { $criteria->add(SessionTableMap::COL_OS, $this->os); } if ($this->isColumnModified(SessionTableMap::COL_LOCATION)) { $criteria->add(SessionTableMap::COL_LOCATION, $this->location); } if ($this->isColumnModified(SessionTableMap::COL_CREATED_AT)) { $criteria->add(SessionTableMap::COL_CREATED_AT, $this->created_at); } if ($this->isColumnModified(SessionTableMap::COL_UPDATED_AT)) { $criteria->add(SessionTableMap::COL_UPDATED_AT, $this->updated_at); } return $criteria; }
/** * Build a Criteria object containing the values of all modified columns in this object. * * @return Criteria The Criteria object containing all modified values. */ public function buildCriteria() { $criteria = new Criteria(CommentTableMap::DATABASE_NAME); if ($this->isColumnModified(CommentTableMap::COL_ID)) { $criteria->add(CommentTableMap::COL_ID, $this->id); } if ($this->isColumnModified(CommentTableMap::COL_USER_ID)) { $criteria->add(CommentTableMap::COL_USER_ID, $this->user_id); } if ($this->isColumnModified(CommentTableMap::COL_NOTE_ID)) { $criteria->add(CommentTableMap::COL_NOTE_ID, $this->note_id); } if ($this->isColumnModified(CommentTableMap::COL_TEXT)) { $criteria->add(CommentTableMap::COL_TEXT, $this->text); } if ($this->isColumnModified(CommentTableMap::COL_CREATED_AT)) { $criteria->add(CommentTableMap::COL_CREATED_AT, $this->created_at); } if ($this->isColumnModified(CommentTableMap::COL_UPDATED_AT)) { $criteria->add(CommentTableMap::COL_UPDATED_AT, $this->updated_at); } return $criteria; }
/** * Build a Criteria object containing the values of all modified columns in this object. * * @return Criteria The Criteria object containing all modified values. */ public function buildCriteria() { $criteria = new Criteria(RigAttributeValueTableMap::DATABASE_NAME); if ($this->isColumnModified(RigAttributeValueTableMap::COL_ID)) { $criteria->add(RigAttributeValueTableMap::COL_ID, $this->id); } if ($this->isColumnModified(RigAttributeValueTableMap::COL_RIG_ID)) { $criteria->add(RigAttributeValueTableMap::COL_RIG_ID, $this->rig_id); } if ($this->isColumnModified(RigAttributeValueTableMap::COL_RIG_ATTRIBUTE_ID)) { $criteria->add(RigAttributeValueTableMap::COL_RIG_ATTRIBUTE_ID, $this->rig_attribute_id); } if ($this->isColumnModified(RigAttributeValueTableMap::COL_VALUE)) { $criteria->add(RigAttributeValueTableMap::COL_VALUE, $this->value); } return $criteria; }
/** * Build a Criteria object containing the values of all modified columns in this object. * * @return Criteria The Criteria object containing all modified values. */ public function buildCriteria() { $criteria = new Criteria(UserTableMap::DATABASE_NAME); if ($this->isColumnModified(UserTableMap::COL_ID)) { $criteria->add(UserTableMap::COL_ID, $this->id); } if ($this->isColumnModified(UserTableMap::COL_NAME)) { $criteria->add(UserTableMap::COL_NAME, $this->name); } if ($this->isColumnModified(UserTableMap::COL_EMAIL)) { $criteria->add(UserTableMap::COL_EMAIL, $this->email); } if ($this->isColumnModified(UserTableMap::COL_PASSWORD)) { $criteria->add(UserTableMap::COL_PASSWORD, $this->password); } if ($this->isColumnModified(UserTableMap::COL_REMEMBER)) { $criteria->add(UserTableMap::COL_REMEMBER, $this->remember); } if ($this->isColumnModified(UserTableMap::COL_ACCOUNT_TYPE)) { $criteria->add(UserTableMap::COL_ACCOUNT_TYPE, $this->account_type); } if ($this->isColumnModified(UserTableMap::COL_CREATED_AT)) { $criteria->add(UserTableMap::COL_CREATED_AT, $this->created_at); } if ($this->isColumnModified(UserTableMap::COL_UPDATED_AT)) { $criteria->add(UserTableMap::COL_UPDATED_AT, $this->updated_at); } return $criteria; }
/** * Build a Criteria object containing the values of all modified columns in this object. * * @return Criteria The Criteria object containing all modified values. */ public function buildCriteria() { $criteria = new Criteria(WpUsermetaTableMap::DATABASE_NAME); if ($this->isColumnModified(WpUsermetaTableMap::COL_UMETA_ID)) { $criteria->add(WpUsermetaTableMap::COL_UMETA_ID, $this->umeta_id); } if ($this->isColumnModified(WpUsermetaTableMap::COL_USER_ID)) { $criteria->add(WpUsermetaTableMap::COL_USER_ID, $this->user_id); } if ($this->isColumnModified(WpUsermetaTableMap::COL_META_KEY)) { $criteria->add(WpUsermetaTableMap::COL_META_KEY, $this->meta_key); } if ($this->isColumnModified(WpUsermetaTableMap::COL_META_VALUE)) { $criteria->add(WpUsermetaTableMap::COL_META_VALUE, $this->meta_value); } return $criteria; }
/** * Builds a Criteria object containing the primary key for this object. * * Unlike buildCriteria() this method includes the primary key values regardless * of whether or not they have been modified. * * @return Criteria The Criteria object containing value(s) for primary key(s). */ public function buildPkeyCriteria() { $criteria = new Criteria(MenuItemVersionTableMap::DATABASE_NAME); $criteria->add(MenuItemVersionTableMap::ID, $this->id); $criteria->add(MenuItemVersionTableMap::MENU_ID, $this->menu_id); $criteria->add(MenuItemVersionTableMap::VERSION, $this->version); return $criteria; }
/** * Build a Criteria object containing the values of all modified columns in this object. * * @return Criteria The Criteria object containing all modified values. */ public function buildCriteria() { $criteria = new Criteria(StudentTableMap::DATABASE_NAME); if ($this->isColumnModified(StudentTableMap::COL_ID)) { $criteria->add(StudentTableMap::COL_ID, $this->id); } if ($this->isColumnModified(StudentTableMap::COL_IDENTIFICATION_NUMBER)) { $criteria->add(StudentTableMap::COL_IDENTIFICATION_NUMBER, $this->identification_number); } if ($this->isColumnModified(StudentTableMap::COL_SCHOOL_YEAR_ID)) { $criteria->add(StudentTableMap::COL_SCHOOL_YEAR_ID, $this->school_year_id); } if ($this->isColumnModified(StudentTableMap::COL_COURSE_ID)) { $criteria->add(StudentTableMap::COL_COURSE_ID, $this->course_id); } if ($this->isColumnModified(StudentTableMap::COL_FIRST_NAME)) { $criteria->add(StudentTableMap::COL_FIRST_NAME, $this->first_name); } if ($this->isColumnModified(StudentTableMap::COL_LAST_NAME)) { $criteria->add(StudentTableMap::COL_LAST_NAME, $this->last_name); } if ($this->isColumnModified(StudentTableMap::COL_BIRTH_PLACE)) { $criteria->add(StudentTableMap::COL_BIRTH_PLACE, $this->birth_place); } if ($this->isColumnModified(StudentTableMap::COL_BIRTHDAY)) { $criteria->add(StudentTableMap::COL_BIRTHDAY, $this->birthday); } if ($this->isColumnModified(StudentTableMap::COL_PHONE_NUMBER)) { $criteria->add(StudentTableMap::COL_PHONE_NUMBER, $this->phone_number); } if ($this->isColumnModified(StudentTableMap::COL_CREATED_AT)) { $criteria->add(StudentTableMap::COL_CREATED_AT, $this->created_at); } if ($this->isColumnModified(StudentTableMap::COL_UPDATED_AT)) { $criteria->add(StudentTableMap::COL_UPDATED_AT, $this->updated_at); } return $criteria; }
/** * Build a Criteria object containing the values of all modified columns in this object. * * @return Criteria The Criteria object containing all modified values. */ public function buildCriteria() { $criteria = new Criteria(JaPaginaCategoriasTableMap::DATABASE_NAME); if ($this->isColumnModified(JaPaginaCategoriasTableMap::COL_ID)) { $criteria->add(JaPaginaCategoriasTableMap::COL_ID, $this->id); } if ($this->isColumnModified(JaPaginaCategoriasTableMap::COL_ID_PAGINA)) { $criteria->add(JaPaginaCategoriasTableMap::COL_ID_PAGINA, $this->id_pagina); } if ($this->isColumnModified(JaPaginaCategoriasTableMap::COL_ID_CATEGORIA)) { $criteria->add(JaPaginaCategoriasTableMap::COL_ID_CATEGORIA, $this->id_categoria); } return $criteria; }
/** * Build a Criteria object containing the values of all modified columns in this object. * * @return Criteria The Criteria object containing all modified values. */ public function buildCriteria() { $criteria = new Criteria(MatchTableMap::DATABASE_NAME); if ($this->isColumnModified(MatchTableMap::COL_ID)) { $criteria->add(MatchTableMap::COL_ID, $this->id); } if ($this->isColumnModified(MatchTableMap::COL_NR)) { $criteria->add(MatchTableMap::COL_NR, $this->nr); } if ($this->isColumnModified(MatchTableMap::COL_DATE)) { $criteria->add(MatchTableMap::COL_DATE, $this->date); } if ($this->isColumnModified(MatchTableMap::COL_RESULT)) { $criteria->add(MatchTableMap::COL_RESULT, $this->result); } if ($this->isColumnModified(MatchTableMap::COL_TOTO)) { $criteria->add(MatchTableMap::COL_TOTO, $this->toto); } if ($this->isColumnModified(MatchTableMap::COL_CHAMPIONSHIP_ID)) { $criteria->add(MatchTableMap::COL_CHAMPIONSHIP_ID, $this->championship_id); } if ($this->isColumnModified(MatchTableMap::COL_ROUND_ID)) { $criteria->add(MatchTableMap::COL_ROUND_ID, $this->round_id); } if ($this->isColumnModified(MatchTableMap::COL_LEAGUE_ID)) { $criteria->add(MatchTableMap::COL_LEAGUE_ID, $this->league_id); } if ($this->isColumnModified(MatchTableMap::COL_HOMETEAM_ID)) { $criteria->add(MatchTableMap::COL_HOMETEAM_ID, $this->hometeam_id); } if ($this->isColumnModified(MatchTableMap::COL_AWAYTEAM_ID)) { $criteria->add(MatchTableMap::COL_AWAYTEAM_ID, $this->awayteam_id); } return $criteria; }
/** * Build a Criteria object containing the values of all modified columns in this object. * * @return Criteria The Criteria object containing all modified values. */ public function buildCriteria() { $criteria = new Criteria(DataTableMap::DATABASE_NAME); if ($this->isColumnModified(DataTableMap::COL_ID)) { $criteria->add(DataTableMap::COL_ID, $this->id); } if ($this->isColumnModified(DataTableMap::COL__FORCONTRIBUTION)) { $criteria->add(DataTableMap::COL__FORCONTRIBUTION, $this->_forcontribution); } if ($this->isColumnModified(DataTableMap::COL__FORTEMPLATEFIELD)) { $criteria->add(DataTableMap::COL__FORTEMPLATEFIELD, $this->_fortemplatefield); } if ($this->isColumnModified(DataTableMap::COL__CONTENT)) { $criteria->add(DataTableMap::COL__CONTENT, $this->_content); } if ($this->isColumnModified(DataTableMap::COL__ISJSON)) { $criteria->add(DataTableMap::COL__ISJSON, $this->_isjson); } if ($this->isColumnModified(DataTableMap::COL___USER__)) { $criteria->add(DataTableMap::COL___USER__, $this->__user__); } if ($this->isColumnModified(DataTableMap::COL___CONFIG__)) { $criteria->add(DataTableMap::COL___CONFIG__, $this->__config__); } if ($this->isColumnModified(DataTableMap::COL___SPLIT__)) { $criteria->add(DataTableMap::COL___SPLIT__, $this->__split__); } if ($this->isColumnModified(DataTableMap::COL___PARENTNODE__)) { $criteria->add(DataTableMap::COL___PARENTNODE__, $this->__parentnode__); } if ($this->isColumnModified(DataTableMap::COL___SORT__)) { $criteria->add(DataTableMap::COL___SORT__, $this->__sort__); } return $criteria; }
public function testCommentDoDelete() { $c = new Criteria(); $c->setComment('Foo'); $c->add(BookTableMap::COL_TITLE, 'War And Peace'); $con = Propel::getServiceContainer()->getConnection(BookTableMap::DATABASE_NAME); $c->doDelete($con); $expected = $this->getSql('DELETE /* Foo */ FROM `book` WHERE book.TITLE=\'War And Peace\''); $this->assertEquals($expected, $con->getLastExecutedQuery(), 'Criteria::setComment() adds a comment to delete queries'); }
/** * Build a Criteria object containing the values of all modified columns in this object. * * @return Criteria The Criteria object containing all modified values. */ public function buildCriteria() { $criteria = new Criteria(FileTableMap::DATABASE_NAME); if ($this->isColumnModified(FileTableMap::COL_FILE_ID)) { $criteria->add(FileTableMap::COL_FILE_ID, $this->file_id); } if ($this->isColumnModified(FileTableMap::COL_FILE_TYPE_ID)) { $criteria->add(FileTableMap::COL_FILE_TYPE_ID, $this->file_type_id); } if ($this->isColumnModified(FileTableMap::COL_FILE_PATH)) { $criteria->add(FileTableMap::COL_FILE_PATH, $this->file_path); } if ($this->isColumnModified(FileTableMap::COL_CREATED_AT)) { $criteria->add(FileTableMap::COL_CREATED_AT, $this->created_at); } if ($this->isColumnModified(FileTableMap::COL_UPDATED_AT)) { $criteria->add(FileTableMap::COL_UPDATED_AT, $this->updated_at); } return $criteria; }
/** * Build a Criteria object containing the values of all modified columns in this object. * * @return Criteria The Criteria object containing all modified values. */ public function buildCriteria() { $criteria = new Criteria(RFieldpostprocessorForfieldTableMap::DATABASE_NAME); if ($this->isColumnModified(RFieldpostprocessorForfieldTableMap::COL__POSTPROCESSORID)) { $criteria->add(RFieldpostprocessorForfieldTableMap::COL__POSTPROCESSORID, $this->_postprocessorid); } if ($this->isColumnModified(RFieldpostprocessorForfieldTableMap::COL__TEMPLATEID)) { $criteria->add(RFieldpostprocessorForfieldTableMap::COL__TEMPLATEID, $this->_templateid); } return $criteria; }
/** * Builds a Criteria object containing the primary key for this object. * * Unlike buildCriteria() this method includes the primary key values regardless * of whether or not they have been modified. * * @return Criteria The Criteria object containing value(s) for primary key(s). */ public function buildPkeyCriteria() { $criteria = new Criteria(CustomerTitleI18nTableMap::DATABASE_NAME); $criteria->add(CustomerTitleI18nTableMap::ID, $this->id); $criteria->add(CustomerTitleI18nTableMap::LOCALE, $this->locale); return $criteria; }
/** * Builds a Criteria object containing the primary key for this object. * * Unlike buildCriteria() this method includes the primary key values regardless * of whether or not they have been modified. * * @return Criteria The Criteria object containing value(s) for primary key(s). */ public function buildPkeyCriteria() { $criteria = new Criteria(ProductImageTableMap::DATABASE_NAME); $criteria->add(ProductImageTableMap::ID, $this->id); return $criteria; }
public function testModifiedObjectsRemainInTheCollection() { $c = new Criteria(); $c->add(BookTableMap::ID, $this->books[0]->getId()); $books = BookQuery::create(null, $c)->joinWithAuthor()->find(); $books[0]->setTitle('Modified'); $books2 = $books[0]->getAuthor()->getBooks(); $this->assertEquals(2, count($books2)); $this->assertEquals(2, $books2[0]->getAuthor()->countBooks()); $this->assertEquals('Modified', $books2[0]->getTitle()); }
/** * Build a Criteria object containing the values of all modified columns in this object. * * @return Criteria The Criteria object containing all modified values. */ public function buildCriteria() { $criteria = new Criteria(GroupTableMap::DATABASE_NAME); if ($this->isColumnModified(GroupTableMap::COL_ID)) { $criteria->add(GroupTableMap::COL_ID, $this->id); } if ($this->isColumnModified(GroupTableMap::COL_NAME)) { $criteria->add(GroupTableMap::COL_NAME, $this->name); } if ($this->isColumnModified(GroupTableMap::COL_DESCRIPTION)) { $criteria->add(GroupTableMap::COL_DESCRIPTION, $this->description); } if ($this->isColumnModified(GroupTableMap::COL_OWNER_ID)) { $criteria->add(GroupTableMap::COL_OWNER_ID, $this->owner_id); } if ($this->isColumnModified(GroupTableMap::COL_CREATED_AT)) { $criteria->add(GroupTableMap::COL_CREATED_AT, $this->created_at); } if ($this->isColumnModified(GroupTableMap::COL_UPDATED_AT)) { $criteria->add(GroupTableMap::COL_UPDATED_AT, $this->updated_at); } return $criteria; }
/** * Builds a Criteria object containing the primary key for this object. * * Unlike buildCriteria() this method includes the primary key values regardless * of whether or not they have been modified. * * @return Criteria The Criteria object containing value(s) for primary key(s). */ public function buildPkeyCriteria() { $criteria = new Criteria(ContentTableMap::DATABASE_NAME); $criteria->add(ContentTableMap::ID, $this->id); return $criteria; }
/** * Builds a Criteria object containing the primary key for this object. * * Unlike buildCriteria() this method includes the primary key values regardless * of whether or not they have been modified. * * @throws LogicException if no primary key is defined * * @return Criteria The Criteria object containing value(s) for primary key(s). */ public function buildPkeyCriteria() { $criteria = new Criteria(UserTableMap::DATABASE_NAME); $criteria->add(UserTableMap::COL_ID, $this->id); return $criteria; }
/** * Builds a Criteria object containing the primary key for this object. * * Unlike buildCriteria() this method includes the primary key values regardless * of whether or not they have been modified. * * @return Criteria The Criteria object containing value(s) for primary key(s). */ public function buildPkeyCriteria() { $criteria = new Criteria(CouponVersionTableMap::DATABASE_NAME); $criteria->add(CouponVersionTableMap::ID, $this->id); $criteria->add(CouponVersionTableMap::VERSION, $this->version); return $criteria; }
/** * Builds a Criteria object containing the primary key for this object. * * Unlike buildCriteria() this method includes the primary key values regardless * of whether or not they have been modified. * * @return Criteria The Criteria object containing value(s) for primary key(s). */ public function buildPkeyCriteria() { $criteria = new Criteria(OrderStatusI18nTableMap::DATABASE_NAME); $criteria->add(OrderStatusI18nTableMap::ID, $this->id); $criteria->add(OrderStatusI18nTableMap::LOCALE, $this->locale); return $criteria; }