Changeset 31820 for trunk/ippToPsps/jython/mysql.py

Timestamp:

Jul 1, 2011, 3:59:16 PM (15 years ago)

Author:

rhenders

Message:

new method that gets an updatable result set. we use this to update the likelihoods; new method to make a column the primary key

File:

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

trunk/ippToPsps/jython/mysql.py

@@ -112 +112 @@
         except: pass
             #self.logger.warn("Index already in place on '" + column + "' for table '" + table + "'")
+
+    '''
+    Alters a column to be the primary key
+    '''
+    def makeColumnPrimaryKey(self, table, column):
+
+        self.logger.debug("Making '"+column+"' the primary key on table '"+table+"'")
+
+        sql = "ALTER TABLE " + table + " ADD PRIMARY KEY (" + column + ")"
+        try:
+            self.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
@@ -143 +156 @@
         return rs
 
+    '''
+    TODO
+    '''
+    def executeUpdatableQuery(self, sql):
+
+        stmt = self.con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE)
+        rs = stmt.executeQuery(sql)
+        #stmt.close()
+        return rs
     '''
     Returns a list of column names for this table