Changeset 2179 for branches/HeuristicLab.Modeling Database Backend/sources/HeuristicLab.Modeling.SQLiteBackend/3.2/Model.cs

Timestamp:

07/23/09 11:01:40 (15 years ago)

Author:

mkommend

Message:

implemented final prototyp of LinqToSql mapping (ticket #712)

File:

• branches/HeuristicLab.Modeling Database Backend/sources/HeuristicLab.Modeling.SQLiteBackend/3.2/Model.cs (modified) (8 diffs)

branches/HeuristicLab.Modeling Database Backend/sources/HeuristicLab.Modeling.SQLiteBackend/3.2/Model.cs

@@ -6 +6 @@
 using System.Text;
 
-namespace HeuristicLab.Modeling.SQLiteBackend {  
-  [Table(Name="Model")]
+namespace HeuristicLab.Modeling.SQLiteBackend {
+  [Table(Name = "Model")]
   public class Model {
     public Model() {
@@ -14 +14 @@
     }
 
+    public Model(Variable targetVariable, Algorithm algorithm, object data)
+      : this() {
+      this.TargetVariable = targetVariable;
+      this.Algorithm = algorithm;
+      this.data = data;
+    }
+
     private int id;
-    [Column(Storage = "id", DbType = "integer", IsPrimaryKey = true, IsDbGenerated = true, UpdateCheck = UpdateCheck.Never)]
+    [Column(Storage = "id", IsPrimaryKey = true, IsDbGenerated = true)]
     public int Id {
       get { return this.id; }
@@ -22 +29 @@
 
     private object data;
-    [Column(Storage = "data", DbType = "text", CanBeNull = false)]
+    [Column(Storage = "data", DbType = "varbinary(8000)", CanBeNull = false)]
     public object Data {
       get { return this.data; }
@@ -29 +36 @@
 
     private int algorithmId;
-    [Column(Storage="algorithmId", DbType="Int not null")]
+    [Column(Storage = "algorithmId", CanBeNull = false)]
     public int AlgorithmId {
-      get { return this.algorithmId;}
-      private set { 
-        if(algorithmId != value) {
-          if(algorithm.HasLoadedOrAssignedValue)
+      get { return this.algorithmId; }
+      private set {
+        if (algorithmId != value) {
+          if (algorithm.HasLoadedOrAssignedValue)
             throw new ForeignKeyReferenceAlreadyHasValueException();
-          algorithmId =value;
+          algorithmId = value;
         }
       }
     }
 
-
     private EntityRef<Algorithm> algorithm;
-    [Association(Storage="algorithm",ThisKey="AlgorithmId",OtherKey="Id",IsForeignKey=true)]
+    [Association(Storage = "algorithm", ThisKey = "AlgorithmId", OtherKey = "Id", IsForeignKey = true)]
     public Algorithm Algorithm {
       get { return this.algorithm.Entity; }
@@ -49 +55 @@
         Algorithm previousValue = algorithm.Entity;
         if (previousValue != value || (!algorithm.HasLoadedOrAssignedValue)) {
-          if (previousValue == null) {
+          if (previousValue != null) {
             algorithm.Entity = null;
-            previousValue.Models.Remove(this);
           }
           algorithm.Entity = value;
           if (value != null) {
-            value.Models.Add(this);
             algorithmId = value.Id;
-          } else
-            throw new NullReferenceException("Null not allowed as value for Model.Algorithm");
+          }
         }
       }
@@ -64 +67 @@
 
     private int targetVariableId;
-    [Column(Storage = "targetVariableId", DbType = "Int not null")]
+    [Column(Storage = "targetVariableId", CanBeNull = false)]
     public int TargetVariableId {
       get { return this.targetVariableId; }
@@ -83 +86 @@
         Variable previousValue = targetVariable.Entity;
         if (previousValue != value || (!targetVariable.HasLoadedOrAssignedValue)) {
-          if (previousValue == null) {
+          if (previousValue != null) {
             targetVariable.Entity = null;
-            previousValue.ModelsPredictingThisVariable.Remove(this);
           }
           targetVariable.Entity = value;
           if (value != null) {
-            value.ModelsPredictingThisVariable.Add(this);
             targetVariableId = value.Id;
-          } else
-            throw new NullReferenceException("Null not allowed as value for Model.TargetVariable");
+          } 
         }
       }
     }
 
-    public IEnumerable<Variable> inputVariables {
+    public IEnumerable<Variable> InputVariables {
       get {
         using (ModelingDataContext ctx = new ModelingDataContext()) {
@@ -107 +107 @@
       }
     }
+
+    public Dictionary<string, double> ResultValues {
+      get {
+        using (ModelingDataContext ctx = new ModelingDataContext()) {
+          var x = (from modelResult in ctx.ModelResults
+                   where modelResult.Model == this
+                   select modelResult)
+                  .ToDictionary(
+                    modelResult => modelResult.Result.Name,
+                    modelResult => modelResult.Value);
+          return x;
+        }
+      }
+    }
   }
 }