Changeset 871 for trunk/Monitoring/smon/local_repo.py

Timestamp:

06/11/13 09:33:58 (11 years ago)

Author:

jripsl

Message:

Improve "config-card" file handling.
Use explicite function for "repo_io" module initialization

File:

• trunk/Monitoring/smon/local_repo.py (modified) (5 diffs)

trunk/Monitoring/smon/local_repo.py

@@ -14 +14 @@
 import sys
 import sqlite3
+
+import types
 
 _conn=None
@@ -39 +41 @@
 
 def create_tables():
+
         _conn.execute("create table simulation (id INTEGER PRIMARY KEY, name TEXT)")
+        _conn.execute("create unique index idx_simulation on simulation (name)")
+
         _conn.execute("create table message (id INTEGER PRIMARY KEY, simulation_id TEXT)") # TODO: check how to use INT datatype for simulation_id column
+
+def populate_tables_with_sample():
+
+        rows = [('SIMU-001',),
+                        ('SIMU-002',),
+                        ('SIMU-003',),]
+        _conn.executemany('INSERT INTO simulation (name) VALUES (?)', rows)
+
+def retrieve_simulations():
+        li=[]
+        c=_conn.cursor()
+
+        c.execute("select name,id from simulation")
+
+        rs=c.fetchone()
+        while rs is not None:
+                li.append(types.Simulation(name=rs[0],id=rs[1]))
+                rs=c.fetchone()
+
+        return li
 
 def retrieve_simulation(name):
@@ -52 +77 @@
                 raise Exception()
 
-        return smon.types.Simulation(id=rs[1])
+        return types.Simulation(id=rs[1])
     
 def delete_simulation(simulation):
@@ -72 +97 @@
         rs=c.fetchone()
         while rs is not None:
-                li.append(smon.types.Message(id=rs[0]))
+                li.append(types.Message(id=rs[0]))
                 rs=c.fetchone()
 
@@ -93 +118 @@
                 raise Exception()
 
-        return smon.types.Message(id=rs[0])
+        return types.Message(id=rs[0])