[sqlalchemy] Any recommended approach for creating a new dialect?

2015-04-07 Thread Ralph Heinkel
Hello dialect experts, what would be the best approach for creating a SqlAlchemy dialect for a new database system? Are there any recipes available for this area, or is the way to go to read code of existing dialects and derive my own dialect from those? I had a first glance at some built-in

Re: [sqlalchemy] Test test/engine/test_pool.py::QueuePoolTest::()::test_queuepool_close fails

2015-04-07 Thread Mike Bayer
it's a test that very seldom fails in some cases no matter what, as it's checking reference counts on objects that are expected to be garbage collected without any cycles. A failure of this test is not strictly a bug, it just refers to connections or cursors that are not collected

[sqlalchemy] Test test/engine/test_pool.py::QueuePoolTest::()::test_queuepool_close fails

2015-04-07 Thread Tony Locke
Hi, I found the following SQLAlchemy test fails: FAIL test/engine/test_pool.py::QueuePoolTest::()::test_queuepool_close with the stack trace: __ QueuePoolTest.test_queuepool_close ___ Traceback (most recent call last): File

[sqlalchemy] Reverse delete orphan?

2015-04-07 Thread Jonathan Gordon
How can I cascade delete from a many to one only when deleting the many means this one has no other children? Imagine the following mapping: class Container(Base): __tablename__ = 'container' pk = sa.Column(sa.Integer, primary_key=True) entries = relationship('Entry',

Re: [sqlalchemy] Reverse delete orphan?

2015-04-07 Thread Mike Bayer
On 4/7/15 4:43 PM, Jonathan Gordon wrote: How can I cascade delete from a many to one only when deleting the many means this one has no other children? Imagine the following mapping: class Container(Base): __tablename__ = 'container' pk = sa.Column(sa.Integer, primary_key=True)

Re: [sqlalchemy] Test test/engine/test_pool.py::QueuePoolTest::()::test_queuepool_close fails

2015-04-07 Thread Mike Bayer
On 4/7/15 4:33 PM, Mike Bayer wrote: it's a test that very seldom fails in some cases no matter what, as it's checking reference counts on objects that are expected to be garbage collected without any cycles. A failure of this test is not strictly a bug, it just refers to connections or

Re: [sqlalchemy] Test test/engine/test_pool.py::QueuePoolTest::()::test_queuepool_close fails

2015-04-07 Thread Mike Bayer
On 4/7/15 4:33 PM, Mike Bayer wrote: it's a test that very seldom fails in some cases no matter what, as it's checking reference counts on objects that are expected to be garbage collected without any cycles. A failure of this test is not strictly a bug, it just refers to connections or

Re: [sqlalchemy] Any recommended approach for creating a new dialect?

2015-04-07 Thread Mike Bayer
On 4/7/15 1:59 PM, Ralph Heinkel wrote: Hello dialect experts, what would be the best approach for creating a SqlAlchemy dialect for a new database system? Are there any recipes available for this area, or is the way to go to read code of existing dialects and derive my own dialect from