SSO Implementation

1 files changed, 57 insertions, 20 deletions

diff --git a/id/server/moa-id-commons/src/main/java/at/gv/egovernment/moa/id/commons/db/dao/session/AuthenticatedSessionStore.java b/id/server/moa-id-commons/src/main/java/at/gv/egovernment/moa/id/commons/db/dao/session/AuthenticatedSessionStore.java
index 01c18062c..4ed42175e 100644
--- a/id/server/moa-id-commons/src/main/java/at/gv/egovernment/moa/id/commons/db/dao/session/AuthenticatedSessionStore.java
+++ b/id/server/moa-id-commons/src/main/java/at/gv/egovernment/moa/id/commons/db/dao/session/AuthenticatedSessionStore.java
@@ -1,14 +1,18 @@
 package at.gv.egovernment.moa.id.commons.db.dao.session;
 
 import java.io.Serializable;
+import java.util.ArrayList;
 import java.util.Date;
+import java.util.List;
 import java.util.Set;
 
+import javax.persistence.CascadeType;
 import javax.persistence.Column;
 import javax.persistence.Entity;
 import javax.persistence.GeneratedValue;
 import javax.persistence.GenerationType;
 import javax.persistence.Id;
+import javax.persistence.JoinColumn;
 import javax.persistence.Lob;
 import javax.persistence.OneToMany;
 import javax.persistence.PrePersist;
@@ -18,6 +22,7 @@ import javax.persistence.Temporal;
 import javax.persistence.TemporalType;
 
 import org.hibernate.annotations.DynamicUpdate;
+import org.hibernate.annotations.IndexColumn;
 import org.hibernate.annotations.NamedQueries;
 import org.hibernate.annotations.NamedQuery;
 
@@ -26,6 +31,7 @@ import org.hibernate.annotations.NamedQuery;
 @Table(name = "authenticatedsessionstore")
 @NamedQueries({
     @NamedQuery(name="getSessionWithID", query = "select authenticatedsessionstore from AuthenticatedSessionStore authenticatedsessionstore where authenticatedsessionstore.sessionid = :sessionid"),
+    @NamedQuery(name="getSessionWithSSOID", query = "select authenticatedsessionstore from AuthenticatedSessionStore authenticatedsessionstore where authenticatedsessionstore.SSOsessionid = :sessionid"),
     @NamedQuery(name="getMOAISessionsWithTimeOut", query = "select authenticatedsessionstore from AuthenticatedSessionStore authenticatedsessionstore where authenticatedsessionstore.created < :timeout")
 })
 
@@ -34,13 +40,16 @@ public class AuthenticatedSessionStore implements Serializable{
 	private static final long serialVersionUID = 1L;
 
 	@Id
-	@GeneratedValue(strategy=GenerationType.AUTO)
+	@GeneratedValue(strategy = GenerationType.IDENTITY)
 	@Column(name = "id", unique=true, nullable=false)
-	private int id = 0;
+	private long id;
 	
 	@Column(name = "sessionid", unique=true, nullable=false)
 	private String sessionid;
 	
+	@Column(name = "SSOsessionid")
+	private String SSOsessionid;
+	
 	@Column(name = "session", nullable=false)
 	@Lob private byte [] session;
 	
@@ -49,12 +58,6 @@ public class AuthenticatedSessionStore implements Serializable{
 	
 	@Column(name = "isSSOSession", nullable=false)
 	private boolean isSSOSession =  false;
-
-	@OneToMany(mappedBy="ssoidentifier")
-    private Set<OASessionStore> activeOAsessions;
-	
-	@OneToMany(mappedBy="ssoidentifier")
-    private Set<OldSSOSessionIDStore> oldssosessionids;
 	
 	@Column(name = "created", updatable=false, nullable=false)
     @Temporal(TemporalType.TIMESTAMP)
@@ -63,7 +66,13 @@ public class AuthenticatedSessionStore implements Serializable{
     @Column(name = "updated")
     @Temporal(TemporalType.TIMESTAMP)
     private Date updated;
-
+	
+	@OneToMany(mappedBy="moasession", cascade=CascadeType.ALL)
+    private List<OASessionStore> activeOAsessions = null;
+	
+	@OneToMany(mappedBy="moasession", cascade=CascadeType.ALL)
+    private List<OldSSOSessionIDStore> oldssosessionids = null;
+	
     @PrePersist
     protected void created() {
     this.updated = this.created = new Date();
@@ -74,12 +83,11 @@ public class AuthenticatedSessionStore implements Serializable{
     this.updated = new Date();
     }
 
-    
-	public int getId() {
+	public long getId() {
 		return id;
 	}
 
-	public void setId(int id) {
+	public void setId(long id) {
 		this.id = id;
 	}
 
@@ -91,6 +99,14 @@ public class AuthenticatedSessionStore implements Serializable{
 		this.sessionid = sessionid;
 	}
 
+	public String getSSOsessionid() {
+		return SSOsessionid;
+	}
+
+	public void setSSOsessionid(String sSOsessionid) {
+		SSOsessionid = sSOsessionid;
+	}
+
 	public byte[] getSession() {
 		return session;
 	}
@@ -107,30 +123,51 @@ public class AuthenticatedSessionStore implements Serializable{
 		this.isAuthenticated = isAuthenticated;
 	}
 
-	public Date getCreated() {
-		return created;
+	public boolean isSSOSession() {
+		return isSSOSession;
 	}
 
-	public Date getUpdated() {
-		return updated;
+	public void setSSOSession(boolean isSSOSession) {
+		this.isSSOSession = isSSOSession;
+	}
+
+	public Date getCreated() {
+		return created;
 	}
 
 	public void setCreated(Date created) {
 		this.created = created;
 	}
 
+	public Date getUpdated() {
+		return updated;
+	}
+
 	public void setUpdated(Date updated) {
 		this.updated = updated;
 	}
 
-	public boolean isSSOSession() {
-		return isSSOSession;
+	public List<OASessionStore> getActiveOAsessions() {
+		return activeOAsessions;
 	}
 
-	public void setSSOSession(boolean isSSOSession) {
-		this.isSSOSession = isSSOSession;
+	public void setActiveOAsessions(List<OASessionStore> activeOAsessions) {
+		if (activeOAsessions == null) {
+			this.activeOAsessions = new ArrayList<OASessionStore>();
+		}
+		
+		this.activeOAsessions = activeOAsessions;
 	}
 
+	public List<OldSSOSessionIDStore> getOldssosessionids() {
+		return oldssosessionids;
+	}
 
+	public void setOldssosessionids(List<OldSSOSessionIDStore> oldssosessionids) {
+		this.oldssosessionids = oldssosessionids;
+	}
+
+    
 
+	
 }