Re: [sqlalchemy] multiple desktop app issues

На 16.07.2014 19:17 Michael Bayer mike...@zzzcomputing.com написа: On Jul 16, 2014, at 11:02 AM, Vladimir Iliev vladimir.il...@gmail.com wrote: hi, we're developing a desktop app using sa so the sessions is long living. we use postgres and sqlite. if the desktop app is dormant

[sqlalchemy] multiple desktop app issues

hi, we're developing a desktop app using sa so the sessions is long living. we use postgres and sqlite. 1. sometimes we see same object twice in one to many relation. it's very hard to reproduce and the problem is gone after commit. does anyone else seen such a behavior? 2. sometimes i do

[sqlalchemy] Re: multiple desktop app issues

issue 2 - i guess it happens because the relation contents are still referenced in selections after they are marked for deletion or something like that... -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and

Re: [sqlalchemy] column property problem

) ) ) ) I’ll try to get that patch in for 0.9.5. On Jun 2, 2014, at 6:09 AM, Vladimir Iliev vladimi...@gmail.com javascript: wrote: sorry, i have copy-and-paste incomplete parts of my real model definitions. run the attached file and you will see the exception

Re: [sqlalchemy] column property problem

sorry, i have copy-and-paste incomplete parts of my real model definitions. run the attached file and you will see the exception sqlalchemy.exc.InterfaceError: (InterfaceError) Error binding parameter 0 - probably unsupported type. u'SELECT (SELECT sum(nestingsheetlayoutitem.quantity) AS

[sqlalchemy] column property problem

Hi, i'm trying to add a column property with where clause that depends on other 2 column properties (see JobItem.nested_quantity) in the attached file) but looks like it's not possible. Any ideas if it's possible to achieve same result one way or another ? Thanks -- You received this

[sqlalchemy] single table inheritance + composite primary key problem

hi, what's wrong with the following mapping ? TYPE_DEFAULT = 1 class BaseFriend(DeclarativeBase): __tablename__ = 'friends' __table_args__ = {'mysql_engine': 'InnoDB', 'mysql_charset': 'utf8'} type = Column(SmallInteger, primary_key=True) user_id

[sqlalchemy] Re: single table inheritance + composite primary key problem

p.s. i'm using SA 0.7.1 On Saturday, June 16, 2012 4:37:39 PM UTC+3, Vladimir Iliev wrote: hi, what's wrong with the following mapping ? TYPE_DEFAULT = 1 class BaseFriend(DeclarativeBase): __tablename__ = 'friends' __table_args__ = {'mysql_engine': 'InnoDB

Re: [sqlalchemy] single table inheritance + composite primary key problem

On Saturday, June 16, 2012 4:52:14 PM UTC+3, Michael Bayer wrote: On Jun 16, 2012, at 9:37 AM, Vladimir Iliev wrote: hi, what's wrong with the following mapping ? TYPE_DEFAULT = 1 class BaseFriend(DeclarativeBase): __tablename__ = 'friends

[sqlalchemy] dynamic relation filtering

hi, how can i filter dynamic relation's query to instances of a given class, including the subclasses ? i tried something like part.documents.filter(Part.documents.of_type(CADDocument)) but i'm getting ArgumentError: filter() argument must be of type sqlalchemy.sql.ClauseElement or string

[sqlalchemy] Re: dynamic relation filtering

InvalidRequestError: Query.with_polymorphic() being called on a Query with existing criterion a...@svilendobrev.com написа: thequery().with_polymorphic( list of classes ) ? On Wednesday 25 February 2009 15:43:54 Vladimir Iliev wrote: hi, how can i filter dynamic relation's query

[sqlalchemy] Re: dynamic relation filtering

so it's not possible to reuse relation's query definition ? Michael Bayer написа: with_polymorphic() needs to be called first. On Feb 25, 2009, at 9:54 AM, Vladimir Iliev wrote: InvalidRequestError: Query.with_polymorphic() being called on a Query with existing criterion

[sqlalchemy] Re: dynamic relation filtering

ok, thanks Michael Bayer написа: not currently no On Feb 25, 2009, at 10:46 AM, Vladimir Iliev wrote: so it's not possible to reuse relation's query definition ? Michael Bayer написа: with_polymorphic() needs to be called first. On Feb 25, 2009, at 9:54 AM, Vladimir Iliev wrote

[sqlalchemy] single table inheritance and changing object's type

how can i change the type of mapped object using single table inheritance? thanks --~--~-~--~~~---~--~~ 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] question

hi, i have a method that returns list of (material, thickness) groups which looks like: C = [order_element_items.c.material_uuid, materials.c.name, order_element_items.c.thickness] S = select( C,

[sqlalchemy] dynamic relations

hi, what's wrong with the attached example? --~--~-~--~~~---~--~~ 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

[sqlalchemy] Re: dynamic relations

i'm glad you're always so responsive ;-) Michael Bayer написа: im glad people are finally using dynamic relationstry out rev 3869. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post

[sqlalchemy] column_property() caching

hi, is it possible to add a non-caching column_property() to my mapping? --~--~-~--~~~---~--~~ 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