| | 390 | sql = "SELECT changetime FROM master_ticket WHERE dbuser='bs_%s_user' ORDER BY time DESC" % (p.short_name) |
|---|
| | 391 | trac_cursor.execute(sql) |
|---|
| | 392 | trac_last_ticket_change_time = trac_cursor.fetchone() |
|---|
| | 393 | if trac_last_ticket_change_time: |
|---|
| | 394 | trac_time = datetime.fromtimestamp(trac_last_ticket_change_time[0]) |
|---|
| | 395 | trac_db_time = trac_time.strftime("%b %d, %Y - %I:%M %p") |
|---|
| | 396 | else: |
|---|
| | 397 | trac_db_time = "None" |
|---|
| | 398 | sql = "SELECT value FROM elgg_profile_data WHERE owner='%s' AND name='last_ticket_change'" % (project_id) |
|---|
| | 399 | cursor.execute(sql) |
|---|
| | 400 | value = cursor.fetchone() |
|---|
| | 401 | if value: |
|---|
| | 402 | sql = "UPDATE elgg_profile_data SET value='%s' WHERE owner='%s' AND name='last_ticket_change'" % (trac_db_time, project_id) |
|---|
| | 403 | cursor.execute(sql) |
|---|
| | 404 | conn.commit() |
|---|
| | 405 | else: |
|---|
| | 406 | 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 | |
|---|
