[sqlalchemy] Re: SQLAlchemy - Postgres Connection Issue

2018-10-15 Thread Shankar Ganesh
@jonathan I went through that. What is the possible reason for disconnect ? I am not restarting my dbs. On Monday, 15 October 2018 20:43:45 UTC+5:30, Jonathan Vanasco wrote: > > There are a few strategies to handling disconnects that are outlined in > the docs: > > > https://docs.sqlalchemy.

[sqlalchemy] Re: SQLAlchemy - Postgres Connection Issue

2018-10-15 Thread Shankar Ganesh
s-it-odd-that-my-sqlalchemy-mysql-connection-always-ends-up-sleeping> Handle mysql restart in SQLAlchemy <https://stackoverflow.com/questions/3033234/handle-mysql-restart-in-sqlalchemy> On Monday, 15 October 2018 19:31:07 UTC+5:30, Shankar Ganesh wrote: > > Hi > > Flask with

[sqlalchemy] SQLAlchemy - Postgres Connection Issue

2018-10-15 Thread Shankar Ganesh
Hi Flask with SQLAlchemy Flask==0.10.1 SQLAlchemy==1.0.8 In production after a lot of usages (connection) we are getting this error. After that restarting the server helps, what will be the permanent solution OperationalError: (psycopg2.OperationalError) server closed the connection unexpec

Re: [sqlalchemy] Update Primary Key in the Session Data based Unique Key

2016-05-26 Thread Shankar Ganesh
gs separately on these sets to establish the data in > the database. > > > http://docs.sqlalchemy.org/en/latest/orm/session_api.html?highlight=bulk_insert#sqlalchemy.orm.session.Session.bulk_insert_mappings > > > > http://docs.sqlalchemy.org/en/latest/orm/session_api.html?highlight=bulk

[sqlalchemy] Update Primary Key in the Session Data based Unique Key

2016-05-24 Thread Shankar Ganesh
Hi, I need to know about what is the best way for doing update session data (session data is incomplete - not having the entire data) . Say data doesn't have primary key itself, How we can populate the primary key in the SQL Alchemy session ? Use Case: * Have the arbitrary data currently, ne

[sqlalchemy] Update Primary Key in the Session Data based Unique Key

2016-05-24 Thread Shankar Ganesh
Hi, I need to know about what is the best way for doing update session data (session data is incomplete - not having the entire data) . Say data doesn't have primary key itself, How we can populate the primary key in the SQL Alchemy session ? Suggested ways: We can put the entire data into t

[sqlalchemy] Re: Marshmallow Sqlalchemy

2016-04-11 Thread Shankar Ganesh
Mike, Thanks. I posted the same in github also. Posted the same because if there is any one knows how to solve this if they are also using marshmallow-sqlalchemy package . Regards, Shankar. On Monday, 11 April 2016 19:45:38 UTC+5:30, Shankar Ganesh wrote: > > Hi, > > Is there a

[sqlalchemy] Marshmallow Sqlalchemy

2016-04-11 Thread Shankar Ganesh
Hi, Is there a way to avoid inserting the data into session while using Marshmallow - sqlalchemy sqlalchemy marshmallow avoid loading into session Ref: https://marshmallow-sqlalchemy.readthedocs.org/en/latest/ Because we tried to manage the objects by ourself. Will add into the session if req