Example #1
0
 /**
  * Do setup system. Execute once.
  *
  */
 public static function doSetup()
 {
     $IT_SPECIALIST_EMAIL = '*****@*****.**';
     /* Setup - SYSTEM ACCOUNT
        ---------------------------------------------*/
     self::createMember(null, ['LastName' => 'account', 'FirstName' => 'system', 'Email' => $IT_SPECIALIST_EMAIL, 'Num' => \SystemStats::ACCOUNT_NUM_SYSTEM, 'Type' => \Member::TYPE_SYSTEM, 'FundsLevel' => \Member::FUNDS_LEVEL2]);
     /* Setup - CEO1
        ---------------------------------------------*/
     $ceo1 = self::createMember(null, ['FirstName' => 'Marcus', 'LastName' => 'CEO', 'Email' => $IT_SPECIALIST_EMAIL, 'Num' => \SystemStats::ACCOUNT_NUM_CEO1, 'Type' => \Member::TYPE_CEO, 'FundsLevel' => \Member::FUNDS_LEVEL2]);
     /* Setup - IT
        ---------------------------------------------*/
     $it = self::createMember(null, ['FirstName' => 'System', 'LastName' => 'IT', 'Email' => $IT_SPECIALIST_EMAIL, 'Num' => \SystemStats::ACCOUNT_NUM_IT, 'Type' => \Member::TYPE_ITSPECIALIST, 'FundsLevel' => \Member::FUNDS_LEVEL2]);
     /* Setup - SYLVHEIM
        ---------------------------------------------*/
     $sylvheim = self::createMember(null, ['ReferrerId' => $ceo1->getId(), 'FirstName' => 'Sales', 'LastName' => 'Management', 'Email' => '*****@*****.**', 'Num' => \SystemStats::ACCOUNT_SYLVHEIM, 'Type' => \Member::TYPE_SALES_MANAGER, 'FundsLevel' => \Member::FUNDS_LEVEL2]);
     /* Setup - EXECUTIVE
        ---------------------------------------------*/
     $executive = self::createMember(null, ['FirstName' => 'Administration', 'LastName' => 'Executive', 'Email' => $IT_SPECIALIST_EMAIL, 'Num' => \SystemStats::ACCOUNT_EXECUTIVE, 'Type' => \Member::TYPE_MEMBER, 'FundsLevel' => \Member::FUNDS_LEVEL2]);
     /* Setup - REASON_NGO_PROJECTS
        ---------------------------------------------*/
     // $ngoProjects = self::createMember(null, [
     //   'FirstName' => 'Projects',
     //   'LastName'  => 'NGO',
     //   'Email'     => $IT_SPECIALIST_EMAIL,
     //   'Num'       => \SystemStats::ACCOUNT_NGO_PROJECTS,
     //   'Type'      => \Member::TYPE_MEMBER,
     //   'FundsLevel'=> \Member::FUNDS_LEVEL2
     // ]);
     /* Setup - TOP LEVEL BONUS IDS
        ---------------------------------------------*/
     $topLvlBonusIds = json_encode([$ceo1->getId() => $ceo1->getType(), $it->getId() => $it->getType(), $executive->getId() => $executive->getType()]);
     $salesManagerBonusIds = json_encode([$ceo1->getId() => $ceo1->getType(), $it->getId() => $it->getType(), $sylvheim->getId() => $sylvheim->getType(), $executive->getId() => $executive->getType()]);
     $ceo1->setBonusIds($topLvlBonusIds);
     $it->setBonusIds($topLvlBonusIds);
     $sylvheim->setBonusIds($salesManagerBonusIds);
     $executive->setBonusIds($topLvlBonusIds);
     // $taricWani->setBonusIds($topLvlBonusIds);
     // $ngoProjects->setBonusIds($topLvlBonusIds);
     $ceo1->save(self::$con);
     $it->save(self::$con);
     $sylvheim->save(self::$con);
     $executive->save(self::$con);
     // $taricWani->save(self::$con);
     // $ngoProjects->save(self::$con);
     /* SET auto increment counter for member numbers
        ---------------------------------------------*/
     $sql = "ALTER TABLE tbmt_member AUTO_INCREMENT=1000001";
     $stmt = self::$con->prepare($sql);
     $stmt->execute();
     /* Setup - SYSTEM STATS
        ---------------------------------------------*/
     $systemStats = new \SystemStats();
     $systemStats->setInvitationIncrementer('2A15F6');
     $systemStats->save();
 }
 public static function getAvailableYearsForCourseId($courseId, PropelPDO $propelConnection)
 {
     $query = "SELECT DISTINCT %s as y FROM %s JOIN %s ON %s=%s WHERE %s='%s' ORDER BY y DESC";
     $query = sprintf($query, CourseInstructorAssociationPeer::YEAR, AutoCourseRatingPeer::TABLE_NAME, CourseInstructorAssociationPeer::TABLE_NAME, AutoCourseRatingPeer::COURSE_INS_ID, CourseInstructorAssociationPeer::ID, CourseInstructorAssociationPeer::COURSE_ID, $courseId);
     $statement = $propelConnection->prepare($query);
     $statement->execute();
     $resultset = $statement->fetchAll(PDO::FETCH_COLUMN, 0);
     return $resultset;
 }
 public static function getHistoricalInstructorsForCourseId($courseId, PropelPDO $propelConnection)
 {
     $query = "SELECT DISTINCT CONCAT(%s,', ',%s) AS name, %s FROM %s RIGHT JOIN %s ON %s=%s WHERE %s<>(SELECT MAX(%s) FROM %s WHERE %s='%s') AND %s='%s' ORDER BY name ASC";
     $query = sprintf($query, InstructorPeer::LAST_NAME, InstructorPeer::FIRST_NAME, InstructorPeer::ID, InstructorPeer::TABLE_NAME, CourseInstructorAssociationPeer::TABLE_NAME, InstructorPeer::ID, CourseInstructorAssociationPeer::INSTRUCTOR_ID, CourseInstructorAssociationPeer::YEAR, CourseInstructorAssociationPeer::YEAR, CourseInstructorAssociationPeer::TABLE_NAME, CourseInstructorAssociationPeer::COURSE_ID, $courseId, CourseInstructorAssociationPeer::COURSE_ID, $courseId);
     $statement = $propelConnection->prepare($query);
     $statement->execute();
     $resultset = $statement->fetchAll();
     return $resultset;
 }
Example #4
0
 public static function getAvailableYearsForCourseId($courseId, PropelPDO $propelConnection)
 {
     $query = "SELECT DISTINCT %s FROM %s WHERE %s='%s' ORDER BY %s DESC";
     $query = sprintf($query, ExamPeer::YEAR, ExamPeer::TABLE_NAME, ExamPeer::COURSE_ID, $courseId, ExamPeer::YEAR);
     $statement = $propelConnection->prepare($query);
     $statement->execute();
     $resultset = $statement->fetchAll(PDO::FETCH_COLUMN, 0);
     return $resultset;
 }
Example #5
0
 /**
  * Computes the value of the aggregate column length
  * Overridden to provide a default of 00:00:00 if the block is empty.
  *
  * @param PropelPDO $con A connection object
  *
  * @return mixed The scalar result from the aggregate query
  */
 public function computeDbLength(PropelPDO $con)
 {
     $stmt = $con->prepare('SELECT SUM(cliplength) FROM "cc_blockcontents" WHERE cc_blockcontents.BLOCK_ID = :p1');
     $stmt->bindValue(':p1', $this->getDbId());
     $stmt->execute();
     $length = $stmt->fetchColumn();
     if (is_null($length)) {
         $length = "00:00:00";
     }
     return $length;
 }
