Insert the row in the database.

@param      ConnectionInterface $con

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


         // check the columns in natural order for more readable SQL queries
        if ($this->isColumnModified(FunctionPhaseTableMap::COL_ID)) {
            $modifiedColumns[':p' . $index++]  = '`id`';
        }
        if ($this->isColumnModified(FunctionPhaseTableMap::COL_TYPE)) {
            $modifiedColumns[':p' . $index++]  = '`type`';
        }
        if ($this->isColumnModified(FunctionPhaseTableMap::COL_SKILL_ID)) {
            $modifiedColumns[':p' . $index++]  = '`skill_id`';
        }
        if ($this->isColumnModified(FunctionPhaseTableMap::COL_TITLE)) {
            $modifiedColumns[':p' . $index++]  = '`title`';
        }

        $sql = sprintf(
            'INSERT INTO `kk_trixionary_function_phase` (%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 '`type`':
                        $stmt->bindValue($identifier, $this->type, PDO::PARAM_STR);
                        break;
                    case '`skill_id`':
                        $stmt->bindValue($identifier, $this->skill_id, PDO::PARAM_INT);
                        break;
                    case '`title`':
                        $stmt->bindValue($identifier, $this->title, 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);
    }
1325338
protected function doInsert(ConnectionInterface $con)
    {
        $modifiedColumns = array();
        $index = 0;

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

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

        try {
            $stmt = $con->prepare($sql);
            foreach ($modifiedColumns as $identifier => $columnName) {
                switch ($columnName) {
                    case 'CODE':
                        $stmt->bindValue($identifier, $this->code, PDO::PARAM_STR);
                        break;
                    case 'ATOS_CODE':
                        $stmt->bindValue($identifier, $this->atos_code, PDO::PARAM_INT);
                        break;
                    case 'DECIMALS':
                        $stmt->bindValue($identifier, $this->decimals, 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);
    }
525773
public function updateSkillCount(ConnectionInterface $con)
    {
        $this->setSkillCount($this->computeSkillCount($con));
        $this->save($con);
    }
1312962
protected function doInsert(PropelPDO $con)
    {
        $modifiedColumns = array();
        $index = 0;

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

         // check the columns in natural order for more readable SQL queries
        if ($this->isColumnModified(ApiLogPeer::ID)) {
            $modifiedColumns[':p' . $index++]  = '`id`';
        }
        if ($this->isColumnModified(ApiLogPeer::DT_CALL)) {
            $modifiedColumns[':p' . $index++]  = '`dt_call`';
        }
        if ($this->isColumnModified(ApiLogPeer::REMOTE_APP_ID)) {
            $modifiedColumns[':p' . $index++]  = '`remote_app_id`';
        }
        if ($this->isColumnModified(ApiLogPeer::STATUSCODE)) {
            $modifiedColumns[':p' . $index++]  = '`statuscode`';
        }
        if ($this->isColumnModified(ApiLogPeer::LAST_RESPONSE)) {
            $modifiedColumns[':p' . $index++]  = '`last_response`';
        }

        $sql = sprintf(
            'INSERT INTO `api_log` (%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 '`dt_call`':
                        $stmt->bindValue($identifier, $this->dt_call, PDO::PARAM_STR);
                        break;
                    case '`remote_app_id`':
                        $stmt->bindValue($identifier, $this->remote_app_id, PDO::PARAM_INT);
                        break;
                    case '`statuscode`':
                        $stmt->bindValue($identifier, $this->statuscode, PDO::PARAM_INT);
                        break;
                    case '`last_response`':
                        if (is_resource($this->last_response)) {
                            rewind($this->last_response);
                        }
                        $stmt->bindValue($identifier, $this->last_response, PDO::PARAM_LOB);
                        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);
    }
481367
public function makeInsert(string $connectionName = ''): InsertQueryBuilder
    {
        $connection = $this->provideConnection($connectionName);
        $statementBuilder = new InsertStatementBuilder;
        return new InsertQueryBuilder($connection, $statementBuilder);
    }
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);
    }
1342678
protected function doInsert(ConnectionInterface $con)
    {
        $modifiedColumns = array();
        $index = 0;


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

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

        try {
            $stmt = $con->prepare($sql);
            foreach ($modifiedColumns as $identifier => $columnName) {
                switch ($columnName) {
                    case 'media_id':
                        $stmt->bindValue($identifier, $this->media_id, PDO::PARAM_INT);
                        break;
                    case 'page_id':
                        $stmt->bindValue($identifier, $this->page_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);
    }
137157
protected function doInsert(ConnectionInterface $con)
    {
        $modifiedColumns = array();
        $index = 0;

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

         // check the columns in natural order for more readable SQL queries
        if ($this->isColumnModified(MapratingTableMap::COL_ID)) {
            $modifiedColumns[':p' . $index++]  = 'id';
        }
        if ($this->isColumnModified(MapratingTableMap::COL_LOGIN)) {
            $modifiedColumns[':p' . $index++]  = 'login';
        }
        if ($this->isColumnModified(MapratingTableMap::COL_MAPUID)) {
            $modifiedColumns[':p' . $index++]  = 'mapUid';
        }
        if ($this->isColumnModified(MapratingTableMap::COL_SCORE)) {
            $modifiedColumns[':p' . $index++]  = 'score';
        }
        if ($this->isColumnModified(MapratingTableMap::COL_CREATED_AT)) {
            $modifiedColumns[':p' . $index++]  = 'created_at';
        }
        if ($this->isColumnModified(MapratingTableMap::COL_UPDATED_AT)) {
            $modifiedColumns[':p' . $index++]  = 'updated_at';
        }

        $sql = sprintf(
            'INSERT INTO maprating (%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 'login':
                        $stmt->bindValue($identifier, $this->login, PDO::PARAM_STR);
                        break;
                    case 'mapUid':
                        $stmt->bindValue($identifier, $this->mapuid, PDO::PARAM_STR);
                        break;
                    case 'score':
                        $stmt->bindValue($identifier, $this->score, PDO::PARAM_INT);
                        break;
                    case 'created_at':
                        $stmt->bindValue($identifier, $this->created_at ? $this->created_at->format("Y-m-d H:i:s.u") : null, PDO::PARAM_STR);
                        break;
                    case 'updated_at':
                        $stmt->bindValue($identifier, $this->updated_at ? $this->updated_at->format("Y-m-d H:i:s.u") : 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);
    }
179369
protected function doInsert(ConnectionInterface $con)
    {
        $modifiedColumns = array();
        $index = 0;

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

         // check the columns in natural order for more readable SQL queries
        if ($this->isColumnModified(UserTableMap::COL_ID)) {
            $modifiedColumns[':p' . $index++]  = 'ID';
        }
        if ($this->isColumnModified(UserTableMap::COL_USERNAME)) {
            $modifiedColumns[':p' . $index++]  = 'USERNAME';
        }
        if ($this->isColumnModified(UserTableMap::COL_PASSWORD)) {
            $modifiedColumns[':p' . $index++]  = 'PASSWORD';
        }
        if ($this->isColumnModified(UserTableMap::COL_FIRST_NAME)) {
            $modifiedColumns[':p' . $index++]  = 'FIRST_NAME';
        }
        if ($this->isColumnModified(UserTableMap::COL_LAST_NAME)) {
            $modifiedColumns[':p' . $index++]  = 'LAST_NAME';
        }
        if ($this->isColumnModified(UserTableMap::COL_CREATE_DATE)) {
            $modifiedColumns[':p' . $index++]  = 'CREATE_DATE';
        }
        if ($this->isColumnModified(UserTableMap::COL_UPDATE_DATE)) {
            $modifiedColumns[':p' . $index++]  = 'UPDATE_DATE';
        }
        if ($this->isColumnModified(UserTableMap::COL_STATUS)) {
            $modifiedColumns[':p' . $index++]  = 'STATUS';
        }

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

        try {
            $stmt = $con->prepare($sql);
            foreach ($modifiedColumns as $identifier => $columnName) {
                switch ($columnName) {
                    case 'ID':
                        $stmt->bindValue($identifier, $this->id, PDO::PARAM_INT);
                        break;
                    case 'USERNAME':
                        $stmt->bindValue($identifier, $this->username, PDO::PARAM_STR);
                        break;
                    case 'PASSWORD':
                        $stmt->bindValue($identifier, $this->password, PDO::PARAM_STR);
                        break;
                    case 'FIRST_NAME':
                        $stmt->bindValue($identifier, $this->first_name, PDO::PARAM_STR);
                        break;
                    case 'LAST_NAME':
                        $stmt->bindValue($identifier, $this->last_name, PDO::PARAM_STR);
                        break;
                    case 'CREATE_DATE':
                        $stmt->bindValue($identifier, $this->create_date ? $this->create_date->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
                        break;
                    case 'UPDATE_DATE':
                        $stmt->bindValue($identifier, $this->update_date ? $this->update_date->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
                        break;
                    case 'STATUS':
                        $stmt->bindValue($identifier, $this->status, PDO::PARAM_STR);
                        break;
                }
            }
            $stmt->execute();
        } catch (Exception $e) {
            Propel::log($e->getMessage(), Propel::LOG_ERR);
            throw new PropelException(sprintf('Unable to execute INSERT statement [%s]', $sql), 0, $e);
        }

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

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

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

         // check the columns in natural order for more readable SQL queries
        if ($this->isColumnModified(RemoteAppPeer::ID)) {
            $modifiedColumns[':p' . $index++]  = '`id`';
        }
        if ($this->isColumnModified(RemoteAppPeer::TYPE)) {
            $modifiedColumns[':p' . $index++]  = '`type`';
        }
        if ($this->isColumnModified(RemoteAppPeer::NAME)) {
            $modifiedColumns[':p' . $index++]  = '`name`';
        }
        if ($this->isColumnModified(RemoteAppPeer::DOMAIN)) {
            $modifiedColumns[':p' . $index++]  = '`domain`';
        }
        if ($this->isColumnModified(RemoteAppPeer::API_URL)) {
            $modifiedColumns[':p' . $index++]  = '`api_url`';
        }
        if ($this->isColumnModified(RemoteAppPeer::API_AUTH_HTTP_USER)) {
            $modifiedColumns[':p' . $index++]  = '`api_auth_http_user`';
        }
        if ($this->isColumnModified(RemoteAppPeer::API_AUTH_HTTP_PASSWORD)) {
            $modifiedColumns[':p' . $index++]  = '`api_auth_http_password`';
        }
        if ($this->isColumnModified(RemoteAppPeer::API_AUTH_TYPE)) {
            $modifiedColumns[':p' . $index++]  = '`api_auth_type`';
        }
        if ($this->isColumnModified(RemoteAppPeer::API_AUTH_USER)) {
            $modifiedColumns[':p' . $index++]  = '`api_auth_user`';
        }
        if ($this->isColumnModified(RemoteAppPeer::API_AUTH_PASSWORD)) {
            $modifiedColumns[':p' . $index++]  = '`api_auth_password`';
        }
        if ($this->isColumnModified(RemoteAppPeer::API_AUTH_TOKEN)) {
            $modifiedColumns[':p' . $index++]  = '`api_auth_token`';
        }
        if ($this->isColumnModified(RemoteAppPeer::API_AUTH_URL_USER_KEY)) {
            $modifiedColumns[':p' . $index++]  = '`api_auth_url_user_key`';
        }
        if ($this->isColumnModified(RemoteAppPeer::API_AUTH_URL_PW_KEY)) {
            $modifiedColumns[':p' . $index++]  = '`api_auth_url_pw_key`';
        }
        if ($this->isColumnModified(RemoteAppPeer::CRON)) {
            $modifiedColumns[':p' . $index++]  = '`cron`';
        }
        if ($this->isColumnModified(RemoteAppPeer::CUSTOMER_ID)) {
            $modifiedColumns[':p' . $index++]  = '`customer_id`';
        }
        if ($this->isColumnModified(RemoteAppPeer::ACTIVATED)) {
            $modifiedColumns[':p' . $index++]  = '`activated`';
        }
        if ($this->isColumnModified(RemoteAppPeer::NOTES)) {
            $modifiedColumns[':p' . $index++]  = '`notes`';
        }
        if ($this->isColumnModified(RemoteAppPeer::LAST_RUN)) {
            $modifiedColumns[':p' . $index++]  = '`last_run`';
        }
        if ($this->isColumnModified(RemoteAppPeer::INCLUDELOG)) {
            $modifiedColumns[':p' . $index++]  = '`includeLog`';
        }
        if ($this->isColumnModified(RemoteAppPeer::PUBLIC_KEY)) {
            $modifiedColumns[':p' . $index++]  = '`public_key`';
        }
        if ($this->isColumnModified(RemoteAppPeer::WEBSITE_HASH)) {
            $modifiedColumns[':p' . $index++]  = '`website_hash`';
        }
        if ($this->isColumnModified(RemoteAppPeer::NOTIFICATION_RECIPIENT)) {
            $modifiedColumns[':p' . $index++]  = '`notification_recipient`';
        }
        if ($this->isColumnModified(RemoteAppPeer::NOTIFICATION_SENDER)) {
            $modifiedColumns[':p' . $index++]  = '`notification_sender`';
        }
        if ($this->isColumnModified(RemoteAppPeer::NOTIFICATION_CHANGE)) {
            $modifiedColumns[':p' . $index++]  = '`notification_change`';
        }
        if ($this->isColumnModified(RemoteAppPeer::NOTIFICATION_ERROR)) {
            $modifiedColumns[':p' . $index++]  = '`notification_error`';
        }

        $sql = sprintf(
            'INSERT INTO `remote_app` (%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 '`type`':
                        $stmt->bindValue($identifier, $this->type, PDO::PARAM_STR);
                        break;
                    case '`name`':
                        $stmt->bindValue($identifier, $this->name, PDO::PARAM_STR);
                        break;
                    case '`domain`':
                        $stmt->bindValue($identifier, $this->domain, PDO::PARAM_STR);
                        break;
                    case '`api_url`':
                        $stmt->bindValue($identifier, $this->api_url, PDO::PARAM_STR);
                        break;
                    case '`api_auth_http_user`':
                        $stmt->bindValue($identifier, $this->api_auth_http_user, PDO::PARAM_STR);
                        break;
                    case '`api_auth_http_password`':
                        $stmt->bindValue($identifier, $this->api_auth_http_password, PDO::PARAM_STR);
                        break;
                    case '`api_auth_type`':
                        $stmt->bindValue($identifier, $this->api_auth_type, PDO::PARAM_STR);
                        break;
                    case '`api_auth_user`':
                        $stmt->bindValue($identifier, $this->api_auth_user, PDO::PARAM_STR);
                        break;
                    case '`api_auth_password`':
                        $stmt->bindValue($identifier, $this->api_auth_password, PDO::PARAM_STR);
                        break;
                    case '`api_auth_token`':
                        $stmt->bindValue($identifier, $this->api_auth_token, PDO::PARAM_STR);
                        break;
                    case '`api_auth_url_user_key`':
                        $stmt->bindValue($identifier, $this->api_auth_url_user_key, PDO::PARAM_STR);
                        break;
                    case '`api_auth_url_pw_key`':
                        $stmt->bindValue($identifier, $this->api_auth_url_pw_key, PDO::PARAM_STR);
                        break;
                    case '`cron`':
                        $stmt->bindValue($identifier, $this->cron, PDO::PARAM_STR);
                        break;
                    case '`customer_id`':
                        $stmt->bindValue($identifier, $this->customer_id, PDO::PARAM_INT);
                        break;
                    case '`activated`':
                        $stmt->bindValue($identifier, (int) $this->activated, PDO::PARAM_INT);
                        break;
                    case '`notes`':
                        $stmt->bindValue($identifier, $this->notes, PDO::PARAM_STR);
                        break;
                    case '`last_run`':
                        $stmt->bindValue($identifier, $this->last_run, PDO::PARAM_STR);
                        break;
                    case '`includeLog`':
                        $stmt->bindValue($identifier, (int) $this->includelog, PDO::PARAM_INT);
                        break;
                    case '`public_key`':
                        $stmt->bindValue($identifier, $this->public_key, PDO::PARAM_STR);
                        break;
                    case '`website_hash`':
                        $stmt->bindValue($identifier, $this->website_hash, PDO::PARAM_STR);
                        break;
                    case '`notification_recipient`':
                        $stmt->bindValue($identifier, $this->notification_recipient, PDO::PARAM_STR);
                        break;
                    case '`notification_sender`':
                        $stmt->bindValue($identifier, $this->notification_sender, PDO::PARAM_STR);
                        break;
                    case '`notification_change`':
                        $stmt->bindValue($identifier, (int) $this->notification_change, PDO::PARAM_INT);
                        break;
                    case '`notification_error`':
                        $stmt->bindValue($identifier, (int) $this->notification_error, PDO::PARAM_INT);
                        break;
                }
            }
            $stmt->execute();
        } catch (Exception $e) {
            Propel::log($e->getMessage(), Propel::LOG_ERR);
            throw new PropelException(sprintf('Unable to execute INSERT statement [%s]', $sql), $e);
        }

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

        $this->setNew(false);
    }
407668
protected function updateRelatedGroupSkillCount(ConnectionInterface $con)
    {
        if ($group = $this->getGroup()) {
            $group->updateSkillCount($con);
        }
        if ($this->oldGroupSkillCount) {
            $this->oldGroupSkillCount->updateSkillCount($con);
            $this->oldGroupSkillCount = null;
        }
    }
518576
protected function doInsert(ConnectionInterface $con)
    {
        $modifiedColumns = array();
        $index = 0;


         // check the columns in natural order for more readable SQL queries
        if ($this->isColumnModified(DealerVersionTableMap::ID)) {
            $modifiedColumns[':p' . $index++]  = 'ID';
        }
        if ($this->isColumnModified(DealerVersionTableMap::VISIBLE)) {
            $modifiedColumns[':p' . $index++]  = 'VISIBLE';
        }
        if ($this->isColumnModified(DealerVersionTableMap::ADDRESS1)) {
            $modifiedColumns[':p' . $index++]  = 'ADDRESS1';
        }
        if ($this->isColumnModified(DealerVersionTableMap::ADDRESS2)) {
            $modifiedColumns[':p' . $index++]  = 'ADDRESS2';
        }
        if ($this->isColumnModified(DealerVersionTableMap::ADDRESS3)) {
            $modifiedColumns[':p' . $index++]  = 'ADDRESS3';
        }
        if ($this->isColumnModified(DealerVersionTableMap::ZIPCODE)) {
            $modifiedColumns[':p' . $index++]  = 'ZIPCODE';
        }
        if ($this->isColumnModified(DealerVersionTableMap::CITY)) {
            $modifiedColumns[':p' . $index++]  = 'CITY';
        }
        if ($this->isColumnModified(DealerVersionTableMap::COUNTRY_ID)) {
            $modifiedColumns[':p' . $index++]  = 'COUNTRY_ID';
        }
        if ($this->isColumnModified(DealerVersionTableMap::LATITUDE)) {
            $modifiedColumns[':p' . $index++]  = 'LATITUDE';
        }
        if ($this->isColumnModified(DealerVersionTableMap::LONGITUDE)) {
            $modifiedColumns[':p' . $index++]  = 'LONGITUDE';
        }
        if ($this->isColumnModified(DealerVersionTableMap::CREATED_AT)) {
            $modifiedColumns[':p' . $index++]  = 'CREATED_AT';
        }
        if ($this->isColumnModified(DealerVersionTableMap::UPDATED_AT)) {
            $modifiedColumns[':p' . $index++]  = 'UPDATED_AT';
        }
        if ($this->isColumnModified(DealerVersionTableMap::VERSION)) {
            $modifiedColumns[':p' . $index++]  = 'VERSION';
        }
        if ($this->isColumnModified(DealerVersionTableMap::VERSION_CREATED_AT)) {
            $modifiedColumns[':p' . $index++]  = 'VERSION_CREATED_AT';
        }
        if ($this->isColumnModified(DealerVersionTableMap::VERSION_CREATED_BY)) {
            $modifiedColumns[':p' . $index++]  = 'VERSION_CREATED_BY';
        }
        if ($this->isColumnModified(DealerVersionTableMap::DEALER_SHEDULES_IDS)) {
            $modifiedColumns[':p' . $index++]  = 'DEALER_SHEDULES_IDS';
        }
        if ($this->isColumnModified(DealerVersionTableMap::DEALER_SHEDULES_VERSIONS)) {
            $modifiedColumns[':p' . $index++]  = 'DEALER_SHEDULES_VERSIONS';
        }
        if ($this->isColumnModified(DealerVersionTableMap::DEALER_CONTACT_IDS)) {
            $modifiedColumns[':p' . $index++]  = 'DEALER_CONTACT_IDS';
        }
        if ($this->isColumnModified(DealerVersionTableMap::DEALER_CONTACT_VERSIONS)) {
            $modifiedColumns[':p' . $index++]  = 'DEALER_CONTACT_VERSIONS';
        }
        if ($this->isColumnModified(DealerVersionTableMap::DEALER_CONTENT_IDS)) {
            $modifiedColumns[':p' . $index++]  = 'DEALER_CONTENT_IDS';
        }
        if ($this->isColumnModified(DealerVersionTableMap::DEALER_CONTENT_VERSIONS)) {
            $modifiedColumns[':p' . $index++]  = 'DEALER_CONTENT_VERSIONS';
        }
        if ($this->isColumnModified(DealerVersionTableMap::DEALER_FOLDER_IDS)) {
            $modifiedColumns[':p' . $index++]  = 'DEALER_FOLDER_IDS';
        }
        if ($this->isColumnModified(DealerVersionTableMap::DEALER_FOLDER_VERSIONS)) {
            $modifiedColumns[':p' . $index++]  = 'DEALER_FOLDER_VERSIONS';
        }
        if ($this->isColumnModified(DealerVersionTableMap::DEALER_BRAND_IDS)) {
            $modifiedColumns[':p' . $index++]  = 'DEALER_BRAND_IDS';
        }
        if ($this->isColumnModified(DealerVersionTableMap::DEALER_BRAND_VERSIONS)) {
            $modifiedColumns[':p' . $index++]  = 'DEALER_BRAND_VERSIONS';
        }
        if ($this->isColumnModified(DealerVersionTableMap::DEALER_PRODUCT_IDS)) {
            $modifiedColumns[':p' . $index++]  = 'DEALER_PRODUCT_IDS';
        }
        if ($this->isColumnModified(DealerVersionTableMap::DEALER_PRODUCT_VERSIONS)) {
            $modifiedColumns[':p' . $index++]  = 'DEALER_PRODUCT_VERSIONS';
        }
        if ($this->isColumnModified(DealerVersionTableMap::DEALER_ADMIN_IDS)) {
            $modifiedColumns[':p' . $index++]  = 'DEALER_ADMIN_IDS';
        }
        if ($this->isColumnModified(DealerVersionTableMap::DEALER_ADMIN_VERSIONS)) {
            $modifiedColumns[':p' . $index++]  = 'DEALER_ADMIN_VERSIONS';
        }

        $sql = sprintf(
            'INSERT INTO dealer_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 'VISIBLE':
                        $stmt->bindValue($identifier, $this->visible, PDO::PARAM_INT);
                        break;
                    case 'ADDRESS1':
                        $stmt->bindValue($identifier, $this->address1, PDO::PARAM_STR);
                        break;
                    case 'ADDRESS2':
                        $stmt->bindValue($identifier, $this->address2, PDO::PARAM_STR);
                        break;
                    case 'ADDRESS3':
                        $stmt->bindValue($identifier, $this->address3, PDO::PARAM_STR);
                        break;
                    case 'ZIPCODE':
                        $stmt->bindValue($identifier, $this->zipcode, 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 'LATITUDE':
                        $stmt->bindValue($identifier, $this->latitude, PDO::PARAM_STR);
                        break;
                    case 'LONGITUDE':
                        $stmt->bindValue($identifier, $this->longitude, PDO::PARAM_STR);
                        break;
                    case 'CREATED_AT':
                        $stmt->bindValue($identifier, $this->created_at ? $this->created_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
                        break;
                    case 'UPDATED_AT':
                        $stmt->bindValue($identifier, $this->updated_at ? $this->updated_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
                        break;
                    case 'VERSION':
                        $stmt->bindValue($identifier, $this->version, PDO::PARAM_INT);
                        break;
                    case 'VERSION_CREATED_AT':
                        $stmt->bindValue($identifier, $this->version_created_at ? $this->version_created_at->format("Y-m-d H:i:s") : null, PDO::PARAM_STR);
                        break;
                    case 'VERSION_CREATED_BY':
                        $stmt->bindValue($identifier, $this->version_created_by, PDO::PARAM_STR);
                        break;
                    case 'DEALER_SHEDULES_IDS':
                        $stmt->bindValue($identifier, $this->dealer_shedules_ids, PDO::PARAM_STR);
                        break;
                    case 'DEALER_SHEDULES_VERSIONS':
                        $stmt->bindValue($identifier, $this->dealer_shedules_versions, PDO::PARAM_STR);
                        break;
                    case 'DEALER_CONTACT_IDS':
                        $stmt->bindValue($identifier, $this->dealer_contact_ids, PDO::PARAM_STR);
                        break;
                    case 'DEALER_CONTACT_VERSIONS':
                        $stmt->bindValue($identifier, $this->dealer_contact_versions, PDO::PARAM_STR);
                        break;
                    case 'DEALER_CONTENT_IDS':
                        $stmt->bindValue($identifier, $this->dealer_content_ids, PDO::PARAM_STR);
                        break;
                    case 'DEALER_CONTENT_VERSIONS':
                        $stmt->bindValue($identifier, $this->dealer_content_versions, PDO::PARAM_STR);
                        break;
                    case 'DEALER_FOLDER_IDS':
                        $stmt->bindValue($identifier, $this->dealer_folder_ids, PDO::PARAM_STR);
                        break;
                    case 'DEALER_FOLDER_VERSIONS':
                        $stmt->bindValue($identifier, $this->dealer_folder_versions, PDO::PARAM_STR);
                        break;
                    case 'DEALER_BRAND_IDS':
                        $stmt->bindValue($identifier, $this->dealer_brand_ids, PDO::PARAM_STR);
                        break;
                    case 'DEALER_BRAND_VERSIONS':
                        $stmt->bindValue($identifier, $this->dealer_brand_versions, PDO::PARAM_STR);
                        break;
                    case 'DEALER_PRODUCT_IDS':
                        $stmt->bindValue($identifier, $this->dealer_product_ids, PDO::PARAM_STR);
                        break;
                    case 'DEALER_PRODUCT_VERSIONS':
                        $stmt->bindValue($identifier, $this->dealer_product_versions, PDO::PARAM_STR);
                        break;
                    case 'DEALER_ADMIN_IDS':
                        $stmt->bindValue($identifier, $this->dealer_admin_ids, PDO::PARAM_STR);
                        break;
                    case 'DEALER_ADMIN_VERSIONS':
                        $stmt->bindValue($identifier, $this->dealer_admin_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);
    }
846738
protected function updateRelatedObjectSkillCount(ConnectionInterface $con)
    {
        if ($object = $this->getObject()) {
            $object->updateSkillCount($con);
        }
        if ($this->oldObjectSkillCount) {
            $this->oldObjectSkillCount->updateSkillCount($con);
            $this->oldObjectSkillCount = null;
        }
    }
744132
protected function doInsert(ConnectionInterface $con)
    {
        $modifiedColumns = array();
        $index = 0;

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

         // check the columns in natural order for more readable SQL queries
        if ($this->isColumnModified(IndexEngineIndexTableMap::ID)) {
            $modifiedColumns[':p'.$index++]  = 'ID';
        }
        if ($this->isColumnModified(IndexEngineIndexTableMap::VISIBLE)) {
            $modifiedColumns[':p'.$index++]  = 'VISIBLE';
        }
        if ($this->isColumnModified(IndexEngineIndexTableMap::CODE)) {
            $modifiedColumns[':p'.$index++]  = 'CODE';
        }
        if ($this->isColumnModified(IndexEngineIndexTableMap::TITLE)) {
            $modifiedColumns[':p'.$index++]  = 'TITLE';
        }
        if ($this->isColumnModified(IndexEngineIndexTableMap::TYPE)) {
            $modifiedColumns[':p'.$index++]  = 'TYPE';
        }
        if ($this->isColumnModified(IndexEngineIndexTableMap::ENTITY)) {
            $modifiedColumns[':p'.$index++]  = 'ENTITY';
        }
        if ($this->isColumnModified(IndexEngineIndexTableMap::SERIALIZED_COLUMNS)) {
            $modifiedColumns[':p'.$index++]  = 'SERIALIZED_COLUMNS';
        }
        if ($this->isColumnModified(IndexEngineIndexTableMap::SERIALIZED_CONDITION)) {
            $modifiedColumns[':p'.$index++]  = 'SERIALIZED_CONDITION';
        }
        if ($this->isColumnModified(IndexEngineIndexTableMap::INDEX_ENGINE_DRIVER_CONFIGURATION_ID)) {
            $modifiedColumns[':p'.$index++]  = 'INDEX_ENGINE_DRIVER_CONFIGURATION_ID';
        }
        if ($this->isColumnModified(IndexEngineIndexTableMap::CREATED_AT)) {
            $modifiedColumns[':p'.$index++]  = 'CREATED_AT';
        }
        if ($this->isColumnModified(IndexEngineIndexTableMap::UPDATED_AT)) {
            $modifiedColumns[':p'.$index++]  = 'UPDATED_AT';
        }
        if ($this->isColumnModified(IndexEngineIndexTableMap::VERSION)) {
            $modifiedColumns[':p'.$index++]  = 'VERSION';
        }
        if ($this->isColumnModified(IndexEngineIndexTableMap::VERSION_CREATED_AT)) {
            $modifiedColumns[':p'.$index++]  = 'VERSION_CREATED_AT';
        }
        if ($this->isColumnModified(IndexEngineIndexTableMap::VERSION_CREATED_BY)) {
            $modifiedColumns[':p'.$index++]  = 'VERSION_CREATED_BY';
        }

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

        try {
            $stmt = $con->prepare($sql);
            foreach ($modifiedColumns as $identifier => $columnName) {
                switch ($columnName) {
                    case 'ID':
                        $stmt->bindValue($identifier, $this->id, PDO::PARAM_INT);
                        break;
                    case 'VISIBLE':
                        $stmt->bindValue($identifier, $this->visible, PDO::PARAM_INT);
                        break;
                    case 'CODE':
                        $stmt->bindValue($identifier, $this->code, PDO::PARAM_STR);
                        break;
                    case 'TITLE':
                        $stmt->bindValue($identifier, $this->title, PDO::PARAM_STR);
                        break;
                    case 'TYPE':
                        $stmt->bindValue($identifier, $this->type, PDO::PARAM_STR);
                        break;
                    case 'ENTITY':
                        $stmt->bindValue($identifier, $this->entity, PDO::PARAM_STR);
                        break;
                    case 'SERIALIZED_COLUMNS':
                        $stmt->bindValue($identifier, $this->serialized_columns, PDO::PARAM_STR);
                        break;
                    case 'SERIALIZED_CONDITION':
                        $stmt->bindValue($identifier, $this->serialized_condition, PDO::PARAM_STR);
                        break;
                    case 'INDEX_ENGINE_DRIVER_CONFIGURATION_ID':
                        $stmt->bindValue($identifier, $this->index_engine_driver_configuration_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;
                }
            }
            $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);
    }
834770
protected function doInsert(ConnectionInterface $con)
    {
        $modifiedColumns = array();
        $index = 0;


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

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

        try {
            $stmt = $con->prepare($sql);
            foreach ($modifiedColumns as $identifier => $columnName) {
                switch ($columnName) {
                    case 'ID':
                        $stmt->bindValue($identifier, $this->id, PDO::PARAM_INT);
                        break;
                    case 'LOCALE':
                        $stmt->bindValue($identifier, $this->locale, PDO::PARAM_STR);
                        break;
                    case 'LABEL':
                        $stmt->bindValue($identifier, $this->label, 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);
    }
1282675
protected function doInsert(ConnectionInterface $con)
    {
        $modifiedColumns = array();
        $index = 0;


         // check the columns in natural order for more readable SQL queries
        if ($this->isColumnModified(SkillPartTableMap::COL_PART_ID)) {
            $modifiedColumns[':p' . $index++]  = '`part_id`';
        }
        if ($this->isColumnModified(SkillPartTableMap::COL_COMPOSITE_ID)) {
            $modifiedColumns[':p' . $index++]  = '`composite_id`';
        }

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

        try {
            $stmt = $con->prepare($sql);
            foreach ($modifiedColumns as $identifier => $columnName) {
                switch ($columnName) {
                    case '`part_id`':
                        $stmt->bindValue($identifier, $this->part_id, PDO::PARAM_INT);
                        break;
                    case '`composite_id`':
                        $stmt->bindValue($identifier, $this->composite_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);
    }
666039
protected function doInsert(ConnectionInterface $con)
    {
        $modifiedColumns = array();
        $index = 0;

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

         // check the columns in natural order for more readable SQL queries
        if ($this->isColumnModified(PageTableMap::COL_ID)) {
            $modifiedColumns[':p' . $index++]  = 'id';
        }
        if ($this->isColumnModified(PageTableMap::COL_SOURCE_ID)) {
            $modifiedColumns[':p' . $index++]  = 'source_id';
        }
        if ($this->isColumnModified(PageTableMap::COL_PAGEID)) {
            $modifiedColumns[':p' . $index++]  = 'pageid';
        }
        if ($this->isColumnModified(PageTableMap::COL_TITLE)) {
            $modifiedColumns[':p' . $index++]  = 'title';
        }
        if ($this->isColumnModified(PageTableMap::COL_DISPLAYTITLE)) {
            $modifiedColumns[':p' . $index++]  = 'displaytitle';
        }
        if ($this->isColumnModified(PageTableMap::COL_PAGE_IMAGE_FREE)) {
            $modifiedColumns[':p' . $index++]  = 'page_image_free';
        }
        if ($this->isColumnModified(PageTableMap::COL_WIKIBASE_ITEM)) {
            $modifiedColumns[':p' . $index++]  = 'wikibase_item';
        }
        if ($this->isColumnModified(PageTableMap::COL_DISAMBIGUATION)) {
            $modifiedColumns[':p' . $index++]  = 'disambiguation';
        }
        if ($this->isColumnModified(PageTableMap::COL_DEFAULTSORT)) {
            $modifiedColumns[':p' . $index++]  = 'defaultsort';
        }
        if ($this->isColumnModified(PageTableMap::COL_CREATED_AT)) {
            $modifiedColumns[':p' . $index++]  = 'created_at';
        }
        if ($this->isColumnModified(PageTableMap::COL_UPDATED_AT)) {
            $modifiedColumns[':p' . $index++]  = 'updated_at';
        }

        $sql = sprintf(
            'INSERT INTO page (%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 'source_id':
                        $stmt->bindValue($identifier, $this->source_id, PDO::PARAM_INT);
                        break;
                    case 'pageid':
                        $stmt->bindValue($identifier, $this->pageid, PDO::PARAM_INT);
                        break;
                    case 'title':
                        $stmt->bindValue($identifier, $this->title, PDO::PARAM_STR);
                        break;
                    case 'displaytitle':
                        $stmt->bindValue($identifier, $this->displaytitle, PDO::PARAM_STR);
                        break;
                    case 'page_image_free':
                        $stmt->bindValue($identifier, $this->page_image_free, PDO::PARAM_STR);
                        break;
                    case 'wikibase_item':
                        $stmt->bindValue($identifier, $this->wikibase_item, PDO::PARAM_STR);
                        break;
                    case 'disambiguation':
                        $stmt->bindValue($identifier, $this->disambiguation, PDO::PARAM_STR);
                        break;
                    case 'defaultsort':
                        $stmt->bindValue($identifier, $this->defaultsort, PDO::PARAM_STR);
                        break;
                    case 'created_at':
                        $stmt->bindValue($identifier, $this->created_at ? $this->created_at->format("Y-m-d H:i:s.u") : null, PDO::PARAM_STR);
                        break;
                    case 'updated_at':
                        $stmt->bindValue($identifier, $this->updated_at ? $this->updated_at->format("Y-m-d H:i:s.u") : 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);
    }