Changeset 504 for trunk/sources/HeuristicLab.Grid/Database.cs

Timestamp:

08/12/08 15:38:27 (16 years ago)

Author:

gkronber

Message:

reenabled waiting/running/finished counters (#197 Use SQLite backend to store waiting engines and results instead of in-memory dictionaries)

File:

• trunk/sources/HeuristicLab.Grid/Database.cs (modified) (1 diff)

trunk/sources/HeuristicLab.Grid/Database.cs

@@ -274 +274 @@
     }
 
+    internal long GetJobCount(JobState status) {
+      rwLock.EnterReadLock();
+      try {
+        using(SQLiteConnection cnn = new SQLiteConnection(connectionString)) {
+          cnn.Open();
+          DbCommand c = cnn.CreateCommand();
+          c.CommandText = "Select Count(id) from Job where Status=@Status";
+          DbParameter stateParameter = c.CreateParameter();
+          stateParameter.ParameterName = "@Status";
+          stateParameter.Value = status.ToString();
+          c.Parameters.Add(stateParameter);
+          return (long)c.ExecuteScalar();
+        }
+      } finally {
+        rwLock.ExitReadLock();
+      }
+    }
+
     /// <summary>
     /// Does nothing right now (= running jobs that disappear are never restarted).