Re: [sqlalchemy] SAWarning: Unicode type received non-unicode bind param value

, send email to sqlalchemy@googlegroups.com mailto:sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout. -- _*check out pointcloud9.com*_ http://pointcloud9.com/ **Sebastian Elsner - Pipeline

[sqlalchemy] mysql double issue

= create_engine('mysql://user:pass@localhost/test', echo=True) Base.metadata.create_all(engine) s = sessionmaker(engine)() r = SomeClass(value=0.1234567891234567) s.add(r) s.commit() x = s.query(SomeClass).get(1) print x.value Regards Sebastian -- check out www.pointcloud9.com Sebastian Elsner - Pipeline

Re: [sqlalchemy] mysql double issue

objects back in this case with DOUBLE, I’d subclass mysql.DOUBLE and specify a new result_processor() method. On Nov 20, 2013, at 7:00 AM, Sebastian Elsner sebast...@risefx.com wrote: Hello, I am inserting float data into a MySQL column of type DOUBLE. The data gets inserted properly

Re: [sqlalchemy] newest address for each user

, Sebastian Elsner sebast...@risefx.com wrote: Hello, using the Address and User example, where the Address is connected to the User via a many-to-many relationship, I want to get all users with the date of their newest address. This is what I have now: s.query(User, s.query(func.max

Re: [sqlalchemy] newest address for each user

, UserAddresses) ) On Oct 21, 2013, at 3:12 AM, Sebastian Elsner sebast...@risefx.com wrote: Thank you for the help! Additionally, I was wondering if it would be able to make newest_address an attribute on the user class, which can then be used in a query with .options(joinedload

[sqlalchemy] newest address for each user

Hello, using the Address and User example, where the Address is connected to the User via a many-to-many relationship, I want to get all users with the date of their newest address. This is what I have now: s.query(User, s.query(func.max(Address.created)).\

Re: [sqlalchemy] update with custom Type

, Michael Bayer wrote: On Aug 28, 2013, at 9:59 AM, Sebastian Elsner sebast...@risefx.com wrote: Now I would like to be able to do the following: s.query(Foo).update({some_timecode: Foo.some_timecode.add_hours(5)}) # Adds 5 hours to every Foo's timecode I have seen this should be possible

[sqlalchemy] update with custom Type

: Foo.some_timecode + TC(01:00:00:00:00)}) I have tried implementing the __add__ for both the TC and Timecode class and read the Augmenting Existing Types help, but failed to put the puzzle together. Thank you for helping! Sebastian -- check out www.pointcloud9.com Sebastian Elsner - Pipeline

Re: [sqlalchemy] Do not add entities automatically to the session?

+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out. -- check out www.pointcloud9.com Sebastian Elsner - Pipeline Technical

[sqlalchemy] count subquery

Hello, I am trying to translate this SQL to a SQLAlchemy query, but failed so far: select `users`.`name`, `assignments`.`id`, ( select count(*) from `assignments` where `assignments`.`user_id` = `users`.`id` ) as `num_assignments` from `users` join `assignments` on

Re: [sqlalchemy] count subquery

