Re: [sqlalchemy] How to reload data from table/all tables using sqlalchemy ORM?

2019-04-23 Thread Jan Sakalos
Hi, many thanks for advice. I did research and found some materials about this topic, so will study little bit. Jano On Tue, Apr 23, 2019 at 12:18 PM Simon King wrote: > I think you need to consider the transactional behaviour of your > application. Remember that if your application crashes (

Re: [sqlalchemy] How to reload data from table/all tables using sqlalchemy ORM?

2019-04-23 Thread Simon King
I think you need to consider the transactional behaviour of your application. Remember that if your application crashes (or more specifically, if a DB connection is unexpectedly closed), anything that has not been committed will be lost. It is possible for one connection to see data from another c

Re: [sqlalchemy] How to reload data from table/all tables using sqlalchemy ORM?

2019-04-23 Thread Jan Sakalos
Hi, API will add rows to table and main loop will have to read them. Meanwhile i found out following ses.commit() will have this effect, but maybe there is more straightforward command. As suggested in documentation, session should not live for so long so maybe it is more suitable to use new s

Re: [sqlalchemy] How to reload data from table/all tables using sqlalchemy ORM?

2019-04-23 Thread Simon King
On Mon, Apr 22, 2019 at 5:09 PM Jan Sakalos wrote: > > Hello, > > How to reload data from table/all tables using sqlalchemy ORM? > > Thanks > Jano > Hi, Can you explain what you mean by "reload data"? Thanks, Simon -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://

[sqlalchemy] How to reload data from table/all tables using sqlalchemy ORM?

2019-04-22 Thread Jan Sakalos
Hello, How to reload data from table/all tables using sqlalchemy ORM? Thanks Jano -- 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://stackoverflo