public function queryAndFetchAll($sql, $fetchStyle, $columnIndex = 0, $filter = null)
{
$finalSql = str_replace(kApiCache::KALTURA_COMMENT_MARKER, $this->getComment(), $sql);
KalturaLog::debug($finalSql);
$sqlStart = microtime(true);
$stmt = parent::query($finalSql);
$sqlTook = microtime(true) - $sqlStart;
KalturaLog::debug("Sql took - " . $sqlTook . " seconds");
KalturaMonitorClient::monitorDatabaseAccess($sql, $sqlTook, $this->hostName);
if (!$stmt) {
return false;
}
if ($fetchStyle == PDO::FETCH_COLUMN) {
$result = $stmt->fetchAll($fetchStyle, $columnIndex);
} else {
$result = $stmt->fetchAll($fetchStyle);
}
if (is_null($result)) {
return false;
}
if (!$result) {
$result = array();
}
$filteredResult = kApiCache::filterQueryResult($result, $filter);
kApiCache::addSqlQueryCondition($this->configKey, $sql, $fetchStyle, $columnIndex, $filter, $filteredResult);
return $filteredResult;
}
/**
* Insert the row in the database.
*
* @param PropelPDO $con
*
* @throws PropelException
* @see doSave()
*/
protected function doInsert(PropelPDO $con)
{
$modifiedColumns = array();
$index = 0;
$this->modifiedColumns[] = Buses201101Peer::ID;
if (null !== $this->id) {
throw new PropelException('Cannot insert a value for auto-increment primary key (' . Buses201101Peer::ID . ')');
}
if (null === $this->id) {
try {
$stmt = $con->query("SELECT nextval('buses_2011_01_id_seq')");
$row = $stmt->fetch(PDO::FETCH_NUM);
$this->id = $row[0];
} catch (Exception $e) {
throw new PropelException('Unable to get sequence id.', $e);
}
}
// check the columns in natural order for more readable SQL queries
if ($this->isColumnModified(Buses201101Peer::ID)) {
$modifiedColumns[':p' . $index++] = 'ID';
}
if ($this->isColumnModified(Buses201101Peer::STATIONID)) {
$modifiedColumns[':p' . $index++] = 'STATIONID';
}
if ($this->isColumnModified(Buses201101Peer::CARTYPE)) {
$modifiedColumns[':p' . $index++] = 'CARTYPE';
}
if ($this->isColumnModified(Buses201101Peer::BUSID)) {
$modifiedColumns[':p' . $index++] = 'BUSID';
}
if ($this->isColumnModified(Buses201101Peer::PROVIDERID)) {
$modifiedColumns[':p' . $index++] = 'PROVIDERID';
}
if ($this->isColumnModified(Buses201101Peer::CARID)) {
$modifiedColumns[':p' . $index++] = 'CARID';
}
if ($this->isColumnModified(Buses201101Peer::DUTYSTATUS)) {
$modifiedColumns[':p' . $index++] = 'DUTYSTATUS';
}
if ($this->isColumnModified(Buses201101Peer::BUSSTATUS)) {
$modifiedColumns[':p' . $index++] = 'BUSSTATUS';
}
if ($this->isColumnModified(Buses201101Peer::ROUTEID)) {
$modifiedColumns[':p' . $index++] = 'ROUTEID';
}
if ($this->isColumnModified(Buses201101Peer::GOBACK)) {
$modifiedColumns[':p' . $index++] = 'GOBACK';
}
if ($this->isColumnModified(Buses201101Peer::LONGITUDE)) {
$modifiedColumns[':p' . $index++] = 'LONGITUDE';
}
if ($this->isColumnModified(Buses201101Peer::LATITUDE)) {
$modifiedColumns[':p' . $index++] = 'LATITUDE';
}
if ($this->isColumnModified(Buses201101Peer::SPEED)) {
$modifiedColumns[':p' . $index++] = 'SPEED';
}
if ($this->isColumnModified(Buses201101Peer::AZIMUTH)) {
$modifiedColumns[':p' . $index++] = 'AZIMUTH';
}
if ($this->isColumnModified(Buses201101Peer::DATATIME)) {
$modifiedColumns[':p' . $index++] = 'DATATIME';
}
$sql = sprintf('INSERT INTO buses_2011_01 (%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 'STATIONID':
$stmt->bindValue($identifier, $this->stationid, PDO::PARAM_INT);
break;
case 'CARTYPE':
$stmt->bindValue($identifier, $this->cartype, PDO::PARAM_INT);
break;
case 'BUSID':
$stmt->bindValue($identifier, $this->busid, PDO::PARAM_STR);
break;
case 'PROVIDERID':
$stmt->bindValue($identifier, $this->providerid, PDO::PARAM_INT);
break;
case 'CARID':
$stmt->bindValue($identifier, $this->carid, PDO::PARAM_INT);
break;
case 'DUTYSTATUS':
$stmt->bindValue($identifier, $this->dutystatus, PDO::PARAM_INT);
break;
case 'BUSSTATUS':
$stmt->bindValue($identifier, $this->busstatus, PDO::PARAM_INT);
break;
case 'ROUTEID':
$stmt->bindValue($identifier, $this->routeid, PDO::PARAM_INT);
break;
case 'GOBACK':
$stmt->bindValue($identifier, $this->goback, PDO::PARAM_INT);
break;
case 'LONGITUDE':
$stmt->bindValue($identifier, $this->longitude, PDO::PARAM_STR);
break;
case 'LATITUDE':
$stmt->bindValue($identifier, $this->latitude, PDO::PARAM_STR);
break;
case 'SPEED':
$stmt->bindValue($identifier, $this->speed, PDO::PARAM_STR);
break;
case 'AZIMUTH':
$stmt->bindValue($identifier, $this->azimuth, PDO::PARAM_STR);
break;
case 'DATATIME':
$stmt->bindValue($identifier, $this->datatime, 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);
}
/**
* Insert the row in the database.
*
* @param PropelPDO $con
*
* @throws PropelException
* @see doSave()
*/
protected function doInsert(PropelPDO $con)
{
$modifiedColumns = array();
$index = 0;
$this->modifiedColumns[] = JQStoreManagedJobPeer::JOB_ID;
if (null !== $this->job_id) {
throw new PropelException('Cannot insert a value for auto-increment primary key (' . JQStoreManagedJobPeer::JOB_ID . ')');
}
if (null === $this->job_id) {
try {
$stmt = $con->query("SELECT nextval('jqstore_managed_job_job_id_seq')");
$row = $stmt->fetch(PDO::FETCH_NUM);
$this->job_id = $row[0];
} catch (Exception $e) {
throw new PropelException('Unable to get sequence id.', $e);
}
}
// check the columns in natural order for more readable SQL queries
if ($this->isColumnModified(JQStoreManagedJobPeer::ATTEMPT_NUMBER)) {
$modifiedColumns[':p' . $index++] = 'ATTEMPT_NUMBER';
}
if ($this->isColumnModified(JQStoreManagedJobPeer::COALESCE_ID)) {
$modifiedColumns[':p' . $index++] = 'COALESCE_ID';
}
if ($this->isColumnModified(JQStoreManagedJobPeer::CREATION_DTS)) {
$modifiedColumns[':p' . $index++] = 'CREATION_DTS';
}
if ($this->isColumnModified(JQStoreManagedJobPeer::END_DTS)) {
$modifiedColumns[':p' . $index++] = 'END_DTS';
}
if ($this->isColumnModified(JQStoreManagedJobPeer::ERROR_MESSAGE)) {
$modifiedColumns[':p' . $index++] = 'ERROR_MESSAGE';
}
if ($this->isColumnModified(JQStoreManagedJobPeer::JOB)) {
$modifiedColumns[':p' . $index++] = 'JOB';
}
if ($this->isColumnModified(JQStoreManagedJobPeer::JOB_ID)) {
$modifiedColumns[':p' . $index++] = 'JOB_ID';
}
if ($this->isColumnModified(JQStoreManagedJobPeer::MAX_ATTEMPTS)) {
$modifiedColumns[':p' . $index++] = 'MAX_ATTEMPTS';
}
if ($this->isColumnModified(JQStoreManagedJobPeer::MAX_RUNTIME_SECONDS)) {
$modifiedColumns[':p' . $index++] = 'MAX_RUNTIME_SECONDS';
}
if ($this->isColumnModified(JQStoreManagedJobPeer::PRIORITY)) {
$modifiedColumns[':p' . $index++] = 'PRIORITY';
}
if ($this->isColumnModified(JQStoreManagedJobPeer::QUEUE_NAME)) {
$modifiedColumns[':p' . $index++] = 'QUEUE_NAME';
}
if ($this->isColumnModified(JQStoreManagedJobPeer::START_DTS)) {
$modifiedColumns[':p' . $index++] = 'START_DTS';
}
if ($this->isColumnModified(JQStoreManagedJobPeer::STATUS)) {
$modifiedColumns[':p' . $index++] = 'STATUS';
}
$sql = sprintf('INSERT INTO jqstore_managed_job (%s) VALUES (%s)', implode(', ', $modifiedColumns), implode(', ', array_keys($modifiedColumns)));
try {
$stmt = $con->prepare($sql);
foreach ($modifiedColumns as $identifier => $columnName) {
switch ($columnName) {
case 'ATTEMPT_NUMBER':
$stmt->bindValue($identifier, $this->attempt_number, PDO::PARAM_INT);
break;
case 'COALESCE_ID':
$stmt->bindValue($identifier, $this->coalesce_id, PDO::PARAM_STR);
break;
case 'CREATION_DTS':
$stmt->bindValue($identifier, $this->creation_dts, PDO::PARAM_STR);
break;
case 'END_DTS':
$stmt->bindValue($identifier, $this->end_dts, PDO::PARAM_STR);
break;
case 'ERROR_MESSAGE':
$stmt->bindValue($identifier, $this->error_message, PDO::PARAM_STR);
break;
case 'JOB':
$stmt->bindValue($identifier, $this->job, PDO::PARAM_STR);
break;
case 'JOB_ID':
$stmt->bindValue($identifier, $this->job_id, PDO::PARAM_INT);
break;
case 'MAX_ATTEMPTS':
$stmt->bindValue($identifier, $this->max_attempts, PDO::PARAM_INT);
break;
case 'MAX_RUNTIME_SECONDS':
$stmt->bindValue($identifier, $this->max_runtime_seconds, PDO::PARAM_INT);
break;
case 'PRIORITY':
$stmt->bindValue($identifier, $this->priority, PDO::PARAM_INT);
break;
case 'QUEUE_NAME':
$stmt->bindValue($identifier, $this->queue_name, PDO::PARAM_STR);
break;
case 'START_DTS':
$stmt->bindValue($identifier, $this->start_dts, PDO::PARAM_STR);
break;
case 'STATUS':
$stmt->bindValue($identifier, $this->status, PDO::PARAM_STR);
break;
}
}
$stmt->execute();
} catch (Exception $e) {
Propel::log($e->getMessage(), Propel::LOG_ERR);
throw new PropelException(sprintf('Unable to execute INSERT statement [%s]', $sql), $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[] = Stops2011Peer::ID;
if (null !== $this->id) {
throw new PropelException('Cannot insert a value for auto-increment primary key (' . Stops2011Peer::ID . ')');
}
if (null === $this->id) {
try {
$stmt = $con->query("SELECT nextval('stops_2011_id_seq')");
$row = $stmt->fetch(PDO::FETCH_NUM);
$this->id = $row[0];
} catch (Exception $e) {
throw new PropelException('Unable to get sequence id.', $e);
}
}
// check the columns in natural order for more readable SQL queries
if ($this->isColumnModified(Stops2011Peer::ID)) {
$modifiedColumns[':p' . $index++] = 'ID';
}
if ($this->isColumnModified(Stops2011Peer::STOPID)) {
$modifiedColumns[':p' . $index++] = 'STOPID';
}
if ($this->isColumnModified(Stops2011Peer::ROUTEID)) {
$modifiedColumns[':p' . $index++] = 'ROUTEID';
}
if ($this->isColumnModified(Stops2011Peer::NAMEZH)) {
$modifiedColumns[':p' . $index++] = 'NAMEZH';
}
if ($this->isColumnModified(Stops2011Peer::NAMEEN)) {
$modifiedColumns[':p' . $index++] = 'NAMEEN';
}
if ($this->isColumnModified(Stops2011Peer::SEQNO)) {
$modifiedColumns[':p' . $index++] = 'SEQNO';
}
if ($this->isColumnModified(Stops2011Peer::PGP)) {
$modifiedColumns[':p' . $index++] = 'PGP';
}
if ($this->isColumnModified(Stops2011Peer::GOBACK)) {
$modifiedColumns[':p' . $index++] = 'GOBACK';
}
if ($this->isColumnModified(Stops2011Peer::LONGITUDE)) {
$modifiedColumns[':p' . $index++] = 'LONGITUDE';
}
if ($this->isColumnModified(Stops2011Peer::LATITUDE)) {
$modifiedColumns[':p' . $index++] = 'LATITUDE';
}
if ($this->isColumnModified(Stops2011Peer::ADDRESS)) {
$modifiedColumns[':p' . $index++] = 'ADDRESS';
}
if ($this->isColumnModified(Stops2011Peer::STOPLOCATIONID)) {
$modifiedColumns[':p' . $index++] = 'STOPLOCATIONID';
}
if ($this->isColumnModified(Stops2011Peer::SHOWLON)) {
$modifiedColumns[':p' . $index++] = 'SHOWLON';
}
if ($this->isColumnModified(Stops2011Peer::SHOWLAT)) {
$modifiedColumns[':p' . $index++] = 'SHOWLAT';
}
if ($this->isColumnModified(Stops2011Peer::VECTOR)) {
$modifiedColumns[':p' . $index++] = 'VECTOR';
}
$sql = sprintf('INSERT INTO stops_2011 (%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 'STOPID':
$stmt->bindValue($identifier, $this->stopid, PDO::PARAM_INT);
break;
case 'ROUTEID':
$stmt->bindValue($identifier, $this->routeid, PDO::PARAM_INT);
break;
case 'NAMEZH':
$stmt->bindValue($identifier, $this->namezh, PDO::PARAM_STR);
break;
case 'NAMEEN':
$stmt->bindValue($identifier, $this->nameen, PDO::PARAM_STR);
break;
case 'SEQNO':
$stmt->bindValue($identifier, $this->seqno, PDO::PARAM_INT);
break;
case 'PGP':
$stmt->bindValue($identifier, $this->pgp, PDO::PARAM_INT);
break;
case 'GOBACK':
$stmt->bindValue($identifier, $this->goback, PDO::PARAM_INT);
break;
case 'LONGITUDE':
$stmt->bindValue($identifier, $this->longitude, PDO::PARAM_STR);
break;
case 'LATITUDE':
$stmt->bindValue($identifier, $this->latitude, PDO::PARAM_STR);
break;
case 'ADDRESS':
$stmt->bindValue($identifier, $this->address, PDO::PARAM_STR);
break;
case 'STOPLOCATIONID':
$stmt->bindValue($identifier, $this->stoplocationid, PDO::PARAM_INT);
break;
case 'SHOWLON':
$stmt->bindValue($identifier, $this->showlon, PDO::PARAM_STR);
break;
case 'SHOWLAT':
$stmt->bindValue($identifier, $this->showlat, PDO::PARAM_STR);
break;
case 'VECTOR':
$stmt->bindValue($identifier, $this->vector, 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[] = Routes2011Peer::ID;
if (null !== $this->id) {
throw new PropelException('Cannot insert a value for auto-increment primary key (' . Routes2011Peer::ID . ')');
}
if (null === $this->id) {
try {
$stmt = $con->query("SELECT nextval('routes_2011_id_seq')");
$row = $stmt->fetch(PDO::FETCH_NUM);
$this->id = $row[0];
} catch (Exception $e) {
throw new PropelException('Unable to get sequence id.', $e);
}
}
// check the columns in natural order for more readable SQL queries
if ($this->isColumnModified(Routes2011Peer::ID)) {
$modifiedColumns[':p' . $index++] = 'ID';
}
if ($this->isColumnModified(Routes2011Peer::ROUTEID)) {
$modifiedColumns[':p' . $index++] = 'ROUTEID';
}
if ($this->isColumnModified(Routes2011Peer::PROVIDERID)) {
$modifiedColumns[':p' . $index++] = 'PROVIDERID';
}
if ($this->isColumnModified(Routes2011Peer::PROVIDERNAME)) {
$modifiedColumns[':p' . $index++] = 'PROVIDERNAME';
}
if ($this->isColumnModified(Routes2011Peer::NAMEZH)) {
$modifiedColumns[':p' . $index++] = 'NAMEZH';
}
if ($this->isColumnModified(Routes2011Peer::NAMEEN)) {
$modifiedColumns[':p' . $index++] = 'NAMEEN';
}
if ($this->isColumnModified(Routes2011Peer::PATHATTRIBUTEID)) {
$modifiedColumns[':p' . $index++] = 'PATHATTRIBUTEID';
}
if ($this->isColumnModified(Routes2011Peer::PATHATTRIBUTENAME)) {
$modifiedColumns[':p' . $index++] = 'PATHATTRIBUTENAME';
}
if ($this->isColumnModified(Routes2011Peer::PATHATTRIBUTEENAME)) {
$modifiedColumns[':p' . $index++] = 'PATHATTRIBUTEENAME';
}
if ($this->isColumnModified(Routes2011Peer::BUILDPERIOD)) {
$modifiedColumns[':p' . $index++] = 'BUILDPERIOD';
}
if ($this->isColumnModified(Routes2011Peer::DEPARTUREZH)) {
$modifiedColumns[':p' . $index++] = 'DEPARTUREZH';
}
if ($this->isColumnModified(Routes2011Peer::DEPARTUREEN)) {
$modifiedColumns[':p' . $index++] = 'DEPARTUREEN';
}
if ($this->isColumnModified(Routes2011Peer::DESTINATIONZH)) {
$modifiedColumns[':p' . $index++] = 'DESTINATIONZH';
}
if ($this->isColumnModified(Routes2011Peer::DESTINATIONEN)) {
$modifiedColumns[':p' . $index++] = 'DESTINATIONEN';
}
if ($this->isColumnModified(Routes2011Peer::REALSEQUENCE)) {
$modifiedColumns[':p' . $index++] = 'REALSEQUENCE';
}
if ($this->isColumnModified(Routes2011Peer::DISTANCE)) {
$modifiedColumns[':p' . $index++] = 'DISTANCE';
}
if ($this->isColumnModified(Routes2011Peer::GOFIRSTBUSTIME)) {
$modifiedColumns[':p' . $index++] = 'GOFIRSTBUSTIME';
}
if ($this->isColumnModified(Routes2011Peer::BACKFIRSTBUSTIME)) {
$modifiedColumns[':p' . $index++] = 'BACKFIRSTBUSTIME';
}
if ($this->isColumnModified(Routes2011Peer::GOLASTBUSTIME)) {
$modifiedColumns[':p' . $index++] = 'GOLASTBUSTIME';
}
if ($this->isColumnModified(Routes2011Peer::BACKLASTBUSTIME)) {
$modifiedColumns[':p' . $index++] = 'BACKLASTBUSTIME';
}
if ($this->isColumnModified(Routes2011Peer::OFFPEAKHEADWAY)) {
$modifiedColumns[':p' . $index++] = 'OFFPEAKHEADWAY';
}
$sql = sprintf('INSERT INTO routes_2011 (%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 'ROUTEID':
$stmt->bindValue($identifier, $this->routeid, PDO::PARAM_INT);
break;
case 'PROVIDERID':
$stmt->bindValue($identifier, $this->providerid, PDO::PARAM_INT);
break;
case 'PROVIDERNAME':
$stmt->bindValue($identifier, $this->providername, PDO::PARAM_STR);
break;
case 'NAMEZH':
$stmt->bindValue($identifier, $this->namezh, PDO::PARAM_STR);
break;
case 'NAMEEN':
$stmt->bindValue($identifier, $this->nameen, PDO::PARAM_STR);
break;
case 'PATHATTRIBUTEID':
$stmt->bindValue($identifier, $this->pathattributeid, PDO::PARAM_INT);
break;
case 'PATHATTRIBUTENAME':
$stmt->bindValue($identifier, $this->pathattributename, PDO::PARAM_STR);
break;
case 'PATHATTRIBUTEENAME':
$stmt->bindValue($identifier, $this->pathattributeename, PDO::PARAM_STR);
break;
case 'BUILDPERIOD':
$stmt->bindValue($identifier, $this->buildperiod, PDO::PARAM_INT);
break;
case 'DEPARTUREZH':
$stmt->bindValue($identifier, $this->departurezh, PDO::PARAM_STR);
break;
case 'DEPARTUREEN':
$stmt->bindValue($identifier, $this->departureen, PDO::PARAM_STR);
break;
case 'DESTINATIONZH':
$stmt->bindValue($identifier, $this->destinationzh, PDO::PARAM_STR);
break;
case 'DESTINATIONEN':
$stmt->bindValue($identifier, $this->destinationen, PDO::PARAM_STR);
break;
case 'REALSEQUENCE':
$stmt->bindValue($identifier, $this->realsequence, PDO::PARAM_INT);
break;
case 'DISTANCE':
$stmt->bindValue($identifier, $this->distance, PDO::PARAM_INT);
break;
case 'GOFIRSTBUSTIME':
$stmt->bindValue($identifier, $this->gofirstbustime, PDO::PARAM_STR);
break;
case 'BACKFIRSTBUSTIME':
$stmt->bindValue($identifier, $this->backfirstbustime, PDO::PARAM_STR);
break;
case 'GOLASTBUSTIME':
$stmt->bindValue($identifier, $this->golastbustime, PDO::PARAM_STR);
break;
case 'BACKLASTBUSTIME':
$stmt->bindValue($identifier, $this->backlastbustime, PDO::PARAM_STR);
break;
case 'OFFPEAKHEADWAY':
$stmt->bindValue($identifier, $this->offpeakheadway, 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);
}
/**
* Insert the row in the database.
*
* @param PropelPDO $con
*
* @throws PropelException
* @see doSave()
*/
protected function doInsert(PropelPDO $con)
{
$modifiedColumns = array();
$index = 0;
$this->modifiedColumns[] = Providers2011Peer::ID;
if (null !== $this->id) {
throw new PropelException('Cannot insert a value for auto-increment primary key (' . Providers2011Peer::ID . ')');
}
if (null === $this->id) {
try {
$stmt = $con->query("SELECT nextval('providers_2011_id_seq')");
$row = $stmt->fetch(PDO::FETCH_NUM);
$this->id = $row[0];
} catch (Exception $e) {
throw new PropelException('Unable to get sequence id.', $e);
}
}
// check the columns in natural order for more readable SQL queries
if ($this->isColumnModified(Providers2011Peer::ID)) {
$modifiedColumns[':p' . $index++] = 'ID';
}
if ($this->isColumnModified(Providers2011Peer::PROVIDERID)) {
$modifiedColumns[':p' . $index++] = 'PROVIDERID';
}
if ($this->isColumnModified(Providers2011Peer::NAMEZN)) {
$modifiedColumns[':p' . $index++] = 'NAMEZN';
}
if ($this->isColumnModified(Providers2011Peer::NAMEEN)) {
$modifiedColumns[':p' . $index++] = 'NAMEEN';
}
if ($this->isColumnModified(Providers2011Peer::EMAIL)) {
$modifiedColumns[':p' . $index++] = 'EMAIL';
}
if ($this->isColumnModified(Providers2011Peer::PHONEINFO)) {
$modifiedColumns[':p' . $index++] = 'PHONEINFO';
}
if ($this->isColumnModified(Providers2011Peer::STATIONID)) {
$modifiedColumns[':p' . $index++] = 'STATIONID';
}
if ($this->isColumnModified(Providers2011Peer::STATIONNAMEZN)) {
$modifiedColumns[':p' . $index++] = 'STATIONNAMEZN';
}
if ($this->isColumnModified(Providers2011Peer::STATIONNAMEEN)) {
$modifiedColumns[':p' . $index++] = 'STATIONNAMEEN';
}
if ($this->isColumnModified(Providers2011Peer::TYPE)) {
$modifiedColumns[':p' . $index++] = 'TYPE';
}
$sql = sprintf('INSERT INTO providers_2011 (%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 'PROVIDERID':
$stmt->bindValue($identifier, $this->providerid, PDO::PARAM_INT);
break;
case 'NAMEZN':
$stmt->bindValue($identifier, $this->namezn, PDO::PARAM_STR);
break;
case 'NAMEEN':
$stmt->bindValue($identifier, $this->nameen, PDO::PARAM_STR);
break;
case 'EMAIL':
$stmt->bindValue($identifier, $this->email, PDO::PARAM_STR);
break;
case 'PHONEINFO':
$stmt->bindValue($identifier, $this->phoneinfo, PDO::PARAM_STR);
break;
case 'STATIONID':
$stmt->bindValue($identifier, $this->stationid, PDO::PARAM_INT);
break;
case 'STATIONNAMEZN':
$stmt->bindValue($identifier, $this->stationnamezn, PDO::PARAM_STR);
break;
case 'STATIONNAMEEN':
$stmt->bindValue($identifier, $this->stationnameen, PDO::PARAM_STR);
break;
case 'TYPE':
$stmt->bindValue($identifier, $this->type, 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[] = TimeEstimations2011Peer::ID;
if (null !== $this->id) {
throw new PropelException('Cannot insert a value for auto-increment primary key (' . TimeEstimations2011Peer::ID . ')');
}
if (null === $this->id) {
try {
$stmt = $con->query("SELECT nextval('time_estimations_2011_id_seq')");
$row = $stmt->fetch(PDO::FETCH_NUM);
$this->id = $row[0];
} catch (Exception $e) {
throw new PropelException('Unable to get sequence id.', $e);
}
}
// check the columns in natural order for more readable SQL queries
if ($this->isColumnModified(TimeEstimations2011Peer::ID)) {
$modifiedColumns[':p' . $index++] = 'ID';
}
if ($this->isColumnModified(TimeEstimations2011Peer::STOPID)) {
$modifiedColumns[':p' . $index++] = 'STOPID';
}
if ($this->isColumnModified(TimeEstimations2011Peer::ROUTEID)) {
$modifiedColumns[':p' . $index++] = 'ROUTEID';
}
if ($this->isColumnModified(TimeEstimations2011Peer::ESTIMATETIME)) {
$modifiedColumns[':p' . $index++] = 'ESTIMATETIME';
}
if ($this->isColumnModified(TimeEstimations2011Peer::GOBACK)) {
$modifiedColumns[':p' . $index++] = 'GOBACK';
}
if ($this->isColumnModified(TimeEstimations2011Peer::TIME)) {
$modifiedColumns[':p' . $index++] = 'TIME';
}
$sql = sprintf('INSERT INTO time_estimations_2011 (%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 'STOPID':
$stmt->bindValue($identifier, $this->stopid, PDO::PARAM_INT);
break;
case 'ROUTEID':
$stmt->bindValue($identifier, $this->routeid, PDO::PARAM_INT);
break;
case 'ESTIMATETIME':
$stmt->bindValue($identifier, $this->estimatetime, PDO::PARAM_INT);
break;
case 'GOBACK':
$stmt->bindValue($identifier, $this->goback, PDO::PARAM_INT);
break;
case 'TIME':
$stmt->bindValue($identifier, $this->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);
}
$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[] = Presidentialelection2004Peer::ID;
if (null !== $this->id) {
throw new PropelException('Cannot insert a value for auto-increment primary key (' . Presidentialelection2004Peer::ID . ')');
}
if (null === $this->id) {
try {
$stmt = $con->query("SELECT nextval('PresidentialElection2004_id_seq')");
$row = $stmt->fetch(PDO::FETCH_NUM);
$this->id = $row[0];
} catch (Exception $e) {
throw new PropelException('Unable to get sequence id.', $e);
}
}
// check the columns in natural order for more readable SQL queries
if ($this->isColumnModified(Presidentialelection2004Peer::ID)) {
$modifiedColumns[':p' . $index++] = 'ID';
}
if ($this->isColumnModified(Presidentialelection2004Peer::COUNTY)) {
$modifiedColumns[':p' . $index++] = 'COUNTY';
}
if ($this->isColumnModified(Presidentialelection2004Peer::CITY)) {
$modifiedColumns[':p' . $index++] = 'CITY';
}
if ($this->isColumnModified(Presidentialelection2004Peer::VILLAGE)) {
$modifiedColumns[':p' . $index++] = 'VILLAGE';
}
if ($this->isColumnModified(Presidentialelection2004Peer::VOTENO)) {
$modifiedColumns[':p' . $index++] = 'VOTENO';
}
if ($this->isColumnModified(Presidentialelection2004Peer::DPPNUM)) {
$modifiedColumns[':p' . $index++] = 'DPPNUM';
}
if ($this->isColumnModified(Presidentialelection2004Peer::DPPRATIO)) {
$modifiedColumns[':p' . $index++] = 'DPPRATIO';
}
if ($this->isColumnModified(Presidentialelection2004Peer::KMTNUM)) {
$modifiedColumns[':p' . $index++] = 'KMTNUM';
}
if ($this->isColumnModified(Presidentialelection2004Peer::KMTRATIO)) {
$modifiedColumns[':p' . $index++] = 'KMTRATIO';
}
if ($this->isColumnModified(Presidentialelection2004Peer::VAILDVOTES)) {
$modifiedColumns[':p' . $index++] = 'VAILDVOTES';
}
if ($this->isColumnModified(Presidentialelection2004Peer::INVAILDVOTES)) {
$modifiedColumns[':p' . $index++] = 'INVAILDVOTES';
}
if ($this->isColumnModified(Presidentialelection2004Peer::TOTALVOTES)) {
$modifiedColumns[':p' . $index++] = 'TOTALVOTES';
}
if ($this->isColumnModified(Presidentialelection2004Peer::OTHERVOTES)) {
$modifiedColumns[':p' . $index++] = 'OTHERVOTES';
}
if ($this->isColumnModified(Presidentialelection2004Peer::VOTERSNUM)) {
$modifiedColumns[':p' . $index++] = 'VOTERSNUM';
}
if ($this->isColumnModified(Presidentialelection2004Peer::VOTERSRATIO)) {
$modifiedColumns[':p' . $index++] = 'VOTERSRATIO';
}
$sql = sprintf('INSERT INTO PresidentialElection2004 (%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 'COUNTY':
$stmt->bindValue($identifier, $this->county, PDO::PARAM_STR);
break;
case 'CITY':
$stmt->bindValue($identifier, $this->city, PDO::PARAM_STR);
break;
case 'VILLAGE':
$stmt->bindValue($identifier, $this->village, PDO::PARAM_STR);
break;
case 'VOTENO':
$stmt->bindValue($identifier, $this->voteno, PDO::PARAM_INT);
break;
case 'DPPNUM':
$stmt->bindValue($identifier, $this->dppnum, PDO::PARAM_INT);
break;
case 'DPPRATIO':
$stmt->bindValue($identifier, $this->dppratio, PDO::PARAM_STR);
break;
case 'KMTNUM':
$stmt->bindValue($identifier, $this->kmtnum, PDO::PARAM_INT);
break;
case 'KMTRATIO':
$stmt->bindValue($identifier, $this->kmtratio, PDO::PARAM_STR);
break;
case 'VAILDVOTES':
$stmt->bindValue($identifier, $this->vaildvotes, PDO::PARAM_INT);
break;
case 'INVAILDVOTES':
$stmt->bindValue($identifier, $this->invaildvotes, PDO::PARAM_INT);
break;
case 'TOTALVOTES':
$stmt->bindValue($identifier, $this->totalvotes, PDO::PARAM_INT);
break;
case 'OTHERVOTES':
$stmt->bindValue($identifier, $this->othervotes, PDO::PARAM_INT);
break;
case 'VOTERSNUM':
$stmt->bindValue($identifier, $this->votersnum, PDO::PARAM_INT);
break;
case 'VOTERSRATIO':
$stmt->bindValue($identifier, $this->votersratio, 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);
}