Re: [sqlalchemy] Text subquery column names in the results

2020-10-16 Thread Kotofos online
d using them in select(). Is it possible in sqlalchemy? On Thursday, 15 October 2020 at 23:55:53 UTC+7 Mike Bayer wrote: > > > On Thu, Oct 15, 2020, at 2:52 AM, Kotofos online wrote: > > > Hi, > Could you shed some light on what I might be doing incorrectly? I have

[sqlalchemy] Text subquery column names in the results

2020-10-15 Thread Kotofos online
Hi, Could you shed some light on what I might be doing incorrectly? I have this text() SELECT * query on top of a one-column sub-query and in the result, I am not getting that column name. ``` stmt = text('select "FirstName", from "Customer"') stmt =

[sqlalchemy] Re: How to know is reflected column has autoincrement

2020-02-19 Thread Kotofos online
Hi, thanks for the detailed reply. My task was to detect the required fields to generate the schema. It looks like it is better to not require field when autoincrement is 'auto'. (And of course, take into account client/server-side defaults) On Monday, 17 February 2020 20:56:01 UTC+7, Kotofos

[sqlalchemy] How to know is reflected column has autoincrement

2020-02-17 Thread Kotofos online
Hi, i'm having a troubles detecting auto-increment on reflected tables across different db types. There is same manually created table in multiple databases of different type: sqlite3 test.db 'create table project (id int primary key not null)' Then reflect it. After reflection, I can check