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
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
wrote:
>
>
> On 6/13/15 3:54 AM, Dr.
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"
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
Base=declar
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 t
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 "db
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()
c