def test_getTraceData(self):
loader=LoadTraceDataFromMysqlDBFactory(dbname='mydatabase',tblname="trajectory",whereClause="order by un,tm")
loader.getTraceData()
self.assertEqual(len(loader.TraceDataframe),40152)
if j == len(tracePoints) - 1:
tracePoints[j].nextPoint = tracePoints[j]
tracePoints[i].direction2next = CacLineCoff(tracePoints[i].prevPoint.x, tracePoints[i].prevPoint.y,
tracePoints[i].nextPoint.x, tracePoints[i].nextPoint.y)
tracePoints[i].baseDirection = CacLineCoff(tracePoints[i].x, tracePoints[i].y,
tracePoints[i].nextPoint.x, tracePoints[i] .nextPoint.y)
#start Loop
loop=1
newInd=index.Index()
while loop<=20:
#cac direction for each point
for po in tracePoints:
this_inclineAngle=po.direction2next[i]
neighIDs=list(idx.intersection((po.x-self.searchDisRange,po.y-self.searchDisRange,
po.x+self.searchDisRange,po.y+self.searchDisRange)))
if len(neighIDs)!=0:
self.cacPostMovePosition()
if __name__=="__main__":
try:
loader = LoadTraceDataFromMysqlDBFactory(dbname='mydatabase', tblname="trajectory",
whereClause="TripID>0 order by un,tm")
traceDF = loader.getTraceData()
tracePoints=[Point(zx=traceDF["zx"][i],zy=traceDF["zy"][i],
TripID=traceDF["TripID"][i],ID=traceDF["UID"][i]) for i in traceDF.index]
clarifyMethod=ClarifyMethod()
clarifyMethod.executeClarify(tracePoints)
except Exception,e:
print e.message
def test_init(self):
loader = LoadTraceDataFromMysqlDBFactory(dbname='mydatabase',tblname="trajectory")
self.assertEqual(loader.database.name,"mydatabase")
self.assertTrue(isinstance(loader,LoadTraceDataFromMysqlDBFactory))