Re: [sqlalchemy] ResourceClosedError on Postgres Database - support needed

2020-01-16 Thread Mirek Morek
are being run (like what test runner, any multiprocessing in > use, etc.) would be places to start. > > > > On Mon, Jan 13, 2020, at 9:35 AM, Mirek Morek wrote: > > Hello, > I use sqlalchemy to execute my tests on Postgres Database. I run like ~200 > tests, every

[sqlalchemy] ResourceClosedError on Postgres Database - support needed

2020-01-13 Thread Mirek Morek
Hello, I use sqlalchemy to execute my tests on Postgres Database. I run like ~200 tests, every test uses its own setup and teardown. creates a connection and closes it after all. I sometimes get *ResourceClosedError *(*"StatementError: (sqlalchemy.exc.ResourceClosedError) This Connection is

Re: [sqlalchemy] How to force sqlalchemy to use custom column name as a column name in the query

2019-10-07 Thread Mirek Morek
something like this: > > query = select([FLIGHT_TRACK.c[column_name]]).\ > etc. > > Simon > > On Mon, Oct 7, 2019 at 12:00 PM Mirek Morek > wrote: > >> Yes, thanks, I tried that, but I receive: >> >> *ArgumentError: columns argument to select() must b

Re: [sqlalchemy] How to force sqlalchemy to use custom column name as a column name in the query

2019-10-07 Thread Mirek Morek
Yes, thanks, I tried that, but I receive: *ArgumentError: columns argument to select() must be a Python list or other iterable* W dniu poniedziałek, 7 października 2019 12:36:03 UTC+2 użytkownik Simon King napisał: > > On Mon, Oct 7, 2019 at 11:24 AM Mirek Morek > wrote: > &g

[sqlalchemy] How to force sqlalchemy to use custom column name as a column name in the query

2019-10-07 Thread Mirek Morek
Hello, I have a following question: I have a python method which should get field value from a table. I would like it to work like this: I pass method with parameters: *"select flight track field value10 cat"* Then it execute following query: query = select([FLIGHT_TRACK.c.*cat*]).\

Re: [sqlalchemy] How to add custom column name in sqlalchemy update query?

2019-07-16 Thread Mirek Morek
Ok, below there is a working solution. I had to import null from sqlachemy.sql.expression and then: [image: apt null.jpg] W dniu wtorek, 16 lipca 2019 07:47:30 UTC+2 użytkownik Mirek Morek napisał: > > Yes, when passing integer value as value everything is fine, so only value >

Re: [sqlalchemy] How to add custom column name in sqlalchemy update query?

2019-07-15 Thread Mirek Morek
icious of those airport_sys_id > and project_sys_id values. Why are they being passed as floating point > values, rather than integers? > > Does the same query work if the reference_temperature is not None? > > On Mon, Jul 15, 2019 at 3:32 PM Mirek Morek > wrote: > >> >

Re: [sqlalchemy] How to add custom column name in sqlalchemy update query?

2019-07-15 Thread Mirek Morek
Sure[image: log.jpg] W dniu poniedziałek, 15 lipca 2019 15:28:54 UTC+2 użytkownik Simon King napisał: > > I don't have any other ideas, I'm afraid. Can you post the relevant > section from the logs? > > On Mon, Jul 15, 2019 at 1:51 PM Mirek Morek > wrote: > >>

Re: [sqlalchemy] How to add custom column name in sqlalchemy update query?

2019-07-15 Thread Mirek Morek
ou > create your SQLAlchemy engine) will show exactly what values you are > passing to the database. > > Simon > > On Mon, Jul 15, 2019 at 10:45 AM Mirek Morek > wrote: > >> Hello Simon, >> One extra question: >> >> Do you know maybe how to assign

Re: [sqlalchemy] How to add custom column name in sqlalchemy update query?

2019-07-15 Thread Mirek Morek
s as keyword arguments to the > function. > > >>> def f(a, b, c): > ... print("a =", a) > ... print("b =", b) > ... print("c =", c) > ... > >>> f(a=1, b=2, c=3) > a = 1 > b = 2 > c = 3 > >>

Re: [sqlalchemy] How to add custom column name in sqlalchemy update query?

2019-07-15 Thread Mirek Morek
s as keyword arguments to the > function. > > >>> def f(a, b, c): > ... print("a =", a) > ... print("b =", b) > ... print("c =", c) > ... > >>> f(a=1, b=2, c=3) > a = 1 > b = 2 > c = 3 > >>

Re: [sqlalchemy] How to add custom column name in sqlalchemy update query?

2019-07-12 Thread Mirek Morek
> Hope that helps, > > Simon > > On Thu, Jul 11, 2019 at 3:00 PM Mirek Morek > wrote: > > > > Hello everyone, > > I have a following question: > > > > I use sqlalchemy within my python method as follows: > > > > > > I wa

[sqlalchemy] How to add custom column name in sqlalchemy update query?

2019-07-11 Thread Mirek Morek
Hello everyone, I have a following question: I use sqlalchemy within my python method as follows: I want to be able to replace 'custom_column' with parameter passed in the method. The same way as it works fine for airport_sys_id, project_sys_id and value. For example I want to pass in my