On Wed, Oct 24, 2018 at 7:15 PM Jonathan Vanasco wrote:
>
> A new suite of unittests shed light on what appears to be anti-pattern in an
> application. I'm not sure how to address this one.
>
>
> The general flow of a particular web request is this:
>
>
> Phase 1- load some database objects for
On Wed, Oct 24, 2018 at 7:24 PM Travis Briggs wrote:
>
>
>
> On Wed, Oct 24, 2018 at 3:35 PM Mike Bayer wrote:
>>
>> On Wed, Oct 24, 2018 at 4:54 PM Travis Briggs wrote:
>> >
>> > Hi,
>> >
>> > I'm trying to apply a unit of work pattern, where I'm processing all of
>> > the "items" in a
On Wed, Oct 24, 2018 at 3:35 PM Mike Bayer wrote:
> On Wed, Oct 24, 2018 at 4:54 PM Travis Briggs wrote:
> >
> > Hi,
> >
> > I'm trying to apply a unit of work pattern, where I'm processing all of
> the "items" in a category, and I'm opening my session before I query for
> the items in the
A new suite of unittests shed light on what appears to be anti-pattern in
an application. I'm not sure how to address this one.
The general flow of a particular web request is this:
Phase 1- load some database objects for general verification
Phase 2- loop through a handful of routines to
On Wed, Oct 24, 2018 at 4:54 PM Travis Briggs wrote:
>
> Hi,
>
> I'm trying to apply a unit of work pattern, where I'm processing all of the
> "items" in a category, and I'm opening my session before I query for the
> items in the category, then closing the session when the items are all
>
Hi,
I'm trying to apply a unit of work pattern, where I'm processing all of the
"items" in a category, and I'm opening my session before I query for the
items in the category, then closing the session when the items are all
processed.
However, this still could take several minutes and I'm
On Wed, Oct 24, 2018 at 4:12 AM Stanisław Skonieczny
wrote:
>
> It uses threads. It may be correlated with high load, as it usually happens
> when process is run during upgrade. Schema of the table is as follows (I have
> removed unrelated tables and fields):
OK so this is not something you
Query that behaves badly is:
session.query(MyTable).join(MyOtherTable, and_(
ParentMyOtherTable.id == MyTable.parent_id,
ParentMyOtherTable.volume_id == MyTable.volume_id
))
On Wednesday, 24 October 2018 10:12:43 UTC+2, Stanisław Skonieczny wrote:
It uses threads. It may be correlated with high load, as it usually happens
when process is run during upgrade. Schema of the table is as follows (I
have removed unrelated tables and fields):
from sqlalchemy import Column, BigInteger, ForeignKey
from sqlalchemy.ext.declarative import