Changeset 188

Timestamp:

01/22/09 13:19:03 (10 months ago)

Author:

gallardj

Message:

Fixes #2929. Uses a smart truncate function to clip the project description to around 35 characters for easy viewing on the browse page.

Files:

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

management/bs-admin/trunk/cache_and_sync.py

@@ -195 +195 @@
-
-
+def smart_truncate(content, length=35, suffix='...'):
+  if len(content) <= length:
+    return content
+  else:
+    return ' '.join(content[:length+1].split(' ')[0:-1]) + suffix
+
-def sync_project_profiles():
-  # Create Social DB
@@ -321 +327 @@
-          conn.commit()
-        
+        sql = "SELECT value FROM elgg_profile_data WHERE owner='%s' AND name='minibio'" % (project_id)
+        cursor.execute(sql)
+        value = cursor.fetchall()
+        if value:
+          sql = "UPDATE elgg_profile_data SET value=%s WHERE owner=%s AND name='minibio'"
+          cursor.execute(sql, (smart_truncate(descr), project_id))
+          conn.commit()
+        else:
+          sql = "INSERT INTO elgg_profile_data VALUES (DEFAULT, %s, 'LOGGED_IN', 'minibio', %s)"
+          cursor.execute(sql, (project_id, smart_truncate(descr)))
+          conn.commit()
+        
-        sql = "SELECT value FROM elgg_profile_data WHERE owner='%s' AND name='workweb'" % (project_id)
-        cursor.execute(sql)