public function insertRecordIntoIndex($fieldValues)
    {
        $queryBuilder = Db::getQueryBuilder('tx_kesearch_index');
        $addQueryPartFor = $this->getQueryPartForAdditionalFields($fieldValues);

        $queryArray = array();
        $queryArray['set'] = 'SET
			@pid = ' . $queryBuilder->quote($fieldValues['pid'], \PDO::PARAM_INT) . ',
			@title = ' . $queryBuilder->quote($fieldValues['title'], \PDO::PARAM_STR) . ',
			@type = ' . $queryBuilder->quote($fieldValues['type'], \PDO::PARAM_STR) . ',
			@targetpid = ' . $queryBuilder->quote($fieldValues['targetpid'], \PDO::PARAM_INT) . ',
			@content = ' . $queryBuilder->quote($fieldValues['content'], \PDO::PARAM_STR) . ',
			@tags = ' . $queryBuilder->quote($fieldValues['tags'], \PDO::PARAM_STR) . ',
			@params = ' . $queryBuilder->quote($fieldValues['params'], \PDO::PARAM_STR) . ',
			@abstract = ' . $queryBuilder->quote($fieldValues['abstract'], \PDO::PARAM_STR) . ',
			@language = ' . $queryBuilder->quote($fieldValues['language'], \PDO::PARAM_INT) . ',
			@starttime = ' . $queryBuilder->quote($fieldValues['starttime'], \PDO::PARAM_INT) . ',
			@endtime = ' . $queryBuilder->quote($fieldValues['endtime'], \PDO::PARAM_INT) . ',
			@fe_group = ' . $queryBuilder->quote($fieldValues['fe_group'], \PDO::PARAM_INT) . ',
			@tstamp = ' . $queryBuilder->quote($fieldValues['tstamp'], \PDO::PARAM_INT) . ',
			@crdate = ' . $queryBuilder->quote($fieldValues['crdate'], \PDO::PARAM_INT)
            . $addQueryPartFor['set'] . '
		;';

        $queryArray['execute'] = 'EXECUTE insertStmt USING '
            . '@pid, '
            . '@title, '
            . '@type, '
            . '@targetpid, '
            . '@content, '
            . '@tags, '
            . '@params, '
            . '@abstract, '
            . '@language, '
            . '@starttime, '
            . '@endtime, '
            . '@fe_group, '
            . '@tstamp, '
            . '@crdate'
            . $addQueryPartFor['execute'] . ';';

        try  {
            Db::getDatabaseConnection('tx_kesearch_index')->exec($queryArray['set']);
            Db::getDatabaseConnection('tx_kesearch_index')->exec($queryArray['execute']);
        } catch (\Exception $e) {
            $this->logger->error($e->getMessage());
        }

    }
public function insertRecordIntoIndex($fieldValues)
    {
        $queryBuilder = Db::getQueryBuilder('tx_kesearch_index');
        $addQueryPartFor = $this->getQueryPartForAdditionalFields($fieldValues);

        $queryArray = array();
        $queryArray['set'] = 'SET
			@pid = ' . $queryBuilder->quote($fieldValues['pid'], \PDO::PARAM_INT) . ',
			@title = ' . $queryBuilder->quote($fieldValues['title'], \PDO::PARAM_STR) . ',
			@type = ' . $queryBuilder->quote($fieldValues['type'], \PDO::PARAM_STR) . ',
			@targetpid = ' . $queryBuilder->quote($fieldValues['targetpid'], \PDO::PARAM_INT) . ',
			@content = ' . $queryBuilder->quote($fieldValues['content'], \PDO::PARAM_STR) . ',
			@tags = ' . $queryBuilder->quote($fieldValues['tags'], \PDO::PARAM_STR) . ',
			@params = ' . $queryBuilder->quote($fieldValues['params'], \PDO::PARAM_STR) . ',
			@abstract = ' . $queryBuilder->quote($fieldValues['abstract'], \PDO::PARAM_STR) . ',
			@language = ' . $queryBuilder->quote($fieldValues['language'], \PDO::PARAM_INT) . ',
			@starttime = ' . $queryBuilder->quote($fieldValues['starttime'], \PDO::PARAM_INT) . ',
			@endtime = ' . $queryBuilder->quote($fieldValues['endtime'], \PDO::PARAM_INT) . ',
			@fe_group = ' . $queryBuilder->quote($fieldValues['fe_group'], \PDO::PARAM_INT) . ',
			@tstamp = ' . $queryBuilder->quote($fieldValues['tstamp'], \PDO::PARAM_INT) . ',
			@crdate = ' . $queryBuilder->quote($fieldValues['crdate'], \PDO::PARAM_INT)
            . $addQueryPartFor['set'] . '
		;';

        $queryArray['execute'] = 'EXECUTE insertStmt USING '
            . '@pid, '
            . '@title, '
            . '@type, '
            . '@targetpid, '
            . '@content, '
            . '@tags, '
            . '@params, '
            . '@abstract, '
            . '@language, '
            . '@starttime, '
            . '@endtime, '
            . '@fe_group, '
            . '@tstamp, '
            . '@crdate'
            . $addQueryPartFor['execute'] . ';';

        try  {
            Db::getDatabaseConnection('tx_kesearch_index')->exec($queryArray['set']);
            Db::getDatabaseConnection('tx_kesearch_index')->exec($queryArray['execute']);
        } catch (\Exception $e) {
            $this->logger->error($e->getMessage());
        }

    }
