CRUDlex\MySQLData::setValuesAndParameters PHP Method

setValuesAndParameters() protected method

Sets the values and parameters of the upcoming given query according to the entity.
protected setValuesAndParameters ( Entity $entity, Doctrine\DBAL\Query\QueryBuilder $queryBuilder, string $setMethod )
$entity Entity the entity with its fields and values
$queryBuilder Doctrine\DBAL\Query\QueryBuilder the upcoming query
$setMethod string what method to use on the QueryBuilder: 'setValue' or 'set'
    protected function setValuesAndParameters(Entity $entity, QueryBuilder $queryBuilder, $setMethod)
    {
        $formFields = $this->getFormFields();
        $count = count($formFields);
        for ($i = 0; $i < $count; ++$i) {
            $type = $this->definition->getType($formFields[$i]);
            $value = $entity->get($formFields[$i]);
            if ($type == 'boolean') {
                $value = $value ? 1 : 0;
            }
            $queryBuilder->{$setMethod}('`' . $formFields[$i] . '`', '?');
            $queryBuilder->setParameter($i, $value);
        }
    }