Changeset 226

Show
Ignore:
Timestamp:
02/20/09 05:25:37 (9 months ago)
Author:
gallardj
Message:

refs #2674. Adds last wiki change and last commit to profile data

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • management/bs-admin/trunk/cache_and_sync.py

    r223 r226  
    371371          conn.commit() 
    372372         
    373         sql = "SELECT time FROM master_wiki WHERE name='WikiStart' AND author='trac' AND dbuser='bs_%s_user'" % (p.short_name) 
     373        sql = "SELECT time FROM master_wiki WHERE name='WikiStart' AND author='trac' AND dbuser='bs_%s_user' LIMIT 1" % (p.short_name) 
    374374        trac_cursor.execute(sql) 
    375375        trac_start_time = trac_cursor.fetchone()[0] 
    …… 
    388388          conn.commit() 
    389389 
    390         sql = "SELECT changetime FROM master_ticket WHERE dbuser='bs_%s_user' ORDER BY time DESC" % (p.short_name) 
     390        sql = "SELECT changetime FROM master_ticket WHERE dbuser='bs_%s_user' ORDER BY time DESC LIMIT 1" % (p.short_name) 
    391391        trac_cursor.execute(sql) 
    392392        trac_last_ticket_change_time = trac_cursor.fetchone() 
    …… 
    396396        else: 
    397397          trac_db_time = "None" 
    398         sql = "SELECT value FROM elgg_profile_data WHERE owner='%s' AND name='last_ticket_change'" % (project_id) 
     398        sql = "SELECT value FROM elgg_profile_data WHERE owner='%s' AND name='last_ticket_change LIMIT 1'" % (project_id) 
    399399        cursor.execute(sql) 
    400400        value = cursor.fetchone() 
    …… 
    405405        else: 
    406406          sql = "INSERT INTO elgg_profile_data VALUES (DEFAULT, '%s', 'LOGGED_IN', 'last_ticket_change', '%s')" % (project_id, trac_db_time) 
     407          cursor.execute(sql) 
     408          conn.commit() 
     409         
     410        sql = "SELECT time FROM master_wiki WHERE dbuser='bs_%s_user' ORDER BY time DESC LIMIT 1" % (p.short_name) 
     411        trac_cursor.execute(sql) 
     412        trac_last_wiki_change_time = trac_cursor.fetchone() 
     413        if trac_last_wiki_change_time: 
     414          trac_time = datetime.fromtimestamp(trac_last_wiki_change_time[0]) 
     415          trac_db_time = trac_time.strftime("%b %d, %Y - %I:%M %p") 
     416        else: 
     417          trac_db_time = "None" 
     418        sql = "SELECT value FROM elgg_profile_data WHERE owner='%s' AND name='last_wiki_change LIMIT 1'" % (project_id) 
     419        cursor.execute(sql) 
     420        value = cursor.fetchone() 
     421        if value: 
     422          sql = "UPDATE elgg_profile_data SET value='%s' WHERE owner='%s' AND name='last_wiki_change'" % (trac_db_time, project_id) 
     423          cursor.execute(sql) 
     424          conn.commit() 
     425        else: 
     426          sql = "INSERT INTO elgg_profile_data VALUES (DEFAULT, '%s', 'LOGGED_IN', 'last_wiki_change', '%s')" % (project_id, trac_db_time) 
     427          cursor.execute(sql) 
     428          conn.commit() 
     429         
     430        sql = "SELECT rev,time FROM master_revision WHERE dbuser='bs_%s_user' ORDER BY time DESC LIMIT 1" % (p.short_name) 
     431        trac_cursor.execute(sql) 
     432        trac_last_commit = trac_cursor.fetchone() 
     433        if trac_last_commit: 
     434          trac_time = datetime.fromtimestamp(trac_last_commit[1]) 
     435          trac_db_time = "<a href=\"/projects/%s/changeset/%s\">Revision %s</a> (%s)" % (p.short_name, trac_last_commit[0], trac_last_commit[0], trac_time.strftime("%b %d, %Y - %I:%M %p")) 
     436        else: 
     437          trac_db_time = "None" 
     438        sql = "SELECT value FROM elgg_profile_data WHERE owner='%s' AND name='last_commit'" % (project_id) 
     439        cursor.execute(sql) 
     440        value = cursor.fetchone() 
     441        if value: 
     442          sql = "UPDATE elgg_profile_data SET value='%s' WHERE owner='%s' AND name='last_commit'" % (trac_db_time, project_id) 
     443          cursor.execute(sql) 
     444          conn.commit() 
     445        else: 
     446          sql = "INSERT INTO elgg_profile_data VALUES (DEFAULT, '%s', 'LOGGED_IN', 'last_commit', '%s')" % (project_id, trac_db_time) 
    407447          cursor.execute(sql) 
    408448          conn.commit()