>
> from sqlalchemy.dialects.mysql import INTEGER as Integer
> my_int = Column(Integer(unsigned=True))


from:
http://blog.luhn.com/post/20919696026/unsigned-integers-with-sqlalchemy-and-mysql

Keep in mind, as Theron notes on his blog post, that this is MySQL specific
so you won't have compatibility with other DBs.


On 9 June 2013 22:14, Avishay Balderman <balder...@gmail.com> wrote:

> Hi
> I would like to create a table with an integer column.
> This column value must be >= 0.
> How can I enforce it using table defintion?
> i have looked here and it looks fine.
>
> http://docs.sqlalchemy.org/en/rel_0_8/core/schema.html?highlight=checkconstraint#sqlalchemy.schema.CheckConstraint
> Will it work against any DB?
> My backing DB is MySQL.
>
> Thanks
>
> Avishay
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to sqlalchemy+unsubscr...@googlegroups.com.
> To post to this group, send email to sqlalchemy@googlegroups.com.
> Visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to