Re: [sqlalchemy] Date range query problem

2016-02-29 Thread Mike Bayer
On 02/29/2016 06:01 PM, Nana Okyere wrote: I have a model and one of its attributes is a column called last_updated_timestamp . It is a date column set to datetime.datetime.now() . That's all good. I'm trying to query for some roles based on a date range. So I do: results =

[sqlalchemy] Re: Bulk Insert Broken for Polymorphism?

2016-02-29 Thread Alex Hewson
Hi Mike, Thanks for the quick response. If that's the intended behaviour I'll go back to non-bulk inserts for my inherited types. Doubtless I could work around it by inserting N new Entities, fetching their autoincrement ID's then using them to make Child1 and Child2's but I don't trust

Re: [sqlalchemy] Bulk Insert Broken for Polymorphism?

2016-02-29 Thread Mike Bayer
On 02/29/2016 05:38 PM, Alex Hewson wrote: Hello All, I'm trying to use the new bulk_save_objects() to improve performance on bulk inserts, and have run into a problem. If bulk_save_objects() is used to save objects of a polymorphic class.. 1. They are created correctly in the DB, with

[sqlalchemy] Re: Date range query problem

2016-02-29 Thread Nana Okyere
Update: Using current version of sa. Oracle 12 c. -- 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 an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group,

[sqlalchemy] Date range query problem

2016-02-29 Thread Nana Okyere
I have a model and one of its attributes is a column called last_updated_timestamp . It is a date column set to datetime.datetime.now() . That's all good. I'm trying to query for some roles based on a date range. So I do: results =

[sqlalchemy] Bulk Insert Broken for Polymorphism?

2016-02-29 Thread Alex Hewson
Hello All, I'm trying to use the new bulk_save_objects() to improve performance on bulk inserts, and have run into a problem. If bulk_save_objects() is used to save objects of a polymorphic class.. 1. They are created correctly in the DB, with polymorphic type column populated

Re: [sqlalchemy] How to test functions that use sqlalchemy ORM?

2016-02-29 Thread Mike Bayer
sure see that at http://www.sqlalchemy.org/library.html#buildingtheapp. On 02/29/2016 04:01 AM, Abhijeet Rastogi wrote: Hi Mike, Thanks for the reply. Do you have any slides to share from that talk? Cheers! On Monday, February 22, 2016 at 9:54:38 PM UTC+5:30, Mike Bayer wrote: I

[sqlalchemy] @property mapping via hybrid property?

2016-02-29 Thread TomS.
Hi! I've got an answer on Stack ( http://stackoverflow.com/questions/35653889/sqlalchemy-property-mapping/35654405 ) - solution uses relationship and an association proxy. But I also found out that it can be achieved via hybrid property. How to do this? I have following models: |class