Hi, I am also going share Django ORM and SQLAlchemy connections.
Do you know the solution?
Thomas
W dniu środa, 22 czerwca 2011 20:38:54 UTC+2 użytkownik Vladimir Mihailenco
napisał:
>
> I am trying to share connection between Django and SqlAlchemy. I tried
> following code:
>
> from django.db import connection
> from sqlalchemy import create_engine
>
> def get_connection():
> if connection.connection is None:
> connection._cursor() # TODO: better way to open new
> connection?
> return connection.connection
>
> engine = create_engine('postgresql+psycopg2://',
> creator=get_connection)
> engine.execute(s) # s - SqlAlchemy query
>
> But this results in various fails in SqlAchemy (like connection is
> already closed, can't execute some queries). More details are
> available here:
> http://stackoverflow.com/questions/6439119/django-and-sqlalchemy-share-connection
>
>
> So I have following question:
>
> - does anyone know working solution?
> - how big will be performance impact if I use separate connection for
> Django and SqlAlchemy?
> - any explanations why current code is not working :)
>
> Thanks.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
For more options, visit https://groups.google.com/groups/opt_out.
