Hi all,
the subject pretty much explains it all. Here's a complete example of the
issue. Any tips will be appreciate.

Regards,
Mariano

Python 2.7.2 (default, Oct 14 2011, 23:34:02)
[GCC 4.5.2] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlalchemy
>>> sqlalchemy.__version__
'0.7.3'
>>> from sqlalchemy import Table, Column, Integer, create_engine, MetaData, 
>>> CheckConstraint
>>> from sqlalchemy.orm import sessionmaker
>>> session = sessionmaker()
>>> Session = session()
>>> engine = create_engine('postgresql://usr:passws@localhost/base', echo=True)
>>> Session.configure(bind=engine)
>>> md = MetaData()
>>> md.bind = engine
>>> t = Table("test_ck", md, Column("id", Integer, primary_key=True),
... Column("id2", Integer, CheckConstraint("id2 between 1 and 10", 
name="my_constraint")))
>>> md.create_all(engine)
2011-10-21 19:53:45,523 INFO sqlalchemy.engine.base.Engine select version()
2011-10-21 19:53:45,523 INFO sqlalchemy.engine.base.Engine {}
2011-10-21 19:53:45,708 INFO sqlalchemy.engine.base.Engine select 
current_schema()
2011-10-21 19:53:45,709 INFO sqlalchemy.engine.base.Engine {}
2011-10-21 19:53:45,804 INFO sqlalchemy.engine.base.Engine select relname from 
pg_class c join pg_namespace n on n.oid=c.relnamespace where 
n.nspname=current_schema() and relname=%(name)s
2011-10-21 19:53:45,804 INFO sqlalchemy.engine.base.Engine {'name': u'test_ck'}
2011-10-21 19:53:46,168 INFO sqlalchemy.engine.base.Engine
CREATE TABLE test_ck (
        id SERIAL NOT NULL,
        id2 INTEGER CHECK (id2 between 1 and 10),
        PRIMARY KEY (id)
)


2011-10-21 19:53:46,168 INFO sqlalchemy.engine.base.Engine {}
2011-10-21 19:53:47,116 INFO sqlalchemy.engine.base.Engine COMMIT
>>>

-- 
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.

Reply via email to