[sqlalchemy] sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) operator does not exist: jsonb = uuid",

2019-06-20 Thread Jesse Finnegan
Bare with me. I'm some what new to SQL Alchemy so feel free to let me know if there is any info I can provide. I was wondering how I could type cast a jsonb (which should have a UUID init) to a UUID or vice versa in a .join? I have the following code: .join( CandidateActivity, db.and_(

[sqlalchemy] Re: Joining against a subquery and polymorphic contains_eager population

2011-06-03 Thread Jesse Cohen
Hi, Could anyone help point me in the right direction here? Any help would be much appreciated! Thanks, Jesse On May 30, 12:54 pm, Jesse Cohen wrote: > This is my first post here, I've been learning about the query api and I've > got three related questions: > > 1. Suppo

[sqlalchemy] Joining against a subquery and polymorphic contains_eager population

2011-05-30 Thread Jesse Cohen
alchemy handles it and how much easier it makes my life as well as the extensive support community which exists. Thanks!! Best, Jesse Cohen -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@goo

[sqlalchemy] Problem with correlate in a subquery

2010-07-27 Thread Jesse
t I would actually like is the subquery to be part of the SELECT statement and then order by it. Suggestions? Thanks, Jesse -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To

[sqlalchemy] Re: Issue when loading module in scheduler utility

2007-07-23 Thread Jesse James
On Jul 23, 10:33 am, svilen <[EMAIL PROTECTED]> wrote: > > First, I appended the sys.path var like this (relative, was > > absolute before): > > sys.path.append( 'vor') > > IMO u should not touch sys.path unless u really really have no other > chance. Although this above is another whole

[sqlalchemy] Re: Issue when loading module in scheduler utility

2007-07-23 Thread Jesse James
On Jul 23, 10:33 am, svilen <[EMAIL PROTECTED]> wrote: > > First, I appended the sys.path var like this (relative, was > > absolute before): > > sys.path.append( 'vor') > > IMO u should not touch sys.path unless u really really have no other > chance. Although this above is another whole

[sqlalchemy] Re: Issue when loading module in scheduler utility

2007-07-23 Thread Jesse James
> -3: 2.5 or 2.4 all the same (Except abs/rel imports which still dont > work in 2.5 anyway). > -2: u need my_import (or similar) because __import__( 'vor.model') > will not give u want u want. > -1: u need to give _same_ full absolute paths to __import__ (or > substitute) or else u'll get duplic

[sqlalchemy] Re: Issue when loading module in scheduler utility

2007-07-23 Thread Jesse James
Ok, I just tried something that actually worked. WOO HOO! First, I appended the sys.path var like this (relative, was absolute before): sys.path.append( 'vor') combined with this: ... module = my_import('vor.'+modname) ... I realize that this is not ideal. But I'

[sqlalchemy] Re: Issue when loading module in scheduler utility

2007-07-23 Thread Jesse James
> aaah, u are _that_ new... > - use it instead of the __import__() func > - original python library reference of the version u use; > e.g.http://docs.python.org/lib/built-in-funcs.html > > wow there's a level parameter now... somethin to try I'm not using 2.5 (2.4 still). I tried the 'my_import

[sqlalchemy] Re: Issue when loading module in scheduler utility

2007-07-23 Thread Jesse James
which python reference (url?) are you speaking of? how does 'import_fullname' work? how would it be applied? On Jul 21, 11:35 am, [EMAIL PROTECTED] wrote: > > In other words, should I first attempt to > > __import__('vor.'+modname) in runJob() ? > > see the python reference about how to use __imp

[sqlalchemy] Re: Issue when loading module in scheduler utility

2007-07-21 Thread Jesse James
On Jul 20, 10:42 pm, [EMAIL PROTECTED] wrote: > this ain't SA issue, but if u want a solution, u have to provide more > data, and do some prints here-there. > > > When a scheduled job is run, its specified module is loaded using > > __import__ . This works fine unless the loaded module has an >

[sqlalchemy] Issue when loading module in scheduler utility

2007-07-20 Thread Jesse James
SqlAlchemy that would be able to suggest what is wrong here? I've been authorized to pay $100 for a working solution to this problem. Thanks, Jesse --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalche