Changeset 529

Timestamp:

10/09/08 18:06:17 (5 years ago)

Author:

rcorsaro

Message:

added canonize schema method to solve some problems with bad schema names

File:

• trunk/plugins/oforgeplugin/oforge/api.py (modified) (3 diffs)

trunk/plugins/oforgeplugin/oforge/api.py

@@ -149 +149 @@
         return dburl
 
+    def _canonize_schema_name(self, name):
+        return ("workspace_%s"%(re.sub('(\W+)', '', name))).lower()
+
     def converttopostgres(self, name):
         """
@@ -155 +158 @@
         # Setup vars
         config = self.getconfig(name)
-        new_user_schema_name = re.sub('\W+', '', name)
+        new_user_schema_name = self._canonize_schema_name(name)
         new_password = config.get('oforge','initial_db_password', 'secret')
         project_desc = config.get('project','desc', name)
@@ -294 +297 @@
             dburl = None
             if postgres:
-                new_user_schema_name = re.sub('\W+', '', name)
+                new_user_schema_name = self._canonize_schema_name(name)
                 new_password = self.config.get('oforge','initial_db_password', 'secret')
                 self._create_postgres_user_and_schema(new_user_schema_name, new_password)