[Biopython-dev] [Bug 2390] Error importing Swiss Prot in BioSQL

bugzilla-daemon at portal.open-bio.org bugzilla-daemon at portal.open-bio.org
Mon Nov 5 16:22:22 UTC 2007


http://bugzilla.open-bio.org/show_bug.cgi?id=2390





------- Comment #8 from Biosql at hotmail.com  2007-11-05 11:22 EST -------
Hi Peter, 

Here's the SQL query : 

INSERT INTO bioentry (
         biodatabase_id,
         name,
         accession,
         identifier,
         division,
         description,
         version)
        VALUES (%s,
         %s,
         %s,
         %s,
         %s,
         %s,)"""
        self.adaptor.execute(sql, (self.dbid, record.name,
accession,identifier,
                                   division, description, version))

You can see there's a missing %s. 

There's also a similar error in DBUtils module at line 23, where an argument is
also missing. 

sql = r"select max(%s_id) from %s" % table

I've change the line with this one : 

sql = r"select max(%s_id) from %s" % (table, table)

I also tried your suggested patch and I'm not receiving any error since, which
is great ! But, nothing's getting uploaded in the database... Crap...

Again, many thanks for the help Peter. 


-- 
Configure bugmail: http://bugzilla.open-bio.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.



More information about the Biopython-dev mailing list