class UserRole implements Serializable {
User user
Role role
boolean equals(other) {
if (!(other instanceof UserRole)) {
return false
}
other.user?.id == user?.id &&
other.role?.id == role?.id
}
int hashCode() {
def builder = new HashCodeBuilder()
if (user) builder.append(user.id)
if (role) builder.append(role.id)
builder.toHashCode()
}
static UserRole get(long userId, long roleId) {
find 'from UserRole where user.id=:userId and role.id=:roleId',
[userId: userId, roleId: roleId]
}
static UserRole create(User user, Role role, boolean flush = false) {
new UserRole(user: user, role: role).save(flush: flush, insert: true)
}
static boolean remove(User user, Role role, boolean flush = false) {
UserRole instance = UserRole.findByUserAndRole(user, role)
if (!instance) {
return false
}
instance.delete(flush: flush)
true
}
static void removeAll(User user) {
executeUpdate 'DELETE FROM UserRole WHERE user=:user', [user: user]
}
static void removeAll(Role role) {
executeUpdate 'DELETE FROM UserRole WHERE role=:role', [role: role]
}
static mapping = {
id composite: ['role', 'user']
version false
}
}
On Thu, Mar 1, 2012 at 6:37 PM, michael astreiko [via Grails]
<[hidden email]> wrote:
Hello Ravi,
And what is content of yours UserRole domain?
Thursday, March 1, 2012, 3:36:29 PM, you wrote:
|
Michael, Thanks! В I tried your solution but got exactly the same error. Between, when i started with grails (1.3.7), this looked as the most intuitive syntax to traverse the object hierarchy but it did not use to work. That is when i figured that this syntax is only valid for associations and createAlias is the way one can traverse the objectВ hierarchy.
The SQL log for your suggestion: "select this_.role_id as role1_0_0_, this_.user_id as user2_0_0_ from user_role this_ where this_.role_id=? and usr1_.username=?"
On Thu, Mar 1, 2012 at 5:19 PM, michael astreiko [via Grails] <[hidden email]> wrote:
Hello Ravi,
Do not understand the reason as well but maybe try this:
def userRole=UserRole.withCriteria{
В eq('role',Role.findByAuthority('ROLE_ADMIN'))
В user {
В В В eq("username","admin1")
В }
}
Thursday, March 1, 2012, 1:49:24 PM, you wrote:
|
I wrote a very simple criteria query on UserRole Domain Object(created by spring-security-core) and am baffled with sql output
def userRole=UserRole.withCriteria{
createAlias ('user', 'usr')
eq('role',Role.findByAuthority('ROLE_ADMIN'))
eq("usr.username","admin1")
}
The generate Sql В doesn't create a join with user table and givesВ error asВ Unknown column 'usr1_.username' in 'where clause'.
SQL Log: В "select this_.role_id as role1_0_0_, this_.user_id as user2_0_0_ from user_role this_ where this_.role_id=? and usr1_.username=?"
Am I missing something???В
PS : UserRole the default generated Serializable В Domain Class generated by spring-security-core. It is a mapping class Between User and Role Domain Class and has user and role as 2 fields.
|
--В
View this message in context: Re: Does createAlias behaves consistently in all situations
Sent from the Grails - user mailing list archive at Nabble.com.
|
Locked
