Thanks your suggestion first!
And I got another question now.
The Column name has space like below.
user = Table('tbl_user', metadata,\
Column('name', VARCHAR(20)),\
Column('phone number', VARCHAR(20)))
1. when select
user.c.get('phone number') =='12345678'))
2. when insert
{user.c.get('phone number):''7890'}
I should get phone number object in the ugly way. any function in
sqlalcemy could alias column name as below?
1. when select
user.c.name =='nick'
2. when insert
name = 'lisa'
On Jan 23, 12:22 am, Alex K <[email protected]> wrote:
> You can definitely access this table, using SQL engine only
>
> my_table = Table('my_table', metadata,
> Column('my_field', String)
> )
>
> #now we can perform the query
> session.connection().execute(my_table.select())
> #more info here:http://www.sqlalchemy.org/docs/05/sqlexpression.html
>
> On Jan 22, 11:56 am, Ikuta <[email protected]> wrote:
>
> > Hi
>
> > I have a question here, is it possible to access a read-only table
> > (without primary_key) in ORM method?
>
> > Thanks!
>
> > Ikuta
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
