On Aug 31, 2010, at 9:29 PM, Petr Kobalíček wrote:
> Hi devs,
>
> how to get column type from a column instance?
>
> Imagine following table:
>
> RecordTable = Table('t_record', metadata,
> Column('record_id', Integer, primary_key = True),
> Column('dep', Integer, default=None)
> )
>
> I can get my column using:
>
> engine = engine_from_config({
> "sqlalchemy.url": "postgresql:///",
> "sqlalchemy.convert_unicode": True,
> "sqlalchemy.echo": True
> }, prefix="sqlalchemy.")
>
> metadata = MetaData()
> metadata.bind = engine
>
> column = RecordTable.c.dep
>
> Now I'd like to print (for example) 'column' type for 'engine'. This
> is same type which will be used when I use metadata.create_all().
>
> The best I can print is:
> print column.type.get_dbapi_type(engine.dialect.dbapi).name
> which prints me 'NUMBER', but I'm expecting 'INT' (postgres).
youd here want to say print type.compile(engine.dialect).
>
> Best regards
> Petr Kobalicek
>
> --
> 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.
>
--
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.
