Insert the row in the database.

@param      ConnectionInterface $con

@throws PropelException
@see doSave()
762093
protected function doInsert(ConnectionInterface $con)
    {
        $modifiedColumns = array();
        $index = 0;


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

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

        try {
            $stmt = $con->prepare($sql);
            foreach ($modifiedColumns as $identifier => $columnName) {
                switch ($columnName) {
                    case 'ROLE_ID':
                        $stmt->bindValue($identifier, $this->role_id, PDO::PARAM_INT);
                        break;
                    case 'PERMISSION_ID':
                        $stmt->bindValue($identifier, $this->permission_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), 0, $e);
        }

        $this->setNew(false);
    }
1297382
protected function doInsert(ConnectionInterface $con)
    {
        $modifiedColumns = array();
        $index = 0;

        $this->modifiedColumns[VideoTableMap::COL_ID] = true;
        if (null !== $this->id) {
            throw new PropelException('Cannot insert a value for auto-increment primary key (' . VideoTableMap::COL_ID . ')');
        }

         // check the columns in natural order for more readable SQL queries
        if ($this->isColumnModified(VideoTableMap::COL_ID)) {
            $modifiedColumns[':p' . $index++]  = '`id`';
        }
        if ($this->isColumnModified(VideoTableMap::COL_TITLE)) {
            $modifiedColumns[':p' . $index++]  = '`title`';
        }
        if ($this->isColumnModified(VideoTableMap::COL_DESCRIPTION)) {
            $modifiedColumns[':p' . $index++]  = '`description`';
        }
        if ($this->isColumnModified(VideoTableMap::COL_URL)) {
            $modifiedColumns[':p' . $index++]  = '`url`';
        }
        if ($this->isColumnModified(VideoTableMap::COL_IS_TUTORIAL)) {
            $modifiedColumns[':p' . $index++]  = '`is_tutorial`';
        }
        if ($this->isColumnModified(VideoTableMap::COL_ATHLETE)) {
            $modifiedColumns[':p' . $index++]  = '`athlete`';
        }
        if ($this->isColumnModified(VideoTableMap::COL_ATHLETE_ID)) {
            $modifiedColumns[':p' . $index++]  = '`athlete_id`';
        }
        if ($this->isColumnModified(VideoTableMap::COL_UPLOADER_ID)) {
            $modifiedColumns[':p' . $index++]  = '`uploader_id`';
        }
        if ($this->isColumnModified(VideoTableMap::COL_SKILL_ID)) {
            $modifiedColumns[':p' . $index++]  = '`skill_id`';
        }
        if ($this->isColumnModified(VideoTableMap::COL_REFERENCE_ID)) {
            $modifiedColumns[':p' . $index++]  = '`reference_id`';
        }
        if ($this->isColumnModified(VideoTableMap::COL_POSTER_URL)) {
            $modifiedColumns[':p' . $index++]  = '`poster_url`';
        }
        if ($this->isColumnModified(VideoTableMap::COL_PROVIDER)) {
            $modifiedColumns[':p' . $index++]  = '`provider`';
        }
        if ($this->isColumnModified(VideoTableMap::COL_PROVIDER_ID)) {
            $modifiedColumns[':p' . $index++]  = '`provider_id`';
        }
        if ($this->isColumnModified(VideoTableMap::COL_PLAYER_URL)) {
            $modifiedColumns[':p' . $index++]  = '`player_url`';
        }
        if ($this->isColumnModified(VideoTableMap::COL_WIDTH)) {
            $modifiedColumns[':p' . $index++]  = '`width`';
        }
        if ($this->isColumnModified(VideoTableMap::COL_HEIGHT)) {
            $modifiedColumns[':p' . $index++]  = '`height`';
        }

        $sql = sprintf(
            'INSERT INTO `kk_trixionary_video` (%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 '`title`':
                        $stmt->bindValue($identifier, $this->title, PDO::PARAM_STR);
                        break;
                    case '`description`':
                        $stmt->bindValue($identifier, $this->description, PDO::PARAM_STR);
                        break;
                    case '`url`':
                        $stmt->bindValue($identifier, $this->url, PDO::PARAM_STR);
                        break;
                    case '`is_tutorial`':
                        $stmt->bindValue($identifier, (int) $this->is_tutorial, PDO::PARAM_INT);
                        break;
                    case '`athlete`':
                        $stmt->bindValue($identifier, $this->athlete, PDO::PARAM_STR);
                        break;
                    case '`athlete_id`':
                        $stmt->bindValue($identifier, $this->athlete_id, PDO::PARAM_INT);
                        break;
                    case '`uploader_id`':
                        $stmt->bindValue($identifier, $this->uploader_id, PDO::PARAM_INT);
                        break;
                    case '`skill_id`':
                        $stmt->bindValue($identifier, $this->skill_id, PDO::PARAM_INT);
                        break;
                    case '`reference_id`':
                        $stmt->bindValue($identifier, $this->reference_id, PDO::PARAM_INT);
                        break;
                    case '`poster_url`':
                        $stmt->bindValue($identifier, $this->poster_url, PDO::PARAM_STR);
                        break;
                    case '`provider`':
                        $stmt->bindValue($identifier, $this->provider, PDO::PARAM_STR);
                        break;
                    case '`provider_id`':
                        $stmt->bindValue($identifier, $this->provider_id, PDO::PARAM_STR);
                        break;
                    case '`player_url`':
                        $stmt->bindValue($identifier, $this->player_url, PDO::PARAM_STR);
                        break;
                    case '`width`':
                        $stmt->bindValue($identifier, $this->width, PDO::PARAM_INT);
                        break;
                    case '`height`':
                        $stmt->bindValue($identifier, $this->height, PDO::PARAM_INT);
                        break;
                }
            }
            $stmt->execute();
        } catch (Exception $e) {
            Propel::log($e->getMessage(), Propel::LOG_ERR);
            throw new PropelException(sprintf('Unable to execute INSERT statement [%s]', $sql), 0, $e);
        }

        try {
            $pk = $con->lastInsertId();
        } catch (Exception $e) {
            throw new PropelException('Unable to get autoincrement id.', 0, $e);
        }
        $this->setId($pk);

        $this->setNew(false);
    }
