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.
