Changeset 201

Show
Ignore:
Timestamp:
03/29/06 09:28:59 (2 years ago)
Author:
dsandler
Message:

Sliding window support.

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • stats/trunk/feedtree_stats.py

    r169 r201  
    1414 
    1515 
    16 def nodes(password, age=DEFAULT_WINDOW): 
     16def nodes(password, win=DEFAULT_WINDOW, center='NOW()'): 
    1717    db = MySQLdb.connect('stats.feedtree.net', 'feedtree', password) 
    1818    db.select_db('feedtree') 
    1919    cu = db.cursor() 
    2020    cu.execute(''' 
    21         select distinct nodeid from reports where NOW() - INTERVAL %d SECOND < ts  
     21        SELECT DISTINCT nodeid FROM reports  
     22        WHERE TIME_TO_SEC(TIMEDIFF(%s, ts)) <= %d 
    2223        ; 
    23     ''' % age); 
     24    ''' % (center, win)); 
    2425    ids = [x[0] for x in cu.fetchall()] 
    2526