1244876
public function save($con = null)
    {
        if (!method_exists($this->getModel(), 'save')) {
            throw new PropelException('Cannot save objects on a read-only model');
        }
        if (null === $con) {
            $con = $this->getConnection(Propel::CONNECTION_WRITE);
        }
        $con->beginTransaction();
        try {
            $obj = $this->getWorkerObject();
            foreach ($this as $element) {
                $obj->clear();
                $obj->fromArray($element);
                $obj->setNew($obj->isPrimaryKeyNull());
                $obj->save($con);
            }
            $con->commit();
        } catch (Exception $e) {
            $con->rollback();
        }
    }
546037
protected function doInsert(ConnectionInterface $con)
    {
        $modifiedColumns = array();
        $index = 0;

        $this->modifiedColumns[LineageTableMap::COL_ID] = true;
        if (null !== $this->id) {
            throw new PropelException('Cannot insert a value for auto-increment primary key (' . LineageTableMap::COL_ID . ')');
        }

         // check the columns in natural order for more readable SQL queries
        if ($this->isColumnModified(LineageTableMap::COL_ID)) {
            $modifiedColumns[':p' . $index++]  = '`id`';
        }
        if ($this->isColumnModified(LineageTableMap::COL_SKILL_ID)) {
            $modifiedColumns[':p' . $index++]  = '`skill_id`';
        }
        if ($this->isColumnModified(LineageTableMap::COL_ANCESTOR_ID)) {
            $modifiedColumns[':p' . $index++]  = '`ancestor_id`';
        }
        if ($this->isColumnModified(LineageTableMap::COL_POSITION)) {
            $modifiedColumns[':p' . $index++]  = '`position`';
        }

        $sql = sprintf(
            'INSERT INTO `kk_trixionary_lineage` (%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 '`skill_id`':
                        $stmt->bindValue($identifier, $this->skill_id, PDO::PARAM_INT);
                        break;
                    case '`ancestor_id`':
                        $stmt->bindValue($identifier, $this->ancestor_id, PDO::PARAM_INT);
                        break;
                    case '`position`':
                        $stmt->bindValue($identifier, $this->position, PDO::PARAM_INT);
                        break;
                }
            }
            $stmt->execute();
        } catch (Exception $e) {
            Propel::log($e->getMessage(), Propel::LOG_ERR);
            throw new PropelException(sprintf('Unable to execute INSERT statement [%s]', $sql), 0, $e);
        }

        try {
            $pk = $con->lastInsertId();
        } catch (Exception $e) {
            throw new PropelException('Unable to get autoincrement id.', 0, $e);
        }
        $this->setId($pk);

        $this->setNew(false);
    }