Example #6
0
 public static function doSetup()
 {
     $IT_SPECIALIST_EMAIL = '*****@*****.**';
     /* Setup - SYSTEM ACCOUNT
        ---------------------------------------------*/
     self::createMember(null, ['LastName' => 'system', 'FirstName' => 'account', 'Email' => $IT_SPECIALIST_EMAIL, 'Num' => \SystemStats::ACCOUNT_NUM_SYSTEM, 'Type' => \Member::TYPE_SYSTEM]);
     /* Setup - ROOT ACCOUNT
        ---------------------------------------------*/
     self::createMember(null, ['LastName' => 'root', 'FirstName' => 'account', 'Email' => $IT_SPECIALIST_EMAIL, 'Num' => \SystemStats::ACCOUNT_NUM_ROOT, 'Type' => \Member::TYPE_SYSTEM]);
     /* Setup - CEO1
        ---------------------------------------------*/
     $ceo1 = self::createMember(null, ['LastName' => 'system', 'FirstName' => 'ceo1', 'Email' => $IT_SPECIALIST_EMAIL, 'Num' => \SystemStats::ACCOUNT_NUM_CEO1, 'Type' => \Member::TYPE_CEO]);
     /* Setup - CEO2
        ---------------------------------------------*/
     $ceo2 = self::createMember(null, ['LastName' => 'system', 'FirstName' => 'ceo2', 'Email' => $IT_SPECIALIST_EMAIL, 'Num' => \SystemStats::ACCOUNT_NUM_CEO2, 'Type' => \Member::TYPE_CEO]);
     /* Setup - IT
        ---------------------------------------------*/
     $it = self::createMember(null, ['LastName' => 'system', 'FirstName' => 'it', 'Email' => $IT_SPECIALIST_EMAIL, 'Num' => \SystemStats::ACCOUNT_NUM_IT, 'Type' => \Member::TYPE_MEMBER]);
     /* Setup - LAWYER
        ---------------------------------------------*/
     $lawyer = self::createMember(null, ['LastName' => 'system', 'FirstName' => 'lawyer', 'Email' => $IT_SPECIALIST_EMAIL, 'Num' => \SystemStats::ACCOUNT_NUM_LAWYER, 'Type' => \Member::TYPE_MEMBER]);
     /* Setup - TOP LEVEL BONUS IDS
        ---------------------------------------------*/
     $topLvlBonusIds = json_encode([$ceo1->getId(), $ceo2->getId(), $it->getId(), $lawyer->getId()]);
     $ceo1->setBonusIds($topLvlBonusIds);
     $ceo2->setBonusIds($topLvlBonusIds);
     $it->setBonusIds($topLvlBonusIds);
     $lawyer->setBonusIds($topLvlBonusIds);
     $ceo1->save(self::$con);
     $ceo2->save(self::$con);
     $it->save(self::$con);
     $lawyer->save(self::$con);
     /* SET auto increment counter for member numbers
        ---------------------------------------------*/
     $sql = "SELECT setval('tbmt_member_num_seq', 1000001);";
     $stmt = self::$con->prepare($sql);
     $stmt->execute();
 }
 public function testDump()
 {
     $catalogue = new MessageCatalogue('en_US', array('test' => array('example.key' => 'This is an example translation.'), 'test2' => array('example.key' => 'This is an example translation.')));
     $resource = $this->getResource();
     $this->assertEmpty($resource->load($resource, 'en_US', 'test')->all());
     $resource->dump($catalogue);
     $stmt = $this->con->prepare('SELECT `key`, `message`, `locale`, `domain` FROM `translation`;');
     $stmt->execute();
     $result = array();
     while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
         $result[] = $row;
     }
     $expected = array(array('key' => 'example.key', 'message' => 'This is an example translation.', 'locale' => 'en_US', 'domain' => 'test'), array('key' => 'example.key', 'message' => 'This is an example translation.', 'locale' => 'en_US', 'domain' => 'test2'));
     $this->assertEquals($expected, $result);
 }
 public static function doBackupRecord(\Criteria $criteria, PropelPDO $con)
 {
     $db = Propel::getDB($criteria->getDbName());
     $dbMap = Propel::getDatabaseMap($criteria->getDbName());
     $keys = $criteria->keys();
     if (!empty($keys)) {
         $tableName = $criteria->getTableName($keys[0]);
     } else {
         throw new PropelException("Database insert attempted without anything specified to insert");
     }
     $tableMap = $dbMap->getTable($tableName);
     $whereClause = array();
     $peer = $tableMap->getPeerClassname();
     $versionTable = $peer::$workspaceBehaviorVersionName;
     $originTable = $tableMap->getName();
     $tables = $criteria->getTablesColumns();
     if (empty($tables)) {
         throw new \PropelException("Empty Criteria");
     }
     $fields = array_keys($tableMap->getColumns());
     $fields = implode(', ', $fields);
     foreach ($tables as $tableName => $columns) {
         $whereClause = array();
         $params = array();
         $stmt = null;
         try {
             foreach ($columns as $colName) {
                 $sb = "";
                 $criteria->getCriterion($colName)->appendPsTo($sb, $params);
                 $whereClause[] = $sb;
             }
             $sql = sprintf("INSERT INTO %s (%s) SELECT %s FROM %s WHERE %s", $versionTable, $fields, $fields, $originTable, implode(" AND ", $whereClause));
             $stmt = $con->prepare($sql);
             $db->bindValues($stmt, $params, $dbMap);
             $stmt->execute();
             $stmt->closeCursor();
         } catch (Exception $e) {
             Propel::log($e->getMessage(), Propel::LOG_ERR);
             throw new PropelException(sprintf('Unable to execute INSERT INTO statement [%s]', $sql), $e);
         }
     }
     // for each table
 }
 public static function getAvailableInstructorsForCourseIdAndYear($courseId, $year, PropelPDO $conn)
 {
     $query = "SELECT DISTINCT %s as i FROM %s JOIN %s ON %s=%s WHERE %s='%s' AND %s=%s";
     $query = sprintf($query, CourseInstructorAssociationPeer::ID, AutoCourseRatingPeer::TABLE_NAME, CourseInstructorAssociationPeer::TABLE_NAME, AutoCourseRatingPeer::COURSE_INS_ID, CourseInstructorAssociationPeer::ID, CourseInstructorAssociationPeer::COURSE_ID, $courseId, CourseInstructorAssociationPeer::YEAR, $year);
     $statement = $conn->prepare($query);
     $statement->execute();
     $ids = $statement->fetchAll(PDO::FETCH_COLUMN, 0);
     $results = array();
     $c = new Criteria();
     $c->addJoin(CourseInstructorAssociationPeer::INSTRUCTOR_ID, InstructorPeer::ID);
     foreach ($ids as $id) {
         $crit = $c->getNewCriterion(CourseInstructorAssociationPeer::ID, $id);
         $c->addOr($crit);
     }
     $c->addAscendingOrderByColumn(InstructorPeer::LAST_NAME);
     $c->addAscendingOrderByColumn(InstructorPeer::FIRST_NAME);
     $raw = CourseInstructorAssociationPeer::doSelectJoinInstructor($c, $conn);
     foreach ($raw as $obj) {
         $results[] = $obj->getInstructor();
     }
     return $results;
 }
