Re: [sqlalchemy] Checking approaches around parallel data import for records

2019-04-24 Thread Mike Bayer
On Wed, Apr 24, 2019 at 12:19 PM Markus Elfring wrote: > > > Why not report these problems to the cochinelle tool > > which you are trying to integrate ? > > I suggest to take another look at corresponding information sources. > https://systeme.lip6.fr/pipermail/cocci/2019-April/thread.html >

Re: [sqlalchemy] Checking approaches around parallel data import for records

2019-04-24 Thread Markus Elfring
> Why not report these problems to the cochinelle tool > which you are trying to integrate ? I suggest to take another look at corresponding information sources. https://systeme.lip6.fr/pipermail/cocci/2019-April/thread.html https://github.com/coccinelle/coccinelle/issues Regards, Markus --

Re: [sqlalchemy] Checking approaches around parallel data import for records

2019-04-24 Thread Mike Bayer
On Wed, Apr 24, 2019, 1:50 AM Markus Elfring wrote: > >> Other software architectures can support parallelisation better, > can't they? > > > > Can you clarify what you hope to achieve when you continue to make > statements > > of this form? I don't find them to be very constructive. > > I

[sqlalchemy] Re: What is the standard/best way to merge an object graph into the session?

2019-04-24 Thread James Fennell
Okay let me answer my own question. The problem is that my parent-child relationship does not have the delete-orphan cascade. So when I set the new children, the old child_2 loses its parent (as is expected, because it's no longer a child) and then there's an error because the DB has a not null

[sqlalchemy] Re: What is the standard/best way to merge an object graph into the session?

2019-04-24 Thread James Fennell
Oooo the problem is not what I thought. The problem is that in my 'new data' there is no new_child_2. This is an expected case, as sometimes children disappear, so will update the post. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To

[sqlalchemy] What is the standard/best way to merge an object graph into the session?

2019-04-24 Thread James Fennell
I have a parent child relationship which I construct from a data feed. At the time of constructing the object graph I don't have access to the primary keys of the entities, so I build up the object graph by using the relationship attributes. My understanding was that I could perform a

Re: [sqlalchemy] Checking approaches around parallel data import for records

2019-04-24 Thread Markus Elfring
>> Other software architectures can support parallelisation better, can't >> they? > > Can you clarify what you hope to achieve when you continue to make statements > of this form? I don't find them to be very constructive. I dared to point out that I stumbled on another software

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

2019-04-24 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