[sqlalchemy] Re: Differences between `op.get_bind()` and `op.get_bind().engine.connection()`

Diego Quintana: > Hello! I'm trying to seed my database using my first migration script, and > I have trouble understanding what `op.get_bind()` returns, and mainly the > difference between `Connection` and `engine.connection()`. Say I have a > migration script that creates a table ca

[sqlalchemy] Re: Differences between `op.get_bind()` and `op.get_bind().engine.connection()`

ist`, which probably happens because of what is being discussed here. What other options do I have? How would I get a raw connection from `context` or `bind`? Once again, thanks for your time Am Freitag, 10. Mai 2019 13:09:04 UTC+2 schrieb Diego Quintana: > > Hello! I'm trying to seed

[sqlalchemy] Differences between `op.get_bind()` and `op.get_bind().engine.connection()`

Hello! I'm trying to seed my database using my first migration script, and I have trouble understanding what `op.get_bind()` returns, and mainly the difference between `Connection` and `engine.connection()`. Say I have a migration script that creates a table called `cities` and then it performs

Re: [sqlalchemy] How to override append and remove methods used in orm.relationships

the code bit you changed makes it work, thanks!. There are a lot of things I don't understand. But first, why does I need to use `session_object`? to expose the `execute` method? What is that I am "bypassing" by using this over the orm? Am Freitag, 4. Mai 2018 11:40:34 UTC-3 schrieb D

Re: [sqlalchemy] How to override append and remove methods used in orm.relationships

At the moment I've moved to other features, but I should be back to this somewhere in the near future. I will let you know the results. I really appreciate your time, thanks again. Best, Am Donnerstag, 3. Mai 2018 10:10:47 UTC-3 schrieb Mike Bayer: > > On Thu, May 3, 2018 at 7:39 AM,

Re: [sqlalchemy] How to override append and remove methods used in orm.relationships

eeds > to be all kinds of trickery to protect the events from each other.* > In this case, remove pet from parent has two flavours, namely case A and B. Case A should trigger a different behaviour in the _remove_children listener, and work normally in every other case. Best, Diego Diego A

Re: [sqlalchemy] How to override append and remove methods used in orm.relationships

ing this is on purpose here <https://www.google.com/url?sa=t=j==s=web=4=0ahUKEwjBl6T5uenaAhVHx1kKHZfjCQUQFghEMAM=https%3A%2F%2Fgroups.google.com%2Fd%2Ftopic%2Fsqlalchemy%2Fg8rP_7qErOk=AOvVaw3_M_B49Zqukg5Fk2WOqJ_a> , since accepting kwargs would pollute the API. Perhaps a custom *event* implementation? Than

Re: [sqlalchemy] How to override append and remove methods used in orm.relationships

does not have access to all of the child's pets if __name__ == '__main__': # run tests unittest.main() Am Mittwoch, 2. Mai 2018 11:40:14 UTC-3 schrieb Mike Bayer: > > On Wed, May 2, 2018 at 10:14 AM, Diego Quintana <daqui...@gmail.com > > wrote: > > This worked. >

Re: [sqlalchemy] How to override append and remove methods used in orm.relationships

r from another listener, where the second call can't find something that was already deleted. This might be a long shot, but I'm hoping this pattern might be solved already. Am Donnerstag, 26. April 2018 13:00:45 UTC-3 schrieb Mike Bayer: > > On Thu, Apr 26, 2018 at 11:04 AM, Diego Quin

[sqlalchemy] How to override append and remove methods used in orm.relationships

Hello. Say I have three tables in a declarative fashion, `Parent`, `Child`, and `Pet`, in such way that * `Parent` has a many-to-many relationship with both `Child` and `Pet`, meaning that a Parent can own a Child and its pets, and also a Pet without its Child. * `Child` has a one-to-many

Re: [sqlalchemy] MySQL has gone away

On Thursday, December 27, 2012 10:22:08 PM UTC-3, Michael Bayer wrote: On Dec 27, 2012, at 6:28 PM, Diego Woitasen wrote: Hi, I know that this was discussed several times in the past but I can't solve the problem with the tip that I read in this list. Every morning my application dies

[sqlalchemy] MySQL has gone away

and MySQLdb 1.2.4c1. Is there a checklist of things to check that could cause this problem? Regards, Diego -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy

[sqlalchemy] Can't find any foreign key relationships between ...

' and 'mailing_rcpt'. I can't find the error in my model definition. Regards, Diego -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/keQCxERRA9AJ. To post

Re: [sqlalchemy] Can't find any foreign key relationships between ...

On Tuesday, December 4, 2012 5:12:51 PM UTC-3, Michael Bayer wrote: On Dec 4, 2012, at 2:30 PM, Diego Woitasen wrote: Hi, I have the following tables: rcpt_group_asoc = Table(mailing_rcptgroup_rcpts, Base.metadata, Column('rcpt_id', Integer, ForeignKey

[sqlalchemy] InsertFromSelect with columns support

Hi, This is working version of InsertFromSelect with columns support. Works for me, but I could be useful for somebody else. And also I want to heart other opinions about this. In SQL there is no way to do an INSERT... SELECT. If you want to do it without using raw SQL in several places of

[sqlalchemy] SQLA app and Django app using the same database

using the same DB. At first, the only problem is that we'll need to keep the models in sync but I'm not sure if I'm missing anything. May be someone already faced a problem like this and could tell me his/her experience. Regards, Diego -- You received this message because you are subscribed

[sqlalchemy] Query relationship in order

Hi, Say I have two entities A and B, that have a many to many relationship between them. Now I'd like to get all Bs from a given A, ordered by some attribute of B. Something like select B from A order by B.attr desc How do I express that query using the ORM? Thanks in advance, Diego

Re: [sqlalchemy] Re: Sqlsoup: slow commit on update

) mail_item.volume_id = 3 mboxgroup_db.commit() Is it possible to get an iterator querying with Sqlsoup? Regards, Diego On Tue, Dec 21, 2010 at 3:29 AM, Michael Bayer mike...@zzzcomputing.comwrote: You've got 636000 objects in your session which is quite large. The commit would like

[sqlalchemy] Sqlsoup: slow commit on update

sqlsoup.py:549(__getattr__) 5040.0030.0003.1380.006 sqlsoup.py:535(entity) The problem is commit, almost all the time used by the script is on commit. Is there a faster way to modify every row? Or Should i use raw sql? Regards, Diego -- Diego Woitasen XTECH -- You received

[sqlalchemy] Re: Sqlsoup: slow commit on update

On Tue, Dec 21, 2010 at 12:35 AM, Diego Woitasen dieg...@xtech.com.arwrote: Hi, I have a python script that uses Sqlsoup to iterate over some rows of table to modify them. The script is running really slow and I ran cProfile to see where is the bottleneck. I've got this: 20549870

Re: [sqlalchemy] SQL IF in sqlalchemy?

2009/11/28 Michael Bayer mike...@zzzcomputing.com: we support CASE via case() which will get you there just as well. On Nov 28, 2009, at 1:54 PM, Diego Woitasen wrote: Does sqlalchemy support SQL IF? For example: select date, if(proxy_user_id 1, count(distinct address_id), 0) from table

[sqlalchemy] SQL IF in sqlalchemy?

Does sqlalchemy support SQL IF? For example: select date, if(proxy_user_id 1, count(distinct address_id), 0) from table group by date; I've solved this using literal SQL in Query() parameters but may be I can do it using ORM. -- Diego Woitasen XTECH -- You received this message because you

[sqlalchemy] Simple join

== 'foo').all() but It's too complex. Is there an easier way? Something like: DBSession.query(WorkStation).filter(Workstation.server.label == 'foo').all() Thanks! -- Diego Woitasen XTECH --~--~-~--~~~---~--~~ You received this message because you are subscribed