+ def buildglitchvoltages(self):
+ """This builds tables for glitching voltage ranges from the training set."""
+ print "Precomputing glitching ranges. This might take a while.";
+ sys.stdout.flush();
+ self.db.execute("create temporary table glitchrange(time integer primary key asc,max,min);");
+ self.db.execute("insert into glitchrange(time,max,min) select distinct time, 0, 0 from glitches;");
+ self.db.execute("update glitchrange set max=(select max(vcc) from glitches where glitches.time=glitchrange.time and count=0);");
+ self.db.execute("update glitchrange set min=(select min(vcc) from glitches where glitches.time=glitchrange.time and count>0);");
+