[sqlalchemy] How to load a table with autoload=False?

There seems to be surprisingly little information about how to load a table manually if you set the autoload flag to False. There is a fairly new question on StackOverflow that has not been answered properly either: https://stackoverflow.com/q/43042044/998919. Is there a function (e.g.

Re: [sqlalchemy] How to load a table with autoload=False?

On Thu, Jul 20, 2017 at 5:35 AM, Fredrik Blomqvist wrote: > There seems to be surprisingly little information about how to load a table > manually if you set the autoload flag to False. > There is a fairly new question on StackOverflow that has not been answered >

[sqlalchemy] How to better understand `remote_side` in sqlalchemy?

I've been studying sqlalchemy's self referential table. I've read the documentation many times and still have difficulties understanding the concept of remote_side. Could someone please draw a diagram or use an analogy to help explain this concept? I think visualizing is a better way but

Re: [sqlalchemy] Solr support

there is not but also we aren't supporting Jython at the moment either. On Thu, Jul 20, 2017 at 5:14 PM, Shaun Thompson wrote: > I wanted to verify that currently there is not support for the Solr JDBC > driver. I'm looking at data visualization tools using SuperSet and

Re: [sqlalchemy] How to better understand `remote_side` in sqlalchemy?

On Thu, Jul 20, 2017 at 8:10 PM, Jinghui Niu wrote: > I see. But still I'm struggling to see the real difference between: > > Node.parent_id = Node.id > vs. > Node.id = Node.parent_id > > Aren't we just switching around sides here? those two conditions are equivalent. but

Re: [sqlalchemy] How to better understand `remote_side` in sqlalchemy?

Now I see, thanks Mike! On Jul 20, 2017 6:51 PM, "Mike Bayer" wrote: > On Thu, Jul 20, 2017 at 8:10 PM, Jinghui Niu wrote: > > I see. But still I'm struggling to see the real difference between: > > > > Node.parent_id = Node.id > > vs. > >

Re: [sqlalchemy] How to better understand `remote_side` in sqlalchemy?

On Thu, Jul 20, 2017 at 1:34 PM, Jinghui Niu wrote: > I've been studying sqlalchemy's self referential table. I've read the > documentation many times and still have difficulties understanding the > concept of remote_side. Could someone please draw a diagram or use an >

Re: [sqlalchemy] How to better understand `remote_side` in sqlalchemy?

I see. But still I'm struggling to see the real difference between: Node.parent_id = Node.id vs. Node.id = Node.parent_id Aren't we just switching around sides here? On Thu, Jul 20, 2017 at 4:47 PM, Mike Bayer wrote: > On Thu, Jul 20, 2017 at 1:34 PM, Jinghui Niu

[sqlalchemy] Re: How to better understand `remote_side` in sqlalchemy?

'many' is the same as 'remote' in the example that you are thinking of, but it loses applicability if you are doing a one-to-one relationship. Let me illustrate with the `remote` annotation, which is a corollary form of `remote_side` in the relationships API, and tends to be more clear:

[sqlalchemy] Solr support

I wanted to verify that currently there is not support for the Solr JDBC driver. I'm looking at data visualization tools using SuperSet and Apache Zeppelin to view both Oracle and Solr data. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To

Re: [sqlalchemy] How to load a table with autoload=False?

Thanks for the quick response! I get it now. Sorry for my example, I realize it wasn't that clear. I think trying to explain it further would just make everyone more confused. Main takeaway is, if I want to load a table after it has already been defined, I will use the method you described