Re: [sqlalchemy] Query before_compile issue

2019-10-27 Thread eric . lemoine
> > today, we have this issue, which I can confirm has existed since version > 1.2 over two years ago, reported for the first time ever here, and then a > day later in https://github.com/sqlalchemy/sqlalchemy/issues/4947 . > Even more funny is that this Issue uses a tenant in the provided test-ca

Re: [sqlalchemy] TableProxy equivalent to RowProxies

2019-10-27 Thread Soumaya Mauthoor
With a dataframe you can do df.columns to get the column labels and df[["col1","col2"]] to extract column1 and column2 rowProxy has similar functionality as explained before However if I use s= fetchmany() I return a string and it's not possible to do the equivalent s.keys() and s["col1"]. On Su

Re: [sqlalchemy] TableProxy equivalent to RowProxies

2019-10-27 Thread Mike Bayer
On Sun, Oct 27, 2019, at 7:06 AM, sumau wrote: > RowProxy have useful functionality like row.keys() and row['column'] > > If I use fetchmany/fetchall I return a list of RowProxies. Is the best way of > keeping the functionality of RowProxies to convert the list to a pandas data > frame? Are th

[sqlalchemy] TableProxy equivalent to RowProxies

2019-10-27 Thread sumau
RowProxy have useful functionality like row.keys() and row['column'] If I use fetchmany/fetchall I return a list of RowProxies. Is the best way of keeping the functionality of RowProxies to convert the list to a pandas data frame? Are there any plans to create "Table"Proxy equivalent to RowProxy