[sqlalchemy] Re: SQLACODEGEN + VSCODE + Intellisense not working.

2018-05-11 Thread Jeremy Flowers
Also tried this in extrapaths - no joy either: ${workspaceRoot} Per this thread On Saturday, 12 May 2018 00:32:40 UTC+1, Jeremy Flowers wrote: > > I've also been looking at here >

[sqlalchemy] Re: SQLACODEGEN + VSCODE + Intellisense not working.

2018-05-11 Thread Jeremy Flowers
I've also been looking at here in the hope of finding a solution. I tried setting this in the VS Code (Version 1.23.1) 'User Settings' tab (File -> Preferences -> Settings) "python.autoComplete.extraPaths":

[sqlalchemy] is it possible to make load_only local to an object only and/or avoid the identity map and/or not available via `get`?

2018-05-11 Thread Jonathan Vanasco
I tracked down a pattern that has been causing some bottleneck issues in an app. I'm hoping there may be a way to handle this, but for once I don't expect there to be! The problem arises when I fetch a specific "light" query with joined objects (however toplevel objects have the same issue).

Re: [sqlalchemy] How to formulate a query using sqlalchemy ORM constructs that calculates the difference between entries in rows

2018-05-11 Thread Mike Bayer
On Fri, May 11, 2018 at 3:17 PM, Björn Nadrowski wrote: > > > Hi Mike, > that looks very good, > > However, I am still left with three problems: > > a) the query returns "None" in the datediff column. It seems that the > strings "datetime" and "PreviousDate" are somehow not

Re: [sqlalchemy] How to formulate a query using sqlalchemy ORM constructs that calculates the difference between entries in rows

2018-05-11 Thread Björn Nadrowski
Hi Mike, that looks very good, However, I am still left with three problems: a) the query returns "None" in the datediff column. It seems that the strings "datetime" and "PreviousDate" are somehow not recognized. When I replace "( func.julianday("datetime") -

[sqlalchemy] SQLACODEGEN + VSCODE + Intellisense not working.

2018-05-11 Thread Jeremy Flowers
I have some code in VS Code... jobrow = session.query(Jobmst).filter(Jobmst.jobmst_id==job['jobmst_id']). first() Jobmst is imported from a single module I've created called tidal.py jobrow is an instance of Jobmst... But I can't select any of the columns. I've tried