aboutsummaryrefslogtreecommitdiff
path: root/scripts/database.py
diff options
context:
space:
mode:
authorKarel Kočí <cynerd@email.cz>2015-08-19 10:14:53 +0200
committerKarel Kočí <cynerd@email.cz>2015-08-19 10:19:06 +0200
commit11d45f70ceb41f7dfbf0ae337ebd0ed7a3a63090 (patch)
treedfb472cfdd8292b14a5276dbbcabe135a1f49f32 /scripts/database.py
parent4c42daf1d4c2551b8d3e41f7bd6b90482900dad4 (diff)
downloadlinux-conf-perf-11d45f70ceb41f7dfbf0ae337ebd0ed7a3a63090.tar.gz
linux-conf-perf-11d45f70ceb41f7dfbf0ae337ebd0ed7a3a63090.tar.bz2
linux-conf-perf-11d45f70ceb41f7dfbf0ae337ebd0ed7a3a63090.zip
Store boot output to database
Because configuration is now stored in database only missing informations to make database fully descriptive is boot output. This makes output of boot command to be saved to database and not to file. Also parse script should read input from stdin and not from file from argument.
Diffstat (limited to 'scripts/database.py')
-rw-r--r--scripts/database.py12
1 files changed, 6 insertions, 6 deletions
diff --git a/scripts/database.py b/scripts/database.py
index 01c341a..df89a9a 100644
--- a/scripts/database.py
+++ b/scripts/database.py
@@ -20,7 +20,7 @@ def __timestamp__():
return datetime.datetime.now().strftime('%y-%m-%d-%H-%M-%S')
Config = collections.namedtuple('Config', 'id hash config') # Named tuple for configuration
-Measure = collections.namedtuple('Measure', 'id conf_id mfile value') # Named tuple for measurement
+Measure = collections.namedtuple('Measure', 'id conf_id output value') # Named tuple for measurement
class database:
"Class used for accessing PostgreSQL project database."
@@ -99,17 +99,17 @@ class database:
rtn.append(Config(dt[0], hash, dt[1]))
return rtn
- def add_measure(self, mfile, conf_id, value = None):
+ def add_measure(self, output, conf_id, value = None):
"Add measurement."
ps = self.db.prepare("""INSERT INTO measure
- (conf, mfile, value, mtime, toolgit, linuxgit, measurement)
+ (conf, output, value, mtime, toolgit, linuxgit, measurement)
VALUES
($1, $2, $3, $4, $5, $6, $7);
""")
gt = self.check_toolsgit()
lgt = self.check_linuxgit()
tm = datetime.datetime.now()
- ps(conf_id, mfile, value, tm, gt, lgt, conf.measure_identifier)
+ ps(conf_id, output, value, tm, gt, lgt, conf.measure_identifier)
def update_measure(self, measure_id, value):
"Update measured value"
@@ -122,7 +122,7 @@ class database:
def get_measures(self, conf_id):
"Get measures for configuration with conf_id id"
- ps = self.db.prepare("""SELECT id, mfile, value FROM measure
+ ps = self.db.prepare("""SELECT id, output, value FROM measure
WHERE conf = $1;
""")
rtn = []
@@ -132,7 +132,7 @@ class database:
def get_unmeasured(self):
"Returns list of all unmeasured configurations."
- ps = self.db.prepare("""SELECT id, hash, cfile FROM configurations
+ ps = self.db.prepare("""SELECT id, hash, config FROM configurations
WHERE id NOT IN
(SELECT conf FROM measure)
""")