5b2766aae94c0615aef2c8d6ac178428e6d28745,pymc/database/mysql.py,Trace,tally,#Trace#Any#,46

Before Change

            
        if index + 1 == self.update_interval:
            
            values = ""
            
            for sample in self._trace:
                valstring = ", ".join(sample.astype("c"))
                values += "(NULL, %s, %s)," % (self.current_trace, valstring)
            
            // Add trace to database
            self.db.cur.execute("INSERT INTO %s values %s" % (self.obj.name, values[:-1]))
            
            // Re-initialize trace
            self._trace = zeros(shape(self._trace), self._trace.dtype)

After Change

        except TypeError:
            pass
        
        try:
            // I changed str(x) to "%f"%x to solve a bug appearing due to
            // locale settings. In french for instance, str prints a comma
            // instead of a colon to indicate the decimal, which confuses
            // the database into thinking that there are more values than there
            // is.  A better solution would be to use another delimiter than the
            // comma. -DH
            valstring = ", ".join(["%f"%x for x in self._obj.value])
        except:
            valstring = str(self._obj.value)
        
        // Add value to database
        self.db.cur.execute("INSERT INTO %s (trace, %s) values (%s, %s)" % (self.name, " ,".join(["v%s" % (x+1) for x in range(size)]), self.current_trace, valstring))


class Database(pickle.Database):

Instances