Re: [sqlalchemy] how not to add tablename as column prefix

2017-06-06 Thread Антонио Антуан
вторник, 6 июня 2017 г., 19:46:43 UTC+3 пользователь Mike Bayer написал: > > > > On 06/06/2017 11:14 AM, Антонио Антуан wrote: > > Hi. > > I want to generate query without tablename as columns prefix. How can I > > do this? > > For example, query /Session.query(table.id).filter(table.time >

Re: [sqlalchemy] how not to add tablename as column prefix

2017-06-06 Thread mike bayer
On 06/06/2017 11:14 AM, Антонио Антуан wrote: Hi. I want to generate query without tablename as columns prefix. How can I do this? For example, query /Session.query(table.id).filter(table.time > func.now())/ compiles to /SELECT table.id FROM table WHERE table.time > now(). /I want to get

[sqlalchemy] how not to add tablename as column prefix

2017-06-06 Thread Антонио Антуан
Hi. I want to generate query without tablename as columns prefix. How can I do this? For example, query *Session.query(table.id).filter(table.time > func.now())* compiles to *SELECT table.id FROM table WHERE table.time > now(). *I want to get *SELECT id FROM table WHERE time > now(). * I want

Re: [sqlalchemy] a Python-side value or SQL expression is required

2017-06-06 Thread mike bayer
On 06/06/2017 08:46 AM, alexei.bogda...@ytech.by wrote: Yes, I see, thank you! The only reason I insist trying to understand the logic, because IMHO the mechanism of attributes invocation like: sa.insert(SomeClass).values( {SomeClass.service_id: '12'} ) is more natural and explicit

Re: [sqlalchemy] SQLAlchemy and PyQT5

2017-06-06 Thread Julio César Gázquez
Hi Wayne. El 02/06/17 a las 06:43, Wayne escribió: Hi, Does anyone have any experience, links to open source code or anything else that shows the integration of PyQT5 with SQLAlchemy? I'm using SQLAlchemy with PyQt4. My experience is valid for PyQt5 using QtWidgets module, QtQuick is a

Re: [sqlalchemy] a Python-side value or SQL expression is required

2017-06-06 Thread alexei . bogdanov
Yes, I see, thank you! The only reason I insist trying to understand the logic, because IMHO the mechanism of attributes invocation like: sa.insert(SomeClass).values( {SomeClass.service_id: '12'} ) is more natural and explicit then using string col names, even from point of OOP. On

Re: [sqlalchemy] select with_for_update with nowait=True

2017-06-06 Thread mike bayer
On 06/05/2017 05:52 PM, Uri Okrent wrote: On Monday, May 29, 2017 at 12:27:51 PM UTC-4, Mike Bayer wrote: I'm assuming this "invalidates the transaction" is on the Postgresql side, e.g. you get "current transaction is aborted". There is a simple solution for that which is