Patch to store user info in different DB engines

Jeff Sheltren sheltren at cs.ucsb.edu
Tue Nov 29 20:43:07 UTC 2005


On Nov 25, 2005, at 6:13 PM, Dan Williams wrote:
>
> Jeff,
>
> Could you retest the user migration script?  It turns out that  
> postgres
> doesn't like double-quotes in the INSERT INTO statement.  Since all  
> the
> rest of the stuff in BuildMaster.py uses single quotes in the SQL
> statements, I switched that bit of the migration script to use
> single-quotes too.
>
> Also, Postgres evidently uses "True" and "False" (probably
> case-insensitive) for fields of type BOOLEAN, so I added a conversion
> function for postgres to do that, and converted the %d format  
> options in
> the INSERT INTO statement to %s instead.
>
> These shouldn't affect MySQL at all, but I just want to be sure...
>
> Thanks!
> Dan

Oops, guess I should have tested it against postgres also.  Your new  
version works fine with mysql.

-Jeff




More information about the Fedora-buildsys-list mailing list