Changeset 32590 for trunk/ippToPsps/jython/scratchdb.py

Timestamp:

Oct 28, 2011, 11:41:25 AM (15 years ago)

Author:

rhenders

Message:

Fixed method to install psfLikelihood() stored procedure

File:

• trunk/ippToPsps/jython/scratchdb.py (modified) (3 diffs)

trunk/ippToPsps/jython/scratchdb.py

@@ -33 +33 @@
         self.logger.debugPair("Using DVO detection table", self.dvoDetectionTable)
 
-        #self.createPsfLikelihoodFunction()
-
     '''
     Destructor
@@ -47 +45 @@
     def createPsfLikelihoodFunction(self):
 
-        sql = "DELIMITER $$ \
-               DROP FUNCTION IF EXISTS `psfLikelihood` $$ \
-               CREATE FUNCTION `psfLikelihood`(x REAL) RETURNS REAL \
+        sql = "DROP FUNCTION IF EXISTS `psfLikelihood`"
+        try:
+            self.execute(sql)
+        except:
+            self.logger.errorPair("Could not drop stored procedure", "psfLikelihood")
+            return False
+
+        sql = "CREATE FUNCTION `psfLikelihood`(x REAL) RETURNS REAL \
                DETERMINISTIC \
                COMMENT 'Returns the psfLikelihood using the complimentary error function with fractional error everywhere less than 1.2 x 10-7. From Numerical Recipes in C' \
@@ -64 +67 @@
                END IF; \
                RETURN ans; \
-               END $$ \
-               DELIMITER ;"
+               END"
 
         try: