PHP Propel类代码示例

 public function executeMenu()
 {
     $this->setLayout(false);
     $con = Propel::getConnection();
     $year = date("Y");
     $years = array();
     $sql = "SELECT DISTINCT MONTH(start_date) AS month FROM m_news WHERE start_date LIKE '" . $year . "%'";
     $stmt = $con->createStatement();
     $rs = $stmt->executeQuery($sql);
     while ($rs->next()) {
         $months[] = $rs->get("month");
     }
     $con = Propel::getConnection();
     $year = date("Y");
     $sql = "SELECT DISTINCT YEAR(start_date) AS year FROM m_news";
     $stmt = $con->createStatement();
     $rs = $stmt->executeQuery($sql);
     while ($rs->next()) {
         $years[$rs->get("year")] = $rs->get("year");
     }
     unset($years[$year]);
     if (!empty($years)) {
         $this->pastYears = $years;
     }
     $this->monthsArr = array(1 => "january", 2 => "february", 3 => "march", 4 => "april", 5 => "may", 6 => "june", 7 => "july", 8 => "august", 9 => "september", 10 => "october", 11 => "november", 12 => "december");
     //UtilsHelper::Date()
     $this->months = $months;
     $this->getRequestParameter("month") ? $this->currentMonth = $this->getRequestParameter("month") : ($this->currentMonth = date("n"));
     $this->currentYear = $year;
 }

 /**
  * @see sfPluginConfiguration
  */
 public function initialize()
 {
     sfConfig::set('sf_orm', 'propel');
     if (!sfConfig::get('sf_admin_module_web_dir')) {
         sfConfig::set('sf_admin_module_web_dir', '/sfPropelPlugin');
     }
     sfToolkit::addIncludePath(array(sfConfig::get('sf_root_dir'), sfConfig::get('sf_propel_runtime_path', realpath(dirname(__FILE__) . '/../lib/vendor'))));
     require_once 'propel/Propel.php';
     if (!Propel::isInit()) {
         if (sfConfig::get('sf_debug') && sfConfig::get('sf_logging_enabled')) {
             Propel::setLogger(new sfPropelLogger($this->dispatcher));
         }
         $propelConfiguration = new PropelConfiguration();
         Propel::setConfiguration($propelConfiguration);
         $this->dispatcher->notify(new sfEvent($propelConfiguration, 'propel.configure'));
         Propel::initialize();
     }
     $this->dispatcher->connect('user.change_culture', array('sfPropel', 'listenToChangeCultureEvent'));
     if (sfConfig::get('sf_web_debug')) {
         $this->dispatcher->connect('debug.web.load_panels', array('sfWebDebugPanelPropel', 'listenToAddPanelEvent'));
     }
     if (sfConfig::get('sf_test')) {
         $this->dispatcher->connect('context.load_factories', array($this, 'clearAllInstancePools'));
     }
 }

 public static function getPopularTags($max = 30)
 {
     $connection = Propel::getConnection();
     $query = 'SELECT %s as query, COUNT(*) as count
           FROM %s
           INNER JOIN %s ON %s = %s
           INNER JOIN %s ON %s = %s
           WHERE %s = %s
           GROUP BY query
           ORDER BY count DESC';
     $query = sprintf($query, QueryPeer::QUERY, QueryPeer::TABLE_NAME, ReportQueryPeer::TABLE_NAME, QueryPeer::ID, ReportQueryPeer::QUERY_ID, ReportPeer::TABLE_NAME, ReportQueryPeer::REPORT_ID, ReportPeer::ID, ReportPeer::PUBLIC_RECORD, true);
     $statement = $connection->prepareStatement($query);
     $statement->setLimit($max);
     $resultset = $statement->executeQuery();
     $tags = array();
     $max_count = 0;
     while ($resultset->next()) {
         if (!$max_count) {
             $max_count = $resultset->getInt('count');
         }
         $queries[] = array('query' => $resultset->getString('query'), 'rank' => floor($resultset->getInt('count') / $max_count * 9 + 1), 'count' => $resultset->getInt('count'));
     }
     ksort($queries);
     return $queries;
 }

 /**
  * The doBuild() method builds the DatabaseMap
  *
  * @return     void
  * @throws     PropelException
  */
 public function doBuild()
 {
     $this->dbMap = Propel::getDatabaseMap('workflow');
     $tMap = $this->dbMap->addTable('APP_DELEGATION');
     $tMap->setPhpName('AppDelegation');
     $tMap->setUseIdGenerator(false);
     $tMap->addPrimaryKey('APP_UID', 'AppUid', 'string', CreoleTypes::VARCHAR, true, 32);
     $tMap->addPrimaryKey('DEL_INDEX', 'DelIndex', 'int', CreoleTypes::INTEGER, true, null);
     $tMap->addColumn('DEL_PREVIOUS', 'DelPrevious', 'int', CreoleTypes::INTEGER, true, null);
     $tMap->addColumn('DEL_LAST_INDEX', 'DelLastIndex', 'int', CreoleTypes::INTEGER, true, null);
     $tMap->addColumn('PRO_UID', 'ProUid', 'string', CreoleTypes::VARCHAR, true, 32);
     $tMap->addColumn('TAS_UID', 'TasUid', 'string', CreoleTypes::VARCHAR, true, 32);
     $tMap->addColumn('USR_UID', 'UsrUid', 'string', CreoleTypes::VARCHAR, true, 32);
     $tMap->addColumn('DEL_TYPE', 'DelType', 'string', CreoleTypes::VARCHAR, true, 32);
     $tMap->addColumn('DEL_THREAD', 'DelThread', 'int', CreoleTypes::INTEGER, true, null);
     $tMap->addColumn('DEL_THREAD_STATUS', 'DelThreadStatus', 'string', CreoleTypes::VARCHAR, true, 32);
     $tMap->addColumn('DEL_PRIORITY', 'DelPriority', 'string', CreoleTypes::VARCHAR, true, 32);
     $tMap->addColumn('DEL_DELEGATE_DATE', 'DelDelegateDate', 'int', CreoleTypes::TIMESTAMP, true, null);
     $tMap->addColumn('DEL_INIT_DATE', 'DelInitDate', 'int', CreoleTypes::TIMESTAMP, false, null);
     $tMap->addColumn('DEL_TASK_DUE_DATE', 'DelTaskDueDate', 'int', CreoleTypes::TIMESTAMP, false, null);
     $tMap->addColumn('DEL_FINISH_DATE', 'DelFinishDate', 'int', CreoleTypes::TIMESTAMP, false, null);
     $tMap->addColumn('DEL_DURATION', 'DelDuration', 'double', CreoleTypes::DOUBLE, false, null);
     $tMap->addColumn('DEL_QUEUE_DURATION', 'DelQueueDuration', 'double', CreoleTypes::DOUBLE, false, null);
     $tMap->addColumn('DEL_DELAY_DURATION', 'DelDelayDuration', 'double', CreoleTypes::DOUBLE, false, null);
     $tMap->addColumn('DEL_STARTED', 'DelStarted', 'int', CreoleTypes::TINYINT, false, null);
     $tMap->addColumn('DEL_FINISHED', 'DelFinished', 'int', CreoleTypes::TINYINT, false, null);
     $tMap->addColumn('DEL_DELAYED', 'DelDelayed', 'int', CreoleTypes::TINYINT, false, null);
     $tMap->addColumn('DEL_DATA', 'DelData', 'string', CreoleTypes::LONGVARCHAR, true, null);
     $tMap->addColumn('APP_OVERDUE_PERCENTAGE', 'AppOverduePercentage', 'double', CreoleTypes::DOUBLE, true, null);
     $tMap->addValidator('DEL_TYPE', 'validValues', 'propel.validator.ValidValuesValidator', 'NORMAL|PARALLEL', 'Please select a valid status.');
     $tMap->addValidator('DEL_PRIORITY', 'validValues', 'propel.validator.ValidValuesValidator', '1|2|3|4|5', 'Please select a valid Priority.');
     $tMap->addValidator('DEL_THREAD_STATUS', 'validValues', 'propel.validator.ValidValuesValidator', 'CLOSED|OPEN|PAUSED', 'Please select a valid status.');
 }

 /**
  * The doBuild() method builds the DatabaseMap
  *
  * @return     void
  * @throws     PropelException
  */
 public function doBuild()
 {
     $this->dbMap = Propel::getDatabaseMap(AfaOrgPeer::DATABASE_NAME);
     $tMap = $this->dbMap->addTable(AfaOrgPeer::TABLE_NAME);
     $tMap->setPhpName('AfaOrg');
     $tMap->setClassname('AfaOrg');
     $tMap->setUseIdGenerator(true);
     $tMap->addPrimaryKey('ID', 'Id', 'INTEGER', true, 11);
     $tMap->addColumn('NAME', 'Name', 'VARCHAR', true, 60);
     $tMap->addColumn('ORG_PHONE', 'OrgPhone', 'VARCHAR', false, 16);
     $tMap->addColumn('HOME_PAGE_URL', 'HomePageUrl', 'VARCHAR', false, 80);
     $tMap->addColumn('ORG_FAX', 'OrgFax', 'VARCHAR', false, 16);
     $tMap->addColumn('REF_CONTACT_NAME', 'RefContactName', 'VARCHAR', false, 25);
     $tMap->addColumn('REF_CONTACT_EMAIL', 'RefContactEmail', 'VARCHAR', false, 80);
     $tMap->addColumn('VPO_SOAP_SERVER_URL', 'VpoSoapServerUrl', 'VARCHAR', false, 125);
     $tMap->addColumn('VPO_REQUEST_POST_EMAIL', 'VpoRequestPostEmail', 'VARCHAR', false, 125);
     $tMap->addColumn('VPO_USER_ID', 'VpoUserId', 'VARCHAR', false, 25);
     $tMap->addColumn('VPO_USER_PASSWORD', 'VpoUserPassword', 'VARCHAR', false, 25);
     $tMap->addColumn('VPO_ORG_ID', 'VpoOrgId', 'VARCHAR', false, 5);
     $tMap->addColumn('AFIDS_REQUESTER_USER_NAME', 'AfidsRequesterUserName', 'VARCHAR', false, 25);
     $tMap->addColumn('AFIDS_REQUESTER_PASSWORD', 'AfidsRequesterPassword', 'VARCHAR', false, 25);
     $tMap->addColumn('AFIDS_SOAP_SERVER_URL', 'AfidsSoapServerUrl', 'VARCHAR', false, 125);
     $tMap->addColumn('AFIDS_REQUEST_POST_EMAIL', 'AfidsRequestPostEmail', 'VARCHAR', false, 125);
     $tMap->addColumn('PHONE_NUMBER1', 'PhoneNumber1', 'VARCHAR', false, 16);
     $tMap->addColumn('PHONE_NUMBER2', 'PhoneNumber2', 'VARCHAR', false, 16);
 }

 public function executeSidebar(sfWebRequest $request)
 {
     $route = sfContext::getInstance()->getRouting()->getCurrentRouteName();
     $this->route = $route;
     $id = $request->getParameter('catalogId');
     $stm = Propel::getConnection()->prepare('
         SELECT title,id FROM category WHERE parent_id=4
     ');
     $stm->execute();
     $menu = $stm->fetchAll(PDO::FETCH_OBJ);
     $this->menu = $menu;
     $stm = Propel::getConnection()->prepare('
         SELECT
             title,id
         FROM
             category_has_product
         INNER JOIN product ON product.id = category_has_product.product_id
         WHERE
             category_has_product.category_id = :id
     ');
     $stm->bindParam(':id', $id);
     $stm->execute();
     $product = $stm->fetchAll(PDO::FETCH_OBJ);
     $this->product = $product;
 }

 public function testInvalidCharset()
 {
     $this->markTestSkipped();
     $db = Propel::getDB(BookPeer::DATABASE_NAME);
     if ($db instanceof DBSQLite) {
         $this->markTestSkipped();
     }
     $a = new Author();
     $a->setFirstName("Б.");
     $a->setLastName("АКУНИН");
     $a->save();
     $authorNameWindows1251 = iconv("utf-8", "windows-1251", $a->getLastName());
     $a->setLastName($authorNameWindows1251);
     // Different databases seem to handle invalid data differently (no surprise, I guess...)
     if ($db instanceof DBPostgres) {
         try {
             $a->save();
             $this->fail("Expected an exception when saving non-UTF8 data to database.");
         } catch (Exception $x) {
             print $x;
         }
     } else {
         // No exception is thrown by MySQL ... (others need to be tested still)
         $a->save();
         $a->reload();
         $this->assertEquals("", $a->getLastName(), "Expected last_name to be empty (after inserting invalid charset data)");
     }
 }

 /**
  * Inserts the menu links related to the inserted content,
  * into the w3sMenuElements table
  *   
  * @return bool
  * 
  */
 protected function setDefaultRelatedElements()
 {
     $bRollBack = false;
     $con = Propel::getConnection();
     $con = w3sPropelWorkaround::beginTransaction($con);
     for ($i = 1; $i < 4; $i++) {
         $newMenu = new W3sMenuElement();
         $contentValues = array("ContentId" => $this->content->getId(), "PageId" => 0, "Link" => w3sCommonFunctions::toI18n('This is a link'), "ExternalLink" => '', "Image" => '', "RolloverImage" => '', "Position" => $i);
         $newMenu->fromArray($contentValues);
         $result = $newMenu->save();
         if ($newMenu->isModified() && $result == 0) {
             $bRollBack = true;
             break;
         }
     }
     if (!$bRollBack) {
         // Everything was fine so W3StudioCMS commits to database
         $con->commit();
         $result = true;
     } else {
         // Something was wrong so W3StudioCMS aborts the operation and restores to previous status
         w3sPropelWorkaround::rollBack($con);
         $result = false;
     }
 }

 /**
  * The doBuild() method builds the DatabaseMap
  *
  * @return     void
  * @throws     PropelException
  */
 public function doBuild()
 {
     $this->dbMap = Propel::getDatabaseMap(MissionReportPeer::DATABASE_NAME);
     $tMap = $this->dbMap->addTable(MissionReportPeer::TABLE_NAME);
     $tMap->setPhpName('MissionReport');
     $tMap->setClassname('MissionReport');
     $tMap->setUseIdGenerator(true);
     $tMap->addPrimaryKey('ID', 'Id', 'INTEGER', true, 4);
     $tMap->addColumn('REPORT_DATE', 'ReportDate', 'TIMESTAMP', false, null);
     $tMap->addColumn('MISSION_DATE', 'MissionDate', 'TIMESTAMP', false, null);
     $tMap->addColumn('COPILOT_NAME', 'CopilotName', 'VARCHAR', false, 50);
     $tMap->addColumn('MEMBER_COPILOT', 'MemberCopilot', 'TINYINT', false, 1);
     $tMap->addForeignKey('AIRCRAFT_ID', 'AircraftId', 'INTEGER', 'aircraft', 'ID', false, 4);
     $tMap->addColumn('N_NUMBER', 'NNumber', 'VARCHAR', false, 8);
     $tMap->addColumn('MAKEMODEL', 'Makemodel', 'VARCHAR', false, 60);
     $tMap->addColumn('HOBBS_TIME', 'HobbsTime', 'TIME', false, null);
     $tMap->addColumn('PASSENGER_NAMES', 'PassengerNames', 'VARCHAR', false, 255);
     $tMap->addColumn('MISSION_COMMENTS', 'MissionComments', 'LONGVARCHAR', false, null);
     $tMap->addColumn('EXPENSE_REPORT', 'ExpenseReport', 'LONGVARCHAR', false, null);
     $tMap->addColumn('APPROVED', 'Approved', 'TINYINT', false, 1);
     $tMap->addColumn('PICKUP_AIRPORT_IDENT', 'PickupAirportIdent', 'VARCHAR', false, 25);
     $tMap->addColumn('DROPOFF_AIRPORT_IDENT', 'DropoffAirportIdent', 'VARCHAR', false, 25);
     $tMap->addColumn('ROUTING', 'Routing', 'VARCHAR', false, 40);
     $tMap->addColumn('COMMERCIAL_TICKET_COST', 'CommercialTicketCost', 'INTEGER', false, 8);
     $tMap->addColumn('AIRLINE_REF_NUMBER', 'AirlineRefNumber', 'VARCHAR', false, 40);
     $tMap->addColumn('AIRLINE_OWRT', 'AirlineOwrt', 'VARCHAR', false, 2);
     $tMap->addColumn('MILEAGE', 'Mileage', 'INTEGER', false, 4);
     $tMap->addColumn('PHOTO1', 'Photo1', 'VARCHAR', false, 255);
     $tMap->addColumn('PHOTO2', 'Photo2', 'VARCHAR', false, 255);
     $tMap->addColumn('PHOTO3', 'Photo3', 'VARCHAR', false, 255);
     $tMap->addColumn('PHOTO4', 'Photo4', 'VARCHAR', false, 255);
     $tMap->addColumn('PHOTO5', 'Photo5', 'VARCHAR', false, 255);
 }

 public function testExplainPlanFromString()
 {
     BookstoreDataPopulator::depopulate($this->con);
     BookstoreDataPopulator::populate($this->con);
     $db = Propel::getDb(BookPeer::DATABASE_NAME);
     $query = 'SELECT book.TITLE AS Title FROM book INNER JOIN author ON (book.AUTHOR_ID=author.ID) WHERE author.FIRST_NAME = \'Neal\'';
     $stmt = $db->doExplainPlan($this->con, $query);
     $explain = $stmt->fetchAll(PDO::FETCH_ASSOC);
     if ($db instanceof DBMySQL) {
         $this->assertEquals(sizeof($explain), 2, 'Explain plan return two lines');
         // explain can change sometime, test can't be strict
         $this->assertArrayHasKey('select_type', $explain[0], 'Line 1, select_type key exist');
         $this->assertArrayHasKey('table', $explain[0], 'Line 1, table key exist');
         $this->assertArrayHasKey('type', $explain[0], 'Line 1, type key exist');
         $this->assertArrayHasKey('possible_keys', $explain[0], 'Line 1, possible_keys key exist');
         $this->assertArrayHasKey('select_type', $explain[1], 'Line 2, select_type key exist');
         $this->assertArrayHasKey('table', $explain[1], 'Line 2, table key exist');
         $this->assertArrayHasKey('type', $explain[1], 'Line 2, type key exist');
         $this->assertArrayHasKey('possible_keys', $explain[1], 'Line 2, possible_keys key exist');
     } elseif ($db instanceof DBOracle) {
         $this->assertTrue(sizeof($explain) > 2, 'Explain plan return more than 2 lines');
     } else {
         $this->markTestSkipped('Cannot test explain plan on adapter ' . get_class($db));
     }
 }

 /**
  * Copies the menu links for the sourceContent to the targetContent
  *  
  * @parameter  int The id of the source content
  * @parameter  int The id of the target content
  * 
  * @return     bool false - The save operation has failed
  *                  true  - The save operation has correctly done 
  */
 public static function copyRelatedElements($sourceContent, $targetContent)
 {
     $bRollBack = false;
     $con = Propel::getConnection();
     $con = w3sPropelWorkaround::beginTransaction($con);
     // Deletes all the target menus
     $targetMenus = W3sMenuElementPeer::getContentMenu($targetContent);
     foreach ($targetMenus as $targetMenu) {
         $targetMenu->delete();
     }
     // Retrieves the menu rows related to source content
     $sourceMenus = DbFinder::from('W3sMenuElement')->where('contentId', $sourceContent)->orderBy('position')->find();
     foreach ($sourceMenus as $sourceMenu) {
         $oTargetMenu = new W3sMenuElement();
         $contentValues = array("ContentId" => $targetContent, "PageId" => $sourceMenu->getPageId(), "Link" => $sourceMenu->getLink(), "ExternalLink" => $sourceMenu->getExternalLink(), "Image" => $sourceMenu->getImage(), "RolloverImage" => $sourceMenu->getRolloverImage(), "Position" => $sourceMenu->getPosition());
         $oTargetMenu->fromArray($contentValues);
         // Saves
         $result = $oTargetMenu->save();
         if ($oTargetMenu->isModified() && $result == 0) {
             $bRollBack = true;
             break;
         }
     }
     if (!$bRollBack) {
         // Everything was fine so W3StudioCMS commits to database
         $con->commit();
         $result = true;
     } else {
         // Something was wrong so W3StudioCMS aborts the operation and restores to previous status
         w3sPropelWorkaround::rollBack($con);
         $result = false;
     }
     return $result;
 }

 public function doBuild()
 {
     $this->dbMap = Propel::getDatabaseMap('propel');
     $tMap = $this->dbMap->addTable('student');
     $tMap->setPhpName('Student');
     $tMap->setUseIdGenerator(true);
     $tMap->addPrimaryKey('ID', 'Id', 'int', CreoleTypes::INTEGER, true, null);
     $tMap->addColumn('CODE', 'Code', 'string', CreoleTypes::VARCHAR, false, 64);
     $tMap->addColumn('CODE2', 'Code2', 'string', CreoleTypes::VARCHAR, false, 64);
     $tMap->addColumn('CODE3', 'Code3', 'string', CreoleTypes::VARCHAR, false, 64);
     $tMap->addColumn('NAME', 'Name', 'string', CreoleTypes::VARCHAR, false, 255);
     $tMap->addForeignKey('CURRICULUM_ID', 'CurriculumId', 'int', CreoleTypes::INTEGER, 'curriculum', 'ID', false, null);
     $tMap->addForeignKey('ACADEMIC_CALENDAR_ID', 'AcademicCalendarId', 'int', CreoleTypes::INTEGER, 'academic_calendar', 'ID', false, null);
     $tMap->addForeignKey('CLASS_GROUP_ID', 'ClassGroupId', 'int', CreoleTypes::INTEGER, 'class_group', 'ID', false, null);
     $tMap->addForeignKey('TEST_APPLICANT_ID', 'TestApplicantId', 'int', CreoleTypes::INTEGER, 'test_applicant', 'ID', false, null);
     $tMap->addForeignKey('STUDENT_DETAIL_ID', 'StudentDetailId', 'int', CreoleTypes::INTEGER, 'student_detail', 'ID', false, null);
     $tMap->addForeignKey('MEMBER_ID', 'MemberId', 'int', CreoleTypes::INTEGER, 'member', 'ID', false, null);
     $tMap->addColumn('STATUS', 'Status', 'string', CreoleTypes::CHAR, false, null);
     $tMap->addColumn('GRADUATION_DATE', 'GraduationDate', 'int', CreoleTypes::DATE, false, null);
     $tMap->addColumn('PASSWORD', 'Password', 'string', CreoleTypes::VARCHAR, true, 40);
     $tMap->addColumn('CLASS_NAME', 'ClassName', 'string', CreoleTypes::VARCHAR, false, 2);
     $tMap->addColumn('YEAR', 'Year', 'string', CreoleTypes::VARCHAR, false, 4);
     $tMap->addColumn('DATE_IN', 'DateIn', 'int', CreoleTypes::DATE, false, null);
     $tMap->addColumn('NIK', 'Nik', 'string', CreoleTypes::VARCHAR, false, 64);
 }

 /**
  * The doBuild() method builds the DatabaseMap
  *
  * @return     void
  * @throws     PropelException
  */
 public function doBuild()
 {
     $this->dbMap = Propel::getDatabaseMap(UserProfilePeer::DATABASE_NAME);
     $tMap = $this->dbMap->addTable(UserProfilePeer::TABLE_NAME);
     $tMap->setPhpName('UserProfile');
     $tMap->setClassname('UserProfile');
     $tMap->setUseIdGenerator(true);
     $tMap->addPrimaryKey('ID', 'Id', 'INTEGER', true, null);
     $tMap->addForeignKey('USER_ID', 'UserId', 'INTEGER', 'sf_guard_user', 'ID', true, null);
     $tMap->addColumn('LANGUAGE', 'Language', 'VARCHAR', false, 5);
     $tMap->addColumn('NOMBRE', 'Nombre', 'VARCHAR', false, 255);
     $tMap->addColumn('APELLIDO', 'Apellido', 'VARCHAR', false, 255);
     $tMap->addColumn('FDN', 'Fdn', 'DATE', false, null);
     $tMap->addForeignKey('NACIONALIDAD', 'Nacionalidad', 'INTEGER', 'geo_pais', 'ID', false, null);
     $tMap->addColumn('DOCUMENTO_TIPO', 'DocumentoTipo', 'TINYINT', false, null);
     $tMap->addColumn('DOCUMENTO_NUMERO', 'DocumentoNumero', 'VARCHAR', false, 15);
     $tMap->addColumn('CUIL', 'Cuil', 'VARCHAR', false, 13);
     $tMap->addColumn('LEGAJO', 'Legajo', 'VARCHAR', false, 5);
     $tMap->addColumn('TELEFONO', 'Telefono', 'VARCHAR', false, 255);
     $tMap->addColumn('MOVIL', 'Movil', 'VARCHAR', false, 255);
     $tMap->addColumn('EMAIL', 'Email', 'VARCHAR', false, 255);
     $tMap->addColumn('DOMICILIO_CALLE', 'DomicilioCalle', 'VARCHAR', false, 50);
     $tMap->addColumn('DOMICILIO_NUMERO', 'DomicilioNumero', 'VARCHAR', false, 5);
     $tMap->addColumn('DOMICILIO_MANZANA', 'DomicilioManzana', 'VARCHAR', false, 5);
     $tMap->addColumn('DOMICILIO_BARRIO', 'DomicilioBarrio', 'VARCHAR', false, 50);
     $tMap->addColumn('DOMICILIO_PISO', 'DomicilioPiso', 'VARCHAR', false, 2);
     $tMap->addColumn('DOMICILIO_DEPTO', 'DomicilioDepto', 'VARCHAR', false, 2);
     $tMap->addForeignKey('LOCALIDAD_ID', 'LocalidadId', 'INTEGER', 'geo_localidad', 'ID', false, null);
     $tMap->addForeignKey('PROVINCIA_ID', 'ProvinciaId', 'INTEGER', 'geo_provincia', 'ID', false, null);
     $tMap->addColumn('COMENTARIO', 'Comentario', 'LONGVARCHAR', false, null);
 }

 public static function abortDbBatchJob(BatchJob $dbBatchJob, $force = false)
 {
     // No need to abort finished job
     if (in_array($dbBatchJob->getStatus(), BatchJobPeer::getClosedStatusList())) {
         if ($force) {
             $dbBatchJob->setExecutionStatus(BatchJobExecutionStatus::ABORTED);
             $dbBatchJob->save();
         }
         return $dbBatchJob;
     }
     $lockObject = $dbBatchJob->getBatchJobLock();
     if (is_null($lockObject)) {
         KalturaLog::err("Batch job [" . $dbBatchJob->getId() . "] doesn't have a lock object and can't be deleted. Status (" . $dbBatchJob->getStatus() . ")");
         return $dbBatchJob;
     }
     // Update status
     $con = Propel::getConnection();
     $update = new Criteria();
     $update->add(BatchJobLockPeer::STATUS, BatchJob::BATCHJOB_STATUS_ABORTED);
     $update->add(BatchJobLockPeer::VERSION, $lockObject->getVersion() + 1);
     $updateCondition = new Criteria();
     $updateCondition->add(BatchJobLockPeer::ID, $lockObject->getId(), Criteria::EQUAL);
     $updateCondition->add(BatchJobLockPeer::VERSION, $lockObject->getVersion(), Criteria::EQUAL);
     $updateCondition->add(BatchJobLockPeer::SCHEDULER_ID, null, Criteria::ISNULL);
     $affectedRows = BasePeer::doUpdate($updateCondition, $update, $con);
     if ($affectedRows) {
         $dbBatchJob->setExecutionStatus(BatchJobExecutionStatus::ABORTED);
         $dbBatchJob = self::updateBatchJob($dbBatchJob, BatchJob::BATCHJOB_STATUS_ABORTED);
     } else {
         $dbBatchJob->setExecutionStatus(BatchJobExecutionStatus::ABORTED);
         $dbBatchJob->save();
     }
     self::abortChildJobs($dbBatchJob);
     return $dbBatchJob;
 }

 /**
  * The doBuild() method builds the DatabaseMap
  *
  * @return     void
  * @throws     PropelException
  */
 public function doBuild()
 {
     $this->dbMap = Propel::getDatabaseMap(ParametroPeer::DATABASE_NAME);
     $tMap = $this->dbMap->addTable(ParametroPeer::TABLE_NAME);
     $tMap->setPhpName('Parametro');
     $tMap->setClassname('Parametro');
     $tMap->setUseIdGenerator(true);
     $tMap->addPrimaryKey('ID_PARAMETRO', 'IdParametro', 'INTEGER', true, null);
     $tMap->addForeignKey('TIPOPARAMETRO', 'Tipoparametro', 'VARCHAR', 'parametro_def', 'TIPOPARAMETRO', true, 100);
     $tMap->addColumn('NOMBRE', 'Nombre', 'VARCHAR', false, 100);
     $tMap->addColumn('ORDEN', 'Orden', 'INTEGER', false, null);
     $tMap->addColumn('NUMERO', 'Numero', 'FLOAT', false, null);
     $tMap->addColumn('NUMERO2', 'Numero2', 'FLOAT', false, null);
     $tMap->addColumn('CADENA', 'Cadena', 'LONGVARCHAR', false, null);
     $tMap->addColumn('CADENA1', 'Cadena1', 'LONGVARCHAR', false, null);
     $tMap->addColumn('OTROOBJETO', 'Otroobjeto', 'INTEGER', false, null);
     $tMap->addColumn('SI_NO', 'SiNo', 'BOOLEAN', false, null);
     $tMap->addColumn('FECHA', 'Fecha', 'TIMESTAMP', false, null);
     $tMap->addColumn('CREATED_AT', 'CreatedAt', 'TIMESTAMP', false, null);
     $tMap->addColumn('UPDATED_AT', 'UpdatedAt', 'TIMESTAMP', false, null);
     $tMap->addColumn('FECHABORRADO', 'Fechaborrado', 'TIMESTAMP', false, null);
     $tMap->addColumn('NOMBREFICHERO', 'Nombrefichero', 'VARCHAR', false, 200);
     $tMap->addColumn('TIPO', 'Tipo', 'VARCHAR', false, 100);
     $tMap->addColumn('FICHERO', 'Fichero', 'LONGVARCHAR', false, null);
     $tMap->addColumn('TAMANO', 'Tamano', 'INTEGER', false, null);
 }