681618
protected function doInsert(ConnectionInterface $con)
    {
        $modifiedColumns = array();
        $index = 0;


         // check the columns in natural order for more readable SQL queries
        if ($this->isColumnModified(StructureNodeParentTableMap::COL_STRUCTURE_NODE_ID)) {
            $modifiedColumns[':p' . $index++]  = '`structure_node_id`';
        }
        if ($this->isColumnModified(StructureNodeParentTableMap::COL_PARENT_ID)) {
            $modifiedColumns[':p' . $index++]  = '`parent_id`';
        }

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

        try {
            $stmt = $con->prepare($sql);
            foreach ($modifiedColumns as $identifier => $columnName) {
                switch ($columnName) {
                    case '`structure_node_id`':
                        $stmt->bindValue($identifier, $this->structure_node_id, PDO::PARAM_INT);
                        break;
                    case '`parent_id`':
                        $stmt->bindValue($identifier, $this->parent_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), 0, $e);
        }

        $this->setNew(false);
    }
481367
public function makeInsert(string $connectionName = ''): InsertQueryBuilder
    {
        $connection = $this->provideConnection($connectionName);
        $statementBuilder = new InsertStatementBuilder;
        return new InsertQueryBuilder($connection, $statementBuilder);
    }
596552
public function delete(ConnectionInterface $con = null)
    {
        if ($this->isDeleted()) {
            throw new PropelException("This object has already been deleted.");
        }

        if ($con === null) {
            $con = Propel::getServiceContainer()->getWriteConnection(CustomerGroupTableMap::DATABASE_NAME);
        }

        $con->beginTransaction();
        try {
            $deleteQuery = ChildCustomerGroupQuery::create()
                ->filterByPrimaryKey($this->getPrimaryKey());
            $ret = $this->preDelete($con);
            // sortable behavior

            ChildCustomerGroupQuery::sortableShiftRank(-1, $this->getPosition() + 1, null, $con);
            CustomerGroupTableMap::clearInstancePool();

            if ($ret) {
                $deleteQuery->delete($con);
                $this->postDelete($con);
                $con->commit();
                $this->setDeleted(true);
            } else {
                $con->commit();
            }
        } catch (Exception $e) {
            $con->rollBack();
            throw $e;
        }
    }
345300
protected function doInsert(PropelPDO $con)
    {
        $modifiedColumns = array();
        $index = 0;

        $this->modifiedColumns[] = RemoteHistoryContaoPeer::ID;
        if (null !== $this->id) {
            throw new PropelException('Cannot insert a value for auto-increment primary key (' . RemoteHistoryContaoPeer::ID . ')');
        }

         // check the columns in natural order for more readable SQL queries
        if ($this->isColumnModified(RemoteHistoryContaoPeer::ID)) {
            $modifiedColumns[':p' . $index++]  = '`id`';
        }
        if ($this->isColumnModified(RemoteHistoryContaoPeer::REMOTE_APP_ID)) {
            $modifiedColumns[':p' . $index++]  = '`remote_app_id`';
        }
        if ($this->isColumnModified(RemoteHistoryContaoPeer::APIVERSION)) {
            $modifiedColumns[':p' . $index++]  = '`apiVersion`';
        }
        if ($this->isColumnModified(RemoteHistoryContaoPeer::NAME)) {
            $modifiedColumns[':p' . $index++]  = '`name`';
        }
        if ($this->isColumnModified(RemoteHistoryContaoPeer::VERSION)) {
            $modifiedColumns[':p' . $index++]  = '`version`';
        }
        if ($this->isColumnModified(RemoteHistoryContaoPeer::CONFIG_DISPLAYERRORS)) {
            $modifiedColumns[':p' . $index++]  = '`config_displayErrors`';
        }
        if ($this->isColumnModified(RemoteHistoryContaoPeer::CONFIG_BYPASSCACHE)) {
            $modifiedColumns[':p' . $index++]  = '`config_bypassCache`';
        }
        if ($this->isColumnModified(RemoteHistoryContaoPeer::CONFIG_MINIFYMARKUP)) {
            $modifiedColumns[':p' . $index++]  = '`config_minifyMarkup`';
        }
        if ($this->isColumnModified(RemoteHistoryContaoPeer::CONFIG_DEBUGMODE)) {
            $modifiedColumns[':p' . $index++]  = '`config_debugMode`';
        }
        if ($this->isColumnModified(RemoteHistoryContaoPeer::CONFIG_MAINTENANCEMODE)) {
            $modifiedColumns[':p' . $index++]  = '`config_maintenanceMode`';
        }
        if ($this->isColumnModified(RemoteHistoryContaoPeer::CONFIG_GZIPSCRIPTS)) {
            $modifiedColumns[':p' . $index++]  = '`config_gzipScripts`';
        }
        if ($this->isColumnModified(RemoteHistoryContaoPeer::CONFIG_REWRITEURL)) {
            $modifiedColumns[':p' . $index++]  = '`config_rewriteURL`';
        }
        if ($this->isColumnModified(RemoteHistoryContaoPeer::CONFIG_ADMINEMAIL)) {
            $modifiedColumns[':p' . $index++]  = '`config_adminEmail`';
        }
        if ($this->isColumnModified(RemoteHistoryContaoPeer::CONFIG_CACHEMODE)) {
            $modifiedColumns[':p' . $index++]  = '`config_cacheMode`';
        }
        if ($this->isColumnModified(RemoteHistoryContaoPeer::STATUSCODE)) {
            $modifiedColumns[':p' . $index++]  = '`statuscode`';
        }
        if ($this->isColumnModified(RemoteHistoryContaoPeer::EXTENSIONS)) {
            $modifiedColumns[':p' . $index++]  = '`extensions`';
        }
        if ($this->isColumnModified(RemoteHistoryContaoPeer::LOG)) {
            $modifiedColumns[':p' . $index++]  = '`log`';
        }
        if ($this->isColumnModified(RemoteHistoryContaoPeer::PHP)) {
            $modifiedColumns[':p' . $index++]  = '`php`';
        }
        if ($this->isColumnModified(RemoteHistoryContaoPeer::MYSQL)) {
            $modifiedColumns[':p' . $index++]  = '`mysql`';
        }

        $sql = sprintf(
            'INSERT INTO `remote_history_contao` (%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 '`remote_app_id`':
                        $stmt->bindValue($identifier, $this->remote_app_id, PDO::PARAM_INT);
                        break;
                    case '`apiVersion`':
                        $stmt->bindValue($identifier, $this->apiversion, PDO::PARAM_STR);
                        break;
                    case '`name`':
                        $stmt->bindValue($identifier, $this->name, PDO::PARAM_STR);
                        break;
                    case '`version`':
                        $stmt->bindValue($identifier, $this->version, PDO::PARAM_STR);
                        break;
                    case '`config_displayErrors`':
                        $stmt->bindValue($identifier, $this->config_displayerrors, PDO::PARAM_STR);
                        break;
                    case '`config_bypassCache`':
                        $stmt->bindValue($identifier, $this->config_bypasscache, PDO::PARAM_STR);
                        break;
                    case '`config_minifyMarkup`':
                        $stmt->bindValue($identifier, $this->config_minifymarkup, PDO::PARAM_STR);
                        break;
                    case '`config_debugMode`':
                        $stmt->bindValue($identifier, $this->config_debugmode, PDO::PARAM_STR);
                        break;
                    case '`config_maintenanceMode`':
                        $stmt->bindValue($identifier, $this->config_maintenancemode, PDO::PARAM_STR);
                        break;
                    case '`config_gzipScripts`':
                        $stmt->bindValue($identifier, $this->config_gzipscripts, PDO::PARAM_STR);
                        break;
                    case '`config_rewriteURL`':
                        $stmt->bindValue($identifier, $this->config_rewriteurl, PDO::PARAM_STR);
                        break;
                    case '`config_adminEmail`':
                        $stmt->bindValue($identifier, $this->config_adminemail, PDO::PARAM_STR);
                        break;
                    case '`config_cacheMode`':
                        $stmt->bindValue($identifier, $this->config_cachemode, PDO::PARAM_STR);
                        break;
                    case '`statuscode`':
                        $stmt->bindValue($identifier, $this->statuscode, PDO::PARAM_INT);
                        break;
                    case '`extensions`':
                        $stmt->bindValue($identifier, $this->extensions, PDO::PARAM_STR);
                        break;
                    case '`log`':
                        $stmt->bindValue($identifier, $this->log, PDO::PARAM_STR);
                        break;
                    case '`php`':
                        $stmt->bindValue($identifier, $this->php, PDO::PARAM_STR);
                        break;
                    case '`mysql`':
                        $stmt->bindValue($identifier, $this->mysql, 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);
    }
213377
protected function doInsert(ConnectionInterface $con)
    {
        $modifiedColumns = array();
        $index = 0;

        $this->modifiedColumns[FeatureTypeTableMap::ID] = true;
        if (null !== $this->id) {
            throw new PropelException('Cannot insert a value for auto-increment primary key (' . FeatureTypeTableMap::ID . ')');
        }

         // check the columns in natural order for more readable SQL queries
        if ($this->isColumnModified(FeatureTypeTableMap::ID)) {
            $modifiedColumns[':p' . $index++]  = 'ID';
        }
        if ($this->isColumnModified(FeatureTypeTableMap::SLUG)) {
            $modifiedColumns[':p' . $index++]  = 'SLUG';
        }
        if ($this->isColumnModified(FeatureTypeTableMap::HAS_FEATURE_AV_VALUE)) {
            $modifiedColumns[':p' . $index++]  = 'HAS_FEATURE_AV_VALUE';
        }
        if ($this->isColumnModified(FeatureTypeTableMap::IS_MULTILINGUAL_FEATURE_AV_VALUE)) {
            $modifiedColumns[':p' . $index++]  = 'IS_MULTILINGUAL_FEATURE_AV_VALUE';
        }
        if ($this->isColumnModified(FeatureTypeTableMap::PATTERN)) {
            $modifiedColumns[':p' . $index++]  = 'PATTERN';
        }
        if ($this->isColumnModified(FeatureTypeTableMap::CSS_CLASS)) {
            $modifiedColumns[':p' . $index++]  = 'CSS_CLASS';
        }
        if ($this->isColumnModified(FeatureTypeTableMap::INPUT_TYPE)) {
            $modifiedColumns[':p' . $index++]  = 'INPUT_TYPE';
        }
        if ($this->isColumnModified(FeatureTypeTableMap::MAX)) {
            $modifiedColumns[':p' . $index++]  = 'MAX';
        }
        if ($this->isColumnModified(FeatureTypeTableMap::MIN)) {
            $modifiedColumns[':p' . $index++]  = 'MIN';
        }
        if ($this->isColumnModified(FeatureTypeTableMap::STEP)) {
            $modifiedColumns[':p' . $index++]  = 'STEP';
        }
        if ($this->isColumnModified(FeatureTypeTableMap::IMAGE_MAX_WIDTH)) {
            $modifiedColumns[':p' . $index++]  = 'IMAGE_MAX_WIDTH';
        }
        if ($this->isColumnModified(FeatureTypeTableMap::IMAGE_MAX_HEIGHT)) {
            $modifiedColumns[':p' . $index++]  = 'IMAGE_MAX_HEIGHT';
        }
        if ($this->isColumnModified(FeatureTypeTableMap::IMAGE_RATIO)) {
            $modifiedColumns[':p' . $index++]  = 'IMAGE_RATIO';
        }
        if ($this->isColumnModified(FeatureTypeTableMap::CREATED_AT)) {
            $modifiedColumns[':p' . $index++]  = 'CREATED_AT';
        }
        if ($this->isColumnModified(FeatureTypeTableMap::UPDATED_AT)) {
            $modifiedColumns[':p' . $index++]  = 'UPDATED_AT';
        }

        $sql = sprintf(
            'INSERT INTO feature_type (%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 'SLUG':
                        $stmt->bindValue($identifier, $this->slug, PDO::PARAM_STR);
                        break;
                    case 'HAS_FEATURE_AV_VALUE':
                        $stmt->bindValue($identifier, $this->has_feature_av_value, PDO::PARAM_INT);
                        break;
                    case 'IS_MULTILINGUAL_FEATURE_AV_VALUE':
                        $stmt->bindValue($identifier, $this->is_multilingual_feature_av_value, PDO::PARAM_INT);
                        break;
                    case 'PATTERN':
                        $stmt->bindValue($identifier, $this->pattern, PDO::PARAM_STR);
                        break;
                    case 'CSS_CLASS':
                        $stmt->bindValue($identifier, $this->css_class, PDO::PARAM_STR);
                        break;
                    case 'INPUT_TYPE':
                        $stmt->bindValue($identifier, $this->input_type, PDO::PARAM_STR);
                        break;
                    case 'MAX':
                        $stmt->bindValue($identifier, $this->max, PDO::PARAM_STR);
                        break;
                    case 'MIN':
                        $stmt->bindValue($identifier, $this->min, PDO::PARAM_STR);
                        break;
                    case 'STEP':
                        $stmt->bindValue($identifier, $this->step, PDO::PARAM_STR);
                        break;
                    case 'IMAGE_MAX_WIDTH':
                        $stmt->bindValue($identifier, $this->image_max_width, PDO::PARAM_STR);
                        break;
                    case 'IMAGE_MAX_HEIGHT':
                        $stmt->bindValue($identifier, $this->image_max_height, PDO::PARAM_STR);
                        break;
                    case 'IMAGE_RATIO':
                        $stmt->bindValue($identifier, $this->image_ratio, PDO::PARAM_STR);
                        break;
                    case 'CREATED_AT':
                        $stmt->bindValue($identifier, $this->created_at ? $this->created_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
                        break;
                    case 'UPDATED_AT':
                        $stmt->bindValue($identifier, $this->updated_at ? $this->updated_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
                        break;
                }
            }
            $stmt->execute();
        } catch (Exception $e) {
            Propel::log($e->getMessage(), Propel::LOG_ERR);
            throw new PropelException(sprintf('Unable to execute INSERT statement [%s]', $sql), 0, $e);
        }

        try {
            $pk = $con->lastInsertId();
        } catch (Exception $e) {
            throw new PropelException('Unable to get autoincrement id.', 0, $e);
        }
        $this->setId($pk);

        $this->setNew(false);
    }
492318
protected function doInsert(PropelPDO $con)
    {
        $modifiedColumns = array();
        $index = 0;

        $this->modifiedColumns[] = CustomerPeer::ID;
        if (null !== $this->id) {
            throw new PropelException('Cannot insert a value for auto-increment primary key (' . CustomerPeer::ID . ')');
        }

         // check the columns in natural order for more readable SQL queries
        if ($this->isColumnModified(CustomerPeer::ID)) {
            $modifiedColumns[':p' . $index++]  = '`id`';
        }
        if ($this->isColumnModified(CustomerPeer::NAME)) {
            $modifiedColumns[':p' . $index++]  = '`name`';
        }
        if ($this->isColumnModified(CustomerPeer::STREET)) {
            $modifiedColumns[':p' . $index++]  = '`street`';
        }
        if ($this->isColumnModified(CustomerPeer::ZIP)) {
            $modifiedColumns[':p' . $index++]  = '`zip`';
        }
        if ($this->isColumnModified(CustomerPeer::CITY)) {
            $modifiedColumns[':p' . $index++]  = '`city`';
        }
        if ($this->isColumnModified(CustomerPeer::COUNTRY_ID)) {
            $modifiedColumns[':p' . $index++]  = '`country_id`';
        }
        if ($this->isColumnModified(CustomerPeer::PHONE)) {
            $modifiedColumns[':p' . $index++]  = '`phone`';
        }
        if ($this->isColumnModified(CustomerPeer::FAX)) {
            $modifiedColumns[':p' . $index++]  = '`fax`';
        }
        if ($this->isColumnModified(CustomerPeer::EMAIL)) {
            $modifiedColumns[':p' . $index++]  = '`email`';
        }
        if ($this->isColumnModified(CustomerPeer::LEGALFORM)) {
            $modifiedColumns[':p' . $index++]  = '`legalform`';
        }
        if ($this->isColumnModified(CustomerPeer::LOGO)) {
            $modifiedColumns[':p' . $index++]  = '`logo`';
        }
        if ($this->isColumnModified(CustomerPeer::CREATED)) {
            $modifiedColumns[':p' . $index++]  = '`created`';
        }
        if ($this->isColumnModified(CustomerPeer::NOTES)) {
            $modifiedColumns[':p' . $index++]  = '`notes`';
        }

        $sql = sprintf(
            'INSERT INTO `customer` (%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 '`street`':
                        $stmt->bindValue($identifier, $this->street, PDO::PARAM_STR);
                        break;
                    case '`zip`':
                        $stmt->bindValue($identifier, $this->zip, PDO::PARAM_STR);
                        break;
                    case '`city`':
                        $stmt->bindValue($identifier, $this->city, PDO::PARAM_STR);
                        break;
                    case '`country_id`':
                        $stmt->bindValue($identifier, $this->country_id, PDO::PARAM_INT);
                        break;
                    case '`phone`':
                        $stmt->bindValue($identifier, $this->phone, PDO::PARAM_STR);
                        break;
                    case '`fax`':
                        $stmt->bindValue($identifier, $this->fax, PDO::PARAM_STR);
                        break;
                    case '`email`':
                        $stmt->bindValue($identifier, $this->email, PDO::PARAM_STR);
                        break;
                    case '`legalform`':
                        $stmt->bindValue($identifier, $this->legalform, PDO::PARAM_STR);
                        break;
                    case '`logo`':
                        $stmt->bindValue($identifier, $this->logo, PDO::PARAM_STR);
                        break;
                    case '`created`':
                        $stmt->bindValue($identifier, $this->created, PDO::PARAM_STR);
                        break;
                    case '`notes`':
                        $stmt->bindValue($identifier, $this->notes, 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);
    }
1120168
protected function doInsert(PropelPDO $con)
    {
        $modifiedColumns = array();
        $index = 0;

        $this->modifiedColumns[] = RolePeer::ID;
        if (null !== $this->id) {
            throw new PropelException('Cannot insert a value for auto-increment primary key (' . RolePeer::ID . ')');
        }

         // check the columns in natural order for more readable SQL queries
        if ($this->isColumnModified(RolePeer::ID)) {
            $modifiedColumns[':p' . $index++]  = '`id`';
        }
        if ($this->isColumnModified(RolePeer::NAME)) {
            $modifiedColumns[':p' . $index++]  = '`name`';
        }
        if ($this->isColumnModified(RolePeer::ROLE)) {
            $modifiedColumns[':p' . $index++]  = '`role`';
        }

        $sql = sprintf(
            'INSERT INTO `role` (%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 '`role`':
                        $stmt->bindValue($identifier, $this->role, 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);
    }
784762
protected function doInsert(ConnectionInterface $con)
    {
        $modifiedColumns = array();
        $index = 0;

        $this->modifiedColumns[SportTableMap::COL_ID] = true;
        if (null !== $this->id) {
            throw new PropelException('Cannot insert a value for auto-increment primary key (' . SportTableMap::COL_ID . ')');
        }

         // check the columns in natural order for more readable SQL queries
        if ($this->isColumnModified(SportTableMap::COL_ID)) {
            $modifiedColumns[':p' . $index++]  = '`id`';
        }
        if ($this->isColumnModified(SportTableMap::COL_TITLE)) {
            $modifiedColumns[':p' . $index++]  = '`title`';
        }
        if ($this->isColumnModified(SportTableMap::COL_SLUG)) {
            $modifiedColumns[':p' . $index++]  = '`slug`';
        }
        if ($this->isColumnModified(SportTableMap::COL_ATHLETE_LABEL)) {
            $modifiedColumns[':p' . $index++]  = '`athlete_label`';
        }
        if ($this->isColumnModified(SportTableMap::COL_OBJECT_SLUG)) {
            $modifiedColumns[':p' . $index++]  = '`object_slug`';
        }
        if ($this->isColumnModified(SportTableMap::COL_OBJECT_LABEL)) {
            $modifiedColumns[':p' . $index++]  = '`object_label`';
        }
        if ($this->isColumnModified(SportTableMap::COL_OBJECT_PLURAL_LABEL)) {
            $modifiedColumns[':p' . $index++]  = '`object_plural_label`';
        }
        if ($this->isColumnModified(SportTableMap::COL_SKILL_SLUG)) {
            $modifiedColumns[':p' . $index++]  = '`skill_slug`';
        }
        if ($this->isColumnModified(SportTableMap::COL_SKILL_LABEL)) {
            $modifiedColumns[':p' . $index++]  = '`skill_label`';
        }
        if ($this->isColumnModified(SportTableMap::COL_SKILL_PLURAL_LABEL)) {
            $modifiedColumns[':p' . $index++]  = '`skill_plural_label`';
        }
        if ($this->isColumnModified(SportTableMap::COL_SKILL_PICTURE_URL)) {
            $modifiedColumns[':p' . $index++]  = '`skill_picture_url`';
        }
        if ($this->isColumnModified(SportTableMap::COL_GROUP_SLUG)) {
            $modifiedColumns[':p' . $index++]  = '`group_slug`';
        }
        if ($this->isColumnModified(SportTableMap::COL_GROUP_LABEL)) {
            $modifiedColumns[':p' . $index++]  = '`group_label`';
        }
        if ($this->isColumnModified(SportTableMap::COL_GROUP_PLURAL_LABEL)) {
            $modifiedColumns[':p' . $index++]  = '`group_plural_label`';
        }
        if ($this->isColumnModified(SportTableMap::COL_TRANSITION_LABEL)) {
            $modifiedColumns[':p' . $index++]  = '`transition_label`';
        }
        if ($this->isColumnModified(SportTableMap::COL_TRANSITION_PLURAL_LABEL)) {
            $modifiedColumns[':p' . $index++]  = '`transition_plural_label`';
        }
        if ($this->isColumnModified(SportTableMap::COL_TRANSITIONS_SLUG)) {
            $modifiedColumns[':p' . $index++]  = '`transitions_slug`';
        }
        if ($this->isColumnModified(SportTableMap::COL_POSITION_SLUG)) {
            $modifiedColumns[':p' . $index++]  = '`position_slug`';
        }
        if ($this->isColumnModified(SportTableMap::COL_POSITION_LABEL)) {
            $modifiedColumns[':p' . $index++]  = '`position_label`';
        }
        if ($this->isColumnModified(SportTableMap::COL_FEATURE_COMPOSITION)) {
            $modifiedColumns[':p' . $index++]  = '`feature_composition`';
        }
        if ($this->isColumnModified(SportTableMap::COL_FEATURE_TESTER)) {
            $modifiedColumns[':p' . $index++]  = '`feature_tester`';
        }
        if ($this->isColumnModified(SportTableMap::COL_IS_DEFAULT)) {
            $modifiedColumns[':p' . $index++]  = '`is_default`';
        }

        $sql = sprintf(
            'INSERT INTO `kk_trixionary_sport` (%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 '`title`':
                        $stmt->bindValue($identifier, $this->title, PDO::PARAM_STR);
                        break;
                    case '`slug`':
                        $stmt->bindValue($identifier, $this->slug, PDO::PARAM_STR);
                        break;
                    case '`athlete_label`':
                        $stmt->bindValue($identifier, $this->athlete_label, PDO::PARAM_STR);
                        break;
                    case '`object_slug`':
                        $stmt->bindValue($identifier, $this->object_slug, PDO::PARAM_STR);
                        break;
                    case '`object_label`':
                        $stmt->bindValue($identifier, $this->object_label, PDO::PARAM_STR);
                        break;
                    case '`object_plural_label`':
                        $stmt->bindValue($identifier, $this->object_plural_label, PDO::PARAM_STR);
                        break;
                    case '`skill_slug`':
                        $stmt->bindValue($identifier, $this->skill_slug, PDO::PARAM_STR);
                        break;
                    case '`skill_label`':
                        $stmt->bindValue($identifier, $this->skill_label, PDO::PARAM_STR);
                        break;
                    case '`skill_plural_label`':
                        $stmt->bindValue($identifier, $this->skill_plural_label, PDO::PARAM_STR);
                        break;
                    case '`skill_picture_url`':
                        $stmt->bindValue($identifier, $this->skill_picture_url, PDO::PARAM_STR);
                        break;
                    case '`group_slug`':
                        $stmt->bindValue($identifier, $this->group_slug, PDO::PARAM_STR);
                        break;
                    case '`group_label`':
                        $stmt->bindValue($identifier, $this->group_label, PDO::PARAM_STR);
                        break;
                    case '`group_plural_label`':
                        $stmt->bindValue($identifier, $this->group_plural_label, PDO::PARAM_STR);
                        break;
                    case '`transition_label`':
                        $stmt->bindValue($identifier, $this->transition_label, PDO::PARAM_STR);
                        break;
                    case '`transition_plural_label`':
                        $stmt->bindValue($identifier, $this->transition_plural_label, PDO::PARAM_STR);
                        break;
                    case '`transitions_slug`':
                        $stmt->bindValue($identifier, $this->transitions_slug, PDO::PARAM_STR);
                        break;
                    case '`position_slug`':
                        $stmt->bindValue($identifier, $this->position_slug, PDO::PARAM_STR);
                        break;
                    case '`position_label`':
                        $stmt->bindValue($identifier, $this->position_label, PDO::PARAM_STR);
                        break;
                    case '`feature_composition`':
                        $stmt->bindValue($identifier, (int) $this->feature_composition, PDO::PARAM_INT);
                        break;
                    case '`feature_tester`':
                        $stmt->bindValue($identifier, (int) $this->feature_tester, PDO::PARAM_INT);
                        break;
                    case '`is_default`':
                        $stmt->bindValue($identifier, (int) $this->is_default, PDO::PARAM_INT);
                        break;
                }
            }
            $stmt->execute();
        } catch (Exception $e) {
            Propel::log($e->getMessage(), Propel::LOG_ERR);
            throw new PropelException(sprintf('Unable to execute INSERT statement [%s]', $sql), 0, $e);
        }

        try {
            $pk = $con->lastInsertId();
        } catch (Exception $e) {
            throw new PropelException('Unable to get autoincrement id.', 0, $e);
        }
        $this->setId($pk);

        $this->setNew(false);
    }
889012
public function moveToBottom(ConnectionInterface $con = null)
    {
        if ($this->isLast($con)) {
            return false;
        }
        if (null === $con) {
            $con = Propel::getServiceContainer()->getWriteConnection(CustomerGroupTableMap::DATABASE_NAME);
        }
        $con->beginTransaction();
        try {
            $bottom = ChildCustomerGroupQuery::create()->getMaxRankArray($con);
            $res = $this->moveToRank($bottom, $con);
            $con->commit();

            return $res;
        } catch (Exception $e) {
            $con->rollback();
            throw $e;
        }
    }
1344546
protected function doInsert(ConnectionInterface $con)
    {
        $modifiedColumns = array();
        $index = 0;


         // check the columns in natural order for more readable SQL queries
        if ($this->isColumnModified(TeamVersionTableMap::ID)) {
            $modifiedColumns[':p' . $index++]  = 'ID';
        }
        if ($this->isColumnModified(TeamVersionTableMap::CREATED_AT)) {
            $modifiedColumns[':p' . $index++]  = 'CREATED_AT';
        }
        if ($this->isColumnModified(TeamVersionTableMap::UPDATED_AT)) {
            $modifiedColumns[':p' . $index++]  = 'UPDATED_AT';
        }
        if ($this->isColumnModified(TeamVersionTableMap::VERSION)) {
            $modifiedColumns[':p' . $index++]  = 'VERSION';
        }
        if ($this->isColumnModified(TeamVersionTableMap::VERSION_CREATED_AT)) {
            $modifiedColumns[':p' . $index++]  = 'VERSION_CREATED_AT';
        }
        if ($this->isColumnModified(TeamVersionTableMap::VERSION_CREATED_BY)) {
            $modifiedColumns[':p' . $index++]  = 'VERSION_CREATED_BY';
        }
        if ($this->isColumnModified(TeamVersionTableMap::PERSON_TEAM_LINK_IDS)) {
            $modifiedColumns[':p' . $index++]  = 'PERSON_TEAM_LINK_IDS';
        }
        if ($this->isColumnModified(TeamVersionTableMap::PERSON_TEAM_LINK_VERSIONS)) {
            $modifiedColumns[':p' . $index++]  = 'PERSON_TEAM_LINK_VERSIONS';
        }

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

        try {
            $stmt = $con->prepare($sql);
            foreach ($modifiedColumns as $identifier => $columnName) {
                switch ($columnName) {
                    case 'ID':
                        $stmt->bindValue($identifier, $this->id, PDO::PARAM_INT);
                        break;
                    case 'CREATED_AT':
                        $stmt->bindValue($identifier, $this->created_at ? $this->created_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
                        break;
                    case 'UPDATED_AT':
                        $stmt->bindValue($identifier, $this->updated_at ? $this->updated_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
                        break;
                    case 'VERSION':
                        $stmt->bindValue($identifier, $this->version, PDO::PARAM_INT);
                        break;
                    case 'VERSION_CREATED_AT':
                        $stmt->bindValue($identifier, $this->version_created_at ? $this->version_created_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
                        break;
                    case 'VERSION_CREATED_BY':
                        $stmt->bindValue($identifier, $this->version_created_by, PDO::PARAM_STR);
                        break;
                    case 'PERSON_TEAM_LINK_IDS':
                        $stmt->bindValue($identifier, $this->person_team_link_ids, PDO::PARAM_STR);
                        break;
                    case 'PERSON_TEAM_LINK_VERSIONS':
                        $stmt->bindValue($identifier, $this->person_team_link_versions, PDO::PARAM_STR);
                        break;
                }
            }
            $stmt->execute();
        } catch (Exception $e) {
            Propel::log($e->getMessage(), Propel::LOG_ERR);
            throw new PropelException(sprintf('Unable to execute INSERT statement [%s]', $sql), 0, $e);
        }

        $this->setNew(false);
    }
1306955
protected function doInsert(ConnectionInterface $con)
    {
        $modifiedColumns = array();
        $index = 0;

        $this->modifiedColumns[AttributeAttributeTypeTableMap::ID] = true;
        if (null !== $this->id) {
            throw new PropelException('Cannot insert a value for auto-increment primary key (' . AttributeAttributeTypeTableMap::ID . ')');
        }

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

        $sql = sprintf(
            'INSERT INTO attribute_attribute_type (%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 'ATTRIBUTE_ID':
                        $stmt->bindValue($identifier, $this->attribute_id, PDO::PARAM_INT);
                        break;
                    case 'ATTRIBUTE_TYPE_ID':
                        $stmt->bindValue($identifier, $this->attribute_type_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), 0, $e);
        }

        try {
            $pk = $con->lastInsertId();
        } catch (Exception $e) {
            throw new PropelException('Unable to get autoincrement id.', 0, $e);
        }
        $this->setId($pk);

        $this->setNew(false);
    }
999839
public function onOpen(ConnectionInterface $conn)
    {
        $this->conn = $conn;

        $this->attach()->throttle()->limit();
    }
1068839
public function delete(ConnectionInterface $con = null)
    {
        if ($this->isDeleted()) {
            throw new PropelException("This object has already been deleted.");
        }

        if ($con === null) {
            $con = Propel::getServiceContainer()->getWriteConnection(FeatureFeatureTypeTableMap::DATABASE_NAME);
        }

        $con->beginTransaction();
        try {
            $deleteQuery = ChildFeatureFeatureTypeQuery::create()
                ->filterByPrimaryKey($this->getPrimaryKey());
            $ret = $this->preDelete($con);
            if ($ret) {
                $deleteQuery->delete($con);
                $this->postDelete($con);
                $con->commit();
                $this->setDeleted(true);
            } else {
                $con->commit();
            }
        } catch (Exception $e) {
            $con->rollBack();
            throw $e;
        }
    }