[sqlalchemy] test/dialect/test_sqlite.py::TypeReflectionTest::()::test_round_trip_direct_type_affinity fails

2018-06-22 Thread Hans-Peter Jansen
Hi %, packaging 1.2.8 (and before) fails for openSUSE Tumbleweed, while it succeeds for many former distributions due to a single failing test with Python 2.7.15, sqlite 3.24, pytest 3.6.0: FAIL test/dialect/test_sqlite.py::TypeReflectionTest:: ()::test_round_trip_direct_type_affinity Full

[sqlalchemy] senseless warning messages escape python logging

2014-07-02 Thread Hans-Peter Jansen
Dear SQLAchemistas, this is an issue, that my apps choke on from time to time, _related_ to SQLA. Although, logging is set up correctly, some operations spit out senseless warning messages like this: /usr/lib/python2.6/site-packages/sqlalchemy/engine/default.py:324: Warning: Data truncated

Re: [sqlalchemy] Performance problem of simple orm usage

2014-06-29 Thread Hans-Peter Jansen
Dear Jonathan, thank you for your cool remix of recommendations. Very appreciated. On Donnerstag, 26. Juni 2014 15:09:03 Jonathan Vanasco wrote: In case this helps... This reminds me slightly of some RFID work I did years ago. We had a lot of reads coming in from different units, several

Re: [sqlalchemy] Performance problem of simple orm usage

2014-06-26 Thread Hans-Peter Jansen
Dear Mike, sorry for not coping with preferred reply behavior.. On Donnerstag, 26. Juni 2014 15:26:02 Mike Bayer wrote: On 6/26/14, 3:07 PM, Hans-Peter Jansen wrote: Obviously, some operation triggers the flush method with about the same consequences.. OK, turn off autoflush - either

Re: [sqlalchemy] Modification tracking

2013-08-22 Thread Hans-Peter Jansen
Dear Michael, thanks for the detailed response. On Mittwoch, 21. August 2013 16:55:18 Michael Bayer wrote: On Aug 21, 2013, at 12:40 PM, Hans-Peter Jansen h...@urpla.net wrote: Hi, being new to SQLAlchemy, I try to get my way through it. In an application, I have rather elaborate

Re: [sqlalchemy] Modification tracking

2013-08-22 Thread Hans-Peter Jansen
On Donnerstag, 22. August 2013 23:58:17 Hans-Peter Jansen wrote: Dear Michael, Pardon, I'm using 0.8.2 ATM. Cheers, Pete -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send

[sqlalchemy] Modification tracking

2013-08-21 Thread Hans-Peter Jansen
Hi, being new to SQLAlchemy, I try to get my way through it. In an application, I have rather elaborate needs to track changes. I've defined 3 classes with declarative, where the main class has relationships with two auxiliary classes, that refer to the main class with foreign references. All

Re: [sqlalchemy] 0.7.10 build test failures

2013-07-15 Thread Hans-Peter Jansen
On Montag, 15. Juli 2013 13:19:55 Michael Bayer wrote: issue http://www.sqlalchemy.org/trac/ticket/2782 is added to merge this to all three branches patch for 0.7 attached to the ticket. tested-by: Hans-Peter Jansen h...@urpla.net Thanks, Mike. This nice experience will encourage me to report

[sqlalchemy] 0.7.10 build test failures

2013-07-14 Thread Hans-Peter Jansen
Dear Mike, while building version 0.7.10 on openSUSE build service, I noticed, that there are a bunch of test failures to care about. My SQLAlchemy project: https://build.opensuse.org/package/show/home:frispete:python/python-SQLAlchemy The build logs are located here:

Re: [sqlalchemy] 0.7.10 build test failures

2013-07-14 Thread Hans-Peter Jansen
Hi Mike, On Sonntag, 14. Juli 2013 17:03:14 Michael Bayer wrote: hi Hans - this issue, a missing import that only triggers on certain platforms, has been fixed in all branches since 0.7. But there's no 0.7.11 released planned at this time. Thanks for the quick answer. Mind pointing me

Re: [sqlalchemy] 0.7.10 build test failures

2013-07-14 Thread Hans-Peter Jansen
On Sonntag, 14. Juli 2013 17:38:12 Michael Bayer wrote: you can get that right here: www.sqlalchemy.org/changelog/CHANGES_0_7_11 Thanks, great. That fixed all tests, but this is left still: [ 156s] -- [ 156s] Ran 4075

Re: [sqlalchemy] Problems with retroactive changes to Query objects

2013-01-30 Thread Hans Meine
instead of silently throwing the first part of the FROM clause away. (OTOH, I don't see why the latter has to happen in the first place.) Thanks again, and have a nice day, Hans -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe

Re: [sqlalchemy] Array with custom types in SqlAlchemy 0.8b2

2013-01-07 Thread Hans Lellelid
=engine) e = Example() e.timestamp=datetime.datetime.utcnow(), e.num=2, e.guids = [uuid.uuid4(), uuid.uuid4()] s.add(e) s.commit() I get an error like this: snip return getter(visitor)(self, **kw) File /home/hans/workspace/providence/env/lib/python2.7/site-packages

Re: [sqlalchemy] Array with custom types in SqlAlchemy 0.8b2

2013-01-07 Thread Hans Lellelid
customization. Thanks again! Hans On Monday, January 7, 2013 10:09:53 AM UTC-5, Michael Bayer wrote: change again, that doesn't work. Upon reflection, I think the case here is that there's no alternative but to make sure psycopg2 can properly format the contents of the ARRAY itself

[sqlalchemy] Re: Column order with declarative base and @declared_attr

2011-07-21 Thread Hans-Martin
of a nuisance than a real problem, it only really affects browsing through the tables after all. Thanks, Hans-Martin -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe

[sqlalchemy] Re: Python 3.1 + SQLAlchemy 0.6 or 0.7

2011-03-30 Thread Hans-Martin
is the latest version of py3k and actually has some fairly dramatic behavioral differences vs. 3.1.   If you want to work with 3.2 and let us know what quirks you find... Below is one (Python 3.2, sqlalchemy 0.7b4 (downloaded snapshot 10min ago), Debian). Best wishes, Hans-Martin Traceback (most

[sqlalchemy] Re: Python 3.1 + SQLAlchemy 0.6 or 0.7

2011-03-30 Thread Hans-Martin
None I have a working setup with 2.7 + 0.6.6, but would like to port it to 3.2 relatively soon -- if I can help trying out things, just let me know. Best wishes, Hans-Martin -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send

[sqlalchemy] Re: Python 3.1 + SQLAlchemy 0.6 or 0.7

2011-03-30 Thread Hans-Martin
On Mar 30, 5:43 pm, Michael Bayer mike...@zzzcomputing.com wrote: That's not an error I'm familiar with how to reproduce; it suggests an incorrect string passed to create_engine().   Working code with Python 3.2 plus pg8000 looks like: from sqlalchemy import create_engine e =

[sqlalchemy] Re: Python 3.1 + SQLAlchemy 0.6 or 0.7

2011-03-30 Thread Hans-Martin
you'd need an @ sign in there perhaps: db://@/test Same error. But no big deal, I can wait for psycopg2 support in Python 3.2. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com. To

[sqlalchemy] Re: Python 3.1 + SQLAlchemy 0.6 or 0.7

2011-03-30 Thread Hans-Martin
On Mar 30, 7:13 pm, Michael Bayer mike...@zzzcomputing.com wrote: well its not going to work there either most likely since we don't support connecting without a hostname, probably.  You can't put localhost in there ? Doesn't work either, same error. Adding my system username (and password)

[sqlalchemy] Inactive transactions and commit/rollback from Session

2009-11-12 Thread Hans Lellelid
and executes on that. I do know, though, that some methods such as remove() are not available on instances -- only on the class. This is a bit confusing. Any help would be appreciated. Thanks, Hans --~--~-~--~~~---~--~~ You received this message because you

[sqlalchemy] Re: Inactive transactions and commit/rollback from Session

2009-11-12 Thread Hans Lellelid
. Thanks again! Hans --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr

[sqlalchemy] Filtering lazy='dynamic' collection on class type (single-table inheritance)

2009-01-30 Thread Hans Lellelid
get it to work. I'm sure I'm just not fully understanding how that is supposed to work. Thanks in advance! Hans --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email

[sqlalchemy] Re: Filtering lazy='dynamic' collection on class type (single-table inheritance)

2009-01-30 Thread Hans Lellelid
On Jan 30, 2:37 pm, Michael Bayer mike...@zzzcomputing.com wrote: On Jan 30, 2009, at 1:39 PM, Hans Lellelid wrote: Hi, I did a quick search but couldn't find the right way to do this in SA. For the sake of example, I have a many-to-many relationshp between Book and Reader

[sqlalchemy] Using database functions in UPDATE statement

2008-09-19 Thread Hans Lellelid
that documentation). Thanks in advance! Hans --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL

