of releases to become the default) would make
this an instance of a pit of success
<https://blog.codinghorror.com/falling-into-the-pit-of-success/>.
Of course this would need quite some effort. Thanks to your help, I
think, we are good now: I added a safe_expire helper to our code base
using
about this when writing that code (because I knew the objects in
question are clean anyway).
Greetings and thanks for any insights,
Torsten
--
$---+1+2+3+4+5+6+
SCALE GmbH
Niederlassung Dresden
Torsten Landschoff
Pohlandstraße 19
01309 Dresden
Tel:
our hard work in creating SQLAlchemy!
Greetings, Torsten
--
$---+1+2+3+4+5+6+
SCALE GmbH
Niederlassung Dresden
Torsten Landschoff
Pohlandstraße 19
01309 Dresden
Tel: +49-351-312002-10
Fax: +49-351-312002-29
SCALE GmbH
Registergericht und Sitz: Ingolstad
Hi Mike,
thanks for the reply.
On Thursday, August 25, 2016 at 3:57:30 PM UTC+2, Mike Bayer wrote:
>
>
>
> well dependencyprocessor is about doing the objects in the right order,
>
clear.
> and about invoking a command to "sync" important attributes from one
> side to the other, which
Hi Mike,
On Wednesday, August 24, 2016 at 1:27:42 PM UTC+2, Mike Bayer wrote:
> if you've already solved the problem I'd rather not get into it :)
>
>
I am still curious about the inner workins of the DependencyProcessors of
sqlalchemy and how it would be possible to implement a custom
Hi all,
On Wednesday, August 24, 2016 at 3:17:55 AM UTC+2, Torsten Landschoff wrote:
>
> I am currently pulling my hair out because I have a solution that I think
> should work on the database side (albeit I don't like it), but I can't
> figure out how to do this with sqlalchemy.
Hi *,
this post is a bit short on data because I just wrote a long posting and it
seems to have vanished when I hit the "POST" button. *sigh*
I am trying to do something (admittedly crazy) like this, but without the
after_flush hook - I'd rather like to tell the ORM that member_ids is
Hello everybody,
I am currently pulling my hair out because I have a solution that I think
should work on the database side (albeit I don't like it), but I can't
figure out how to do this with sqlalchemy.
My current goal is to manage (long-lived) locks on copy-on-write
hierarchical data that
/2816 for that.
just to verify, state.key does what you want, right?
Correct. I was just wondering if the right name for it is key or
InstanceState.identity_key, the latter is documented.
Thanks and greetings,
Torsten
- --
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten
test for the ObjectDeletedError).
Greetings, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-312002-10
Fax: +49-(0)351-312002-29
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
DYNAmore Gesellschaft für FEM
an earlier message from you on this list:
On 11/09/2012 11:36 PM, Michael Bayer wrote:
On Nov 8, 2012, at 5:01 PM, Torsten Landschoff wrote:
My first tests with the SQLAlchemy core where promising, but when using
the ORM I get a bunch of deadlocks where it seems like the session opens
two
Hi Michael,
first, thank you for the extensive explanation, it is much appreciated.
On 11/28/2012 04:59 PM, Michael Bayer wrote:
On Nov 28, 2012, at 6:34 AM, Torsten Landschoff wrote:
Let me get that straight: You are saying that a single Session can
have *multiple concurrent* connections
,
Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registration court: Mannheim, HRB: 109659, based in Karlsruhe,
Managing director: Prof
Hi Michael,
On 11/09/2012 11:36 PM, Michael Bayer wrote:
On Nov 8, 2012, at 5:01 PM, Torsten Landschoff wrote:
My first tests with the SQLAlchemy core where promising, but when using
the ORM I get a bunch of deadlocks where it seems like the session opens
two connections A and B where A locks
and commit/rollback session
events, but this still created locking errors due to read requests going
unchecked.
Greetings, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch
Hi all,
sorry for pulling out this old thread again. I continuously run into this.
Am 08/09/2010 11:20 PM, schrieb Michael Bayer:
If I'm understanding correctly, that's not as much about merging as it
is for the unique object recipe, which is this:
deserialization can not go via
__init__.
Greetings, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registration court: Stuttgart, HRB 733694
fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registration court: Stuttgart, HRB 733694
Managing director: Prof. Dr. Karl Schweizerhof, Dipl.-Math. Ulrich Franz
On Tue, 2012-01-31 at 12:52 +0100, Torsten Landschoff wrote:
However, with SQLAlchemy 0.7.5 I get
$ python new_instance.py
Traceback (most recent call last):
File new_instance.py, line 27, in module
session.commit()
[...]
File
/usr/local/lib/python2.6/dist-packages
Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registration court: Mannheim, HRB: 109659, based in Karlsruhe,
Managing director: Prof. Dr. K. Schweizerhof, Dipl.-Math. U
really just calls append_from on the
copied select.
Greetings, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registration court
is an instance of Select? Are there any plans to add a
generative way to extend the froms of a Select? ;-)
Thanks and Greetings, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registration court: Mannheim, HRB: 109659, based in Karlsruhe,
Managing director: Prof. Dr. K. Schweizerhof, Dipl.-Math. U. Franz
at the
MapperExtension in the hope that there is a callback whenever an
instance is expired, but does not seem to be such a thing.
Hints welcome,
Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mapping the derived class?
Greetings, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registration court: Mannheim, HRB: 109659
Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registration court: Mannheim, HRB: 109659, based in Karlsruhe,
Managing director: Prof. Dr. K. Schweizerhof, Dipl.-Math. U
On Tue, 2011-07-12 at 17:47 +0200, Torsten Landschoff wrote:
How can I correlate the subquery in this context? There is a bunch of
correlate methods (Query.correlate, Select.correlate) but I do not
really understand how to make use of it here.
Okay, I found it: correlate does
is still supported when using ORM mapped
classes and __new__ is not. Is there any reason why the latter is harder
to support? Or is it a matter of too little gain (who is using __new__
anyway?) for too much work?
Greetings, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten
the unique constraint.
Is there a way to do what I want without bigger changes to the code? For
now, I will disable the unique constraint again and add some checks to
the Python code.
Greetings, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel
tacked on.Particularly with
pickling this is problematic.
Good point, I missed that __new__ might be needed for unpickling.
Thanks!
Greetings, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351
instance = manager_of_class(MyClass).new_instance()
but I am wondering if this should be needed, especially since the
ClassManager class is not documented. What should I be using instead?
Greetings, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office
.
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registration court: Mannheim, HRB: 109659, based in Karlsruhe,
Managing director: Prof. Dr. K
On Thu, 2011-05-26 at 08:34 +0200, Torsten Landschoff wrote:
basic question: Can I call identity_key in after_commit? If not, are there
any alternatives?
A bit of extra information: My usage of identity_key stems from this
thread on this list:
http://groups.google.com/group/sqlalchemy
documented usage which could cause that. If you were to somehow
get your mapped object injected into the identity map incorrectly, though
you'd have to try fairly hard to pull that off since it guards against
incorrect incoming state.
On May 3, 2011, at 4:12 AM, Torsten Landschoff wrote
with.
Thank you very much!
Greetings, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registration court: Mannheim, HRB: 109659
/outPYZ1.pyz/sqlalchemy.orm.session,
line 766, in expunge_all
AttributeError: 'Preprocess' object has no attribute 'detach'
This is for SQLAlchemy 0.6.5 as I just noticed - I have to update the
deploy machine.
Greetings, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten
?
Greetings, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registration court: Mannheim, HRB: 109659, based in Karlsruhe,
Managing director
foreign_keys=on since it has to be used outside
a transaction.
I welcome comments and suggestions about that patch.
Greetings, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
prefer to do it in small steps.
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registration court: Mannheim, HRB: 109659, based in Karlsruhe
On Mon, 2010-12-20 at 10:16 -0500, Michael Bayer wrote:
On Dec 20, 2010, at 3:42 AM, Torsten Landschoff wrote:
INSERT INTO group_items (group_id, item_id, item_order) VALUES (?, ?, ?)
(None, None, None)
Both the group and the item where created correctly so I ended up with a
database
? (I know that session.{dirty, new, deleted} works fine).
Thanks and happy holidays,
Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registration court: Mannheim, HRB: 109659, based in Karlsruhe,
Managing director: Prof. Dr. K. Schweizerhof, Dipl
to get the best
of both worlds? ;-)
Thanks, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registration court: Mannheim, HRB: 109659
dirty instances.
Just pondering...
Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registration court: Mannheim, HRB: 109659
.
Greetings, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registration court: Mannheim, HRB: 109659, based in Karlsruhe,
Managing director
.
Okay, I updated my example code and it actually works now. However, it
feels like a lot of additional complexity just for adding order.
Greetings, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351
from users
Basically I would like to tell SQLAlchemy to use a query to provide the
values for insert. StackOverflow says this can't be done, but I can't
believe that. :-)
Greetings, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registration court: Mannheim, HRB: 109659, based in Karlsruhe,
Managing director: Prof. Dr. K
Hi Michael,
I only noticed the activity on this thread today.
On Sat, 2010-08-14 at 11:07 -0400, Michael Bayer wrote:
reproduce the problem and it suggests the problem stems from some
behaviour of transactions or of the engine.base.Connection class. I
don't quite know what to make of it
Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registration court: Mannheim, HRB: 109659, based in Karlsruhe,
Managing director: Prof. Dr. K. Schweizerhof, Dipl.-Math. U. Franz
Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registration court: Mannheim, HRB: 109659, based in Karlsruhe,
Managing director: Prof. Dr. K. Schweizerhof
.__table__
or something like that.
In fact I just ran the attached python code which works just fine.
Greetings, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registration court: Mannheim, HRB: 109659, based in Karlsruhe,
Managing director: Prof. Dr. K. Schweizerhof, Dipl.-Math
for anyone who want to do
any serious work with sqlite.
I tend to agree.
Hope this stops somebody from running into the same problem.
Greetings, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
that way.
Thanks for your fast reply. I guess I'll go that route than for now. :)
Greetings, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http
session.get_instance_by_key(key)
to be in the API, but I am unable to find it.
Any hints?
Greetings, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
On Fri, 2010-06-18 at 17:05 +0200, Torsten Landschoff wrote:
Using that key, I can retrieve the instance again in the new process.
But where is the method that can do that? I was expecting something like
session.get_instance_by_key(key)
to be in the API, but I am unable to find
...
conn.rollback()
I did not create an ORM session before updating the tables as the schema
might not match the mapped classes before updating.
Greetings, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
), expire all persistent objects
and refresh the GUI
Greetings, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Büro Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registergericht: Mannheim
Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registration court: Mannheim, HRB: 109659, based in Karlsruhe,
Managing director: Prof. Dr. K. Schweizerhof, Dipl.-Math. U. Franz
--
You
fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registration court: Mannheim, HRB: 109659, based in Karlsruhe,
Managing director: Prof. Dr. K. Schweizerhof, Dipl.-Math
Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registration court: Mannheim, HRB: 109659, based in Karlsruhe,
Managing director: Prof. Dr. K. Schweizerhof, Dipl.-Math. U
Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registration court: Mannheim, HRB: 109659, based in Karlsruhe,
Managing director: Prof. Dr. K. Schweizerhof, Dipl.-Math. U. Franz
--
You
).
Shouldn't something like this be included with SQLAlchemy? Or is this a
bad idea?
Greetings, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http
Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
Tel: +49-(0)351-4519587
Fax: +49-(0)351-4519561
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
Registergericht: Mannheim, HRB: 109659, Sitz: Karlsruhe,
Geschäftsführer: Prof. Dr. K. Schweizerhof, Dipl.-Math. U. Franz
--
You
when the second SA book will be published? I
bought the Essential SA book but it is a bit outdated covering 0.4.x.
Thanks, Torsten
--
DYNAmore Gesellschaft fuer Ingenieurdienstleistungen mbH
Torsten Landschoff
Office Dresden
mailto:torsten.landsch...@dynamore.de
http://www.dynamore.de
66 matches
Mail list logo