Subversion Repositories SmartDukaan

package com.spice.profitmandi.dao.entity;

import java.io.Serializable;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.NamedQueries;

import javax.persistence.NamedQuery;

import javax.persistence.Table;

import javax.persistence.UniqueConstraint;

/**

 * This class basically contains api details

 * 

 * @author ashikali

 *

 */

@Entity

@Table(name="user_role", schema = "dtr", uniqueConstraints = {@UniqueConstraint(columnNames = {"user_id", "role_id"})})

@NamedQueries({

	@NamedQuery(name="UserRole.selectByUserId", query="select ur from UserRole ur where ur.userId= :userId"),

	@NamedQuery(name="UserRole.deleteByUserAndRoleId", query="delete from UserRole ur where ur.userId= :userId and ur.roleId = :roleId"),

	@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")

})

public class UserRole implements Serializable{

	private static final long serialVersionUID = 1L;

	@Id

	@Column(name="id", unique=true, updatable=false)

	@GeneratedValue(strategy = GenerationType.IDENTITY)

	private int id;

	public UserRole() {

	}

	public int getId() {

		return id;

	}

	public void setId(int id) {

		this.id = id;

	}

	@Column(name="user_id", unique=false, updatable=false)

	private int userId;

	@Column(name="role_id", unique = false)

	private int roleId;

	public int getUserId() {

		return userId;

	}

	public void setUserId(int userId) {

		this.userId = userId;

	}

	public int getRoleId() {

		return roleId;

	}

	public void setRoleId(int roleId) {

		this.roleId = roleId;

	}

	@Override

	public String toString() {

		return "UserRole [id=" + id + ", userId=" + userId + ", roleId=" + roleId + "]";

	}

}