Re: [sqlalchemy] ORM: LEFT JOIN LATERAL() ON TRUE

On Wed, Feb 28, 2018 at 5:44 PM, Adam Olsen wrote: > I am trying to replicate the following raw query: > > SELECT r.id, r.name, e.id, e.title, e.start, e.end > FROM room r > LEFT JOIN LATERAL ( > SELECT evt.id, evt.title, evt.start, evt.end > FROM

[sqlalchemy] standalone asc/desc function vs ColumnElement asc/desc function

Greetings, Are there any reasons (canonical, stylistic, etc.) that one would use order_by(desc(Class.column)) vs order_by(Class.column.desc()) ? Thanks! -m -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please

[sqlalchemy] ORM: LEFT JOIN LATERAL() ON TRUE

I am trying to replicate the following raw query: SELECT r.id, r.name, e.id, e.title, e.start, e.end FROM room r LEFT JOIN LATERAL ( SELECT evt.id, evt.title, evt.start, evt.end FROM event evt, calendar cal WHERE r.calendar_id=cal.id AND

Re: [sqlalchemy] Performance of ORDER BY vs. list.sort() vs. sorted()

On Wed, Feb 28, 2018 at 3:02 PM, wrote: > Hello, > > I’m curious about your experience with sorting the results of all() > > queries which return a list. It seems to me that there are

Re: [sqlalchemy] SQLAlchemy and Python 3.7 data classes

it seems these are just a better type of NamedTuple so I would say certainly not: "There have been numerous attempts to define classes which exist primarily to store values which are accessible by attribute lookup. " These classes look a lot more like result rows that are updateable, rather than

[sqlalchemy] Performance of ORDER BY vs. list.sort() vs. sorted()

Hello, I’m curious about your experience with sorting the results of all() queries which return a list. It seems to me that there are three ways of sorting such result lists: 1. Use an ORDER BY

Fwd: Us congress hearing of maan alsaan Money laundry قضية الكونغجرس لغسيل الأموال للمليادير معن الصانع

*موقع اليوتيوب الذي عرض فيديوهات جلسة استماع الكونجرس الأمريكي * * لمتابعة نشاطات غسل الأموال ونشاطات* *السعودي معن عبدالواحد الصانع* *مالك مستشفى وشركة سعد ومدارس سعد بالمنطقة الشرقية ورئيس مجلس ادارة بنك اوال البحريني* *وتعليق محطة سي ان بي سي التلفزيونية* *مترجم باللغة العربية*

[sqlalchemy] SQLAlchemy and Python 3.7 data classes

I don't have a well-formulated question, but reading PEP 557 (https://www.python.org/dev/peps/pep-0557/) made me wonder if SQLAlchemy declarative models would/should in some way be Python 3.7 data classes. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper