| Line 1... |
Line 1... |
| 1 |
package com.spice.profitmandi.dao.entity;
|
1 |
package com.spice.profitmandi.dao.entity.dtr;
|
| 2 |
|
2 |
|
| 3 |
import java.io.Serializable;
|
3 |
import java.io.Serializable;
|
| 4 |
|
4 |
|
| 5 |
import javax.persistence.Column;
|
5 |
import javax.persistence.Column;
|
| 6 |
import javax.persistence.Entity;
|
6 |
import javax.persistence.Entity;
|
| Line 17... |
Line 17... |
| 17 |
*
|
17 |
*
|
| 18 |
* @author ashikali
|
18 |
* @author ashikali
|
| 19 |
*
|
19 |
*
|
| 20 |
*/
|
20 |
*/
|
| 21 |
@Entity
|
21 |
@Entity
|
| 22 |
@Table(name="user_role", schema = "dtr", uniqueConstraints = {@UniqueConstraint(columnNames = {"user_id", "role_id"})})
|
22 |
@Table(name="dtr.user_role", schema = "dtr", uniqueConstraints = {@UniqueConstraint(columnNames = {"user_id", "role_id"})})
|
| 23 |
@NamedQueries({
|
23 |
@NamedQueries({
|
| 24 |
@NamedQuery(name="UserRole.selectByUserId", query="select ur from UserRole ur where ur.userId= :userId"),
|
24 |
@NamedQuery(name="UserRole.selectByUserId", query="select ur from UserRole ur where ur.userId= :userId"),
|
| 25 |
@NamedQuery(name="UserRole.deleteByUserAndRoleId", query="delete from UserRole ur where ur.userId= :userId and ur.roleId = :roleId"),
|
25 |
@NamedQuery(name="UserRole.deleteByUserAndRoleId", query="delete from UserRole ur where ur.userId= :userId and ur.roleId = :roleId"),
|
| 26 |
@NamedQuery(name = "UserRole.selectRolesByUserId", query = "select r.id, r.name, r.type, r.status, r.createTimestamp, r.updateTimestamp, p.type from UserRole ur join Role r on r.id = ur.roleId join Permission p on p.roleId = ur.roleId where ur.userId = :userId")
|
26 |
@NamedQuery(name = "UserRole.selectRolesByUserId", query = "select r.id, r.name, r.type, r.status, r.createTimestamp, r.updateTimestamp, p.type from UserRole ur join Role r on r.id = ur.roleId join Permission p on p.roleId = ur.roleId where ur.userId = :userId")
|
| 27 |
})
|
27 |
})
|