def test_C_BreakdownStreams2Points(self):
# per stream
# get points (lots of data...)
# minThresh = 35
# maxThresh = 55
minThresh = 10
maxThresh = 25
# dev_id = "00000000-00000000-00042DFF-FF0418FB"
dev_id = "00080003-00000000-030001F1-90D17C44"
# timeSince = 1399533532000
timeSince = 1399992866000 # when fix for time comp added
print "Device:", dev_id
print "Start Time:", time.strftime("%B %d, %Y %H:%M:%S", time.localtime((timeSince / 1000)))
strList = datamanager.getStreamListByDeviceID(dev_id)
for st in strList:
print st.stream_id
if st.stream_id == "EventList":
pass
else:
fist = 0
dp = datamanager.getAllDatapointsFiltered(dev_id, timeSince, st.stream_id)
try:
lastRecord = dp[0]
for i in dp:
# should be close to 44
if fist > 0:
delta = (i.timestamp - lastRecord.timestamp) / 1000
if delta < minThresh or delta > maxThresh:
print "Delta:", delta, "\t",
print "Time:", time.strftime(
"%B %d, %Y %H:%M:%S", time.localtime((i.timestamp / 1000))
),
print i.id, i.timestamp, i.datapoint, i.created_on
fist = 1
lastRecord = i
# validate timestamps, ordering
# interval range analyzer
# check for duplicates
# find last
# catch drastic value changes for event occurance?
except Exception, e:
print "Bad Query? : ", e
def test_A_Count(self):
try:
dID = "00000000-00000000-00042DFF-FF051018"
stList = datamanager.getStreamListByDeviceID(dID)
datapoints = datamanager.getAllDatapointsByID(str(dID), stList[int(0)].stream_id)
print "Device Count:", db.session.query(device).filter(device.id.like("%")).count()
print "Data Stream Count:", db.session.query(latestDataStreamPoints).filter(
latestDataStreamPoints.id.like("%")
).count()
print "Data Point Count:", db.session.query(dataPointRecords).filter(dataPointRecords.id.like("%")).count()
print "Latest DataPoint:", time.strftime(
"%B %d, %Y %H:%M:%S", time.localtime((float(datamanager.getMostRecentTSDataPoint()) / 1000))
)
print "WR21 Specific Data Point Count:", db.session.query(dataPointRecords).filter(
dataPointRecords.dev_id.like("%fb%")
).count()
assert 1 == 1
except Exception, e:
print e
self.fail("Counter query fail")