On Mon, Nov 16, 2009 at 06:57, BruceC <bruce.co...@hp.com> wrote:
> I'm trying to implement a character counter on all textarea fields in
> my Elixir-SQLA-Pylons app, & need to find a way to determine the
> maximum number of characters a given column can hold, so I can supply
> the character counter with a "Maximum characters" value. Anyone know
> of a simple method of finding the size-limit of a column?
I use some code which is along the lines of:
prop_length = {}
for prop in mapper.iterate_properties:
if isinstance(prop, sqlalchemy.orm.properties.ColumnProperty):
col = prop.columns[0]
if isinstance(col, sqlalchemy.schema.Column):
if col.type.__class__ in (sqlalchemy.Unicode, sqlalchemy.String):
if col.type.length:
prop_length[prop.key] = col.type.length
--
Gaëtan de Menten
http://openhex.org
--~--~---------~--~----~------------~-------~--~----~
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
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
