{

protected $entityNotFoundExceptionClass = '\\Propel\\Runtime\\Exception\\EntityNotFoundException';

/**

public function __construct($dbName = 'default', $modelName = '\\SOB\\Propel2\\Product', $modelAlias = null)

{

parent::__construct($dbName, $modelName, $modelAlias);

}

/**

public static function create(?string $modelAlias = null, ?Criteria $criteria = null) : Criteria

{

if ($criteria instanceof ChildProductQuery) {

return $criteria;

}

$query = new ChildProductQuery();

if (null !== $modelAlias) {

$query->setModelAlias($modelAlias);

}

if ($criteria instanceof Criteria) {

$query->mergeWith($criteria);

}

return $query;

}

/**

public function delete(?ConnectionInterface $con = null) : int

{

if (null === $con) {

$con = Propel::getServiceContainer()->getWriteConnection(ProductTableMap::DATABASE_NAME);

}

$criteria = $this;

// Set the correct dbName

$criteria->setDbName(ProductTableMap::DATABASE_NAME);

// use transaction because $criteria could contain info

// for more than one table or we could emulating ON DELETE CASCADE, etc.

return $con->transaction(function() use ($con, $criteria) {

$affectedRows = 0; // initialize var to track total num of affected rows

ProductTableMap::removeInstanceFromPool($criteria);

$affectedRows += parent::delete($con);

ProductTableMap::clearRelatedInstancePool();

return $affectedRows;

});

}

/**

public function doDeleteAll(?ConnectionInterface $con = null) : int

{

if (null === $con) {

$con = Propel::getServiceContainer()->getWriteConnection(ProductTableMap::DATABASE_NAME);

}

// use transaction because $criteria could contain info

// for more than one table or we could emulating ON DELETE CASCADE, etc.

return $con->transaction(function() use ($con) {

$affectedRows = 0; // initialize var to track total num of affected rows

$affectedRows += parent::doDeleteAll($con);

// Because this db requires some delete cascade/set null emulation, we have to

// clear the cached instance *after* the emulation has happened (since

// instances get re-added by the select statement contained therein).

ProductTableMap::clearInstancePool();

ProductTableMap::clearRelatedInstancePool();

return $affectedRows;

});

}

/**

public function filterByAttachments($attachments = null, ?string $comparison = null)

{

$this->addUsingAlias(ProductTableMap::COL_ATTACHMENTS, $attachments, $comparison);

return $this;

}

/**

public function filterByCategory($category = null, ?string $comparison = null)

{

if (null === $comparison) {

if (\is_array($category)) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(ProductTableMap::COL_CATEGORY, $category, $comparison);

return $this;

}

/**

public function filterByDescription($description = null, ?string $comparison = null)

{

if (null === $comparison) {

if (\is_array($description)) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(ProductTableMap::COL_DESCRIPTION, $description, $comparison);

return $this;

}

/**

public function filterByDiscontinued($discontinued = null, ?string $comparison = null)

{

if (\is_array($discontinued)) {

$useMinMax = false;

if (isset($discontinued['min'])) {

$this->addUsingAlias(ProductTableMap::COL_DISCONTINUED, $discontinued['min'], Criteria::GREATER_EQUAL);

$useMinMax = true;

}

if (isset($discontinued['max'])) {

$this->addUsingAlias(ProductTableMap::COL_DISCONTINUED, $discontinued['max'], Criteria::LESS_EQUAL);

$useMinMax = true;

}

if ($useMinMax) {

return $this;

}

if (null === $comparison) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(ProductTableMap::COL_DISCONTINUED, $discontinued, $comparison);

return $this;

}

/**

public function filterByListPrice($listPrice = null, ?string $comparison = null)

{

if (\is_array($listPrice)) {

$useMinMax = false;

if (isset($listPrice['min'])) {

$this->addUsingAlias(ProductTableMap::COL_LIST_PRICE, $listPrice['min'], Criteria::GREATER_EQUAL);

$useMinMax = true;

}

if (isset($listPrice['max'])) {

$this->addUsingAlias(ProductTableMap::COL_LIST_PRICE, $listPrice['max'], Criteria::LESS_EQUAL);

$useMinMax = true;

}

if ($useMinMax) {

return $this;

}

if (null === $comparison) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(ProductTableMap::COL_LIST_PRICE, $listPrice, $comparison);

return $this;

}

/**

public function filterByMinimumReorderQuantity($minimumReorderQuantity = null, ?string $comparison = null)

{

if (\is_array($minimumReorderQuantity)) {

$useMinMax = false;

if (isset($minimumReorderQuantity['min'])) {

$this->addUsingAlias(ProductTableMap::COL_MINIMUM_REORDER_QUANTITY, $minimumReorderQuantity['min'], Criteria::GREATER_EQUAL);

$useMinMax = true;

}

if (isset($minimumReorderQuantity['max'])) {

$this->addUsingAlias(ProductTableMap::COL_MINIMUM_REORDER_QUANTITY, $minimumReorderQuantity['max'], Criteria::LESS_EQUAL);

$useMinMax = true;

}

if ($useMinMax) {

return $this;

}

if (null === $comparison) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(ProductTableMap::COL_MINIMUM_REORDER_QUANTITY, $minimumReorderQuantity, $comparison);

return $this;

}

/**

public function filterByPrimaryKey($key)

{

$this->addUsingAlias(ProductTableMap::COL_PRODUCT_ID, $key, Criteria::EQUAL);

return $this;

}

/**

public function filterByPrimaryKeys($keys)

{

$this->addUsingAlias(ProductTableMap::COL_PRODUCT_ID, $keys, Criteria::IN);

return $this;

}

/**

public function filterByProductCode($productCode = null, ?string $comparison = null)

{

if (null === $comparison) {

if (\is_array($productCode)) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(ProductTableMap::COL_PRODUCT_CODE, $productCode, $comparison);

return $this;

}

/**

public function filterByProductId($productId = null, ?string $comparison = null)

{

if (\is_array($productId)) {

$useMinMax = false;

if (isset($productId['min'])) {

$this->addUsingAlias(ProductTableMap::COL_PRODUCT_ID, $productId['min'], Criteria::GREATER_EQUAL);

$useMinMax = true;

}

if (isset($productId['max'])) {

$this->addUsingAlias(ProductTableMap::COL_PRODUCT_ID, $productId['max'], Criteria::LESS_EQUAL);

$useMinMax = true;

}

if ($useMinMax) {

return $this;

}

if (null === $comparison) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(ProductTableMap::COL_PRODUCT_ID, $productId, $comparison);

return $this;

}

/**

public function filterByProductName($productName = null, ?string $comparison = null)

{

if (null === $comparison) {

if (\is_array($productName)) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(ProductTableMap::COL_PRODUCT_NAME, $productName, $comparison);

return $this;

}

/**

public function filterByQuantityPerUnit($quantityPerUnit = null, ?string $comparison = null)

{

if (null === $comparison) {

if (\is_array($quantityPerUnit)) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(ProductTableMap::COL_QUANTITY_PER_UNIT, $quantityPerUnit, $comparison);

return $this;

}

/**

public function filterByReorderLevel($reorderLevel = null, ?string $comparison = null)

{

if (\is_array($reorderLevel)) {

$useMinMax = false;

if (isset($reorderLevel['min'])) {

$this->addUsingAlias(ProductTableMap::COL_REORDER_LEVEL, $reorderLevel['min'], Criteria::GREATER_EQUAL);

$useMinMax = true;

}

if (isset($reorderLevel['max'])) {

$this->addUsingAlias(ProductTableMap::COL_REORDER_LEVEL, $reorderLevel['max'], Criteria::LESS_EQUAL);

$useMinMax = true;

}

if ($useMinMax) {

return $this;

}

if (null === $comparison) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(ProductTableMap::COL_REORDER_LEVEL, $reorderLevel, $comparison);

return $this;

}

/**

public function filterByStandardCost($standardCost = null, ?string $comparison = null)

{

if (\is_array($standardCost)) {

$useMinMax = false;

if (isset($standardCost['min'])) {

$this->addUsingAlias(ProductTableMap::COL_STANDARD_COST, $standardCost['min'], Criteria::GREATER_EQUAL);

$useMinMax = true;

}

if (isset($standardCost['max'])) {

$this->addUsingAlias(ProductTableMap::COL_STANDARD_COST, $standardCost['max'], Criteria::LESS_EQUAL);

$useMinMax = true;

}

if ($useMinMax) {

return $this;

}

if (null === $comparison) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(ProductTableMap::COL_STANDARD_COST, $standardCost, $comparison);

return $this;

}

/**

public function filterByTargetLevel($targetLevel = null, ?string $comparison = null)

{

if (\is_array($targetLevel)) {

$useMinMax = false;

if (isset($targetLevel['min'])) {

$this->addUsingAlias(ProductTableMap::COL_TARGET_LEVEL, $targetLevel['min'], Criteria::GREATER_EQUAL);

$useMinMax = true;

}

if (isset($targetLevel['max'])) {

$this->addUsingAlias(ProductTableMap::COL_TARGET_LEVEL, $targetLevel['max'], Criteria::LESS_EQUAL);

$useMinMax = true;

}

if ($useMinMax) {

return $this;

}

if (null === $comparison) {

$comparison = Criteria::IN;

}

}

$this->addUsingAlias(ProductTableMap::COL_TARGET_LEVEL, $targetLevel, $comparison);

return $this;

}

/**

public function findPk($key, ?ConnectionInterface $con = null)

{

if (null === $key) {

return null;

}

if (null === $con) {

$con = Propel::getServiceContainer()->getReadConnection(ProductTableMap::DATABASE_NAME);

}

$this->basePreSelect($con);

if (

$this->formatter || $this->modelAlias || $this->with || $this->select

|| $this->selectColumns || $this->asColumns || $this->selectModifiers

|| $this->map || $this->having || $this->joins

) {

return $this->findPkComplex($key, $con);

}

if ((null !== ($obj = ProductTableMap::getInstanceFromPool(null === $key || \is_scalar($key) || \is_callable([$key, '__toString']) ? (string)$key : $key)))) {

// the object is already in the instance pool

return $obj;

}

return $this->findPkSimple($key, $con);

}

/**

public function findPks($keys, ?ConnectionInterface $con = null)

{

if (null === $con) {

$con = Propel::getServiceContainer()->getReadConnection($this->getDbName());

}

$this->basePreSelect($con);

$criteria = $this->isKeepQuery() ? clone $this : $this;

$dataFetcher = $criteria

->filterByPrimaryKeys($keys)

->doSelect($con);

return $criteria->getFormatter()->init($criteria)->format($dataFetcher);

}

/**

public function prune($product = null)

{

if ($product) {

$this->addUsingAlias(ProductTableMap::COL_PRODUCT_ID, $product->getProductId(), Criteria::NOT_EQUAL);

}

return $this;

}

/**

protected function findPkComplex($key, ConnectionInterface $con)

{

// As the query uses a PK condition, no limit(1) is necessary.

$criteria = $this->isKeepQuery() ? clone $this : $this;

$dataFetcher = $criteria

->filterByPrimaryKey($key)

->doSelect($con);

return $criteria->getFormatter()->init($criteria)->formatOne($dataFetcher);

}

/**

protected function findPkSimple($key, ConnectionInterface $con)

{

$sql = 'SELECT product_id, product_code, product_name, description, standard_cost, list_price, reorder_level, target_level, quantity_per_unit, discontinued, minimum_reorder_quantity, category, attachments FROM product WHERE product_id = :p0';

try {

$stmt = $con->prepare($sql);

$stmt->bindValue(':p0', $key, PDO::PARAM_INT);

$stmt->execute();

} catch (Exception $e) {

Propel::log($e->getMessage(), Propel::LOG_ERR);

throw new PropelException(\sprintf('Unable to execute SELECT statement [%s]', $sql), 0, $e);

}

$obj = null;

if ($row = $stmt->fetch(\PDO::FETCH_NUM)) {

/** @var ChildProduct $obj */

$obj = new ChildProduct();

$obj->hydrate($row);

ProductTableMap::addInstanceToPool($obj, null === $key || \is_scalar($key) || \is_callable([$key, '__toString']) ? (string)$key : $key);

}

$stmt->closeCursor();

return $obj;

}