Hi
I'm struggling with an SQLAlchemy issue.
I have a one to many relationship like so:
users_tags = Table(
users_tags, Base.metadata,
Column(user_id, Integer, ForeignKey(users.id)),
Column(tag_id, Integer, ForeignKey(tags.id))
)
class Tag(Base):
__tablename__ = tags
id =
I have a very simple table and query. For some reason it hangs after a few
executions and I have to restart the application.
Code to set it up:
from sqlalchemy import (
Column,
Integer,
String
)
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base()
The problem seems to be independent of context. Happens both when I run
python interactively from the prompt, and from within a Pyramid-based web
app.
I have not tried other connectors or raw DBAPI. Will try that.
On Sat, Jun 13, 2015 at 5:48 AM, Mike Bayer mike...@zzzcomputing.com
wrote:
On
On 6/13/15 5:08 AM, Fayaz Yusuf Khan wrote:
On Sunday 31 May 2015 11:36:12 PM Mike Bayer wrote:
you can send in pysqlcipher3 to create_engine() using the dbapi
argument:
import pysqlcipher3
e = create_engine(sqlite+pysqlcipher:///file.db, dbapi=pysqlcipher3)
feel free to submit a PR that
On 6/13/15 3:54 AM, Dr. wrote:
I have a very simple table and query. For some reason it hangs after a
few executions and I have to restart the application.
Code to set it up:
|
fromsqlalchemy import(
Column,
Integer,
String
)
fromsqlalchemy.ext.declarative importdeclarative_base
On Sunday 31 May 2015 11:36:12 PM Mike Bayer wrote:
you can send in pysqlcipher3 to create_engine() using the dbapi
argument:
import pysqlcipher3
e = create_engine(sqlite+pysqlcipher:///file.db, dbapi=pysqlcipher3)
feel free to submit a PR that returns this DBAPI from the dbapi method
Are you positive there isn't some transactional locking going on?
What does mysql say about locked tables/rows when things are stalled?
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from