Subversion Repositories SmartDukaan

package com.spice.profitmandi.dao.entity.dtr;

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="dtr.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 int hashCode() {
                final int prime = 31;
                int result = 1;
                result = prime * result + id;
                result = prime * result + roleId;
                result = prime * result + userId;
                return result;
        }

        @Override
        public boolean equals(Object obj) {
                if (this == obj)
                        return true;
                if (obj == null)
                        return false;
                if (getClass() != obj.getClass())
                        return false;
                UserRole other = (UserRole) obj;
                if (id != other.id)
                        return false;
                if (roleId != other.roleId)
                        return false;
                if (userId != other.userId)
                        return false;
                return true;
        }

        @Override
        public String toString() {
                return "UserRole [id=" + id + ", userId=" + userId + ", roleId=" + roleId + "]";
        }
        
        
        
}