Example #10
0
 /**
  * Insert the row in the database.
  *
  * @param      PropelPDO $con
  *
  * @throws PropelException
  * @see        doSave()
  */
 protected function doInsert(PropelPDO $con)
 {
     $modifiedColumns = array();
     $index = 0;
     $this->modifiedColumns[] = CountryPeer::ID;
     if (null !== $this->id) {
         throw new PropelException('Cannot insert a value for auto-increment primary key (' . CountryPeer::ID . ')');
     }
     // check the columns in natural order for more readable SQL queries
     if ($this->isColumnModified(CountryPeer::ID)) {
         $modifiedColumns[':p' . $index++] = '`ID`';
     }
     if ($this->isColumnModified(CountryPeer::NAME)) {
         $modifiedColumns[':p' . $index++] = '`NAME`';
     }
     if ($this->isColumnModified(CountryPeer::ISO_CODE)) {
         $modifiedColumns[':p' . $index++] = '`ISO_CODE`';
     }
     if ($this->isColumnModified(CountryPeer::ISO_SHORT_CODE)) {
         $modifiedColumns[':p' . $index++] = '`ISO_SHORT_CODE`';
     }
     if ($this->isColumnModified(CountryPeer::DEMONYM)) {
         $modifiedColumns[':p' . $index++] = '`DEMONYM`';
     }
     if ($this->isColumnModified(CountryPeer::DEFAULT_CURRENCY_ID)) {
         $modifiedColumns[':p' . $index++] = '`DEFAULT_CURRENCY_ID`';
     }
     $sql = sprintf('INSERT INTO `country` (%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 '`ISO_CODE`':
                     $stmt->bindValue($identifier, $this->iso_code, PDO::PARAM_STR);
                     break;
                 case '`ISO_SHORT_CODE`':
                     $stmt->bindValue($identifier, $this->iso_short_code, PDO::PARAM_STR);
                     break;
                 case '`DEMONYM`':
                     $stmt->bindValue($identifier, $this->demonym, PDO::PARAM_STR);
                     break;
                 case '`DEFAULT_CURRENCY_ID`':
                     $stmt->bindValue($identifier, $this->default_currency_id, 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), $e);
     }
     try {
         $pk = $con->lastInsertId();
     } catch (Exception $e) {
         throw new PropelException('Unable to get autoincrement id.', $e);
     }
     $this->setId($pk);
     $this->setNew(false);
 }
 /**
  * Insert the row in the database.
  *
  * @param PropelPDO $con
  *
  * @throws PropelException
  * @see        doSave()
  */
 protected function doInsert(PropelPDO $con)
 {
     $modifiedColumns = array();
     $index = 0;
     $this->modifiedColumns[] = DetailBarangMasukPeer::ID;
     if (null !== $this->id) {
         throw new PropelException('Cannot insert a value for auto-increment primary key (' . DetailBarangMasukPeer::ID . ')');
     }
     // check the columns in natural order for more readable SQL queries
     if ($this->isColumnModified(DetailBarangMasukPeer::ID)) {
         $modifiedColumns[':p' . $index++] = '`id`';
     }
     if ($this->isColumnModified(DetailBarangMasukPeer::ID_BARANG_MASUK)) {
         $modifiedColumns[':p' . $index++] = '`id_barang_masuk`';
     }
     if ($this->isColumnModified(DetailBarangMasukPeer::ID_BARANG)) {
         $modifiedColumns[':p' . $index++] = '`id_barang`';
     }
     if ($this->isColumnModified(DetailBarangMasukPeer::HARGA)) {
         $modifiedColumns[':p' . $index++] = '`harga`';
     }
     $sql = sprintf('INSERT INTO `detail_barang_masuk` (%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 '`id_barang_masuk`':
                     $stmt->bindValue($identifier, $this->id_barang_masuk, PDO::PARAM_INT);
                     break;
                 case '`id_barang`':
                     $stmt->bindValue($identifier, $this->id_barang, PDO::PARAM_INT);
                     break;
                 case '`harga`':
                     $stmt->bindValue($identifier, $this->harga, 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), $e);
     }
     try {
         $pk = $con->lastInsertId();
     } catch (Exception $e) {
         throw new PropelException('Unable to get autoincrement id.', $e);
     }
     $this->setId($pk);
     $this->setNew(false);
 }
Example #12
0
	/**
	 * Insert the row in the database.
	 *
	 * @param      PropelPDO $con
	 *
	 * @throws     PropelException
	 * @see        doSave()
	 */
	protected function doInsert(PropelPDO $con)
	{
		$modifiedColumns = array();
		$index = 0;


		 // check the columns in natural order for more readable SQL queries
		if ($this->isColumnModified(AidDetailsPeer::ID)) {
			$modifiedColumns[':p' . $index++]  = 'ID';
		}
		if ($this->isColumnModified(AidDetailsPeer::NOM)) {
			$modifiedColumns[':p' . $index++]  = 'NOM';
		}
		if ($this->isColumnModified(AidDetailsPeer::NUMERO)) {
			$modifiedColumns[':p' . $index++]  = 'NUMERO';
		}
		if ($this->isColumnModified(AidDetailsPeer::INDICE_AID)) {
			$modifiedColumns[':p' . $index++]  = 'INDICE_AID';
		}
		if ($this->isColumnModified(AidDetailsPeer::PERSO1)) {
			$modifiedColumns[':p' . $index++]  = 'PERSO1';
		}
		if ($this->isColumnModified(AidDetailsPeer::PERSO2)) {
			$modifiedColumns[':p' . $index++]  = 'PERSO2';
		}
		if ($this->isColumnModified(AidDetailsPeer::PERSO3)) {
			$modifiedColumns[':p' . $index++]  = 'PERSO3';
		}
		if ($this->isColumnModified(AidDetailsPeer::PRODUCTIONS)) {
			$modifiedColumns[':p' . $index++]  = 'PRODUCTIONS';
		}
		if ($this->isColumnModified(AidDetailsPeer::RESUME)) {
			$modifiedColumns[':p' . $index++]  = 'RESUME';
		}
		if ($this->isColumnModified(AidDetailsPeer::FAMILLE)) {
			$modifiedColumns[':p' . $index++]  = 'FAMILLE';
		}
		if ($this->isColumnModified(AidDetailsPeer::MOTS_CLES)) {
			$modifiedColumns[':p' . $index++]  = 'MOTS_CLES';
		}
		if ($this->isColumnModified(AidDetailsPeer::ADRESSE1)) {
			$modifiedColumns[':p' . $index++]  = 'ADRESSE1';
		}
		if ($this->isColumnModified(AidDetailsPeer::ADRESSE2)) {
			$modifiedColumns[':p' . $index++]  = 'ADRESSE2';
		}
		if ($this->isColumnModified(AidDetailsPeer::PUBLIC_DESTINATAIRE)) {
			$modifiedColumns[':p' . $index++]  = 'PUBLIC_DESTINATAIRE';
		}
		if ($this->isColumnModified(AidDetailsPeer::CONTACTS)) {
			$modifiedColumns[':p' . $index++]  = 'CONTACTS';
		}
		if ($this->isColumnModified(AidDetailsPeer::DIVERS)) {
			$modifiedColumns[':p' . $index++]  = 'DIVERS';
		}
		if ($this->isColumnModified(AidDetailsPeer::MATIERE1)) {
			$modifiedColumns[':p' . $index++]  = 'MATIERE1';
		}
		if ($this->isColumnModified(AidDetailsPeer::MATIERE2)) {
			$modifiedColumns[':p' . $index++]  = 'MATIERE2';
		}
		if ($this->isColumnModified(AidDetailsPeer::ELEVE_PEUT_MODIFIER)) {
			$modifiedColumns[':p' . $index++]  = 'ELEVE_PEUT_MODIFIER';
		}
		if ($this->isColumnModified(AidDetailsPeer::PROF_PEUT_MODIFIER)) {
			$modifiedColumns[':p' . $index++]  = 'PROF_PEUT_MODIFIER';
		}
		if ($this->isColumnModified(AidDetailsPeer::CPE_PEUT_MODIFIER)) {
			$modifiedColumns[':p' . $index++]  = 'CPE_PEUT_MODIFIER';
		}
		if ($this->isColumnModified(AidDetailsPeer::FICHE_PUBLIQUE)) {
			$modifiedColumns[':p' . $index++]  = 'FICHE_PUBLIQUE';
		}
		if ($this->isColumnModified(AidDetailsPeer::AFFICHE_ADRESSE1)) {
			$modifiedColumns[':p' . $index++]  = 'AFFICHE_ADRESSE1';
		}
		if ($this->isColumnModified(AidDetailsPeer::EN_CONSTRUCTION)) {
			$modifiedColumns[':p' . $index++]  = 'EN_CONSTRUCTION';
		}

		$sql = sprintf(
			'INSERT INTO aid (%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_STR);
						break;
					case 'NOM':
						$stmt->bindValue($identifier, $this->nom, PDO::PARAM_STR);
						break;
					case 'NUMERO':
						$stmt->bindValue($identifier, $this->numero, PDO::PARAM_STR);
						break;
					case 'INDICE_AID':
						$stmt->bindValue($identifier, $this->indice_aid, PDO::PARAM_INT);
						break;
					case 'PERSO1':
						$stmt->bindValue($identifier, $this->perso1, PDO::PARAM_STR);
						break;
					case 'PERSO2':
						$stmt->bindValue($identifier, $this->perso2, PDO::PARAM_STR);
						break;
					case 'PERSO3':
						$stmt->bindValue($identifier, $this->perso3, PDO::PARAM_STR);
						break;
					case 'PRODUCTIONS':
						$stmt->bindValue($identifier, $this->productions, PDO::PARAM_STR);
						break;
					case 'RESUME':
						$stmt->bindValue($identifier, $this->resume, PDO::PARAM_STR);
						break;
					case 'FAMILLE':
						$stmt->bindValue($identifier, $this->famille, PDO::PARAM_INT);
						break;
					case 'MOTS_CLES':
						$stmt->bindValue($identifier, $this->mots_cles, PDO::PARAM_STR);
						break;
					case 'ADRESSE1':
						$stmt->bindValue($identifier, $this->adresse1, PDO::PARAM_STR);
						break;
					case 'ADRESSE2':
						$stmt->bindValue($identifier, $this->adresse2, PDO::PARAM_STR);
						break;
					case 'PUBLIC_DESTINATAIRE':
						$stmt->bindValue($identifier, $this->public_destinataire, PDO::PARAM_STR);
						break;
					case 'CONTACTS':
						$stmt->bindValue($identifier, $this->contacts, PDO::PARAM_STR);
						break;
					case 'DIVERS':
						$stmt->bindValue($identifier, $this->divers, PDO::PARAM_STR);
						break;
					case 'MATIERE1':
						$stmt->bindValue($identifier, $this->matiere1, PDO::PARAM_STR);
						break;
					case 'MATIERE2':
						$stmt->bindValue($identifier, $this->matiere2, PDO::PARAM_STR);
						break;
					case 'ELEVE_PEUT_MODIFIER':
						$stmt->bindValue($identifier, $this->eleve_peut_modifier, PDO::PARAM_STR);
						break;
					case 'PROF_PEUT_MODIFIER':
						$stmt->bindValue($identifier, $this->prof_peut_modifier, PDO::PARAM_STR);
						break;
					case 'CPE_PEUT_MODIFIER':
						$stmt->bindValue($identifier, $this->cpe_peut_modifier, PDO::PARAM_STR);
						break;
					case 'FICHE_PUBLIQUE':
						$stmt->bindValue($identifier, $this->fiche_publique, PDO::PARAM_STR);
						break;
					case 'AFFICHE_ADRESSE1':
						$stmt->bindValue($identifier, $this->affiche_adresse1, PDO::PARAM_STR);
						break;
					case 'EN_CONSTRUCTION':
						$stmt->bindValue($identifier, $this->en_construction, 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), $e);
		}

		$this->setNew(false);
	}
