array('ProductId', 'CategoryId', ), self::TYPE_CAMELNAME => array('productId', 'categoryId', ), self::TYPE_COLNAME => array(ProductCategoryTableMap::COL_PRODUCT_ID, ProductCategoryTableMap::COL_CATEGORY_ID, ), self::TYPE_FIELDNAME => array('product_id', 'category_id', ), self::TYPE_NUM => array(0, 1, ) ); /** * holds an array of keys for quick access to the fieldnames array * * first dimension keys are the type constants * e.g. self::$fieldKeys[self::TYPE_PHPNAME]['Id'] = 0 */ protected static $fieldKeys = array ( self::TYPE_PHPNAME => array('ProductId' => 0, 'CategoryId' => 1, ), self::TYPE_CAMELNAME => array('productId' => 0, 'categoryId' => 1, ), self::TYPE_COLNAME => array(ProductCategoryTableMap::COL_PRODUCT_ID => 0, ProductCategoryTableMap::COL_CATEGORY_ID => 1, ), self::TYPE_FIELDNAME => array('product_id' => 0, 'category_id' => 1, ), self::TYPE_NUM => array(0, 1, ) ); /** * Initialize the table attributes and columns * Relations are not initialized by this method since they are lazy loaded * * @return void * @throws PropelException */ public function initialize() { // attributes $this->setName('product_category'); $this->setPhpName('ProductCategory'); $this->setIdentifierQuoting(false); $this->setClassName('\\ProductCategory'); $this->setPackage(''); $this->setUseIdGenerator(false); $this->setIsCrossRef(true); // columns $this->addForeignPrimaryKey('product_id', 'ProductId', 'INTEGER' , 'product', 'id', true, null, null); $this->addForeignPrimaryKey('category_id', 'CategoryId', 'INTEGER' , 'category', 'id', true, null, null); } // initialize() /** * Build the RelationMap objects for this table relationships */ public function buildRelations() { $this->addRelation('Category', '\\Category', RelationMap::MANY_TO_ONE, array ( 0 => array ( 0 => ':category_id', 1 => ':id', ), ), null, null, null, false); $this->addRelation('Product', '\\Product', RelationMap::MANY_TO_ONE, array ( 0 => array ( 0 => ':product_id', 1 => ':id', ), ), null, null, null, false); } // buildRelations() /** * 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 you may need to explicitly add objects * to the cache in order to ensure that the same objects are always returned by find*() * and findPk*() calls. * * @param \ProductCategory $obj A \ProductCategory object. * @param string $key (optional) key to use for instance map (for performance boost if key was already calculated externally). */ public static function addInstanceToPool($obj, $key = null) { if (Propel::isInstancePoolingEnabled()) { if (null === $key) { $key = serialize(array((string) $obj->getProductId(), (string) $obj->getCategoryId())); } // if key === null self::$instances[$key] = $obj; } } /** * Removes an object from 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 doDelete * methods in your stub classes -- you may need to explicitly remove objects * from the cache in order to prevent returning objects that no longer exist. * * @param mixed $value A \ProductCategory object or a primary key value. */ public static function removeInstanceFromPool($value) { if (Propel::isInstancePoolingEnabled() && null !== $value) { if (is_object($value) && $value instanceof \ProductCategory) { $key = serialize(array((string) $value->getProductId(), (string) $value->getCategoryId())); } elseif (is_array($value) && count($value) === 2) { // assume we've been passed a primary key"; $key = serialize(array((string) $value[0], (string) $value[1])); } elseif ($value instanceof Criteria) { self::$instances = []; return; } else { $e = new PropelException("Invalid value passed to removeInstanceFromPool(). Expected primary key or \ProductCategory object; got " . (is_object($value) ? get_class($value) . ' object.' : var_export($value, true))); throw $e; } unset(self::$instances[$key]); } } /** * Retrieves a string version of the primary key from the DB resultset row that can be used to uniquely identify a row in this table. * * For tables with a single-column primary key, that simple pkey value will be returned. For tables with * a multi-column primary key, a serialize()d version of the primary key will be returned. * * @param array $row resultset row. * @param int $offset The 0-based offset for reading from the resultset row. * @param string $indexType One of the class type constants TableMap::TYPE_PHPNAME, TableMap::TYPE_CAMELNAME * TableMap::TYPE_COLNAME, TableMap::TYPE_FIELDNAME, TableMap::TYPE_NUM * * @return string The primary key hash of the row */ public static function getPrimaryKeyHashFromRow($row, $offset = 0, $indexType = TableMap::TYPE_NUM) { // If the PK cannot be derived from the row, return NULL. if ($row[TableMap::TYPE_NUM == $indexType ? 0 + $offset : static::translateFieldName('ProductId', TableMap::TYPE_PHPNAME, $indexType)] === null && $row[TableMap::TYPE_NUM == $indexType ? 1 + $offset : static::translateFieldName('CategoryId', TableMap::TYPE_PHPNAME, $indexType)] === null) { return null; } return serialize(array((string) $row[TableMap::TYPE_NUM == $indexType ? 0 + $offset : static::translateFieldName('ProductId', TableMap::TYPE_PHPNAME, $indexType)], (string) $row[TableMap::TYPE_NUM == $indexType ? 1 + $offset : static::translateFieldName('CategoryId', TableMap::TYPE_PHPNAME, $indexType)])); } /** * Retrieves the primary key from the DB resultset row * For tables with a single-column primary key, that simple pkey value will be returned. For tables with * a multi-column primary key, an array of the primary key columns will be returned. * * @param array $row resultset row. * @param int $offset The 0-based offset for reading from the resultset row. * @param string $indexType One of the class type constants TableMap::TYPE_PHPNAME, TableMap::TYPE_CAMELNAME * TableMap::TYPE_COLNAME, TableMap::TYPE_FIELDNAME, TableMap::TYPE_NUM * * @return mixed The primary key of the row */ public static function getPrimaryKeyFromRow($row, $offset = 0, $indexType = TableMap::TYPE_NUM) { $pks = []; $pks[] = (int) $row[ $indexType == TableMap::TYPE_NUM ? 0 + $offset : self::translateFieldName('ProductId', TableMap::TYPE_PHPNAME, $indexType) ]; $pks[] = (int) $row[ $indexType == TableMap::TYPE_NUM ? 1 + $offset : self::translateFieldName('CategoryId', TableMap::TYPE_PHPNAME, $indexType) ]; return $pks; } /** * The class that the tableMap will make instances of. * * If $withPrefix is true, the returned path * uses a dot-path notation which is translated into a path * relative to a location on the PHP include_path. * (e.g. path.to.MyClass -> 'path/to/MyClass.php') * * @param boolean $withPrefix Whether or not to return the path with the class name * @return string path.to.ClassName */ public static function getOMClass($withPrefix = true) { return $withPrefix ? ProductCategoryTableMap::CLASS_DEFAULT : ProductCategoryTableMap::OM_CLASS; } /** * Populates an object of the default type or an object that inherit from the default. * * @param array $row row returned by DataFetcher->fetch(). * @param int $offset The 0-based offset for reading from the resultset row. * @param string $indexType The index type of $row. Mostly DataFetcher->getIndexType(). One of the class type constants TableMap::TYPE_PHPNAME, TableMap::TYPE_CAMELNAME * TableMap::TYPE_COLNAME, TableMap::TYPE_FIELDNAME, TableMap::TYPE_NUM. * * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. * @return array (ProductCategory object, last column rank) */ public static function populateObject($row, $offset = 0, $indexType = TableMap::TYPE_NUM) { $key = ProductCategoryTableMap::getPrimaryKeyHashFromRow($row, $offset, $indexType); if (null !== ($obj = ProductCategoryTableMap::getInstanceFromPool($key))) { // We no longer rehydrate the object, since this can cause data loss. // See http://www.propelorm.org/ticket/509 // $obj->hydrate($row, $offset, true); // rehydrate $col = $offset + ProductCategoryTableMap::NUM_HYDRATE_COLUMNS; } else { $cls = ProductCategoryTableMap::OM_CLASS; /** @var ProductCategory $obj */ $obj = new $cls(); $col = $obj->hydrate($row, $offset, false, $indexType); ProductCategoryTableMap::addInstanceToPool($obj, $key); } return array($obj, $col); } /** * The returned array will contain objects of the default type or * objects that inherit from the default. * * @param DataFetcherInterface $dataFetcher * @return array * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function populateObjects(DataFetcherInterface $dataFetcher) { $results = array(); // set the class once to avoid overhead in the loop $cls = static::getOMClass(false); // populate the object(s) while ($row = $dataFetcher->fetch()) { $key = ProductCategoryTableMap::getPrimaryKeyHashFromRow($row, 0, $dataFetcher->getIndexType()); if (null !== ($obj = ProductCategoryTableMap::getInstanceFromPool($key))) { // We no longer rehydrate the object, since this can cause data loss. // See http://www.propelorm.org/ticket/509 // $obj->hydrate($row, 0, true); // rehydrate $results[] = $obj; } else { /** @var ProductCategory $obj */ $obj = new $cls(); $obj->hydrate($row); $results[] = $obj; ProductCategoryTableMap::addInstanceToPool($obj, $key); } // if key exists } return $results; } /** * Add all the columns needed to create a new object. * * Note: any columns that were marked with lazyLoad="true" in the * XML schema will not be added to the select list and only loaded * on demand. * * @param Criteria $criteria object containing the columns to add. * @param string $alias optional table alias * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function addSelectColumns(Criteria $criteria, $alias = null) { if (null === $alias) { $criteria->addSelectColumn(ProductCategoryTableMap::COL_PRODUCT_ID); $criteria->addSelectColumn(ProductCategoryTableMap::COL_CATEGORY_ID); } else { $criteria->addSelectColumn($alias . '.product_id'); $criteria->addSelectColumn($alias . '.category_id'); } } /** * Returns the TableMap related to this object. * This method is not needed for general use but a specific application could have a need. * @return TableMap * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function getTableMap() { return Propel::getServiceContainer()->getDatabaseMap(ProductCategoryTableMap::DATABASE_NAME)->getTable(ProductCategoryTableMap::TABLE_NAME); } /** * Add a TableMap instance to the database for this tableMap class. */ public static function buildTableMap() { $dbMap = Propel::getServiceContainer()->getDatabaseMap(ProductCategoryTableMap::DATABASE_NAME); if (!$dbMap->hasTable(ProductCategoryTableMap::TABLE_NAME)) { $dbMap->addTableObject(new ProductCategoryTableMap()); } } /** * Performs a DELETE on the database, given a ProductCategory or Criteria object OR a primary key value. * * @param mixed $values Criteria or ProductCategory 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(ProductCategoryTableMap::DATABASE_NAME); } if ($values instanceof Criteria) { // rename for clarity $criteria = $values; } elseif ($values instanceof \ProductCategory) { // 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(ProductCategoryTableMap::DATABASE_NAME); // primary key is composite; we therefore, expect // the primary key passed to be an array of pkey values if (count($values) == count($values, COUNT_RECURSIVE)) { // array is not multi-dimensional $values = array($values); } foreach ($values as $value) { $criterion = $criteria->getNewCriterion(ProductCategoryTableMap::COL_PRODUCT_ID, $value[0]); $criterion->addAnd($criteria->getNewCriterion(ProductCategoryTableMap::COL_CATEGORY_ID, $value[1])); $criteria->addOr($criterion); } } $query = ProductCategoryQuery::create()->mergeWith($criteria); if ($values instanceof Criteria) { ProductCategoryTableMap::clearInstancePool(); } elseif (!is_object($values)) { // it's a primary key, or an array of pks foreach ((array) $values as $singleval) { ProductCategoryTableMap::removeInstanceFromPool($singleval); } } return $query->delete($con); } /** * Deletes all rows from the product_category table. * * @param ConnectionInterface $con the connection to use * @return int The number of affected rows (if supported by underlying database driver). */ public static function doDeleteAll(ConnectionInterface $con = null) { return ProductCategoryQuery::create()->doDeleteAll($con); } /** * Performs an INSERT on the database, given a ProductCategory or Criteria object. * * @param mixed $criteria Criteria or ProductCategory object containing data that is used to create the INSERT statement. * @param ConnectionInterface $con the ConnectionInterface connection to use * @return mixed The new primary key. * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function doInsert($criteria, ConnectionInterface $con = null) { if (null === $con) { $con = Propel::getServiceContainer()->getWriteConnection(ProductCategoryTableMap::DATABASE_NAME); } if ($criteria instanceof Criteria) { $criteria = clone $criteria; // rename for clarity } else { $criteria = $criteria->buildCriteria(); // build Criteria from ProductCategory object } // Set the correct dbName $query = ProductCategoryQuery::create()->mergeWith($criteria); // use transaction because $criteria could contain info // for more than one table (I guess, conceivably) return $con->transaction(function () use ($con, $query) { return $query->doInsert($con); }); } } // ProductCategoryTableMap // This is the static code needed to register the TableMap for this table with the main Propel class. // ProductCategoryTableMap::buildTableMap();