On Thu, Jan 11, 2018 at 9:14 PM, <[email protected]> wrote:
> Hello,
>
> Is below the way to reconnect to postgresql server automatically?
> everytime I need to remake a session with
> "Session = sessionmaker(bind=engine)
> session = Session()"
> , is this right?
>
> the codes below can work, but if I don't remake the session, it will failed
> at server timeout.
you should close the Session immediately as soon as you are done using
it to emit some commands to the database. It should not be left idle
and open.
>
>
> #!/bin/env python
>
> from urllib import quote_plus as urlquote
> import sqlalchemy
> from sqlalchemy import create_engine
> from sqlalchemy.ext.declarative import declarative_base
> from sqlalchemy import Column, Integer, String
> from sqlalchemy.orm import sessionmaker
>
> Base = declarative_base()
>
> engine =
> create_engine('postgresql+psycopg2://ngrs_reg:%[email protected]/arden_ngrs'%urlquote('ngrs_reg@123'),
> echo=True, pool_recycle=599)
>
> class Arch(Base):
> __tablename__ = 'arch'
> arch_id = Column(Integer, primary_key=True)
> arch_name = Column(String)
>
>
> Session = sessionmaker(bind=engine)
> session = Session()
>
> #print dir(session)
>
> print dir(session.query(Arch))
> for x in session.query(Arch):
> print x.arch_id, x.arch_name
>
> import time
> print 'sleeping'
>
> #conn = session.connection()
>
> # test timeout
> time.sleep(3600)
> print 'waken'
>
> Session = sessionmaker(bind=engine)
> session = Session()
>
> print dir(session.query(Arch))
> for x in session.query(Arch):
> print x.arch_id, x.arch_name
> ~
>
> --
> SQLAlchemy -
> The Python SQL Toolkit and Object Relational Mapper
>
> http://www.sqlalchemy.org/
>
> To post example code, please provide an MCVE: Minimal, Complete, and
> Verifiable Example. See http://stackoverflow.com/help/mcve for a full
> description.
> ---
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at https://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/d/optout.
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
