Re: [sqlalchemy] Encrypt/Decrypt specific column(s)

2020-07-10 Thread Justin Van Vuuren
Also, regarding the client side approach, would one be able to do an order by query? On Thu, 9 Jul 2020 at 21:28, Justvuur wrote: > A, ok ye, I understand, then I prefer client side. > I just need to sort out the encryption then... I'm not too familiar with > encryption algorithms but at

Re: [sqlalchemy] dogpile with SA inheritance

2014-04-15 Thread Justin H
I might be wrong, but maybe you could also use eval if you don't know which class at runtime. i.e. session.query(Person).with_polymorphic(eval(classString)) where classString is a string equal to the name of the class. On Tuesday, April 15, 2014 6:56:36 AM UTC-7, Gunnlaugur Briem wrote: On

Re: [sqlalchemy] Oracle Function Out Params

2012-06-01 Thread Justin Valentini
), outparam('z_out', String)]), x_in=5) print result.out_parameters On May 31, 2012, at 12:17 PM, Justin Valentini wrote: I'm having difficulty determining how to correctly call an oracle package function which returns a numeric value. I want to call this: BEGIN :out

[sqlalchemy] Oracle Function Out Params

2012-05-31 Thread Justin Valentini
I'm having difficulty determining how to correctly call an oracle package function which returns a numeric value. I want to call this: BEGIN :out := my_schema.my_package.test_function(); END; I tried calling that using sqlalchemy.text() but I don't understand how to tell the procedure I want

Re: [sqlalchemy] contains_eager across multiple relationships using aliases

2012-01-28 Thread Justin Thiessen
On Friday, January 20, 2012 9:17:53 PM UTC-8, Michael Bayer wrote: On Jan 20, 2012, at 6:59 PM, Justin Thiessen wrote: snip description of confusion regarding contains_eager and multi-level joins contains_eager(User.job, alias=job_alias) contains_eager(User.job, Job.desk, alias

[sqlalchemy] contains_eager across multiple relationships using aliases

2012-01-20 Thread Justin Thiessen
. It does seem though, that there is no reason why contains_eager should not handle the case I am describing, so I feel like I'm just missing something obvious. Any help or direction would be most appreciated. Thanks, Justin Thiessen -- You received this message because you are subscribed

[sqlalchemy] Multiple rows returning with uselist=False under load.

2011-09-14 Thread Justin Levine
. Any help? Thanks, - Justin -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options

[sqlalchemy] I've got an InterfaceError without reason

2010-10-27 Thread justin
() --- Thank you guys for your time to read this and to try to help me out. Justin. -- 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 unsubscribe from this group

Re: [sqlalchemy] Mapping an object to multiple tables

2010-01-16 Thread justin potts
Michael Bayer wrote: On Jan 16, 2010, at 1:02 AM, justin potts wrote: I realize it's not the typical case, but I would like to know if it's possible to map a class to multiple tables at once, somewhat like mapping to a join statement. I've read the documentation about querying with joins

[sqlalchemy] 2nd Level Cache and RowTuples

2008-07-04 Thread Justin Tulloss
Hello, I'm using SQLAlchemy .5 to produce result sets composed of columns from multiple tables and mapped entities. I'd like to cache these results, but since RowTuples cannot be pickled, I'm having a hard time figuring out how to go about doing this. Any suggestions? Thanks, Justin

[sqlalchemy] exclude_properties in .5

2008-05-30 Thread Justin Tulloss
Hello, I've been playing around with .5 a bit since I like the ability to select individual columns a lot. I've noticed, however, that the exclude_properties for mapper() doesn't seem to work. The mapped object still has the properties I've put in that list. Justin

[sqlalchemy] Counts that depend on joins

2008-05-23 Thread Justin Tulloss
, not the total number of B after being filtered by C. How do I get the count of B having applied the filter on C? Thanks, Justin --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group

[sqlalchemy] Re: Counts that depend on joins

2008-05-23 Thread Justin Tulloss
On May 23, 4:33 pm, Justin Tulloss [EMAIL PROTECTED] wrote: I am doing a A-B join before I do any filtering on a query object Sorry, this should be A-B-C join. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups

[sqlalchemy] count() does not seem to work correctly with relationships

2007-12-21 Thread Justin
() print len(b.reports.all()) # returns the correct number or reports for this branch. print b.reports.count() # ignores the relationship returns the total number of reports in the database. Thanks, - Justin Driscoll --~--~-~--~~~---~--~~ You received this message

[sqlalchemy] Querying for Date column value

2007-12-18 Thread Justin
I have a table with a Date column. Why does a python datetime match the value and a python date does not? For example: # example table institutions_table = Table('institutions', meta, Column('id', Integer, primary_key=True), Column('report_date', Date), ... this works:

[sqlalchemy] Re: Querying for Date column value

2007-12-18 Thread Justin
: [date: 2007-12-18] Thanks, - Justin On Dec 18, 1:19 pm, Michael Bayer [EMAIL PROTECTED] wrote: not sure, it depends on what kind of database youre using (and what DBAPI) as well as the actual type of column is is on the database side

[sqlalchemy] Re: Querying for Date column value

2007-12-18 Thread Justin
I should probably add that I'm curious if this is the desired behavior. From my (relatively inexperienced) point of view it seems that sqlalchemy should try to return whatever the programmer is expecting as designated by the column type. - Justin On Dec 18, 2:03 pm, Justin [EMAIL PROTECTED

[sqlalchemy] Re: Python in instead of list of or_ values.

2007-12-17 Thread Justin Driscoll
Thanks! - Justin On Dec 17, 2007 11:44 AM, Michael Bayer [EMAIL PROTECTED] wrote: On Dec 17, 2007, at 11:32 AM, Justin wrote: Using the Django ORM you can write: MyModel.objects.filter(property__in=['list', 'of', 'values']) ...and It will OR those values for you. Does SQLAlchemy