[sqlalchemy] Re: Using database functions in UPDATE statement

2008-09-19 Thread Hans Lellelid
==idvar, {'geocolumn': func.GeomFromText(wkt, 4326)}) while this does not: up = mytable.update(mytable.c.id==idvar) conn.execute(up, {'geocolumn': func.GeomFromText(wkt, 4326)}) It wasn't obvious to me that these were not equivalent. Sorry for the confusion! Hans On Sep 19, 12:52 pm, Hans

[sqlalchemy] Re: Using database functions in UPDATE statement

2008-09-19 Thread Hans Lellelid
trial/ error and list responses), I'd be happy to help fill in some of the sparse areas of the documentation. Is there a standard procedure for submitting documentation patches? Thanks, Hans --~--~-~--~~~---~--~~ You received this message because you are subscribed

[sqlalchemy] Re: custom type for PostGIS geometry

2008-07-23 Thread Hans
investigating how the original label_select_column does that. Thanks again for the help. Hans --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com

[sqlalchemy] custom type for PostGIS geometry

2008-06-30 Thread Hans
, is there a way to accomplish what I want? Thanks in advance! Hans --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from

[sqlalchemy] Re: custom type for PostGIS geometry

2008-06-30 Thread Hans
On Jun 30, 1:24 pm, Michael Bayer [EMAIL PROTECTED] wrote: On Jun 30, 2008, at 1:04 PM, Hans wrote: The problem is that I'd like to have sqlalchemy return KML for all geometry types by default, but I don't know how to setup my type to specify a SQL function that needs to be applied

[sqlalchemy] understanding thread-safe connections, engines and sessions

2008-06-18 Thread Hans
need to always specify that I want a contextual connection? i.e. conn = engine.contextual_connect() ? (What happens if I just run engine.connect() as normal with a threadlocal connection?) I assume all of this is necessary in a multi-threaded environment? Thanks for the help! Hans

[sqlalchemy] Re: understanding thread-safe connections, engines and sessions

2008-06-18 Thread Hans
On Jun 18, 12:12 pm, Michael Bayer [EMAIL PROTECTED] wrote: On Jun 18, 2008, at 11:43 AM, Hans wrote: Now, if I want to do some stuff with the engine or connection directly, should I create my engine with context=threadlocal additionally? (And then pass that threadlocal engine off

[sqlalchemy] Re: understanding thread-safe connections, engines and sessions

2008-06-18 Thread Hans
On Jun 18, 1:18 pm, Michael Bayer [EMAIL PROTECTED] wrote: On Jun 18, 2008, at 12:41 PM, Hans wrote: Ok, this makes sense. I guess I don't need to worry about the threadlocal stuff if I'm always creating and disposing of connections. For example, if I have a DAO method (classmethod

[sqlalchemy] Re: Executing post-create_all() SQL causing rollback?

2008-06-17 Thread Hans
On Jun 17, 11:12 am, Michael Bayer [EMAIL PROTECTED] wrote: On Jun 17, 10:36 am, Hans [EMAIL PROTECTED] wrote: I'm not sure I completely understand what's going on, so I apologize is this is obvious use error :) I'm trying to add to the create_all() method (by wrapping in my own

[sqlalchemy] Re: Executing post-create_all() SQL causing rollback?

2008-06-17 Thread Hans
On Jun 17, 11:15 am, Hans [EMAIL PROTECTED] wrote: On Jun 17, 11:12 am, Michael Bayer [EMAIL PROTECTED] wrote: On Jun 17, 10:36 am, Hans [EMAIL PROTECTED] wrote: I'm not sure I completely understand what's going on, so I apologize is this is obvious use error :) I'm trying