Example #13
0
 /**
  * Insert the row in the database.
  *
  * @param PropelPDO $con
  *
  * @throws PropelException
  * @see        doSave()
  */
 protected function doInsert(PropelPDO $con)
 {
     $modifiedColumns = array();
     $index = 0;
     $this->modifiedColumns[] = PlayerPeer::ID;
     if (null !== $this->id) {
         throw new PropelException('Cannot insert a value for auto-increment primary key (' . PlayerPeer::ID . ')');
     }
     // check the columns in natural order for more readable SQL queries
     if ($this->isColumnModified(PlayerPeer::ID)) {
         $modifiedColumns[':p' . $index++] = '`id`';
     }
     if ($this->isColumnModified(PlayerPeer::LAST_NAME)) {
         $modifiedColumns[':p' . $index++] = '`last_name`';
     }
     if ($this->isColumnModified(PlayerPeer::FIRST_NAME)) {
         $modifiedColumns[':p' . $index++] = '`first_name`';
     }
     if ($this->isColumnModified(PlayerPeer::PHOTO)) {
         $modifiedColumns[':p' . $index++] = '`photo`';
     }
     if ($this->isColumnModified(PlayerPeer::PHONE)) {
         $modifiedColumns[':p' . $index++] = '`phone`';
     }
     if ($this->isColumnModified(PlayerPeer::MOBILE)) {
         $modifiedColumns[':p' . $index++] = '`mobile`';
     }
     if ($this->isColumnModified(PlayerPeer::NOTE)) {
         $modifiedColumns[':p' . $index++] = '`note`';
     }
     $sql = sprintf('INSERT INTO `player` (%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 '`last_name`':
                     $stmt->bindValue($identifier, $this->last_name, PDO::PARAM_STR);
                     break;
                 case '`first_name`':
                     $stmt->bindValue($identifier, $this->first_name, PDO::PARAM_STR);
                     break;
                 case '`photo`':
                     $stmt->bindValue($identifier, $this->photo, PDO::PARAM_STR);
                     break;
                 case '`phone`':
                     $stmt->bindValue($identifier, $this->phone, PDO::PARAM_STR);
                     break;
                 case '`mobile`':
                     $stmt->bindValue($identifier, $this->mobile, PDO::PARAM_STR);
                     break;
                 case '`note`':
                     $stmt->bindValue($identifier, $this->note, 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), $e);
     }
     try {
         $pk = $con->lastInsertId();
     } catch (Exception $e) {
         throw new PropelException('Unable to get autoincrement id.', $e);
     }
     $this->setId($pk);
     $this->setNew(false);
 }
