Ejemplo n.º 1
0
def buildEventStreamTable():
    rows = c.execute(qry).fetchall()
    c.execute("drop table if exists eventstream")
    c.execute("""create table eventstream 
    (matchid,halfid,eventtime int,
    eventname,duel,locationx,locationy,idactor1,teamid,position,eventid)""")
    logger.map("Building eventstream table", rows, insertRow)
Ejemplo n.º 2
0
def buildVirtualEventStreamTable():
    c.execute("drop table if exists virtualeventstream")
    c.execute("""create table virtualeventstream 
    (matchid int,halfid int,eventtime int,
    eventname text,duel int,locationx int,locationy int,idactor1 int,teamid int,position text)""")
    matchids = [m for (m,) in c.execute("select id from match").fetchall()]
    logger.map("Building virtualeventstream table", matchids, storeVirtualEventOfMatch)
Ejemplo n.º 3
0
 def search_k_nearest_neighbours(self,window,log=True):
     f = lambda candidate: (self.dist(window, candidate),candidate)
     tups = logger.map("Processed NN: ",self.windows,f,log=log,percstep=20)
     tups.sort(key=lambda tup:tup[0])
     #print([t[0] for t in tups])
     self.nn = tups[0:self.k]
     return self.nn