doctrine / dbal

        self::assertEquals('SELECT u.* FROM users u', (string)$qb);

    }

    public function testCreateNamedParameter()

    {

        $qb   = new QueryBuilder($this->conn);

        $qb->select('u.*')->from('users', 'u')->where(

            $qb->expr()->eq('u.name', $qb->createNamedParameter(10, \PDO::PARAM_INT))

        );

        self::assertEquals('SELECT u.* FROM users u WHERE u.name = :dcValue1', (string)$qb);

        self::assertEquals(10, $qb->getParameter('dcValue1'));

        self::assertEquals(\PDO::PARAM_INT, $qb->getParameterType('dcValue1'));

    }

    public function testCreateNamedParameterCustomPlaceholder()

    {

        self::assertEquals(\PDO::PARAM_INT, $qb->getParameterType('dcValue1'));

    }

    public function testCreateNamedParameterCustomPlaceholder()

    {

        $qb   = new QueryBuilder($this->conn);

        $qb->select('u.*')->from('users', 'u')->where(

            $qb->expr()->eq('u.name', $qb->createNamedParameter(10, \PDO::PARAM_INT, ':test'))

        );

        self::assertEquals('SELECT u.* FROM users u WHERE u.name = :test', (string)$qb);

        self::assertEquals(10, $qb->getParameter('test'));

        self::assertEquals(\PDO::PARAM_INT, $qb->getParameterType('test'));

    }

    public function testCreatePositionalParameter()

    {

        self::assertEquals(\PDO::PARAM_INT, $qb->getParameterType('test'));

    }

    public function testCreatePositionalParameter()

    {

        $qb   = new QueryBuilder($this->conn);

        $qb->select('u.*')->from('users', 'u')->where(

            $qb->expr()->eq('u.name', $qb->createPositionalParameter(10, \PDO::PARAM_INT))

        );

        self::assertEquals('SELECT u.* FROM users u WHERE u.name = ?', (string)$qb);

        self::assertEquals(10, $qb->getParameter(1));

        self::assertEquals(\PDO::PARAM_INT, $qb->getParameterType(1));

    }

    /**

     * @group DBAL-172