Datenbankteile für SSO:

 -alte SSO Session IDs
 -angemeldete OAs

1 files changed, 88 insertions, 0 deletions

diff --git a/id/server/moa-id-commons/src/main/java/at/gv/egovernment/moa/id/commons/db/dao/session/OASessionStore.java b/id/server/moa-id-commons/src/main/java/at/gv/egovernment/moa/id/commons/db/dao/session/OASessionStore.java
new file mode 100644
index 000000000..597c275b7
--- /dev/null
+++ b/id/server/moa-id-commons/src/main/java/at/gv/egovernment/moa/id/commons/db/dao/session/OASessionStore.java
@@ -0,0 +1,88 @@
+package at.gv.egovernment.moa.id.commons.db.dao.session;
+
+import java.io.Serializable;
+import java.util.Date;
+
+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.ManyToOne;
+import javax.persistence.PrePersist;
+import javax.persistence.Table;
+import javax.persistence.Temporal;
+import javax.persistence.TemporalType;
+
+import org.hibernate.annotations.DynamicUpdate;
+import org.hibernate.annotations.NamedQueries;
+import org.hibernate.annotations.NamedQuery;
+
+@Entity
+@DynamicUpdate(value=true)
+@Table(name = "oasessionstore")
+
+@NamedQueries({
+    @NamedQuery(name="getOAsWithSSOID", query = "select oasessionstore from OASessionStore oasessionstore where oasessionstore.ssoidentifier = :ssoidentifier")
+})
+
+public class OASessionStore implements Serializable{
+
+	private static final long serialVersionUID = 1L;
+	
+	@Id
+	@GeneratedValue(strategy=GenerationType.AUTO)
+	@Column(name = "idOASession", unique=true, nullable=false)
+	private int idOASession = 0;
+	
+	@ManyToOne
+	@JoinColumn(name = "id")
+	private AuthenticatedSessionStore ssoidentifier;
+	
+	@Column(name = "oaurlprefix", unique=false, nullable=false)
+	private String oaurlprefix;
+	
+	@Column(name = "created", updatable=false, nullable=false)
+    @Temporal(TemporalType.TIMESTAMP)
+    private Date created;
+	
+    @PrePersist
+    protected void created() {
+    	this.created = new Date();
+    }
+
+	public int getId() {
+		return idOASession;
+	}
+
+	public void setId(int id) {
+		this.idOASession = id;
+	}
+
+	public AuthenticatedSessionStore getSsoidentifier() {
+		return ssoidentifier;
+	}
+
+	public void setSsoidentifier(AuthenticatedSessionStore ssoidentifier) {
+		this.ssoidentifier = ssoidentifier;
+	}
+
+	public String getOaurlprefix() {
+		return oaurlprefix;
+	}
+
+	public void setOaurlprefix(String oaurlprefix) {
+		this.oaurlprefix = oaurlprefix;
+	}
+
+	public Date getCreated() {
+		return created;
+	}
+
+	public void setCreated(Date created) {
+		this.created = created;
+	}
+    
+}
+