HI Hermann -
table/column naming looks like this:
mytable = Table('sometablename', metadata,
Column('colname', Integer, key='someothername')
)
access the column:
mytable.c.someothername
so above, we access the real database table "sometablename.colname"
using an expression such as "mytable.c.someothername", so both names
are modified in the application against what they are in the database.
- mike
On Oct 15, 2007, at 3:33 AM, Hermann Himmelbauer wrote:
>
> Hi,
> I'm currently implementing an application, which accesses a
> database that's
> implemented in german. Table and column names are all in german.
>
> As some english-only speaking programmers are involved in the
> development, I'm
> considering renaming them to english, as otherwise, these german
> identifiers
> will be all over the Python code. However, I must not directly
> rename them in
> the database itself, as other older applications are depending on
> the german
> identifiers.
>
> But, perhaps there's a way to alias the table and column names via
> SA in some
> way?
>
> Best Regards,
> Hermann
>
> --
> [EMAIL PROTECTED]
> GPG key ID: 299893C7 (on keyservers)
> FP: 0124 2584 8809 EF2A DBF9 4902 64B4 D16B 2998 93C7
>
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
