Changeset 222

Timestamp:

02/20/09 04:38:07 (9 months ago)

Author:

gallardj

Message:

refs #2674. This updates cache_and_sync.py to add the project start date into the profile data.

Files:

• management/bs-admin/trunk/cache_and_sync.py (modified) (6 diffs)

management/bs-admin/trunk/cache_and_sync.py

@@ -12 +12 @@
-from ConfigParser import ConfigParser
-import time,os
+from time import strftime
+from datetime import datetime
-from difflib import *
-from subprocess import *
@@ -202 +204 @@
-
-def sync_project_profiles():
+  
-  # Create Social DB
-  file = open("/var/www/social/config.php")
@@ -221 +224 @@
-  cursor = conn.cursor()    
-
+  #Trac DB
+  config = ConfigParser()
+  config.read('beaversource.ini')
+  tracuser = config.get('trac', 'dbadmin')
+  tracpass = config.get('trac', 'dbpass')
+  
+  try:
+    tracconn = psycopg2.connect("dbname='projects' user='%s' host='localhost' password='%s'" % (tracuser, tracpass))
+  except:
+    print "Unable to connect to the trac db"
+
+  trac_cursor = tracconn.cursor()
+  
-
-  # New Profile Sync
@@ -252 +268 @@
-      cursor.execute(sql)
-      conn.commit()
+
+
-    else:
-      sql = "INSERT INTO elgg_users (username, active, owner, user_type, moderation) VALUES ('%s', 'yes', '-1', 'person', 'no')" % (p.owner.username)
@@ -353 +371 @@
-          conn.commit()
-        
+        sql = "SELECT time FROM master_wiki WHERE name='WikiStart' AND author='trac' AND dbuser='bs_%s_user'" % (p.short_name)
+        trac_cursor.execute(sql)
+        trac_start_time = trac_cursor.fetchone()[0]
+        trac_time = datetime.fromtimestamp(trac_start_time)
+        trac_db_time = trac_time.strftime("%b %d, %Y - %I:%M %p")
+        sql = "SELECT value FROM elgg_profile_data WHERE owner='%s' AND name='start_time'" % (project_id)
+        cursor.execute(sql)
+        value = cursor.fetchone()
+        if value:
+          sql = "UPDATE elgg_profile_data SET value='%s' WHERE owner='%s' AND name='start_time'" % (trac_db_time, project_id)
+          cursor.execute(sql)
+          conn.commit()
+        else:
+          sql = "INSERT INTO elgg_profile_data VALUES (DEFAULT, '%s', 'LOGGED_IN', 'start_time', '%s')" % (project_id, trac_db_time)
+          cursor.execute(sql)
+          conn.commit()
+
-        sql = "SELECT value FROM elgg_profile_data WHERE owner='%s' AND name='workweb'" % (project_id)
-        cursor.execute(sql)
@@ -369 +404 @@
-        conn.commit()
-
-
-#Call all the funcation
-
-
-
-
-
+#
+#
+#
+#
+#
-sync_project_profiles()