def test_aggregate_table(self): """Insert 47 datasets from ID 10 and test against this """ _id = 10 sampling = 1 # seconds src = "Profiles_060_WTH_STATIC_EL90" dest = "Profiles_060_WTH_STATIC_EL90_Images_1_TEST" con = db.connect("cube", "cube", "HDCP2") self.assertEqual(True, image.aggregate_table(con, _id, sampling, src, dest)) self.cursor.execute("SELECT COUNT(img_id) FROM `Profiles_060_WTH_STATIC_EL90_Images_1_TEST`") total = self.cursor.fetchone() self.assertEqual(47, total[0])
timestamp BIGINT(20), width int, height int, image BLOB, P_Id int, RG_start DOUBLE(5,2), RG_end DOUBLE(5,2), PRIMARY KEY (img_id), FOREIGN KEY (P_Id) REFERENCES Profiles_060_WTH_Event(Id))""" tstart = time.time() row = cursor.fetchone() while row: _id = row[0] image.aggregate_table(con, _id, sampling, src, dest, gate, logging=True) row = cursor.fetchone() elapsed = time.time() - tstart print "==Profiler==" print "Time taken: " + str(elapsed) print "Done."