Re: [sqlalchemy] Removing a column from a sqlalchemy table

2019-08-05 Thread Abdeali Kothari
, but we are considering using pyhive which has the hive dialect for sqlalchemy. On Mon, Aug 5, 2019, 19:17 Mike Bayer wrote: > > > On Sun, Aug 4, 2019, at 11:32 PM, Abdeali Kothari wrote: > > Thanks for the quick revert. I saw sqlalchemy-migration and have used > alembic a lot.

Re: [sqlalchemy] Removing a column from a sqlalchemy table

2019-08-04 Thread Abdeali Kothari
bles reflect that change? On Mon, Aug 5, 2019, 07:44 Mike Bayer wrote: > > > On Sun, Aug 4, 2019, at 1:14 PM, Abdeali Kothari wrote: > > I am using the sqlalchemy Table class to load up a data schema I am > provided. > > Once loaded into sqlalchemy, I want to use

[sqlalchemy] Removing a column from a sqlalchemy table

2019-08-04 Thread Abdeali Kothari
I am using the sqlalchemy Table class to load up a data schema I am provided. Once loaded into sqlalchemy, I want to use some of the existing extensions like: - ERD plots - eralchemy - Auto finding relationships using automap etc. I am not using any actual DB connection under the table though -

Re: [sqlalchemy] Using sqlalchemy to figure out multi table relationships

2019-07-11 Thread Abdeali Kothari
handles relationships. Thanks for the input! On Thu, Jul 11, 2019 at 7:49 PM Mike Bayer wrote: > > On Thu, Jul 11, 2019, at 7:41 AM, Abdeali Kothari wrote: > > I am trying to use SQLAlchemy to do some smart joins for me without me > having to explicitly figure out the joins during

[sqlalchemy] Using sqlalchemy to figure out multi table relationships

2019-07-11 Thread Abdeali Kothari
I am trying to use SQLAlchemy to do some smart joins for me without me having to explicitly figure out the joins during queries. (i.e. by figuring out the relationships on its own to figure out how the tables are related to each other) I have an example where i have BookSeries -> Book -> Boot2Au