Hi,
to get the friends of a user i have a table like this:
AmigoUsuario:
columns:
user1_id:
type: integer(4)
user2_id:
type: integer(4)
estado:
type: integer
default: 0
relations:
User1:
class: Usuario
local: user1_id
foreignAlias: AmigosUsuario
onDelete: CASCADE
User2:
class: Usuario
local: user2_id
foreignAlias: AmigosUsuario
onDelete: CASCADE
I have also these queries below to get friends of a user (I have two
queries because the id of the user can be stored as User1 or User2).
These are the queries:
// hemos tenido que hacer dos querys porque la amistad puede
estar definida
// en cualquiera de la dos direcciones (así X->Y o así Y->X)
$q1 = Doctrine_Query::create()
->from('Usuario u')
->leftJoin('u.AmigoUsuario a ON u.id = a.user2_id')
->where("a.user1_id = ?", $id)
->andWhere("a.estado LIKE ?", 1);
$q2 = Doctrine_Query::create()
->from('Usuario u')
->leftJoin('u.AmigoUsuario a ON u.id = a.user1_id')
->where("a.user2_id = ?", $id)
->andWhere("a.estado LIKE ?", 1);
Now i want to paginate the results. What is your advice?
Regards
Javi
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en