the select() and then call as_scalar() on it so that it behaves like a column in a SQL expression. On Jun 24, 2013, at 9:34 AM, Sebastian Elsner sebast...@risefx.com wrote: Hello, I am trying to translate this SQL to a SQLAlchemy query, but failed so far: select `users`.`name`, `assignments`.`id

[sqlalchemy] query.whereclause

Hello, I want to feed a Query.whereclause to mysqldump. For this i will need the full where clause with all labels replaced with values, right now I get labels like :project_id_1. How can I do that? Many thanks, Sebastian -- check out www.pointcloud9.com Sebastian Elsner - Pipeline

Re: [sqlalchemy] query.whereclause

Thank you, this did the trick. And since only I use it offline the security issues are OK for me. On 02/28/2013 12:27 PM, Simon King wrote: On Thu, Feb 28, 2013 at 10:28 AM, Sebastian Elsner sebast...@risefx.com wrote: Hello, I want to feed a Query.whereclause to mysqldump. For this i

[sqlalchemy] serialize list

Hello, I want to serialize a python list, which by convention can only contain strings and save it to mysql database in on column. I was thinking about an unicode column and an attribute event which just does a str(list) for saving and a eval(string) for access. I am not sure though if this

Re: [sqlalchemy] Read-Only Database

-only, and would that simplify the work that SA does behind the scenes? Thanks, Mark -- Sebastian Elsner - Pipeline TD - r i s e | fx t: +49 30 201 803 00 sebast...@risefx.com c: +49 175 336 5739 7548 www.risefx.com r i s e | fx GmbH Schlesische Strasse 28, Aufgang B 10997 Berlin Richard-Byrd

[sqlalchemy] get_history not returning as expected

Hello, using Python 2.6 and SA 0.6.6. Please see the example below. I want to get the History of a relationship attribute, but whatever I pass to the passive argument, I never get the deleted version of the object, only the PASSIVE_NO_RESULT symbol (if I understand correctly, I would not

[sqlalchemy] logging user changes

. Is that possible? Can you give me a hint where to read up? Being in the design phase I am also open to other approaches on how to tackle logging of user changes in a db. Thanks Sebastian -- Sebastian Elsner - Pipeline TD - r i s e | fx t: +49 30 201 803 00 sebast...@risefx.com c: +49 175

[sqlalchemy] understanding connection pooling

Hello, I wanted to make sure, I get this right: every session creates its own connection on demand (only if I actually do query with the session), right? So, using MySQL with max_connections = 100 I quickly run out of connections, because every client is using about 6 connections, one for

Re: [sqlalchemy] understanding connection pooling

So, using MySQL with max_connections = 100 I quickly run out of connections, because every client is using about 6 connections, one for each dialog window, which has its own session instance. seems like an architecture that could use some trimming Yes, you are probably right. But what

[sqlalchemy] self_group on Query

Hello, wanting to create the following query: (SELECT * from tbl ORDER BY b LIMIT 5) UNION ALL (SELECT * from tbl ORDER BY a LIMIT 5) The important thing are the (), which I cant get to work with the examples in the union() docs . I came across a solution involving self_group on Queries

[sqlalchemy] Newest records per category

Hello, I have one table called 'Assets' with a 'category' (String) and 'created' (DateTime) column. Now I would like to find the records created since a given datetime for each category: This is what I thought would work (with a self-join): session.query(Asset).join(Asset,

Re: [sqlalchemy] Newest records per category

, at 7:50 AM, Sebastian Elsner wrote: have one table called 'Assets' with a 'category' (String) and 'created' (DateTime) column. Now I would like to find the records created since a given datetime for each category: This is what I thought would work (with a self-join): session.query(Asset).join

[sqlalchemy] modify existing query with group_by and count

Hello, I build a query to filter a table depending on options a user can specify. So I have a working query to execute when all GUI elements (which provide the filter information) are evaluated. What I do is asking for the GUI elements value and depending on that I modify the query: class

Re: [sqlalchemy] modify existing query with group_by and count

Thank you very much, from_self() works a treat! On 06/28/2010 04:47 PM, Michael Bayer wrote: On Jun 28, 2010, at 5:23 AM, Sebastian Elsner wrote: Hello, I build a query to filter a table depending on options a user can specify. So I have a working query to execute when all GUI elements

[sqlalchemy] deleting

Hello, I am unsure on how to delete correctly. Lets say I have a query's result, which is a list. del list[5] does not seem to do anything, right? I would always have to do session.delete(list[5])? But what about when I created a mapped object, which is not yet persistent, how would I

Re: [sqlalchemy] 'NoneType' object has no attribute '_sa_iterator' exception

')()) AttributeError: 'NoneType' object has no attribute '_sa_iterator' I don't have a good test for this, but i'm trying to create one. Does anyone knows why this is happening? Thanks! -- Sebastian Elsner-pipeline td - r i s e | fx t: +49 30 20180300 sebast...@risefx.com

Re: [sqlalchemy] implications of weak_identity_map

would never have thought I would say this, but now I'd like to go back to c++ :) I am already using the newest build of PyQt, so I guess I will post on the mailing list there. Thank you, Sebastian On Wed, 24 Mar 2010 21:06:10 +0100, Michael Bayer mike...@zzzcomputing.com wrote: Sebastian

[sqlalchemy] implications of weak_identity_map

Hello, This is the situation: I am using Qt with its tree view to display data coming from sqlalchemy. Mapped classes are used as nodes for the tree. Relations define the connections to children and parent. As for the QTreeViews model data structure a sqlalchemy list returned by a query is

Re: [sqlalchemy] implications of weak_identity_map

My first question is: What exactly is the commit doing to the list returned from the query so that pointers to other objects are lost (python.exe will crash on me then)? The commit expires all attributes by default, since the transaction is committed, and upon next access will be loaded again

Re: [sqlalchemy] distinct query

Hello, qry = session.query(AssetCategory).join(Asset).join(Shot).filter(Shot.id==1).distinct() this one already did the trick. qry = qry.filter(Shot.id==shot_id_of_interest) what did you add this for? The results seem to be identical... that generates SELECT DISTINCT AssetCategory.id

[sqlalchemy] distinct query

Hello, I am stuck here with a query, it't not too complicated I think, but I dont get it... I have three Class/table mappings: Shots, Assets, which belong to a Shot (1:n) and AssetCategories, which are owned by Assets (n:1) The objective is: For a given shot instance get all distinct

[sqlalchemy] three primary keys on association object

Hello, I have an association object declaratively with three primary keys, but on insert, the first (id) is not autoincremented. Please see test the code below from sqlalchemy import create_engine, Column,Integer, String, ForeignKey from sqlalchemy.ext.declarative import

Re: [sqlalchemy] three primary keys on association object

Oh, thanks for the pointer. There's so much to read and learn being new to SQLAlchemy... Sorry for bugging. On Fri, 05 Mar 2010 15:49:03 +0100, Michael Bayer mike...@zzzcomputing.com wrote: Sebastian Elsner wrote: Hello, I have an association object declaratively with three primary