[SQLObject] what is the best way to make an EncryptedCol

2007-03-19 Thread Mathias Stearn
N() will work. Also, I dont want to have to put __set_SSN and __get_SSN in each class that needs them. If I cant easily make a new column type, is there an easy way to execute an sqlbuilder.func call? Thank-you, Mathias Stearn

Re: [SQLObject] what is the best way to make an EncryptedCol

2007-03-22 Thread Mathias Stearn
I've got that working for reads and writes, so "id = i.SSN" and "i.SSN = '9' " work as expected. The problem is I cant figure out a way to search by an encrypted field. At the very least I think the bySSN method should run the argument through the from_python part of the validator. It woul

Re: [SQLObject] how to get info from 3 linked tables

2007-03-22 Thread Mathias Stearn
better sql would be: SELECT cb.brandName, ct.typeName, c.carPrice FROM carsBrand AS cb join carsType AS ct on ct.brandTypeIP=cb.id join cars AS c on c.carTypeID=ct.id SQLObject can represent this (with different sql) as either: carlist = cars.select() for car in carlist: print car.price, car.

Re: [SQLObject] what is the best way to make an EncryptedCol

2007-03-23 Thread Mathias Stearn
d features I'd like to add, but the code is kinda hard to grok. Do you have any sort of developer documentation or a general description of what is where? --Mathias On 3/22/07, Oleg Broytmann <[EMAIL PROTECTED]> wrote: > On Thu, Mar 22, 2007 at 11:21:38AM -0400, Mathias Stearn wrote:

Re: [SQLObject] Working with (ordered) lists

2007-04-09 Thread Mathias Stearn
If the lists are likely to be small you can use a PickleCol that stores a python list. On 4/9/07, Aaron Digulla <[EMAIL PROTECTED]> wrote: > Hello, > > Is it possible to store and load an ordered list of items with SQLObject? > > In my specific case, I have a recursive data structure: > > class Kn