Subversion Repositories SmartDukaan

Rev

Rev 22216 | Rev 22580 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 22216 Rev 22352
Line 7... Line 7...
7
import javax.persistence.Convert;
7
import javax.persistence.Convert;
8
import javax.persistence.Entity;
8
import javax.persistence.Entity;
9
import javax.persistence.GeneratedValue;
9
import javax.persistence.GeneratedValue;
10
import javax.persistence.GenerationType;
10
import javax.persistence.GenerationType;
11
import javax.persistence.Id;
11
import javax.persistence.Id;
12
import javax.persistence.NamedQueries;
-
 
13
import javax.persistence.NamedQuery;
-
 
14
import javax.persistence.Table;
12
import javax.persistence.Table;
15
import javax.persistence.UniqueConstraint;
13
import javax.persistence.UniqueConstraint;
16
 
14
 
17
import org.hibernate.annotations.UpdateTimestamp;
15
import org.hibernate.annotations.UpdateTimestamp;
18
 
16
 
Line 24... Line 22...
24
 * @author ashikali
22
 * @author ashikali
25
 *
23
 *
26
 */
24
 */
27
@Entity
25
@Entity
28
@Table(name="dtr.users", schema = "dtr",uniqueConstraints = {@UniqueConstraint(columnNames = {"email","mobile_number"})})
26
@Table(name="dtr.users", schema = "dtr",uniqueConstraints = {@UniqueConstraint(columnNames = {"email","mobile_number"})})
29
@NamedQueries({
-
 
30
	@NamedQuery(name = "User.selectCount", query = "select count(u) from User u"),
-
 
31
	@NamedQuery(name = "User.selectAll",query="select u from User u"),
-
 
32
	@NamedQuery(name = "User.selectById",query="select u from User u where u.id= :id"),
-
 
33
	@NamedQuery(name = "User.selectByEmailId", query = "select u from User u where u.emailId= :emailId"),
-
 
34
	@NamedQuery(name = "User.selectByMobileNumber", query = "select u from User u where u.mobileNumber= :mobileNumber"),
-
 
35
	@NamedQuery(name = "User.countByEmailId", query = "select count(u) from User u where u.emailId= :emailId"),
-
 
36
	@NamedQuery(name = "User.countByMobileNumber", query = "select count(u) from User u where u.mobileNumber= :mobileNumber"),
-
 
37
	@NamedQuery(name = "User.selectIdAndSololicUserId", query = "select u.id, ua.account_key, u.createTimestamp, u.updateTimestamp from User u join UserAccounts ua on u.id = ua.user_id where ua.account_type = 'saholic'")
-
 
38
})
-
 
39
public class User implements Serializable{
27
public class User implements Serializable{
40
	
28
	
41
	
29
	
42
	private static final long serialVersionUID = 1L;
30
	private static final long serialVersionUID = 1L;
43
 
31