Re: queries on HABTM relationships

Yes I am sure. In my case id is not numeric, the permission name is already an identifier for the permission

On Wednesday, January 2, 2013 3:56:41 PM UTC+1, Maicon Pinto wrote:

array('id'=>'can_access_admin') ????

Do you have sure is ID? Usually ID is numeric. 

Em terça-feira, 1 de janeiro de 2013 19h23min58s UTC-3, Stefano Campanella escreveu:

Hello all,

this is my first time posting here. I recently started to study how to use CakePHP and I'm trying to develop a website.

In my website I am writing a custom authorize component where each user get one or more groups and each group has one or more permissions associated to it.

I have problems in using the find() method.

This is my structure:

User hasAndBelongsToMany Group

Group hasAndBelongsToMany Perm

I have attached Containable to all the Models (in AppModel)

now in my authorization component I need to check if a group has a specific permission, and for this I use find():

if(!isset($this->controller()->Group)){
  $this->controller()->loadModel('Group');
}
$n_perm=$this->controller()->Group->find('count',array(
  'conditions'=>array('id'=>1),
  'contain'=>array(
    'Perm'=>array(
      'conditions' => array('id'=>'can_access_admin')
    )
  ) 

));

I would expect this to give me a result >=1 if group 1 has the 'can_access_admin' permission, and =0 if the group has no such permission.

This is not what actually happens, the only query that cakePHP shows is this:

SELECT COUNT(*) AS `count` FROM `groups` AS `Group` WHERE `id` = 1

And it is obviously not enough to find what I requested.

Can anyone help me?

Thanks

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com.
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.