Thread: [SQLObject] I need som help understanding SQLObject usage
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Peter D. <pe...@si...> - 2006-01-19 08:51:11
|
Hello list, I've begun investigating SQLObject for one of my projects but I've encountered several problems. first the datetime issue: I naively tried to use a DateTimeCol for a birthday but I keep getting OverflowError: mktime argument out of range How should I describe a birthday? Should I use a different type of column? second is the performance issue... I have 2 simple structures class Dates(SQLObject): date = StringCol() dType = IntCol() intervClass = IntCol() intervSubClass = StringCol(default=None) comments = StringCol() patient = ForeignKey('Patients') class Patient(SQLObject): name = StringCol() bday = StringCol() address = StringCol() phone = StringCol() comments = StringCol() dates = MultipleJoin('Dates') and a simple select results = Patient.select() names = [pac.name for pac in results] this takes 0.3 seconds... is that normal for something like 2500 patients? something like names = [pac.name for pac in results if filter(lambda d: d.dType==3, pac.dates)] takes 35 seconds. Now I do know that the filter should have went into the select but I don't know how to do that... can someone help ? Any help will do :) Thank you in advance. Peter. |
From: Oleg B. <ph...@ma...> - 2006-01-19 11:12:26
|
On Thu, Jan 19, 2006 at 10:50:43AM +0200, Peter Damoc wrote: > first the datetime issue: > > I naively tried to use a DateTimeCol for a birthday but I keep getting > OverflowError: mktime argument out of range This is a known bug. It is fixed in 0.7-branch and will be in 0.7.1 when it will be ready. (Chances are it will be ready RSN.) Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Peter D. <pe...@si...> - 2006-01-20 08:37:34
|
On Thu, 19 Jan 2006 13:12:24 +0200, Oleg Broytmann <ph...@ma...> wrote: > On Thu, Jan 19, 2006 at 10:50:43AM +0200, Peter Damoc wrote: >> first the datetime issue: >> >> I naively tried to use a DateTimeCol for a birthday but I keep getting >> OverflowError: mktime argument out of range > > This is a known bug. It is fixed in 0.7-branch and will be in 0.7.1 > when > it will be ready. (Chances are it will be ready RSN.) > > Oleg. How about the other issue... I have no idea how to filter the selection if the patient has or has not a certain type of operation in their dates list. Any ideas would be apreciated. Thank you in advance. Peter. |