def test_aggregate_stitch(self):
"""Stitch 47 images (1 minute) from 2826 rows (1 sec) """
_id = 8
sampling = 60
src = "Profiles_060_WTH_STATIC_EL90"
onesec = "Profiles_060_WTH_STATIC_EL90_IM_S1_8000_JET"
dest = "Profiles_060_WTH_STATIC_EL90_Images_60_TEST"
con = db.connect("cube", "cube", "HDCP2")
self.assertEqual(True, image.aggregate_table_stitch(con, _id, sampling, src, onesec, dest))
self.cursor.execute("SELECT COUNT(img_id) FROM `Profiles_060_WTH_STATIC_EL90_Images_60_TEST`")
total = self.cursor.fetchone()
self.assertEqual(48, 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_stitch(con, _id, sampling, src, onesec, dest, logging=True)
row = cursor.fetchone()
elapsed = time.time() - tstart
print "==Profiler=="
print "Time taken: " + str(elapsed)
print "Done."
