/**
* @param string $xml
*
* @return Database|boolean
*/
public function applyXml($xml, $changeRequired = false)
{
$this->readDatabase();
$builder = new QuickBuilder();
$builder->setIdentifierQuoting(true);
$builder->setPlatform($this->database->getPlatform());
$builder->setSchema($xml);
$database = $builder->getDatabase();
$database->setSchema('migration');
$database->setPlatform($this->database->getPlatform());
$diff = DatabaseComparator::computeDiff($this->database, $database);
if (false === $diff) {
if ($changeRequired) {
throw new BuildException(sprintf("No changes in schema to current database: \nSchema database:\n%s\n\nCurrent Database:\n%s", $database, $this->database));
}
return false;
}
$sql = $this->database->getPlatform()->getModifyDatabaseDDL($diff);
$this->con->beginTransaction();
if (!$sql) {
throw new BuildException(sprintf('Ooops. There is a diff between current database and schema xml but no SQL has been generated. Change: %s', $diff));
}
$statements = SqlParser::parseString($sql);
foreach ($statements as $statement) {
try {
$stmt = $this->con->prepare($statement);
$stmt->execute();
} catch (\Exception $e) {
throw new BuildException(sprintf("Can not execute SQL: \n%s\nFrom database: \n%s\n\nTo database: \n%s\n", $statement, $this->database, $database), null, $e);
}
}
$this->con->commit();
return $database;
}
/**
* @param string $xml
*
* @return Database
*/
public function applyXml($xml)
{
$this->readDatabase();
$builder = new QuickBuilder();
$builder->setPlatform($this->database->getPlatform());
$builder->setSchema($xml);
$database = $builder->getDatabase();
$database->setSchema('migration');
$database->setPlatform($this->database->getPlatform());
$diff = DatabaseComparator::computeDiff($this->database, $database);
if (false === $diff) {
return null;
}
$sql = $this->database->getPlatform()->getModifyDatabaseDDL($diff);
$this->con->beginTransaction();
$statements = SqlParser::parseString($sql);
foreach ($statements as $statement) {
try {
$stmt = $this->con->prepare($statement);
$stmt->execute();
} catch (\Exception $e) {
$this->con->rollBack();
throw new BuildException(sprintf("Can not execute SQL: \n%s\nFrom database: \n%s\n\nTo database: \n%s\n", $statement, $this->database, $database), null, $e);
}
}
$this->con->commit();
return $database;
}
/**
* Execute a list of DDL statements based on an array
* Does not use transactions since they are not supported in DDL statements
*
* @param array $statements a list of SQL statements
* @param ConnectionInterface $connection a connection object
*
* @return integer the number of executed statements
*/
protected static function executeStatements($statements, ConnectionInterface $connection)
{
$executed = 0;
foreach ($statements as $statement) {
$stmt = $connection->prepare($statement);
if ($stmt instanceof StatementInterface) {
// only execute if has no error
$stmt->execute();
$executed++;
}
}
return $executed;
}
/**
* Detects the differences between current connected database and $pDatabase
* and updates the schema. This does not DROP tables.
*
* @param Database $pDatabase
*/
public function updateSchema($pDatabase)
{
$diff = DatabaseComparator::computeDiff($this->database, $pDatabase);
$sql = $this->database->getPlatform()->getModifyDatabaseDDL($diff);
$statements = SqlParser::parseString($sql);
foreach ($statements as $statement) {
if (strpos($statement, 'DROP') === 0) {
// drop statements cause errors since the table doesn't exist
continue;
}
$stmt = $this->con->prepare($statement);
$stmt->execute();
}
}
/**
* Insert the row in the database.
*
* @param ConnectionInterface $con
*
* @throws PropelException
* @see doSave()
*/
protected function doInsert(ConnectionInterface $con)
{
$modifiedColumns = array();
$index = 0;
$this->modifiedColumns[WishlistProductTableMap::COL_WISHLIST_PRODUCT_ID] = true;
if (null !== $this->wishlist_product_id) {
throw new PropelException('Cannot insert a value for auto-increment primary key (' . WishlistProductTableMap::COL_WISHLIST_PRODUCT_ID . ')');
}
// check the columns in natural order for more readable SQL queries
if ($this->isColumnModified(WishlistProductTableMap::COL_WISHLIST_PRODUCT_ID)) {
$modifiedColumns[':p' . $index++] = 'wishlist_product_id';
}
if ($this->isColumnModified(WishlistProductTableMap::COL_WISHLIST_ID)) {
$modifiedColumns[':p' . $index++] = 'wishlist_id';
}
if ($this->isColumnModified(WishlistProductTableMap::COL_PRODUCT_ID)) {
$modifiedColumns[':p' . $index++] = 'product_id';
}
if ($this->isColumnModified(WishlistProductTableMap::COL_WISHLIST_PRODUCT_COMMENT)) {
$modifiedColumns[':p' . $index++] = 'wishlist_product_comment';
}
if ($this->isColumnModified(WishlistProductTableMap::COL_CREATED_AT)) {
$modifiedColumns[':p' . $index++] = 'created_at';
}
if ($this->isColumnModified(WishlistProductTableMap::COL_UPDATED_AT)) {
$modifiedColumns[':p' . $index++] = 'updated_at';
}
$sql = sprintf('INSERT INTO wishlist_product (%s) VALUES (%s)', implode(', ', $modifiedColumns), implode(', ', array_keys($modifiedColumns)));
try {
$stmt = $con->prepare($sql);
foreach ($modifiedColumns as $identifier => $columnName) {
switch ($columnName) {
case 'wishlist_product_id':
$stmt->bindValue($identifier, $this->wishlist_product_id, PDO::PARAM_INT);
break;
case 'wishlist_id':
$stmt->bindValue($identifier, $this->wishlist_id, PDO::PARAM_INT);
break;
case 'product_id':
$stmt->bindValue($identifier, $this->product_id, PDO::PARAM_INT);
break;
case 'wishlist_product_comment':
$stmt->bindValue($identifier, $this->wishlist_product_comment, PDO::PARAM_STR);
break;
case 'created_at':
$stmt->bindValue($identifier, $this->created_at ? $this->created_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
case 'updated_at':
$stmt->bindValue($identifier, $this->updated_at ? $this->updated_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
}
}
$stmt->execute();
} catch (Exception $e) {
Propel::log($e->getMessage(), Propel::LOG_ERR);
throw new PropelException(sprintf('Unable to execute INSERT statement [%s]', $sql), 0, $e);
}
try {
$pk = $con->lastInsertId();
} catch (Exception $e) {
throw new PropelException('Unable to get autoincrement id.', 0, $e);
}
$this->setWishlistProductId($pk);
$this->setNew(false);
}
/**
* Find object by primary key using raw SQL to go fast.
* Bypass doSelect() and the object formatter by using generated code.
*
* @param mixed $key Primary key to use for the query
* @param ConnectionInterface $con A connection object
*
* @throws \Propel\Runtime\Exception\PropelException
*
* @return ChildPermissionGroupUser A model object, or null if the key is not found
*/
protected function findPkSimple($key, ConnectionInterface $con)
{
$sql = 'SELECT `user_id`, `group_id` FROM `permission_group_user` WHERE `user_id` = :p0 AND `group_id` = :p1';
try {
$stmt = $con->prepare($sql);
$stmt->bindValue(':p0', $key[0], PDO::PARAM_INT);
$stmt->bindValue(':p1', $key[1], 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 ChildPermissionGroupUser $obj */
$obj = new ChildPermissionGroupUser();
$obj->hydrate($row);
PermissionGroupUserTableMap::addInstanceToPool($obj, serialize([null === $key[0] || is_scalar($key[0]) || is_callable([$key[0], '__toString']) ? (string) $key[0] : $key[0], null === $key[1] || is_scalar($key[1]) || is_callable([$key[1], '__toString']) ? (string) $key[1] : $key[1]]));
}
$stmt->closeCursor();
return $obj;
}
/**
* Insert the row in the database.
*
* @param ConnectionInterface $con
*
* @throws PropelException
* @see doSave()
*/
protected function doInsert(ConnectionInterface $con)
{
$modifiedColumns = array();
$index = 0;
// check the columns in natural order for more readable SQL queries
if ($this->isColumnModified(MenuI18nVersionTableMap::ID)) {
$modifiedColumns[':p' . $index++] = 'ID';
}
if ($this->isColumnModified(MenuI18nVersionTableMap::LOCALE)) {
$modifiedColumns[':p' . $index++] = 'LOCALE';
}
if ($this->isColumnModified(MenuI18nVersionTableMap::TITLE)) {
$modifiedColumns[':p' . $index++] = 'TITLE';
}
if ($this->isColumnModified(MenuI18nVersionTableMap::DESCRIPTION)) {
$modifiedColumns[':p' . $index++] = 'DESCRIPTION';
}
if ($this->isColumnModified(MenuI18nVersionTableMap::CHAPO)) {
$modifiedColumns[':p' . $index++] = 'CHAPO';
}
if ($this->isColumnModified(MenuI18nVersionTableMap::POSTSCRIPTUM)) {
$modifiedColumns[':p' . $index++] = 'POSTSCRIPTUM';
}
if ($this->isColumnModified(MenuI18nVersionTableMap::CREATED_AT)) {
$modifiedColumns[':p' . $index++] = 'CREATED_AT';
}
if ($this->isColumnModified(MenuI18nVersionTableMap::UPDATED_AT)) {
$modifiedColumns[':p' . $index++] = 'UPDATED_AT';
}
if ($this->isColumnModified(MenuI18nVersionTableMap::VERSION)) {
$modifiedColumns[':p' . $index++] = 'VERSION';
}
if ($this->isColumnModified(MenuI18nVersionTableMap::VERSION_CREATED_AT)) {
$modifiedColumns[':p' . $index++] = 'VERSION_CREATED_AT';
}
if ($this->isColumnModified(MenuI18nVersionTableMap::VERSION_CREATED_BY)) {
$modifiedColumns[':p' . $index++] = 'VERSION_CREATED_BY';
}
$sql = sprintf('INSERT INTO menu_i18n_version (%s) VALUES (%s)', implode(', ', $modifiedColumns), implode(', ', array_keys($modifiedColumns)));
try {
$stmt = $con->prepare($sql);
foreach ($modifiedColumns as $identifier => $columnName) {
switch ($columnName) {
case 'ID':
$stmt->bindValue($identifier, $this->id, PDO::PARAM_INT);
break;
case 'LOCALE':
$stmt->bindValue($identifier, $this->locale, PDO::PARAM_STR);
break;
case 'TITLE':
$stmt->bindValue($identifier, $this->title, PDO::PARAM_STR);
break;
case 'DESCRIPTION':
$stmt->bindValue($identifier, $this->description, PDO::PARAM_STR);
break;
case 'CHAPO':
$stmt->bindValue($identifier, $this->chapo, PDO::PARAM_STR);
break;
case 'POSTSCRIPTUM':
$stmt->bindValue($identifier, $this->postscriptum, PDO::PARAM_STR);
break;
case 'CREATED_AT':
$stmt->bindValue($identifier, $this->created_at ? $this->created_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
case 'UPDATED_AT':
$stmt->bindValue($identifier, $this->updated_at ? $this->updated_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
case 'VERSION':
$stmt->bindValue($identifier, $this->version, PDO::PARAM_INT);
break;
case 'VERSION_CREATED_AT':
$stmt->bindValue($identifier, $this->version_created_at ? $this->version_created_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
case 'VERSION_CREATED_BY':
$stmt->bindValue($identifier, $this->version_created_by, PDO::PARAM_STR);
break;
}
}
$stmt->execute();
} catch (Exception $e) {
Propel::log($e->getMessage(), Propel::LOG_ERR);
throw new PropelException(sprintf('Unable to execute INSERT statement [%s]', $sql), 0, $e);
}
$this->setNew(false);
}
/**
* Find object by primary key using raw SQL to go fast.
* Bypass doSelect() and the object formatter by using generated code.
*
* @param mixed $key Primary key to use for the query
* @param ConnectionInterface $con A connection object
*
* @throws \Propel\Runtime\Exception\PropelException
*
* @return ChildPlayersOld A model object, or null if the key is not found
*/
protected function findPkSimple($key, ConnectionInterface $con)
{
$sql = 'SELECT ID, lastn, bats, bday, age, mlb, draft_year, position, card, d_e, lg, mwbl, category, comment, mwbl_link, mlb_link, mwbl_link_enabled, mlb_link_enabled FROM players_old WHERE 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 ChildPlayersOld $obj */
$obj = new ChildPlayersOld();
$obj->hydrate($row);
PlayersOldTableMap::addInstanceToPool($obj, (string) $key);
}
$stmt->closeCursor();
return $obj;
}
/**
* Find object by primary key using raw SQL to go fast.
* Bypass doSelect() and the object formatter by using generated code.
*
* @param mixed $key Primary key to use for the query
* @param ConnectionInterface $con A connection object
*
* @return ChildCouponCountry A model object, or null if the key is not found
*/
protected function findPkSimple($key, $con)
{
$sql = 'SELECT `COUPON_ID`, `COUNTRY_ID` FROM `coupon_country` WHERE `COUPON_ID` = :p0 AND `COUNTRY_ID` = :p1';
try {
$stmt = $con->prepare($sql);
$stmt->bindValue(':p0', $key[0], PDO::PARAM_INT);
$stmt->bindValue(':p1', $key[1], 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)) {
$obj = new ChildCouponCountry();
$obj->hydrate($row);
CouponCountryTableMap::addInstanceToPool($obj, serialize(array((string) $key[0], (string) $key[1])));
}
$stmt->closeCursor();
return $obj;
}
/**
* Find object by primary key using raw SQL to go fast.
* Bypass doSelect() and the object formatter by using generated code.
*
* @param mixed $key Primary key to use for the query
* @param ConnectionInterface $con A connection object
*
* @throws \Propel\Runtime\Exception\PropelException
*
* @return ChildTranslationCatalog A model object, or null if the key is not found
*/
protected function findPkSimple($key, ConnectionInterface $con)
{
$sql = 'SELECT id, application_id, name, created_at, updated_at FROM translation_catalog WHERE 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 ChildTranslationCatalog $obj */
$obj = new ChildTranslationCatalog();
$obj->hydrate($row);
TranslationCatalogTableMap::addInstanceToPool($obj, (string) $key);
}
$stmt->closeCursor();
return $obj;
}
/**
* Insert the row in the database.
*
* @param ConnectionInterface $con
*
* @throws PropelException
* @see doSave()
*/
protected function doInsert(ConnectionInterface $con)
{
$modifiedColumns = array();
$index = 0;
// check the columns in natural order for more readable SQL queries
if ($this->isColumnModified(CouponVersionTableMap::ID)) {
$modifiedColumns[':p' . $index++] = '`ID`';
}
if ($this->isColumnModified(CouponVersionTableMap::CODE)) {
$modifiedColumns[':p' . $index++] = '`CODE`';
}
if ($this->isColumnModified(CouponVersionTableMap::TYPE)) {
$modifiedColumns[':p' . $index++] = '`TYPE`';
}
if ($this->isColumnModified(CouponVersionTableMap::SERIALIZED_EFFECTS)) {
$modifiedColumns[':p' . $index++] = '`SERIALIZED_EFFECTS`';
}
if ($this->isColumnModified(CouponVersionTableMap::IS_ENABLED)) {
$modifiedColumns[':p' . $index++] = '`IS_ENABLED`';
}
if ($this->isColumnModified(CouponVersionTableMap::START_DATE)) {
$modifiedColumns[':p' . $index++] = '`START_DATE`';
}
if ($this->isColumnModified(CouponVersionTableMap::EXPIRATION_DATE)) {
$modifiedColumns[':p' . $index++] = '`EXPIRATION_DATE`';
}
if ($this->isColumnModified(CouponVersionTableMap::MAX_USAGE)) {
$modifiedColumns[':p' . $index++] = '`MAX_USAGE`';
}
if ($this->isColumnModified(CouponVersionTableMap::IS_CUMULATIVE)) {
$modifiedColumns[':p' . $index++] = '`IS_CUMULATIVE`';
}
if ($this->isColumnModified(CouponVersionTableMap::IS_REMOVING_POSTAGE)) {
$modifiedColumns[':p' . $index++] = '`IS_REMOVING_POSTAGE`';
}
if ($this->isColumnModified(CouponVersionTableMap::IS_AVAILABLE_ON_SPECIAL_OFFERS)) {
$modifiedColumns[':p' . $index++] = '`IS_AVAILABLE_ON_SPECIAL_OFFERS`';
}
if ($this->isColumnModified(CouponVersionTableMap::IS_USED)) {
$modifiedColumns[':p' . $index++] = '`IS_USED`';
}
if ($this->isColumnModified(CouponVersionTableMap::SERIALIZED_CONDITIONS)) {
$modifiedColumns[':p' . $index++] = '`SERIALIZED_CONDITIONS`';
}
if ($this->isColumnModified(CouponVersionTableMap::PER_CUSTOMER_USAGE_COUNT)) {
$modifiedColumns[':p' . $index++] = '`PER_CUSTOMER_USAGE_COUNT`';
}
if ($this->isColumnModified(CouponVersionTableMap::CREATED_AT)) {
$modifiedColumns[':p' . $index++] = '`CREATED_AT`';
}
if ($this->isColumnModified(CouponVersionTableMap::UPDATED_AT)) {
$modifiedColumns[':p' . $index++] = '`UPDATED_AT`';
}
if ($this->isColumnModified(CouponVersionTableMap::VERSION)) {
$modifiedColumns[':p' . $index++] = '`VERSION`';
}
if ($this->isColumnModified(CouponVersionTableMap::VERSION_CREATED_AT)) {
$modifiedColumns[':p' . $index++] = '`VERSION_CREATED_AT`';
}
if ($this->isColumnModified(CouponVersionTableMap::VERSION_CREATED_BY)) {
$modifiedColumns[':p' . $index++] = '`VERSION_CREATED_BY`';
}
$sql = sprintf('INSERT INTO `coupon_version` (%s) VALUES (%s)', implode(', ', $modifiedColumns), implode(', ', array_keys($modifiedColumns)));
try {
$stmt = $con->prepare($sql);
foreach ($modifiedColumns as $identifier => $columnName) {
switch ($columnName) {
case '`ID`':
$stmt->bindValue($identifier, $this->id, PDO::PARAM_INT);
break;
case '`CODE`':
$stmt->bindValue($identifier, $this->code, PDO::PARAM_STR);
break;
case '`TYPE`':
$stmt->bindValue($identifier, $this->type, PDO::PARAM_STR);
break;
case '`SERIALIZED_EFFECTS`':
$stmt->bindValue($identifier, $this->serialized_effects, PDO::PARAM_STR);
break;
case '`IS_ENABLED`':
$stmt->bindValue($identifier, (int) $this->is_enabled, PDO::PARAM_INT);
break;
case '`START_DATE`':
$stmt->bindValue($identifier, $this->start_date ? $this->start_date->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
case '`EXPIRATION_DATE`':
$stmt->bindValue($identifier, $this->expiration_date ? $this->expiration_date->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
case '`MAX_USAGE`':
$stmt->bindValue($identifier, $this->max_usage, PDO::PARAM_INT);
break;
case '`IS_CUMULATIVE`':
$stmt->bindValue($identifier, (int) $this->is_cumulative, PDO::PARAM_INT);
break;
case '`IS_REMOVING_POSTAGE`':
$stmt->bindValue($identifier, (int) $this->is_removing_postage, PDO::PARAM_INT);
break;
case '`IS_AVAILABLE_ON_SPECIAL_OFFERS`':
$stmt->bindValue($identifier, (int) $this->is_available_on_special_offers, PDO::PARAM_INT);
break;
case '`IS_USED`':
$stmt->bindValue($identifier, (int) $this->is_used, PDO::PARAM_INT);
break;
case '`SERIALIZED_CONDITIONS`':
$stmt->bindValue($identifier, $this->serialized_conditions, PDO::PARAM_STR);
break;
case '`PER_CUSTOMER_USAGE_COUNT`':
$stmt->bindValue($identifier, (int) $this->per_customer_usage_count, PDO::PARAM_INT);
break;
case '`CREATED_AT`':
$stmt->bindValue($identifier, $this->created_at ? $this->created_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
case '`UPDATED_AT`':
$stmt->bindValue($identifier, $this->updated_at ? $this->updated_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
case '`VERSION`':
$stmt->bindValue($identifier, $this->version, PDO::PARAM_INT);
break;
case '`VERSION_CREATED_AT`':
$stmt->bindValue($identifier, $this->version_created_at ? $this->version_created_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
case '`VERSION_CREATED_BY`':
$stmt->bindValue($identifier, $this->version_created_by, PDO::PARAM_STR);
break;
}
}
$stmt->execute();
} catch (Exception $e) {
Propel::log($e->getMessage(), Propel::LOG_ERR);
throw new PropelException(sprintf('Unable to execute INSERT statement [%s]', $sql), 0, $e);
}
$this->setNew(false);
}
/**
* Find object by primary key using raw SQL to go fast.
* Bypass doSelect() and the object formatter by using generated code.
*
* @param mixed $key Primary key to use for the query
* @param ConnectionInterface $con A connection object
*
* @return ChildCustomerTitleI18n A model object, or null if the key is not found
*/
protected function findPkSimple($key, $con)
{
$sql = 'SELECT `ID`, `LOCALE`, `SHORT`, `LONG` FROM `customer_title_i18n` WHERE `ID` = :p0 AND `LOCALE` = :p1';
try {
$stmt = $con->prepare($sql);
$stmt->bindValue(':p0', $key[0], PDO::PARAM_INT);
$stmt->bindValue(':p1', $key[1], PDO::PARAM_STR);
$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)) {
$obj = new ChildCustomerTitleI18n();
$obj->hydrate($row);
CustomerTitleI18nTableMap::addInstanceToPool($obj, serialize(array((string) $key[0], (string) $key[1])));
}
$stmt->closeCursor();
return $obj;
}
/**
* Insert the row in the database.
*
* @param ConnectionInterface $con
*
* @throws PropelException
* @see doSave()
*/
protected function doInsert(ConnectionInterface $con)
{
$modifiedColumns = array();
$index = 0;
$this->modifiedColumns[JaCategoriasTableMap::COL_ID] = true;
if (null !== $this->id) {
throw new PropelException('Cannot insert a value for auto-increment primary key (' . JaCategoriasTableMap::COL_ID . ')');
}
// check the columns in natural order for more readable SQL queries
if ($this->isColumnModified(JaCategoriasTableMap::COL_ID)) {
$modifiedColumns[':p' . $index++] = 'id';
}
if ($this->isColumnModified(JaCategoriasTableMap::COL_TITULO)) {
$modifiedColumns[':p' . $index++] = 'titulo';
}
if ($this->isColumnModified(JaCategoriasTableMap::COL_SLUG)) {
$modifiedColumns[':p' . $index++] = 'slug';
}
$sql = sprintf('INSERT INTO ja_categorias (%s) VALUES (%s)', implode(', ', $modifiedColumns), implode(', ', array_keys($modifiedColumns)));
try {
$stmt = $con->prepare($sql);
foreach ($modifiedColumns as $identifier => $columnName) {
switch ($columnName) {
case 'id':
$stmt->bindValue($identifier, $this->id, PDO::PARAM_INT);
break;
case 'titulo':
$stmt->bindValue($identifier, $this->titulo, PDO::PARAM_STR);
break;
case 'slug':
$stmt->bindValue($identifier, $this->slug, PDO::PARAM_STR);
break;
}
}
$stmt->execute();
} catch (Exception $e) {
Propel::log($e->getMessage(), Propel::LOG_ERR);
throw new PropelException(sprintf('Unable to execute INSERT statement [%s]', $sql), 0, $e);
}
try {
$pk = $con->lastInsertId();
} catch (Exception $e) {
throw new PropelException('Unable to get autoincrement id.', 0, $e);
}
$this->setId($pk);
$this->setNew(false);
}
/**
* Find object by primary key using raw SQL to go fast.
* Bypass doSelect() and the object formatter by using generated code.
*
* @param mixed $key Primary key to use for the query
* @param ConnectionInterface $con A connection object
*
* @return ChildProductVersion A model object, or null if the key is not found
*/
protected function findPkSimple($key, $con)
{
$sql = 'SELECT `ID`, `TAX_RULE_ID`, `REF`, `VIRTUAL`, `VISIBLE`, `POSITION`, `TEMPLATE_ID`, `BRAND_ID`, `CREATED_AT`, `UPDATED_AT`, `VERSION`, `VERSION_CREATED_AT`, `VERSION_CREATED_BY` FROM `product_version` WHERE `ID` = :p0 AND `VERSION` = :p1';
try {
$stmt = $con->prepare($sql);
$stmt->bindValue(':p0', $key[0], PDO::PARAM_INT);
$stmt->bindValue(':p1', $key[1], 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)) {
$obj = new ChildProductVersion();
$obj->hydrate($row);
ProductVersionTableMap::addInstanceToPool($obj, serialize(array((string) $key[0], (string) $key[1])));
}
$stmt->closeCursor();
return $obj;
}
/**
* Insert the row in the database.
*
* @param ConnectionInterface $con
*
* @throws PropelException
* @see doSave()
*/
protected function doInsert(ConnectionInterface $con)
{
$modifiedColumns = array();
$index = 0;
// check the columns in natural order for more readable SQL queries
if ($this->isColumnModified(CustomerTitleI18nTableMap::ID)) {
$modifiedColumns[':p' . $index++] = '`ID`';
}
if ($this->isColumnModified(CustomerTitleI18nTableMap::LOCALE)) {
$modifiedColumns[':p' . $index++] = '`LOCALE`';
}
if ($this->isColumnModified(CustomerTitleI18nTableMap::SHORT)) {
$modifiedColumns[':p' . $index++] = '`SHORT`';
}
if ($this->isColumnModified(CustomerTitleI18nTableMap::LONG)) {
$modifiedColumns[':p' . $index++] = '`LONG`';
}
$sql = sprintf('INSERT INTO `customer_title_i18n` (%s) VALUES (%s)', implode(', ', $modifiedColumns), implode(', ', array_keys($modifiedColumns)));
try {
$stmt = $con->prepare($sql);
foreach ($modifiedColumns as $identifier => $columnName) {
switch ($columnName) {
case '`ID`':
$stmt->bindValue($identifier, $this->id, PDO::PARAM_INT);
break;
case '`LOCALE`':
$stmt->bindValue($identifier, $this->locale, PDO::PARAM_STR);
break;
case '`SHORT`':
$stmt->bindValue($identifier, $this->short, PDO::PARAM_STR);
break;
case '`LONG`':
$stmt->bindValue($identifier, $this->long, PDO::PARAM_STR);
break;
}
}
$stmt->execute();
} catch (Exception $e) {
Propel::log($e->getMessage(), Propel::LOG_ERR);
throw new PropelException(sprintf('Unable to execute INSERT statement [%s]', $sql), 0, $e);
}
$this->setNew(false);
}
/**
* Find object by primary key using raw SQL to go fast.
* Bypass doSelect() and the object formatter by using generated code.
*
* @param mixed $key Primary key to use for the query
* @param ConnectionInterface $con A connection object
*
* @return ChildInseeGeoDepartment A model object, or null if the key is not found
*/
protected function findPkSimple($key, $con)
{
$sql = 'SELECT ID, MAIN_MUNICIPALITY_ID, REGION_ID, GEO_POINT2D_X, GEO_POINT2D_Y, GEO_SHAPE, CREATED_AT, UPDATED_AT FROM insee_geo_department WHERE ID = :p0';
try {
$stmt = $con->prepare($sql);
$stmt->bindValue(':p0', $key, PDO::PARAM_STR);
$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)) {
$obj = new ChildInseeGeoDepartment();
$obj->hydrate($row);
InseeGeoDepartmentTableMap::addInstanceToPool($obj, (string) $key);
}
$stmt->closeCursor();
return $obj;
}
/**
* Insert the row in the database.
*
* @param ConnectionInterface $con
*
* @throws PropelException
* @see doSave()
*/
protected function doInsert(ConnectionInterface $con)
{
$modifiedColumns = array();
$index = 0;
// check the columns in natural order for more readable SQL queries
if ($this->isColumnModified(ModuleImageI18nTableMap::ID)) {
$modifiedColumns[':p' . $index++] = '`ID`';
}
if ($this->isColumnModified(ModuleImageI18nTableMap::LOCALE)) {
$modifiedColumns[':p' . $index++] = '`LOCALE`';
}
if ($this->isColumnModified(ModuleImageI18nTableMap::TITLE)) {
$modifiedColumns[':p' . $index++] = '`TITLE`';
}
if ($this->isColumnModified(ModuleImageI18nTableMap::DESCRIPTION)) {
$modifiedColumns[':p' . $index++] = '`DESCRIPTION`';
}
if ($this->isColumnModified(ModuleImageI18nTableMap::CHAPO)) {
$modifiedColumns[':p' . $index++] = '`CHAPO`';
}
if ($this->isColumnModified(ModuleImageI18nTableMap::POSTSCRIPTUM)) {
$modifiedColumns[':p' . $index++] = '`POSTSCRIPTUM`';
}
$sql = sprintf('INSERT INTO `module_image_i18n` (%s) VALUES (%s)', implode(', ', $modifiedColumns), implode(', ', array_keys($modifiedColumns)));
try {
$stmt = $con->prepare($sql);
foreach ($modifiedColumns as $identifier => $columnName) {
switch ($columnName) {
case '`ID`':
$stmt->bindValue($identifier, $this->id, PDO::PARAM_INT);
break;
case '`LOCALE`':
$stmt->bindValue($identifier, $this->locale, PDO::PARAM_STR);
break;
case '`TITLE`':
$stmt->bindValue($identifier, $this->title, PDO::PARAM_STR);
break;
case '`DESCRIPTION`':
$stmt->bindValue($identifier, $this->description, PDO::PARAM_STR);
break;
case '`CHAPO`':
$stmt->bindValue($identifier, $this->chapo, PDO::PARAM_STR);
break;
case '`POSTSCRIPTUM`':
$stmt->bindValue($identifier, $this->postscriptum, PDO::PARAM_STR);
break;
}
}
$stmt->execute();
} catch (Exception $e) {
Propel::log($e->getMessage(), Propel::LOG_ERR);
throw new PropelException(sprintf('Unable to execute INSERT statement [%s]', $sql), 0, $e);
}
$this->setNew(false);
}
/**
* Insert the row in the database.
*
* @param ConnectionInterface $con
*
* @throws PropelException
* @see doSave()
*/
protected function doInsert(ConnectionInterface $con)
{
$modifiedColumns = array();
$index = 0;
$this->modifiedColumns[UserTableMap::COL_ID] = true;
if (null !== $this->id) {
throw new PropelException('Cannot insert a value for auto-increment primary key (' . UserTableMap::COL_ID . ')');
}
// check the columns in natural order for more readable SQL queries
if ($this->isColumnModified(UserTableMap::COL_ID)) {
$modifiedColumns[':p' . $index++] = 'ID';
}
if ($this->isColumnModified(UserTableMap::COL_USERNAME)) {
$modifiedColumns[':p' . $index++] = 'USERNAME';
}
if ($this->isColumnModified(UserTableMap::COL_PASSWORD)) {
$modifiedColumns[':p' . $index++] = 'PASSWORD';
}
if ($this->isColumnModified(UserTableMap::COL_FIRST_NAME)) {
$modifiedColumns[':p' . $index++] = 'FIRST_NAME';
}
if ($this->isColumnModified(UserTableMap::COL_LAST_NAME)) {
$modifiedColumns[':p' . $index++] = 'LAST_NAME';
}
if ($this->isColumnModified(UserTableMap::COL_CREATE_DATE)) {
$modifiedColumns[':p' . $index++] = 'CREATE_DATE';
}
if ($this->isColumnModified(UserTableMap::COL_UPDATE_DATE)) {
$modifiedColumns[':p' . $index++] = 'UPDATE_DATE';
}
if ($this->isColumnModified(UserTableMap::COL_STATUS)) {
$modifiedColumns[':p' . $index++] = 'STATUS';
}
$sql = sprintf('INSERT INTO user (%s) VALUES (%s)', implode(', ', $modifiedColumns), implode(', ', array_keys($modifiedColumns)));
try {
$stmt = $con->prepare($sql);
foreach ($modifiedColumns as $identifier => $columnName) {
switch ($columnName) {
case 'ID':
$stmt->bindValue($identifier, $this->id, PDO::PARAM_INT);
break;
case 'USERNAME':
$stmt->bindValue($identifier, $this->username, PDO::PARAM_STR);
break;
case 'PASSWORD':
$stmt->bindValue($identifier, $this->password, PDO::PARAM_STR);
break;
case 'FIRST_NAME':
$stmt->bindValue($identifier, $this->first_name, PDO::PARAM_STR);
break;
case 'LAST_NAME':
$stmt->bindValue($identifier, $this->last_name, PDO::PARAM_STR);
break;
case 'CREATE_DATE':
$stmt->bindValue($identifier, $this->create_date ? $this->create_date->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
case 'UPDATE_DATE':
$stmt->bindValue($identifier, $this->update_date ? $this->update_date->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
case 'STATUS':
$stmt->bindValue($identifier, $this->status, PDO::PARAM_STR);
break;
}
}
$stmt->execute();
} catch (Exception $e) {
Propel::log($e->getMessage(), Propel::LOG_ERR);
throw new PropelException(sprintf('Unable to execute INSERT statement [%s]', $sql), 0, $e);
}
try {
$pk = $con->lastInsertId();
} catch (Exception $e) {
throw new PropelException('Unable to get autoincrement id.', 0, $e);
}
$this->setId($pk);
$this->setNew(false);
}
/**
* Insert the row in the database.
*
* @param ConnectionInterface $con
*
* @throws PropelException
* @see doSave()
*/
protected function doInsert(ConnectionInterface $con)
{
$modifiedColumns = array();
$index = 0;
$this->modifiedColumns[GroupTableMap::COL_ID] = true;
if (null !== $this->id) {
throw new PropelException('Cannot insert a value for auto-increment primary key (' . GroupTableMap::COL_ID . ')');
}
// check the columns in natural order for more readable SQL queries
if ($this->isColumnModified(GroupTableMap::COL_ID)) {
$modifiedColumns[':p' . $index++] = 'id';
}
if ($this->isColumnModified(GroupTableMap::COL_NAME)) {
$modifiedColumns[':p' . $index++] = 'name';
}
if ($this->isColumnModified(GroupTableMap::COL_DESCRIPTION)) {
$modifiedColumns[':p' . $index++] = 'description';
}
if ($this->isColumnModified(GroupTableMap::COL_OWNER_ID)) {
$modifiedColumns[':p' . $index++] = 'owner_id';
}
if ($this->isColumnModified(GroupTableMap::COL_CREATED_AT)) {
$modifiedColumns[':p' . $index++] = 'created_at';
}
if ($this->isColumnModified(GroupTableMap::COL_UPDATED_AT)) {
$modifiedColumns[':p' . $index++] = 'updated_at';
}
$sql = sprintf('INSERT INTO group_of_users (%s) VALUES (%s)', implode(', ', $modifiedColumns), implode(', ', array_keys($modifiedColumns)));
try {
$stmt = $con->prepare($sql);
foreach ($modifiedColumns as $identifier => $columnName) {
switch ($columnName) {
case 'id':
$stmt->bindValue($identifier, $this->id, PDO::PARAM_INT);
break;
case 'name':
$stmt->bindValue($identifier, $this->name, PDO::PARAM_STR);
break;
case 'description':
$stmt->bindValue($identifier, $this->description, PDO::PARAM_STR);
break;
case 'owner_id':
$stmt->bindValue($identifier, $this->owner_id, PDO::PARAM_INT);
break;
case 'created_at':
$stmt->bindValue($identifier, $this->created_at ? $this->created_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
case 'updated_at':
$stmt->bindValue($identifier, $this->updated_at ? $this->updated_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
}
}
$stmt->execute();
} catch (Exception $e) {
Propel::log($e->getMessage(), Propel::LOG_ERR);
throw new PropelException(sprintf('Unable to execute INSERT statement [%s]', $sql), 0, $e);
}
try {
$pk = $con->lastInsertId();
} catch (Exception $e) {
throw new PropelException('Unable to get autoincrement id.', 0, $e);
}
$this->setId($pk);
$this->setNew(false);
}
/**
* Find object by primary key using raw SQL to go fast.
* Bypass doSelect() and the object formatter by using generated code.
*
* @param mixed $key Primary key to use for the query
* @param ConnectionInterface $con A connection object
*
* @return ChildDebit A model object, or null if the key is not found
*/
protected function findPkSimple($key, ConnectionInterface $con)
{
$sql = 'SELECT ID, PURCHASE_ID, TOTAL, PAID, STATUS FROM debit WHERE 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 ChildDebit $obj */
$obj = new ChildDebit();
$obj->hydrate($row);
DebitTableMap::addInstanceToPool($obj, (string) $key);
}
$stmt->closeCursor();
return $obj;
}
/**
* Insert the row in the database.
*
* @param ConnectionInterface $con
*
* @throws PropelException
* @see doSave()
*/
protected function doInsert(ConnectionInterface $con)
{
$modifiedColumns = array();
$index = 0;
$this->modifiedColumns[ApplicationTableMap::COL_ID] = true;
if (null !== $this->id) {
throw new PropelException('Cannot insert a value for auto-increment primary key (' . ApplicationTableMap::COL_ID . ')');
}
// check the columns in natural order for more readable SQL queries
if ($this->isColumnModified(ApplicationTableMap::COL_ID)) {
$modifiedColumns[':p' . $index++] = 'id';
}
if ($this->isColumnModified(ApplicationTableMap::COL_STUDENT_ID)) {
$modifiedColumns[':p' . $index++] = 'student_id';
}
if ($this->isColumnModified(ApplicationTableMap::COL_SUBJECT_ID)) {
$modifiedColumns[':p' . $index++] = 'subject_id';
}
if ($this->isColumnModified(ApplicationTableMap::COL_PERIOD_ID)) {
$modifiedColumns[':p' . $index++] = 'period_id';
}
if ($this->isColumnModified(ApplicationTableMap::COL_SCHOOL_YEAR_ID)) {
$modifiedColumns[':p' . $index++] = 'school_year_id';
}
if ($this->isColumnModified(ApplicationTableMap::COL_APPLICATION_DATE)) {
$modifiedColumns[':p' . $index++] = 'application_date';
}
if ($this->isColumnModified(ApplicationTableMap::COL_EXAM_DATE)) {
$modifiedColumns[':p' . $index++] = 'exam_date';
}
if ($this->isColumnModified(ApplicationTableMap::COL_EXAM_TIME)) {
$modifiedColumns[':p' . $index++] = 'exam_time';
}
if ($this->isColumnModified(ApplicationTableMap::COL_EXAM_SCORE)) {
$modifiedColumns[':p' . $index++] = 'exam_score';
}
if ($this->isColumnModified(ApplicationTableMap::COL_CREATED_AT)) {
$modifiedColumns[':p' . $index++] = 'created_at';
}
if ($this->isColumnModified(ApplicationTableMap::COL_UPDATED_AT)) {
$modifiedColumns[':p' . $index++] = 'updated_at';
}
$sql = sprintf('INSERT INTO application (%s) VALUES (%s)', implode(', ', $modifiedColumns), implode(', ', array_keys($modifiedColumns)));
try {
$stmt = $con->prepare($sql);
foreach ($modifiedColumns as $identifier => $columnName) {
switch ($columnName) {
case 'id':
$stmt->bindValue($identifier, $this->id, PDO::PARAM_INT);
break;
case 'student_id':
$stmt->bindValue($identifier, $this->student_id, PDO::PARAM_INT);
break;
case 'subject_id':
$stmt->bindValue($identifier, $this->subject_id, PDO::PARAM_INT);
break;
case 'period_id':
$stmt->bindValue($identifier, $this->period_id, PDO::PARAM_INT);
break;
case 'school_year_id':
$stmt->bindValue($identifier, $this->school_year_id, PDO::PARAM_INT);
break;
case 'application_date':
$stmt->bindValue($identifier, $this->application_date ? $this->application_date->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
case 'exam_date':
$stmt->bindValue($identifier, $this->exam_date ? $this->exam_date->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
case 'exam_time':
$stmt->bindValue($identifier, $this->exam_time ? $this->exam_time->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
case 'exam_score':
$stmt->bindValue($identifier, $this->exam_score, PDO::PARAM_INT);
break;
case 'created_at':
$stmt->bindValue($identifier, $this->created_at ? $this->created_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
case 'updated_at':
$stmt->bindValue($identifier, $this->updated_at ? $this->updated_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
}
}
$stmt->execute();
} catch (Exception $e) {
Propel::log($e->getMessage(), Propel::LOG_ERR);
throw new PropelException(sprintf('Unable to execute INSERT statement [%s]', $sql), 0, $e);
}
try {
$pk = $con->lastInsertId();
} catch (Exception $e) {
throw new PropelException('Unable to get autoincrement id.', 0, $e);
}
$this->setId($pk);
$this->setNew(false);
}
/**
* Insert the row in the database.
*
* @param ConnectionInterface $con
*
* @throws PropelException
* @see doSave()
*/
protected function doInsert(ConnectionInterface $con)
{
$modifiedColumns = array();
$index = 0;
$this->modifiedColumns[StudentTableMap::COL_ID] = true;
if (null !== $this->id) {
throw new PropelException('Cannot insert a value for auto-increment primary key (' . StudentTableMap::COL_ID . ')');
}
// check the columns in natural order for more readable SQL queries
if ($this->isColumnModified(StudentTableMap::COL_ID)) {
$modifiedColumns[':p' . $index++] = 'id';
}
if ($this->isColumnModified(StudentTableMap::COL_IDENTIFICATION_NUMBER)) {
$modifiedColumns[':p' . $index++] = 'identification_number';
}
if ($this->isColumnModified(StudentTableMap::COL_SCHOOL_YEAR_ID)) {
$modifiedColumns[':p' . $index++] = 'school_year_id';
}
if ($this->isColumnModified(StudentTableMap::COL_COURSE_ID)) {
$modifiedColumns[':p' . $index++] = 'course_id';
}
if ($this->isColumnModified(StudentTableMap::COL_FIRST_NAME)) {
$modifiedColumns[':p' . $index++] = 'first_name';
}
if ($this->isColumnModified(StudentTableMap::COL_LAST_NAME)) {
$modifiedColumns[':p' . $index++] = 'last_name';
}
if ($this->isColumnModified(StudentTableMap::COL_BIRTH_PLACE)) {
$modifiedColumns[':p' . $index++] = 'birth_place';
}
if ($this->isColumnModified(StudentTableMap::COL_BIRTHDAY)) {
$modifiedColumns[':p' . $index++] = 'birthday';
}
if ($this->isColumnModified(StudentTableMap::COL_PHONE_NUMBER)) {
$modifiedColumns[':p' . $index++] = 'phone_number';
}
if ($this->isColumnModified(StudentTableMap::COL_CREATED_AT)) {
$modifiedColumns[':p' . $index++] = 'created_at';
}
if ($this->isColumnModified(StudentTableMap::COL_UPDATED_AT)) {
$modifiedColumns[':p' . $index++] = 'updated_at';
}
$sql = sprintf('INSERT INTO student (%s) VALUES (%s)', implode(', ', $modifiedColumns), implode(', ', array_keys($modifiedColumns)));
try {
$stmt = $con->prepare($sql);
foreach ($modifiedColumns as $identifier => $columnName) {
switch ($columnName) {
case 'id':
$stmt->bindValue($identifier, $this->id, PDO::PARAM_INT);
break;
case 'identification_number':
$stmt->bindValue($identifier, $this->identification_number, PDO::PARAM_INT);
break;
case 'school_year_id':
$stmt->bindValue($identifier, $this->school_year_id, PDO::PARAM_INT);
break;
case 'course_id':
$stmt->bindValue($identifier, $this->course_id, PDO::PARAM_INT);
break;
case 'first_name':
$stmt->bindValue($identifier, $this->first_name, PDO::PARAM_STR);
break;
case 'last_name':
$stmt->bindValue($identifier, $this->last_name, PDO::PARAM_STR);
break;
case 'birth_place':
$stmt->bindValue($identifier, $this->birth_place, PDO::PARAM_STR);
break;
case 'birthday':
$stmt->bindValue($identifier, $this->birthday ? $this->birthday->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
case 'phone_number':
$stmt->bindValue($identifier, $this->phone_number, PDO::PARAM_STR);
break;
case 'created_at':
$stmt->bindValue($identifier, $this->created_at ? $this->created_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
case 'updated_at':
$stmt->bindValue($identifier, $this->updated_at ? $this->updated_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
}
}
$stmt->execute();
} catch (Exception $e) {
Propel::log($e->getMessage(), Propel::LOG_ERR);
throw new PropelException(sprintf('Unable to execute INSERT statement [%s]', $sql), 0, $e);
}
try {
$pk = $con->lastInsertId();
} catch (Exception $e) {
throw new PropelException('Unable to get autoincrement id.', 0, $e);
}
$this->setId($pk);
$this->setNew(false);
}
/**
* Insert the row in the database.
*
* @param ConnectionInterface $con
*
* @throws PropelException
* @see doSave()
*/
protected function doInsert(ConnectionInterface $con)
{
$modifiedColumns = array();
$index = 0;
$this->modifiedColumns[CommentTableMap::ID] = true;
if (null !== $this->id) {
throw new PropelException('Cannot insert a value for auto-increment primary key (' . CommentTableMap::ID . ')');
}
// check the columns in natural order for more readable SQL queries
if ($this->isColumnModified(CommentTableMap::ID)) {
$modifiedColumns[':p' . $index++] = 'ID';
}
if ($this->isColumnModified(CommentTableMap::USERNAME)) {
$modifiedColumns[':p' . $index++] = 'USERNAME';
}
if ($this->isColumnModified(CommentTableMap::CUSTOMER_ID)) {
$modifiedColumns[':p' . $index++] = 'CUSTOMER_ID';
}
if ($this->isColumnModified(CommentTableMap::REF)) {
$modifiedColumns[':p' . $index++] = 'REF';
}
if ($this->isColumnModified(CommentTableMap::REF_ID)) {
$modifiedColumns[':p' . $index++] = 'REF_ID';
}
if ($this->isColumnModified(CommentTableMap::EMAIL)) {
$modifiedColumns[':p' . $index++] = 'EMAIL';
}
if ($this->isColumnModified(CommentTableMap::TITLE)) {
$modifiedColumns[':p' . $index++] = 'TITLE';
}
if ($this->isColumnModified(CommentTableMap::CONTENT)) {
$modifiedColumns[':p' . $index++] = 'CONTENT';
}
if ($this->isColumnModified(CommentTableMap::RATING)) {
$modifiedColumns[':p' . $index++] = 'RATING';
}
if ($this->isColumnModified(CommentTableMap::STATUS)) {
$modifiedColumns[':p' . $index++] = 'STATUS';
}
if ($this->isColumnModified(CommentTableMap::VERIFIED)) {
$modifiedColumns[':p' . $index++] = 'VERIFIED';
}
if ($this->isColumnModified(CommentTableMap::ABUSE)) {
$modifiedColumns[':p' . $index++] = 'ABUSE';
}
if ($this->isColumnModified(CommentTableMap::LOCALE)) {
$modifiedColumns[':p' . $index++] = 'LOCALE';
}
if ($this->isColumnModified(CommentTableMap::CREATED_AT)) {
$modifiedColumns[':p' . $index++] = 'CREATED_AT';
}
if ($this->isColumnModified(CommentTableMap::UPDATED_AT)) {
$modifiedColumns[':p' . $index++] = 'UPDATED_AT';
}
$sql = sprintf('INSERT INTO comment (%s) VALUES (%s)', implode(', ', $modifiedColumns), implode(', ', array_keys($modifiedColumns)));
try {
$stmt = $con->prepare($sql);
foreach ($modifiedColumns as $identifier => $columnName) {
switch ($columnName) {
case 'ID':
$stmt->bindValue($identifier, $this->id, PDO::PARAM_INT);
break;
case 'USERNAME':
$stmt->bindValue($identifier, $this->username, PDO::PARAM_STR);
break;
case 'CUSTOMER_ID':
$stmt->bindValue($identifier, $this->customer_id, PDO::PARAM_INT);
break;
case 'REF':
$stmt->bindValue($identifier, $this->ref, PDO::PARAM_STR);
break;
case 'REF_ID':
$stmt->bindValue($identifier, $this->ref_id, PDO::PARAM_INT);
break;
case 'EMAIL':
$stmt->bindValue($identifier, $this->email, PDO::PARAM_STR);
break;
case 'TITLE':
$stmt->bindValue($identifier, $this->title, PDO::PARAM_STR);
break;
case 'CONTENT':
$stmt->bindValue($identifier, $this->content, PDO::PARAM_STR);
break;
case 'RATING':
$stmt->bindValue($identifier, $this->rating, PDO::PARAM_INT);
break;
case 'STATUS':
$stmt->bindValue($identifier, $this->status, PDO::PARAM_INT);
break;
case 'VERIFIED':
$stmt->bindValue($identifier, $this->verified, PDO::PARAM_INT);
break;
case 'ABUSE':
$stmt->bindValue($identifier, $this->abuse, PDO::PARAM_INT);
break;
case 'LOCALE':
$stmt->bindValue($identifier, $this->locale, PDO::PARAM_STR);
break;
case 'CREATED_AT':
$stmt->bindValue($identifier, $this->created_at ? $this->created_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
case 'UPDATED_AT':
$stmt->bindValue($identifier, $this->updated_at ? $this->updated_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
}
}
$stmt->execute();
} catch (Exception $e) {
Propel::log($e->getMessage(), Propel::LOG_ERR);
throw new PropelException(sprintf('Unable to execute INSERT statement [%s]', $sql), 0, $e);
}
try {
$pk = $con->lastInsertId();
} catch (Exception $e) {
throw new PropelException('Unable to get autoincrement id.', 0, $e);
}
$this->setId($pk);
$this->setNew(false);
}
/**
* Insert the row in the database.
*
* @param ConnectionInterface $con
*
* @throws PropelException
* @see doSave()
*/
protected function doInsert(ConnectionInterface $con)
{
$modifiedColumns = array();
$index = 0;
// check the columns in natural order for more readable SQL queries
if ($this->isColumnModified(SessionTableMap::COL_TOKEN)) {
$modifiedColumns[':p' . $index++] = '`token`';
}
if ($this->isColumnModified(SessionTableMap::COL_USER_ID)) {
$modifiedColumns[':p' . $index++] = '`user_id`';
}
if ($this->isColumnModified(SessionTableMap::COL_IP)) {
$modifiedColumns[':p' . $index++] = '`ip`';
}
if ($this->isColumnModified(SessionTableMap::COL_USER_AGENT)) {
$modifiedColumns[':p' . $index++] = '`user_agent`';
}
if ($this->isColumnModified(SessionTableMap::COL_BROWSER)) {
$modifiedColumns[':p' . $index++] = '`browser`';
}
if ($this->isColumnModified(SessionTableMap::COL_DEVICE)) {
$modifiedColumns[':p' . $index++] = '`device`';
}
if ($this->isColumnModified(SessionTableMap::COL_OS)) {
$modifiedColumns[':p' . $index++] = '`os`';
}
if ($this->isColumnModified(SessionTableMap::COL_LOCATION)) {
$modifiedColumns[':p' . $index++] = '`location`';
}
if ($this->isColumnModified(SessionTableMap::COL_CREATED_AT)) {
$modifiedColumns[':p' . $index++] = '`created_at`';
}
if ($this->isColumnModified(SessionTableMap::COL_UPDATED_AT)) {
$modifiedColumns[':p' . $index++] = '`updated_at`';
}
$sql = sprintf('INSERT INTO `kk_session` (%s) VALUES (%s)', implode(', ', $modifiedColumns), implode(', ', array_keys($modifiedColumns)));
try {
$stmt = $con->prepare($sql);
foreach ($modifiedColumns as $identifier => $columnName) {
switch ($columnName) {
case '`token`':
$stmt->bindValue($identifier, $this->token, PDO::PARAM_STR);
break;
case '`user_id`':
$stmt->bindValue($identifier, $this->user_id, PDO::PARAM_INT);
break;
case '`ip`':
$stmt->bindValue($identifier, $this->ip, PDO::PARAM_STR);
break;
case '`user_agent`':
$stmt->bindValue($identifier, $this->user_agent, PDO::PARAM_STR);
break;
case '`browser`':
$stmt->bindValue($identifier, $this->browser, PDO::PARAM_STR);
break;
case '`device`':
$stmt->bindValue($identifier, $this->device, PDO::PARAM_STR);
break;
case '`os`':
$stmt->bindValue($identifier, $this->os, PDO::PARAM_STR);
break;
case '`location`':
$stmt->bindValue($identifier, $this->location, PDO::PARAM_STR);
break;
case '`created_at`':
$stmt->bindValue($identifier, $this->created_at ? $this->created_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
case '`updated_at`':
$stmt->bindValue($identifier, $this->updated_at ? $this->updated_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
}
}
$stmt->execute();
} catch (Exception $e) {
Propel::log($e->getMessage(), Propel::LOG_ERR);
throw new PropelException(sprintf('Unable to execute INSERT statement [%s]', $sql), 0, $e);
}
$this->setNew(false);
}
/**
* Find object by primary key using raw SQL to go fast.
* Bypass doSelect() and the object formatter by using generated code.
*
* @param mixed $key Primary key to use for the query
* @param ConnectionInterface $con A connection object
*
* @throws \Propel\Runtime\Exception\PropelException
*
* @return ChildPeople A model object, or null if the key is not found
*/
protected function findPkSimple($key, ConnectionInterface $con)
{
$sql = 'SELECT id, name, date, city, street, fix_text, normal, company FROM people WHERE 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 ChildPeople $obj */
$obj = new ChildPeople();
$obj->hydrate($row);
PeopleTableMap::addInstanceToPool($obj, null === $key || is_scalar($key) || is_callable([$key, '__toString']) ? (string) $key : $key);
}
$stmt->closeCursor();
return $obj;
}
/**
* Find object by primary key using raw SQL to go fast.
* Bypass doSelect() and the object formatter by using generated code.
*
* @param mixed $key Primary key to use for the query
* @param ConnectionInterface $con A connection object
*
* @throws \Propel\Runtime\Exception\PropelException
*
* @return ChildJudge A model object, or null if the key is not found
*/
protected function findPkSimple($key, ConnectionInterface $con)
{
$sql = 'SELECT `id`, `position`, `startgroup_id`, `user_id` FROM `kk_junia_judge` WHERE `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 ChildJudge $obj */
$obj = new ChildJudge();
$obj->hydrate($row);
JudgeTableMap::addInstanceToPool($obj, (string) $key);
}
$stmt->closeCursor();
return $obj;
}
/**
* Insert the row in the database.
*
* @param ConnectionInterface $con
*
* @throws PropelException
* @see doSave()
*/
protected function doInsert(ConnectionInterface $con)
{
$modifiedColumns = array();
$index = 0;
$this->modifiedColumns[ContentTableMap::ID] = true;
if (null !== $this->id) {
throw new PropelException('Cannot insert a value for auto-increment primary key (' . ContentTableMap::ID . ')');
}
// check the columns in natural order for more readable SQL queries
if ($this->isColumnModified(ContentTableMap::ID)) {
$modifiedColumns[':p' . $index++] = '`ID`';
}
if ($this->isColumnModified(ContentTableMap::VISIBLE)) {
$modifiedColumns[':p' . $index++] = '`VISIBLE`';
}
if ($this->isColumnModified(ContentTableMap::POSITION)) {
$modifiedColumns[':p' . $index++] = '`POSITION`';
}
if ($this->isColumnModified(ContentTableMap::CREATED_AT)) {
$modifiedColumns[':p' . $index++] = '`CREATED_AT`';
}
if ($this->isColumnModified(ContentTableMap::UPDATED_AT)) {
$modifiedColumns[':p' . $index++] = '`UPDATED_AT`';
}
if ($this->isColumnModified(ContentTableMap::VERSION)) {
$modifiedColumns[':p' . $index++] = '`VERSION`';
}
if ($this->isColumnModified(ContentTableMap::VERSION_CREATED_AT)) {
$modifiedColumns[':p' . $index++] = '`VERSION_CREATED_AT`';
}
if ($this->isColumnModified(ContentTableMap::VERSION_CREATED_BY)) {
$modifiedColumns[':p' . $index++] = '`VERSION_CREATED_BY`';
}
$sql = sprintf('INSERT INTO `content` (%s) VALUES (%s)', implode(', ', $modifiedColumns), implode(', ', array_keys($modifiedColumns)));
try {
$stmt = $con->prepare($sql);
foreach ($modifiedColumns as $identifier => $columnName) {
switch ($columnName) {
case '`ID`':
$stmt->bindValue($identifier, $this->id, PDO::PARAM_INT);
break;
case '`VISIBLE`':
$stmt->bindValue($identifier, $this->visible, PDO::PARAM_INT);
break;
case '`POSITION`':
$stmt->bindValue($identifier, $this->position, PDO::PARAM_INT);
break;
case '`CREATED_AT`':
$stmt->bindValue($identifier, $this->created_at ? $this->created_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
case '`UPDATED_AT`':
$stmt->bindValue($identifier, $this->updated_at ? $this->updated_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
case '`VERSION`':
$stmt->bindValue($identifier, $this->version, PDO::PARAM_INT);
break;
case '`VERSION_CREATED_AT`':
$stmt->bindValue($identifier, $this->version_created_at ? $this->version_created_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
break;
case '`VERSION_CREATED_BY`':
$stmt->bindValue($identifier, $this->version_created_by, PDO::PARAM_STR);
break;
}
}
$stmt->execute();
} catch (Exception $e) {
Propel::log($e->getMessage(), Propel::LOG_ERR);
throw new PropelException(sprintf('Unable to execute INSERT statement [%s]', $sql), 0, $e);
}
try {
$pk = $con->lastInsertId();
} catch (Exception $e) {
throw new PropelException('Unable to get autoincrement id.', 0, $e);
}
$this->setId($pk);
$this->setNew(false);
}
/**
* Insert the row in the database.
*
* @param ConnectionInterface $con
*
* @throws PropelException
* @see doSave()
*/
protected function doInsert(ConnectionInterface $con)
{
$modifiedColumns = array();
$index = 0;
$this->modifiedColumns[DataTableMap::COL_ID] = true;
if (null !== $this->id) {
throw new PropelException('Cannot insert a value for auto-increment primary key (' . DataTableMap::COL_ID . ')');
}
// check the columns in natural order for more readable SQL queries
if ($this->isColumnModified(DataTableMap::COL_ID)) {
$modifiedColumns[':p' . $index++] = 'id';
}
if ($this->isColumnModified(DataTableMap::COL__FORCONTRIBUTION)) {
$modifiedColumns[':p' . $index++] = '_forcontribution';
}
if ($this->isColumnModified(DataTableMap::COL__FORTEMPLATEFIELD)) {
$modifiedColumns[':p' . $index++] = '_fortemplatefield';
}
if ($this->isColumnModified(DataTableMap::COL__CONTENT)) {
$modifiedColumns[':p' . $index++] = '_content';
}
if ($this->isColumnModified(DataTableMap::COL__ISJSON)) {
$modifiedColumns[':p' . $index++] = '_isjson';
}
if ($this->isColumnModified(DataTableMap::COL___USER__)) {
$modifiedColumns[':p' . $index++] = '__user__';
}
if ($this->isColumnModified(DataTableMap::COL___CONFIG__)) {
$modifiedColumns[':p' . $index++] = '__config__';
}
if ($this->isColumnModified(DataTableMap::COL___SPLIT__)) {
$modifiedColumns[':p' . $index++] = '__split__';
}
if ($this->isColumnModified(DataTableMap::COL___PARENTNODE__)) {
$modifiedColumns[':p' . $index++] = '__parentnode__';
}
if ($this->isColumnModified(DataTableMap::COL___SORT__)) {
$modifiedColumns[':p' . $index++] = '__sort__';
}
$sql = sprintf('INSERT INTO _data (%s) VALUES (%s)', implode(', ', $modifiedColumns), implode(', ', array_keys($modifiedColumns)));
try {
$stmt = $con->prepare($sql);
foreach ($modifiedColumns as $identifier => $columnName) {
switch ($columnName) {
case 'id':
$stmt->bindValue($identifier, $this->id, PDO::PARAM_INT);
break;
case '_forcontribution':
$stmt->bindValue($identifier, $this->_forcontribution, PDO::PARAM_INT);
break;
case '_fortemplatefield':
$stmt->bindValue($identifier, $this->_fortemplatefield, PDO::PARAM_INT);
break;
case '_content':
$stmt->bindValue($identifier, $this->_content, PDO::PARAM_STR);
break;
case '_isjson':
$stmt->bindValue($identifier, (int) $this->_isjson, PDO::PARAM_INT);
break;
case '__user__':
$stmt->bindValue($identifier, $this->__user__, PDO::PARAM_INT);
break;
case '__config__':
$stmt->bindValue($identifier, $this->__config__, PDO::PARAM_STR);
break;
case '__split__':
$stmt->bindValue($identifier, $this->__split__, PDO::PARAM_STR);
break;
case '__parentnode__':
$stmt->bindValue($identifier, $this->__parentnode__, PDO::PARAM_INT);
break;
case '__sort__':
$stmt->bindValue($identifier, $this->__sort__, PDO::PARAM_INT);
break;
}
}
$stmt->execute();
} catch (Exception $e) {
Propel::log($e->getMessage(), Propel::LOG_ERR);
throw new PropelException(sprintf('Unable to execute INSERT statement [%s]', $sql), 0, $e);
}
try {
$pk = $con->lastInsertId();
} catch (Exception $e) {
throw new PropelException('Unable to get autoincrement id.', 0, $e);
}
$this->setId($pk);
$this->setNew(false);
}
/**
* Find object by primary key using raw SQL to go fast.
* Bypass doSelect() and the object formatter by using generated code.
*
* @param mixed $key Primary key to use for the query
* @param ConnectionInterface $con A connection object
*
* @return ChildGoogleshoppingProductSynchronisation A model object, or null if the key is not found
*/
protected function findPkSimple($key, $con)
{
$sql = 'SELECT ID, PRODUCT_ID, TARGET_COUNTRY, LANG, SYNC_ENABLE, GOOGLESHOPPING_ACCOUNT_ID FROM googleshopping_product_synchronisation WHERE 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)) {
$obj = new ChildGoogleshoppingProductSynchronisation();
$obj->hydrate($row);
GoogleshoppingProductSynchronisationTableMap::addInstanceToPool($obj, (string) $key);
}
$stmt->closeCursor();
return $obj;
}
/**
* Find object by primary key using raw SQL to go fast.
* Bypass doSelect() and the object formatter by using generated code.
*
* @param mixed $key Primary key to use for the query
* @param ConnectionInterface $con A connection object
*
* @return ChildDiaporamaVersion A model object, or null if the key is not found
*/
protected function findPkSimple($key, $con)
{
$sql = 'SELECT ID, SHORTCODE, CREATED_AT, UPDATED_AT, VERSION, VERSION_CREATED_AT, VERSION_CREATED_BY FROM diaporama_version WHERE ID = :p0 AND VERSION = :p1';
try {
$stmt = $con->prepare($sql);
$stmt->bindValue(':p0', $key[0], PDO::PARAM_INT);
$stmt->bindValue(':p1', $key[1], 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)) {
$obj = new ChildDiaporamaVersion();
$obj->hydrate($row);
DiaporamaVersionTableMap::addInstanceToPool($obj, serialize(array((string) $key[0], (string) $key[1])));
}
$stmt->closeCursor();
return $obj;
}