public function insertRecordIntoIndex ( $ fieldValues ) { $ queryBuilder = Db :: getQueryBuilder ( 'tx_kesearch_index' ) ; $ addQueryPartFor = $ this -> getQueryPartForAdditionalFields ( $ fieldValues ) ; $ queryArray = array ( ) ; $ queryArray [ 'set' ] = 'SET
			@pid = ' . $ queryBuilder -> quote ( $ fieldValues [ 'pid' ] , \ PDO :: PARAM_INT ) . ',
			@title = ' . $ queryBuilder -> quote ( $ fieldValues [ 'title' ] , \ PDO :: PARAM_STR ) . ',
			@type = ' . $ queryBuilder -> quote ( $ fieldValues [ 'type' ] , \ PDO :: PARAM_STR ) . ',
			@targetpid = ' . $ queryBuilder -> quote ( $ fieldValues [ 'targetpid' ] , \ PDO :: PARAM_INT ) . ',
			@content = ' . $ queryBuilder -> quote ( $ fieldValues [ 'content' ] , \ PDO :: PARAM_STR ) . ',
			@tags = ' . $ queryBuilder -> quote ( $ fieldValues [ 'tags' ] , \ PDO :: PARAM_STR ) . ',
			@params = ' . $ queryBuilder -> quote ( $ fieldValues [ 'params' ] , \ PDO :: PARAM_STR ) . ',
			@abstract = ' . $ queryBuilder -> quote ( $ fieldValues [ 'abstract' ] , \ PDO :: PARAM_STR ) . ',
			@language = ' . $ queryBuilder -> quote ( $ fieldValues [ 'language' ] , \ PDO :: PARAM_INT ) . ',
			@starttime = ' . $ queryBuilder -> quote ( $ fieldValues [ 'starttime' ] , \ PDO :: PARAM_INT ) . ',
			@endtime = ' . $ queryBuilder -> quote ( $ fieldValues [ 'endtime' ] , \ PDO :: PARAM_INT ) . ',
			@fe_group = ' . $ queryBuilder -> quote ( $ fieldValues [ 'fe_group' ] , \ PDO :: PARAM_INT ) . ',
			@tstamp = ' . $ queryBuilder -> quote ( $ fieldValues [ 'tstamp' ] , \ PDO :: PARAM_INT ) . ',
			@crdate = ' . $ queryBuilder -> quote ( $ fieldValues [ 'crdate' ] , \ PDO :: PARAM_INT ) . $ addQueryPartFor [ 'set' ] . '
		;' ; $ queryArray [ 'execute' ] = 'EXECUTE insertStmt USING ' . '@pid, ' . '@title, ' . '@type, ' . '@targetpid, ' . '@content, ' . '@tags, ' . '@params, ' . '@abstract, ' . '@language, ' . '@starttime, ' . '@endtime, ' . '@fe_group, ' . '@tstamp, ' . '@crdate' . $ addQueryPartFor [ 'execute' ] . ';' ; try { Db :: getDatabaseConnection ( 'tx_kesearch_index' ) -> exec ( $ queryArray [ 'set' ] ) ; Db :: getDatabaseConnection ( 'tx_kesearch_index' ) -> exec ( $ queryArray [ 'execute' ] ) ; } catch ( \ Exception $ e ) { $ this -> logger -> error ( $ e -> getMessage ( ) ) ; } }
inserts a new record into the index using a prepared statement
@param $fieldValues array
inserts a new record into the index using a prepared statement