[prev in list] [next in list] [prev in thread] [next in thread] 

List:       fedora-buildsys-list
Subject:    Re: Patch to store user info in different DB engines
From:       Jeff Sheltren <sheltren () cs ! ucsb ! edu>
Date:       2005-11-29 20:43:07
Message-ID: 16FF7F6D-30FB-412E-ABC3-FE556797487A () cs ! ucsb ! edu
[Download RAW message or body]

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

[prev in list] [next in list] [prev in thread] [next in thread]