Example #14
0
 /**
  * Insert the row in the database.
  *
  * @param PropelPDO $con
  *
  * @throws PropelException
  * @see        doSave()
  */
 protected function doInsert(PropelPDO $con)
 {
     $modifiedColumns = array();
     $index = 0;
     $this->modifiedColumns[] = ClientePeer::ID;
     if (null !== $this->id) {
         throw new PropelException('Cannot insert a value for auto-increment primary key (' . ClientePeer::ID . ')');
     }
     // check the columns in natural order for more readable SQL queries
     if ($this->isColumnModified(ClientePeer::ID)) {
         $modifiedColumns[':p' . $index++] = '`ID`';
     }
     if ($this->isColumnModified(ClientePeer::NOMBRE)) {
         $modifiedColumns[':p' . $index++] = '`NOMBRE`';
     }
     if ($this->isColumnModified(ClientePeer::CORREO)) {
         $modifiedColumns[':p' . $index++] = '`CORREO`';
     }
     if ($this->isColumnModified(ClientePeer::DIRECCION)) {
         $modifiedColumns[':p' . $index++] = '`DIRECCION`';
     }
     if ($this->isColumnModified(ClientePeer::TELEFONO)) {
         $modifiedColumns[':p' . $index++] = '`TELEFONO`';
     }
     if ($this->isColumnModified(ClientePeer::CIUDAD)) {
         $modifiedColumns[':p' . $index++] = '`CIUDAD`';
     }
     if ($this->isColumnModified(ClientePeer::OBSERVACION)) {
         $modifiedColumns[':p' . $index++] = '`OBSERVACION`';
     }
     if ($this->isColumnModified(ClientePeer::PUNTOS)) {
         $modifiedColumns[':p' . $index++] = '`PUNTOS`';
     }
     if ($this->isColumnModified(ClientePeer::NIT)) {
         $modifiedColumns[':p' . $index++] = '`NIT`';
     }
     $sql = sprintf('INSERT INTO `cliente` (%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 '`NOMBRE`':
                     $stmt->bindValue($identifier, $this->nombre, PDO::PARAM_STR);
                     break;
                 case '`CORREO`':
                     $stmt->bindValue($identifier, $this->correo, PDO::PARAM_STR);
                     break;
                 case '`DIRECCION`':
                     $stmt->bindValue($identifier, $this->direccion, PDO::PARAM_STR);
                     break;
                 case '`TELEFONO`':
                     $stmt->bindValue($identifier, $this->telefono, PDO::PARAM_STR);
                     break;
                 case '`CIUDAD`':
                     $stmt->bindValue($identifier, $this->ciudad, PDO::PARAM_STR);
                     break;
                 case '`OBSERVACION`':
                     $stmt->bindValue($identifier, $this->observacion, PDO::PARAM_STR);
                     break;
                 case '`PUNTOS`':
                     $stmt->bindValue($identifier, $this->puntos, PDO::PARAM_INT);
                     break;
                 case '`NIT`':
                     $stmt->bindValue($identifier, $this->nit, 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), $e);
     }
     try {
         $pk = $con->lastInsertId();
     } catch (Exception $e) {
         throw new PropelException('Unable to get autoincrement id.', $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     PropelPDO $con A connection object
  *
  * @return                 Medicofacturacion A model object, or null if the key is not found
  * @throws PropelException
  */
 protected function findPkSimple($key, $con)
 {
     $sql = 'SELECT `idmedicofacturacion`, `idmedico`, `medicofacturacion_razonsocial`, `medicofacturacion_rfc`, `medicofacturacion_calle`, `medicofacturacion_noexterior`, `medicofacturacion_nointerior`, `medicofacturacion_colonia`, `medicofacturacion_ciudad`, `medicofacturacion_estado`, `medicofacturacion_pais`, `medicofacturacion_codigopostal`, `medicofacturacion_telefono`, `medicofacturacion_email` FROM `medicofacturacion` WHERE `idmedicofacturacion` = :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), $e);
     }
     $obj = null;
     if ($row = $stmt->fetch(PDO::FETCH_NUM)) {
         $obj = new Medicofacturacion();
         $obj->hydrate($row);
         MedicofacturacionPeer::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     PropelPDO $con A connection object
  *
  * @return    Presidentialelection2004 A model object, or null if the key is not found
  */
 protected function findPkSimple($key, $con)
 {
     $sql = 'SELECT ID, COUNTY, CITY, VILLAGE, VOTENO, DPPNUM, DPPRATIO, KMTNUM, KMTRATIO, VAILDVOTES, INVAILDVOTES, TOTALVOTES, OTHERVOTES, VOTERSNUM, VOTERSRATIO FROM PresidentialElection2004 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), $e);
     }
     $obj = null;
     if ($row = $stmt->fetch(PDO::FETCH_NUM)) {
         $obj = new Presidentialelection2004();
         $obj->hydrate($row);
         Presidentialelection2004Peer::addInstanceToPool($obj, (string) $row[0]);
     }
     $stmt->closeCursor();
     return $obj;
 }
Example #17
0
	/**
	 * Insert the row in the database.
	 *
	 * @param      PropelPDO $con
	 *
	 * @throws     PropelException
	 * @see        doSave()
	 */
	protected function doInsert(PropelPDO $con)
	{
		$modifiedColumns = array();
		$index = 0;


		 // check the columns in natural order for more readable SQL queries
		if ($this->isColumnModified(JScolClassesPeer::LOGIN)) {
			$modifiedColumns[':p' . $index++]  = 'LOGIN';
		}
		if ($this->isColumnModified(JScolClassesPeer::ID_CLASSE)) {
			$modifiedColumns[':p' . $index++]  = 'ID_CLASSE';
		}

		$sql = sprintf(
			'INSERT INTO j_scol_classes (%s) VALUES (%s)',
			implode(', ', $modifiedColumns),
			implode(', ', array_keys($modifiedColumns))
		);

		try {
			$stmt = $con->prepare($sql);
			foreach ($modifiedColumns as $identifier => $columnName) {
				switch ($columnName) {
					case 'LOGIN':
						$stmt->bindValue($identifier, $this->login, PDO::PARAM_STR);
						break;
					case 'ID_CLASSE':
						$stmt->bindValue($identifier, $this->id_classe, 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), $e);
		}

		$this->setNew(false);
	}
 /**
  * Insert the row in the database.
  *
  * @param PropelPDO $con
  *
  * @throws PropelException
  * @see        doSave()
  */
 protected function doInsert(PropelPDO $con)
 {
     $modifiedColumns = array();
     $index = 0;
     $this->modifiedColumns[] = NewsletterPeer::ID;
     if (null !== $this->id) {
         throw new PropelException('Cannot insert a value for auto-increment primary key (' . NewsletterPeer::ID . ')');
     }
     // check the columns in natural order for more readable SQL queries
     if ($this->isColumnModified(NewsletterPeer::ID)) {
         $modifiedColumns[':p' . $index++] = '`id`';
     }
     if ($this->isColumnModified(NewsletterPeer::SUBJECT)) {
         $modifiedColumns[':p' . $index++] = '`subject`';
     }
     if ($this->isColumnModified(NewsletterPeer::NEWSLETTER_BODY)) {
         $modifiedColumns[':p' . $index++] = '`newsletter_body`';
     }
     if ($this->isColumnModified(NewsletterPeer::LANGUAGE_ID)) {
         $modifiedColumns[':p' . $index++] = '`language_id`';
     }
     if ($this->isColumnModified(NewsletterPeer::IS_APPROVED)) {
         $modifiedColumns[':p' . $index++] = '`is_approved`';
     }
     if ($this->isColumnModified(NewsletterPeer::IS_HTML)) {
         $modifiedColumns[':p' . $index++] = '`is_html`';
     }
     if ($this->isColumnModified(NewsletterPeer::TEMPLATE_NAME)) {
         $modifiedColumns[':p' . $index++] = '`template_name`';
     }
     if ($this->isColumnModified(NewsletterPeer::CREATED_AT)) {
         $modifiedColumns[':p' . $index++] = '`created_at`';
     }
     if ($this->isColumnModified(NewsletterPeer::UPDATED_AT)) {
         $modifiedColumns[':p' . $index++] = '`updated_at`';
     }
     if ($this->isColumnModified(NewsletterPeer::CREATED_BY)) {
         $modifiedColumns[':p' . $index++] = '`created_by`';
     }
     if ($this->isColumnModified(NewsletterPeer::UPDATED_BY)) {
         $modifiedColumns[':p' . $index++] = '`updated_by`';
     }
     $sql = sprintf('INSERT INTO `newsletters` (%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 '`subject`':
                     $stmt->bindValue($identifier, $this->subject, PDO::PARAM_STR);
                     break;
                 case '`newsletter_body`':
                     if (is_resource($this->newsletter_body)) {
                         rewind($this->newsletter_body);
                     }
                     $stmt->bindValue($identifier, $this->newsletter_body, PDO::PARAM_LOB);
                     break;
                 case '`language_id`':
                     $stmt->bindValue($identifier, $this->language_id, PDO::PARAM_STR);
                     break;
                 case '`is_approved`':
                     $stmt->bindValue($identifier, (int) $this->is_approved, PDO::PARAM_INT);
                     break;
                 case '`is_html`':
                     $stmt->bindValue($identifier, (int) $this->is_html, PDO::PARAM_INT);
                     break;
                 case '`template_name`':
                     $stmt->bindValue($identifier, $this->template_name, PDO::PARAM_STR);
                     break;
                 case '`created_at`':
                     $stmt->bindValue($identifier, $this->created_at, PDO::PARAM_STR);
                     break;
                 case '`updated_at`':
                     $stmt->bindValue($identifier, $this->updated_at, PDO::PARAM_STR);
                     break;
                 case '`created_by`':
                     $stmt->bindValue($identifier, $this->created_by, PDO::PARAM_INT);
                     break;
                 case '`updated_by`':
                     $stmt->bindValue($identifier, $this->updated_by, 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), $e);
     }
     try {
         $pk = $con->lastInsertId();
     } catch (Exception $e) {
         throw new PropelException('Unable to get autoincrement id.', $e);
     }
     $this->setId($pk);
     $this->setNew(false);
 }
Example #19
0
 /**
  * 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     PropelPDO $con A connection object
  *
  * @return                 Udm A model object, or null if the key is not found
  * @throws PropelException
  */
 protected function findPkSimple($key, $con)
 {
     $sql = 'SELECT `idudm`, `udm_nombre`, `udm_descripcion` FROM `udm` WHERE `idudm` = :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), $e);
     }
     $obj = null;
     if ($row = $stmt->fetch(PDO::FETCH_NUM)) {
         $obj = new Udm();
         $obj->hydrate($row);
         UdmPeer::addInstanceToPool($obj, (string) $key);
     }
     $stmt->closeCursor();
     return $obj;
 }
Example #20
0
 /**
  * Builds, binds and executes a SELECT query based on the current object.
  *
  * @param PropelPDO $con A connection object
  *
  * @return PDOStatement A PDO statement executed using the connection, ready to be fetched
  *
  * @throws PropelException
  */
 protected function doSelect($con)
 {
     // check that the columns of the main class are already added (if this is the primary ModelCriteria)
     if (!$this->hasSelectClause() && !$this->getPrimaryCriteria()) {
         $this->addSelfSelectColumns();
     }
     $this->configureSelectColumns();
     $dbMap = Propel::getDatabaseMap($this->getDbName());
     $db = Propel::getDB($this->getDbName());
     $params = array();
     $sql = BasePeer::createSelectSql($this, $params);
     try {
         $stmt = $con->prepare($sql);
         $db->bindValues($stmt, $params, $dbMap);
         $stmt->execute();
     } catch (Exception $e) {
         Propel::log($e->getMessage(), Propel::LOG_ERR);
         throw new PropelException(sprintf('Unable to execute SELECT statement [%s]', $sql), $e);
     }
     return $stmt;
 }
 /**
  * Insert the row in the database.
  *
  * @param      PropelPDO $con
  *
  * @throws     PropelException
  * @see        doSave()
  */
 protected function doInsert(PropelPDO $con)
 {
     $modifiedColumns = array();
     $index = 0;
     $this->modifiedColumns[] = Slider_maePeer::ID;
     if (null !== $this->id) {
         throw new PropelException('Cannot insert a value for auto-increment primary key (' . Slider_maePeer::ID . ')');
     }
     // check the columns in natural order for more readable SQL queries
     if ($this->isColumnModified(Slider_maePeer::ID)) {
         $modifiedColumns[':p' . $index++] = '`ID`';
     }
     if ($this->isColumnModified(Slider_maePeer::ID_LIBRO)) {
         $modifiedColumns[':p' . $index++] = '`ID_LIBRO`';
     }
     if ($this->isColumnModified(Slider_maePeer::POSICION)) {
         $modifiedColumns[':p' . $index++] = '`POSICION`';
     }
     if ($this->isColumnModified(Slider_maePeer::ID_CATEGORIA)) {
         $modifiedColumns[':p' . $index++] = '`ID_CATEGORIA`';
     }
     $sql = sprintf('INSERT INTO `slider_mae` (%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 '`ID_LIBRO`':
                     $stmt->bindValue($identifier, $this->id_libro, PDO::PARAM_INT);
                     break;
                 case '`POSICION`':
                     $stmt->bindValue($identifier, $this->posicion, PDO::PARAM_INT);
                     break;
                 case '`ID_CATEGORIA`':
                     $stmt->bindValue($identifier, $this->id_categoria, 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), $e);
     }
     try {
         $pk = $con->lastInsertId();
     } catch (Exception $e) {
         throw new PropelException('Unable to get autoincrement id.', $e);
     }
     $this->setId($pk);
     $this->setNew(false);
 }
