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