Tarioch\EveapiFetcherBundle\Entity\ApiRepository

Complexity

Total Complexity

3

Size/Duplication

Total Lines	37
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

2 Methods

Rating	Name	Duplication	Size	Complexity
A	loadValidApis()	0	20	2
A	loadApiKeyInfoApi()	0	13	1

<?php
namespace Tarioch\EveapiFetcherBundle\Entity;

use Doctrine\ORM\EntityRepository;

class ApiRepository extends EntityRepository
{
    public function loadValidApis($accessMask, $keyType)
    {
        if ($keyType == 'Corporation') {
            $corpRestriction = 'a.section = :corpSection';
        } else {
            $corpRestriction = 'a.section <> :corpSection';
        }

        $qb = $this->createQueryBuilder('a');
        $q = $qb->select('a')
            ->where(
                'BIT_AND(a.mask, :accessMask) = a.mask
                and ' . $corpRestriction
            )
            ->getQuery()
            ->setParameter('accessMask', $accessMask)
            ->setParameter('corpSection', 'corp');

        return $q->getResult();
    }

    public function loadApiKeyInfoApi()
    {
        $qb = $this->createQueryBuilder('a');
        $q = $qb->select('a')
            ->where(
                'a.section = :section and a.name = :name'
            )
            ->setParameter('section', 'account')
            ->setParameter('name', 'APIKeyInfo')
            ->getQuery();

        return $q->getSingleResult();
    }
}