Tom,
On Mon, Oct 27, 2008 at 4:03 PM, Tom H <[EMAIL PROTECTED]> wrote:
>
> I'm experiencing the following problem with SA 0.4.7
>
> The table has the following columns:
> id - int primary key
> DOB - varchar(25)
> ... extra columns not needed for report
>
> It's a table from legacy app that I'm accessing from SA to generate
> reports, etc.
>
> I'm having the table definition auto load (reflected from the
> database) like this:
>
> myTable = Table('sample_table', metadata, autoload=True,
> include_columns=['id', 'DOB'])
>
> When I later retreive data, the DOB column is not reflected. If I
> change 'DOB' to 'dob' for the include_columns list, the column is
> reflected as 'DOB' ... strange that the reflected name is capitalized,
> but when I specify all caps for include_columns the field is not
> reflected.
>
> Any recommendations or suggestions for dealing with this issue?
>
The problem is related to this bit of code.:
if only and name.lower() not in only:
self.logger.info("Omitting reflected column %s.%s" %
(table.name, name))
return
If you would please submit a ticket we can get it fixed.
Thanks,
Michael
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---