----- "Ed Leafe" <[email protected]> wrote: > On Mar 11, 2009, at 11:30 AM, Adrian Klaver wrote: > > > Invoking UserSQL overrides the SQL Builder methods in > dCursorMixin.py. > > Correct. > > > This means you lose any parent-child relationship information set > > > in a bizobj > > False. You have to define the join, but you can use a placeholder for > > the value of the dependent key, and if the relationship is defined in > > the bizobjs, the param will be correctly returned. Also, requerying > the parent requeries the children, whether or not those queries are > defined by UserSQL or SQL Builder methods.
Will try this. > > > Doing bizobj.filter() sets up a sqlite3 dataset. > > Internally, yes, but that's not relevant to using it. filter() > modifies the current dataset in place, but remembers the original, so > > that you can remove the filter without having to hit the backend > again. Only until you do something sqlite3 does not like :) That was why I was working through the data path. Seeing where it went from a Dabo data structure to a sqlite3 one. > > > sqlite3 does not understand timestamps with time zones. This is what > > > initially led to all this. I tried to bizobj.filter() and the > > dataset choked on a timestamp field I did not think I had included > > > in my bizobj. This a is an issue with sqlite/pysqlite they will > > INSERT a string with a time zone offset but will error on > > retrieving it. Now that I understand DataStructure, it is not > > problem. Something to deal with at another time. > > If you can submit a brief program that demonstrates this, I'd like to > > look into it. Create a Trac issue explaining the problem, and attach > > the code to that. I can do that. > > > -- Ed Leafe Thanks, Adrian Klaver [email protected] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/1786254763.7280211236790609838.javamail.r...@sz0030a.emeryville.ca.mail.comcast.net