Example #22
0
 /**
  * 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     PropelPDO $con A connection object
  *
  * @return                 Property A model object, or null if the key is not found
  * @throws PropelException
  */
 protected function findPkSimple($key, $con)
 {
     $sql = 'SELECT `id`, `account_id`, `name`, `label`, `description`, `type`, `default_value`, `fixed` FROM `property` 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), $e);
     }
     $obj = null;
     if ($row = $stmt->fetch(PDO::FETCH_NUM)) {
         $obj = new Property();
         $obj->hydrate($row);
         PropertyPeer::addInstanceToPool($obj, (string) $key);
     }
     $stmt->closeCursor();
     return $obj;
 }
 /**
  * Insert the row in the database.
  *
  * @param      PropelPDO $con
  *
  * @throws     PropelException
  * @see        doSave()
  */
 protected function doInsert(PropelPDO $con)
 {
     $modifiedColumns = array();
     $index = 0;
     $this->modifiedColumns[] = VentaPeer::IDVENTA;
     if (null !== $this->idventa) {
         throw new PropelException('Cannot insert a value for auto-increment primary key (' . VentaPeer::IDVENTA . ')');
     }
     // check the columns in natural order for more readable SQL queries
     if ($this->isColumnModified(VentaPeer::IDVENTA)) {
         $modifiedColumns[':p' . $index++] = '`IDVENTA`';
     }
     if ($this->isColumnModified(VentaPeer::FECHA)) {
         $modifiedColumns[':p' . $index++] = '`FECHA`';
     }
     if ($this->isColumnModified(VentaPeer::IDCLIENTE)) {
         $modifiedColumns[':p' . $index++] = '`IDCLIENTE`';
     }
     if ($this->isColumnModified(VentaPeer::IDPRODUCTO)) {
         $modifiedColumns[':p' . $index++] = '`IDPRODUCTO`';
     }
     $sql = sprintf('INSERT INTO `venta` (%s) VALUES (%s)', implode(', ', $modifiedColumns), implode(', ', array_keys($modifiedColumns)));
     try {
         $stmt = $con->prepare($sql);
         foreach ($modifiedColumns as $identifier => $columnName) {
             switch ($columnName) {
                 case '`IDVENTA`':
                     $stmt->bindValue($identifier, $this->idventa, PDO::PARAM_INT);
                     break;
                 case '`FECHA`':
                     $stmt->bindValue($identifier, $this->fecha, PDO::PARAM_STR);
                     break;
                 case '`IDCLIENTE`':
                     $stmt->bindValue($identifier, $this->idcliente, PDO::PARAM_INT);
                     break;
                 case '`IDPRODUCTO`':
                     $stmt->bindValue($identifier, $this->idproducto, 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), $e);
     }
     try {
         $pk = $con->lastInsertId();
     } catch (Exception $e) {
         throw new PropelException('Unable to get autoincrement id.', $e);
     }
     $this->setIdventa($pk);
     $this->setNew(false);
 }
Example #24
0
 /**
  * Insert the row in the database.
  *
  * @param PropelPDO $con
  *
  * @throws PropelException
  * @see        doSave()
  */
 protected function doInsert(PropelPDO $con)
 {
     $modifiedColumns = array();
     $index = 0;
     $this->modifiedColumns[] = RightPeer::ID;
     if (null !== $this->id) {
         throw new PropelException('Cannot insert a value for auto-increment primary key (' . RightPeer::ID . ')');
     }
     // check the columns in natural order for more readable SQL queries
     if ($this->isColumnModified(RightPeer::ID)) {
         $modifiedColumns[':p' . $index++] = '`id`';
     }
     if ($this->isColumnModified(RightPeer::ROLE_KEY)) {
         $modifiedColumns[':p' . $index++] = '`role_key`';
     }
     if ($this->isColumnModified(RightPeer::PAGE_ID)) {
         $modifiedColumns[':p' . $index++] = '`page_id`';
     }
     if ($this->isColumnModified(RightPeer::IS_INHERITED)) {
         $modifiedColumns[':p' . $index++] = '`is_inherited`';
     }
     if ($this->isColumnModified(RightPeer::MAY_EDIT_PAGE_DETAILS)) {
         $modifiedColumns[':p' . $index++] = '`may_edit_page_details`';
     }
     if ($this->isColumnModified(RightPeer::MAY_EDIT_PAGE_CONTENTS)) {
         $modifiedColumns[':p' . $index++] = '`may_edit_page_contents`';
     }
     if ($this->isColumnModified(RightPeer::MAY_DELETE)) {
         $modifiedColumns[':p' . $index++] = '`may_delete`';
     }
     if ($this->isColumnModified(RightPeer::MAY_CREATE_CHILDREN)) {
         $modifiedColumns[':p' . $index++] = '`may_create_children`';
     }
     if ($this->isColumnModified(RightPeer::MAY_VIEW_PAGE)) {
         $modifiedColumns[':p' . $index++] = '`may_view_page`';
     }
     if ($this->isColumnModified(RightPeer::CREATED_AT)) {
         $modifiedColumns[':p' . $index++] = '`created_at`';
     }
     if ($this->isColumnModified(RightPeer::UPDATED_AT)) {
         $modifiedColumns[':p' . $index++] = '`updated_at`';
     }
     if ($this->isColumnModified(RightPeer::CREATED_BY)) {
         $modifiedColumns[':p' . $index++] = '`created_by`';
     }
     if ($this->isColumnModified(RightPeer::UPDATED_BY)) {
         $modifiedColumns[':p' . $index++] = '`updated_by`';
     }
     $sql = sprintf('INSERT INTO `rights` (%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 '`role_key`':
                     $stmt->bindValue($identifier, $this->role_key, PDO::PARAM_STR);
                     break;
                 case '`page_id`':
                     $stmt->bindValue($identifier, $this->page_id, PDO::PARAM_INT);
                     break;
                 case '`is_inherited`':
                     $stmt->bindValue($identifier, (int) $this->is_inherited, PDO::PARAM_INT);
                     break;
                 case '`may_edit_page_details`':
                     $stmt->bindValue($identifier, (int) $this->may_edit_page_details, PDO::PARAM_INT);
                     break;
                 case '`may_edit_page_contents`':
                     $stmt->bindValue($identifier, (int) $this->may_edit_page_contents, PDO::PARAM_INT);
                     break;
                 case '`may_delete`':
                     $stmt->bindValue($identifier, (int) $this->may_delete, PDO::PARAM_INT);
                     break;
                 case '`may_create_children`':
                     $stmt->bindValue($identifier, (int) $this->may_create_children, PDO::PARAM_INT);
                     break;
                 case '`may_view_page`':
                     $stmt->bindValue($identifier, (int) $this->may_view_page, PDO::PARAM_INT);
                     break;
                 case '`created_at`':
                     $stmt->bindValue($identifier, $this->created_at, PDO::PARAM_STR);
                     break;
                 case '`updated_at`':
                     $stmt->bindValue($identifier, $this->updated_at, PDO::PARAM_STR);
                     break;
                 case '`created_by`':
                     $stmt->bindValue($identifier, $this->created_by, PDO::PARAM_INT);
                     break;
                 case '`updated_by`':
                     $stmt->bindValue($identifier, $this->updated_by, 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), $e);
     }
     try {
         $pk = $con->lastInsertId();
     } catch (Exception $e) {
         throw new PropelException('Unable to get autoincrement id.', $e);
     }
     $this->setId($pk);
     $this->setNew(false);
 }
 /**
  * Insert the row in the database.
  *
  * @param      PropelPDO $con
  *
  * @throws     PropelException
  * @see        doSave()
  */
 protected function doInsert(PropelPDO $con)
 {
     $modifiedColumns = array();
     $index = 0;
     $this->modifiedColumns[] = afWidgetHelpSettingsPeer::ID;
     if (null !== $this->id) {
         throw new PropelException('Cannot insert a value for auto-increment primary key (' . afWidgetHelpSettingsPeer::ID . ')');
     }
     // check the columns in natural order for more readable SQL queries
     if ($this->isColumnModified(afWidgetHelpSettingsPeer::ID)) {
         $modifiedColumns[':p' . $index++] = '`ID`';
     }
     if ($this->isColumnModified(afWidgetHelpSettingsPeer::USER_ID)) {
         $modifiedColumns[':p' . $index++] = '`USER_ID`';
     }
     if ($this->isColumnModified(afWidgetHelpSettingsPeer::WIDGET_HELP_IS_ENABLED)) {
         $modifiedColumns[':p' . $index++] = '`WIDGET_HELP_IS_ENABLED`';
     }
     if ($this->isColumnModified(afWidgetHelpSettingsPeer::POPUP_HELP_IS_ENABLED)) {
         $modifiedColumns[':p' . $index++] = '`POPUP_HELP_IS_ENABLED`';
     }
     if ($this->isColumnModified(afWidgetHelpSettingsPeer::HELP_TYPE)) {
         $modifiedColumns[':p' . $index++] = '`HELP_TYPE`';
     }
     if ($this->isColumnModified(afWidgetHelpSettingsPeer::CREATED_AT)) {
         $modifiedColumns[':p' . $index++] = '`CREATED_AT`';
     }
     if ($this->isColumnModified(afWidgetHelpSettingsPeer::UPDATED_AT)) {
         $modifiedColumns[':p' . $index++] = '`UPDATED_AT`';
     }
     $sql = sprintf('INSERT INTO `af_widget_help_settings` (%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 '`USER_ID`':
                     $stmt->bindValue($identifier, $this->user_id, PDO::PARAM_INT);
                     break;
                 case '`WIDGET_HELP_IS_ENABLED`':
                     $stmt->bindValue($identifier, (int) $this->widget_help_is_enabled, PDO::PARAM_INT);
                     break;
                 case '`POPUP_HELP_IS_ENABLED`':
                     $stmt->bindValue($identifier, (int) $this->popup_help_is_enabled, PDO::PARAM_INT);
                     break;
                 case '`HELP_TYPE`':
                     $stmt->bindValue($identifier, $this->help_type, PDO::PARAM_INT);
                     break;
                 case '`CREATED_AT`':
                     $stmt->bindValue($identifier, $this->created_at, PDO::PARAM_STR);
                     break;
                 case '`UPDATED_AT`':
                     $stmt->bindValue($identifier, $this->updated_at, 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), $e);
     }
     try {
         $pk = $con->lastInsertId();
     } catch (Exception $e) {
         throw new PropelException('Unable to get autoincrement id.', $e);
     }
     $this->setId($pk);
     $this->setNew(false);
 }
 /**
  * Insert the row in the database.
  *
  * @param      PropelPDO $con
  *
  * @throws     PropelException
  * @see        doSave()
  */
 protected function doInsert(PropelPDO $con)
 {
     $modifiedColumns = array();
     $index = 0;
     $this->modifiedColumns[] = ClientePeer::ID_CLIE;
     if (null !== $this->id_clie) {
         throw new PropelException('Cannot insert a value for auto-increment primary key (' . ClientePeer::ID_CLIE . ')');
     }
     // check the columns in natural order for more readable SQL queries
     if ($this->isColumnModified(ClientePeer::ID_CLIE)) {
         $modifiedColumns[':p' . $index++] = '`ID_CLIE`';
     }
     if ($this->isColumnModified(ClientePeer::APELLIDO)) {
         $modifiedColumns[':p' . $index++] = '`APELLIDO`';
     }
     if ($this->isColumnModified(ClientePeer::NOMBRE)) {
         $modifiedColumns[':p' . $index++] = '`NOMBRE`';
     }
     if ($this->isColumnModified(ClientePeer::TELEFONO)) {
         $modifiedColumns[':p' . $index++] = '`TELEFONO`';
     }
     if ($this->isColumnModified(ClientePeer::DIRECCION)) {
         $modifiedColumns[':p' . $index++] = '`DIRECCION`';
     }
     if ($this->isColumnModified(ClientePeer::ID_PROV)) {
         $modifiedColumns[':p' . $index++] = '`ID_PROV`';
     }
     if ($this->isColumnModified(ClientePeer::ID_CIUDAD)) {
         $modifiedColumns[':p' . $index++] = '`ID_CIUDAD`';
     }
     if ($this->isColumnModified(ClientePeer::EMAIL)) {
         $modifiedColumns[':p' . $index++] = '`EMAIL`';
     }
     if ($this->isColumnModified(ClientePeer::USER)) {
         $modifiedColumns[':p' . $index++] = '`USER`';
     }
     if ($this->isColumnModified(ClientePeer::PASS)) {
         $modifiedColumns[':p' . $index++] = '`PASS`';
     }
     $sql = sprintf('INSERT INTO `cliente` (%s) VALUES (%s)', implode(', ', $modifiedColumns), implode(', ', array_keys($modifiedColumns)));
     try {
         $stmt = $con->prepare($sql);
         foreach ($modifiedColumns as $identifier => $columnName) {
             switch ($columnName) {
                 case '`ID_CLIE`':
                     $stmt->bindValue($identifier, $this->id_clie, PDO::PARAM_INT);
                     break;
                 case '`APELLIDO`':
                     $stmt->bindValue($identifier, $this->apellido, PDO::PARAM_STR);
                     break;
                 case '`NOMBRE`':
                     $stmt->bindValue($identifier, $this->nombre, PDO::PARAM_STR);
                     break;
                 case '`TELEFONO`':
                     $stmt->bindValue($identifier, $this->telefono, PDO::PARAM_STR);
                     break;
                 case '`DIRECCION`':
                     $stmt->bindValue($identifier, $this->direccion, PDO::PARAM_STR);
                     break;
                 case '`ID_PROV`':
                     $stmt->bindValue($identifier, $this->id_prov, PDO::PARAM_INT);
                     break;
                 case '`ID_CIUDAD`':
                     $stmt->bindValue($identifier, $this->id_ciudad, PDO::PARAM_INT);
                     break;
                 case '`EMAIL`':
                     $stmt->bindValue($identifier, $this->email, PDO::PARAM_STR);
                     break;
                 case '`USER`':
                     $stmt->bindValue($identifier, $this->user, PDO::PARAM_STR);
                     break;
                 case '`PASS`':
                     $stmt->bindValue($identifier, $this->pass, 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), $e);
     }
     try {
         $pk = $con->lastInsertId();
     } catch (Exception $e) {
         throw new PropelException('Unable to get autoincrement id.', $e);
     }
     $this->setIdClie($pk);
     $this->setNew(false);
 }
 /**
  * Insert the row in the database.
  *
  * @param PropelPDO $con
  *
  * @throws PropelException
  * @see        doSave()
  */
 protected function doInsert(PropelPDO $con)
 {
     $modifiedColumns = array();
     $index = 0;
     $this->modifiedColumns[] = ExpedientehistorialPeer::IDEXPEDIENTEHISTORIAL;
     if (null !== $this->idexpedientehistorial) {
         throw new PropelException('Cannot insert a value for auto-increment primary key (' . ExpedientehistorialPeer::IDEXPEDIENTEHISTORIAL . ')');
     }
     // check the columns in natural order for more readable SQL queries
     if ($this->isColumnModified(ExpedientehistorialPeer::IDEXPEDIENTEHISTORIAL)) {
         $modifiedColumns[':p' . $index++] = '`idexpedientehistorial`';
     }
     if ($this->isColumnModified(ExpedientehistorialPeer::IDEXPEDIENTESERVICIO)) {
         $modifiedColumns[':p' . $index++] = '`idexpedienteservicio`';
     }
     if ($this->isColumnModified(ExpedientehistorialPeer::IDESTADOSERVICIO)) {
         $modifiedColumns[':p' . $index++] = '`idestadoservicio`';
     }
     if ($this->isColumnModified(ExpedientehistorialPeer::EXPEDIENTEHISTORIAL_FECHA)) {
         $modifiedColumns[':p' . $index++] = '`expedientehistorial_fecha`';
     }
     if ($this->isColumnModified(ExpedientehistorialPeer::EXPEDIENTEHISTORIAL_NOTA)) {
         $modifiedColumns[':p' . $index++] = '`expedientehistorial_nota`';
     }
     $sql = sprintf('INSERT INTO `expedientehistorial` (%s) VALUES (%s)', implode(', ', $modifiedColumns), implode(', ', array_keys($modifiedColumns)));
     try {
         $stmt = $con->prepare($sql);
         foreach ($modifiedColumns as $identifier => $columnName) {
             switch ($columnName) {
                 case '`idexpedientehistorial`':
                     $stmt->bindValue($identifier, $this->idexpedientehistorial, PDO::PARAM_INT);
                     break;
                 case '`idexpedienteservicio`':
                     $stmt->bindValue($identifier, $this->idexpedienteservicio, PDO::PARAM_INT);
                     break;
                 case '`idestadoservicio`':
                     $stmt->bindValue($identifier, $this->idestadoservicio, PDO::PARAM_INT);
                     break;
                 case '`expedientehistorial_fecha`':
                     $stmt->bindValue($identifier, $this->expedientehistorial_fecha, PDO::PARAM_STR);
                     break;
                 case '`expedientehistorial_nota`':
                     $stmt->bindValue($identifier, $this->expedientehistorial_nota, 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), $e);
     }
     try {
         $pk = $con->lastInsertId();
     } catch (Exception $e) {
         throw new PropelException('Unable to get autoincrement id.', $e);
     }
     $this->setIdexpedientehistorial($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     PropelPDO $con A connection object
  *
  * @return                 JournalEntryImage A model object, or null if the key is not found
  * @throws PropelException
  */
 protected function findPkSimple($key, $con)
 {
     $sql = 'SELECT `journal_entry_id`, `document_id`, `sort`, `legend`, `created_at`, `updated_at`, `created_by`, `updated_by` FROM `journal_entry_images` WHERE `journal_entry_id` = :p0 AND `document_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), $e);
     }
     $obj = null;
     if ($row = $stmt->fetch(PDO::FETCH_NUM)) {
         $obj = new JournalEntryImage();
         $obj->hydrate($row);
         JournalEntryImagePeer::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     PropelPDO $con A connection object
  *
  * @return                 OrganizationProduct A model object, or null if the key is not found
  * @throws PropelException
  */
 protected function findPkSimple($key, $con)
 {
     $sql = 'SELECT `organization_id`, `product_id`, `expires` FROM `organization_product` WHERE `organization_id` = :p0 AND `product_id` = :p1';
     try {
         $stmt = $con->prepare($sql);
         $stmt->bindValue(':p0', $key[0], PDO::PARAM_STR);
         $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), $e);
     }
     $obj = null;
     if ($row = $stmt->fetch(PDO::FETCH_NUM)) {
         $obj = new OrganizationProduct();
         $obj->hydrate($row);
         OrganizationProductPeer::addInstanceToPool($obj, serialize(array((string) $key[0], (string) $key[1])));
     }
     $stmt->closeCursor();
     return $obj;
 }
Example #30
0
 /**
  * Insert the row in the database.
  *
  * @param PropelPDO $con
  *
  * @throws PropelException
  * @see        doSave()
  */
 protected function doInsert(PropelPDO $con)
 {
     $modifiedColumns = array();
     $index = 0;
     $this->modifiedColumns[] = PluginPeer::ID;
     if (null !== $this->id) {
         throw new PropelException('Cannot insert a value for auto-increment primary key (' . PluginPeer::ID . ')');
     }
     // check the columns in natural order for more readable SQL queries
     if ($this->isColumnModified(PluginPeer::ID)) {
         $modifiedColumns[':p' . $index++] = '`id`';
     }
     if ($this->isColumnModified(PluginPeer::ACCOUNT_ID)) {
         $modifiedColumns[':p' . $index++] = '`account_id`';
     }
     if ($this->isColumnModified(PluginPeer::ENTITY)) {
         $modifiedColumns[':p' . $index++] = '`entity`';
     }
     if ($this->isColumnModified(PluginPeer::EVENT)) {
         $modifiedColumns[':p' . $index++] = '`event`';
     }
     if ($this->isColumnModified(PluginPeer::PRIORITY)) {
         $modifiedColumns[':p' . $index++] = '`priority`';
     }
     if ($this->isColumnModified(PluginPeer::IDENTIFIER)) {
         $modifiedColumns[':p' . $index++] = '`identifier`';
     }
     if ($this->isColumnModified(PluginPeer::NAME)) {
         $modifiedColumns[':p' . $index++] = '`name`';
     }
     if ($this->isColumnModified(PluginPeer::CODE)) {
         $modifiedColumns[':p' . $index++] = '`code`';
     }
     if ($this->isColumnModified(PluginPeer::ACTIVE)) {
         $modifiedColumns[':p' . $index++] = '`active`';
     }
     if ($this->isColumnModified(PluginPeer::INTERVAL)) {
         $modifiedColumns[':p' . $index++] = '`interval`';
     }
     if ($this->isColumnModified(PluginPeer::START)) {
         $modifiedColumns[':p' . $index++] = '`start`';
     }
     if ($this->isColumnModified(PluginPeer::LAST_EXECUTION_TIME)) {
         $modifiedColumns[':p' . $index++] = '`last_execution_time`';
     }
     $sql = sprintf('INSERT INTO `plugin` (%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 '`account_id`':
                     $stmt->bindValue($identifier, $this->account_id, PDO::PARAM_INT);
                     break;
                 case '`entity`':
                     $stmt->bindValue($identifier, $this->entity, PDO::PARAM_STR);
                     break;
                 case '`event`':
                     $stmt->bindValue($identifier, $this->event, PDO::PARAM_STR);
                     break;
                 case '`priority`':
                     $stmt->bindValue($identifier, $this->priority, PDO::PARAM_INT);
                     break;
                 case '`identifier`':
                     $stmt->bindValue($identifier, $this->identifier, PDO::PARAM_STR);
                     break;
                 case '`name`':
                     $stmt->bindValue($identifier, $this->name, PDO::PARAM_STR);
                     break;
                 case '`code`':
                     $stmt->bindValue($identifier, $this->code, PDO::PARAM_STR);
                     break;
                 case '`active`':
                     $stmt->bindValue($identifier, $this->active, PDO::PARAM_INT);
                     break;
                 case '`interval`':
                     $stmt->bindValue($identifier, $this->interval, PDO::PARAM_INT);
                     break;
                 case '`start`':
                     $stmt->bindValue($identifier, $this->start, PDO::PARAM_INT);
                     break;
                 case '`last_execution_time`':
                     $stmt->bindValue($identifier, $this->last_execution_time, 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), $e);
     }
     try {
         $pk = $con->lastInsertId();
     } catch (Exception $e) {
         throw new PropelException('Unable to get autoincrement id.', $e);
     }
     $this->setId($pk);
     $this->setNew(false);
 }