doctrine-dbal-util / connection

{

    use ConnectionAbstractTrait;

    public function getWhereAndTraversable($table, array $where)

    // url/show

    {

        $qb = $this->getConnection()->createQueryBuilder();

        return $qb

            ->select('*')

            ->from($table)

            ->where(call_user_func_array([$qb->expr(), 'andX'],

                array_map(

                    [$qb->expr(), 'eq'],

                    array_keys($where),

                    array_map([$qb, 'createNamedParameter'], array_values($where))

                )

            ))

            ->execute();

        // TODO: check if $stmt should be ->execute() like in getByUnique

    }

    public function findUniqueBy($table, array $where)

    {

        $qb->execute();

    }

    public function deleteByUnique($table, array $id)

    { // TODO: assert unicity of index

        $qb = $this->getConnection()->createQueryBuilder();

        $qb

            ->delete($table)

            ->where(call_user_func_array([$qb->expr(), 'andX'],

                array_map(

                    [$qb->expr(), 'eq'],

                    array_keys($id),

                    array_map([$qb, 'createNamedParameter'], array_values($id))

                )

            ))

            ->execute()

        ;

    }

    public function getManyToManyTraversable($base_table, $base_id, $link_base_id, $link_table, $link_distant_id, $distant_id, $distant_table, array $unique)

    // url/show