Changeset 31401

Timestamp:

Apr 28, 2011, 3:49:36 PM (15 years ago)

Author:

rhenders

Message:

added method to make a certain column of a certain table unique

File:

• trunk/ippToPsps/jython/mysql.py (modified) (2 diffs)

trunk/ippToPsps/jython/mysql.py

@@ -65 +65 @@
         except: return
 
+    '''
+    Alters a column to be unique
+    '''
+    def makeColumnUnique(self, table, column):
+
+        self.logger.debug("Making '"+column+"' unique on table '"+table+"'")
+
+        sql = "ALTER TABLE " + table + " ADD UNIQUE (" + column + ")"
+        try:
+            self.stmt.execute(sql)
+        except: pass
+            #self.logger.warn("Index already in place on '" + column + "' for table '" + table + "'")
     '''
     Adds an index to the supplied table and column
@@ -97 +109 @@
 
       sql = "UPDATE " + tableName + " SET " + column + " = " + sub + " WHERE " + column + " IS NULL"
-      print sql
       self.stmt.execute(sql)