PHP Query::setParameter方法代码示例

 /**
  * @param \Doctrine\ORM\Query|\Doctrine\ORM\QueryBuilder $query
  * @param array $array
  * @param string $contiene
  * @return \Doctrine\ORM\Query|\Doctrine\ORM\QueryBuilder
  */
 public function consultaContiene($query, $array, $contiene)
 {
     if ($contiene != "") {
         $fields = array_keys($this->getClassMetadata()->fieldNames);
         $alias = $query->getRootAlias();
         $count = 0;
         foreach ($array as $field) {
             $fieldMapping = $this->getClassMetadata()->getFieldForColumn($field);
             $where = sprintf("UPPER(%s.%s) LIKE :condicion", $alias, $fieldMapping);
             if ($count == 0) {
                 $query->andWhere($where);
             } else {
                 $query->orWhere($where);
             }
             $count++;
         }
         $query->setParameter("condicion", "%" . strtoupper($contiene) . "%");
     }
     return $query;
 }

 /**
  * @covers Kunstmaan\AdminBundle\Helper\Security\Acl\AclHelper::apply
  * @covers Kunstmaan\AdminBundle\Helper\Security\Acl\AclHelper::cloneQuery
  */
 public function testApplyAnonymous()
 {
     /* @var $queryBuilder QueryBuilder */
     $queryBuilder = $this->getMockBuilder('Doctrine\\ORM\\QueryBuilder')->disableOriginalConstructor()->getMock();
     $query = new Query($this->em);
     $query->setParameter('paramName', 'paramValue', 'paramType');
     $queryBuilder->expects($this->any())->method('getQuery')->will($this->returnValue($query));
     $queryBuilder->expects($this->once())->method('getRootEntities')->will($this->returnValue(array('Kunstmaan\\NodeBundle\\Entity\\Node')));
     $queryBuilder->expects($this->once())->method('getRootAliases')->will($this->returnValue(array('n')));
     $roles = array();
     $this->token->expects($this->once())->method('getRoles')->will($this->returnValue($roles));
     $this->rh->expects($this->once())->method('getReachableRoles')->with($roles)->will($this->returnValue($roles));
     $this->token->expects($this->any())->method('getUser')->will($this->returnValue('anon.'));
     $permissionDef = new PermissionDefinition(array('view'), 'Kunstmaan\\NodeBundle\\Entity\\Node');
     /* @var $query Query */
     $query = $this->object->apply($queryBuilder, $permissionDef);
     $this->assertEquals(MaskBuilder::MASK_VIEW, $query->getHint('acl.mask'));
     $this->assertEquals($permissionDef->getEntity(), $query->getHint('acl.root.entity'));
     $this->assertEquals('rootTable', $query->getHint('acl.entityRootTableName'));
     $this->assertEquals('n', $query->getHint('acl.entityRootTableDqlAlias'));
     $aclQuery = $query->getHint('acl.extra.query');
     $this->assertContains('"IS_AUTHENTICATED_ANONYMOUSLY"', $aclQuery);
 }

 /**
  * {@inheritdoc}
  */
 public function findCollectionBreadcrumbById($id)
 {
     try {
         $sql = sprintf('SELECT n, collectionMeta, defaultMeta
              FROM %s AS p,
                   %s AS n
                     LEFT JOIN n.meta AS collectionMeta
                     LEFT JOIN n.defaultMeta AS defaultMeta
              WHERE p.id = :id AND p.lft > n.lft AND p.rgt < n.rgt
              ORDER BY n.lft', $this->_entityName, $this->_entityName);
         $query = new Query($this->_em);
         $query->setDQL($sql);
         $query->setParameter('id', $id);
         return $query->getResult();
     } catch (NoResultException $ex) {
         return [];
     }
 }

 /**
  * Sets parameters for the query
  *
  * @param \Doctrine\ORM\Query $query      Query to be set parameters on
  * @param array               $parameters Variables
  *
  * @return \Doctrine\ORM\Query
  *
  * @author r1pp3rj4ck <attila.bukor@gmail.com>
  */
 private function setParameters(\Doctrine\ORM\Query $query, array $parameters)
 {
     foreach ($parameters as $name => $param) {
         $query->setParameter($name, $param['value']);
     }
     return $query;
 }

 public function testStaticApply()
 {
     $staticSegmentStub = new Segment();
     $staticSegmentStub->setType(new SegmentType(SegmentType::TYPE_STATIC));
     $filterData = ['value' => $staticSegmentStub];
     $subquery = 'SELECT ts1.entity_id FROM OroSegmentBundle:SegmentSnapshot ts1 WHERE ts1.segmentId = :segment';
     $em = $this->getTestEntityManager();
     $qb = new QueryBuilder($em);
     $qb->select(['t1.name'])->from('OroSegmentBundle:CmsUser', 't1');
     $ds = new OrmFilterDatasourceAdapter($qb);
     $query = new Query($em);
     $query->setDQL($subquery);
     $query->setParameter('segment', $staticSegmentStub);
     $this->staticSegmentQueryBuilder->expects($this->once())->method('build')->with($staticSegmentStub)->will($this->returnValue($query));
     $this->filter->init('someName', [FilterUtility::DATA_NAME_KEY => self::TEST_FIELD_NAME]);
     $this->filter->apply($ds, $filterData);
     $expectedResult = ['SELECT t1.name FROM OroSegmentBundle:CmsUser t1 WHERE t1.id', 'IN(SELECT ts1.entity_id FROM OroSegmentBundle:SegmentSnapshot ts1 WHERE ts1.segmentId = :segment)'];
     $expectedResult = implode(' ', $expectedResult);
     $this->assertEquals($expectedResult, $ds->getQueryBuilder()->getDQL());
     $params = $ds->getQueryBuilder()->getParameters();
     $this->assertCount(1, $params, 'Should pass params to main query builder');
     $this->assertEquals($staticSegmentStub, $params[0]->getValue());
 }

 /**
  * Sets params value in a query object
  *
  * @access   public
  * @param    string $sParamName
  * @param    string $mParamValue
  * @return   $this
  * @since    1.0.0-alpha
  * @version  1.0.0-alpha
  */
 public function param($sParamName, $mParamValue)
 {
     $this->oQuery->setParameter($sParamName, $mParamValue);
     return $this;
 }

 /**
  * @depends testIssue
  */
 public function testCacheMissWhenTypeChanges(Query $query)
 {
     $query->setParameter('field', 'test', 'string');
     $this->assertStringEndsWith('.field = ?', $query->getSQL());
 }

    /**
     * @route: blog_tag
     * Tag Controller
     */
    public function tagAction($slug)
    {
        $em = $this->getEm();
        $query = new Query($em);
        $query->setDQL(
            'SELECT t
                FROM Bundle\BlogBundle\Entity\Tag t WHERE t.slug = ?1'
        );
        $query->setParameter(1, $slug);
        $tag = $query->getSingleResult();

        

        return $this->render('BlogBundle:Blog:tag.html.twig', array(
            'tag' => $tag,
            'posts' => $tag->getPosts()
        ));
    }