Re: [SQLObject] Passthrough SQL.

[David M. C. <da...@da...>]

On Fri, May 28, 2004 at 11:49:54AM -0400, Ian Sparks wrote:

> Before I start digging into the source code does the following ability
> already exist in SQLObject and, if not, does anyone else want it.


You can do

  Klass._connection.queryAll(sql)

For example, I needed to quickly get a lookup dictionary of row IDs of a
table that were in a joined table, so that I could determine which items in
a tree widget would get expanders (without having to load all the joining
objects)

  result = Klass.select(Join_klass.q.klassID==Klass.q.id) 
  lookup = dict([(o.id,None) for o in result])

works OK, but

  dict(Klass._connection.queryAll("select klass_id, NULL from join_klass"))

is 10 times faster even with cached objects.  I think I saw that fetching
only IDs instead of objects was on the TODO list.

Dave Cook


> AFAIK SQLObject can't do complex joins. For instance, I might want to do a query like :
> 
> SELECT TimeOfRequests.* FROM TimeOffRequests INNER JOIN Users ON TimeOffRequests.cUserID = Users.cID WHERE Users.Dept = 12
> 
> The result will be a set of "A" objects so I'd like SO to treat them as such. So if SQLObject doesn't already support it what I'd like to be able to do is :
> 
> timeOffReqs = TimeOffRequests.get(passThrough="SELECT TOR.* FROM TimeOffRequests TOR INNER JOIN Users U ON TOR.cUserID = U.cID WHERE U.Dept = 12")
> 
> Obviously, I've just broken the portability of my code so if there were a more SO-ish way of doing it I'd gladly take the education. 
> 
> However, in some DB's like Firebird you can get SQL results from a StoredProc or a view or something and this pass-through capability could prove useful.
> 
> Thoughts?
> 
> 
> 
> 
> 
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: Oracle 10g
> Get certified on the hottest thing ever to hit the market... Oracle 10g.
> Take an Oracle 10g class now, and we'll give you the exam FREE.
> http://ads.osdn.com/?ad_id149&alloc_id66&op=click
> _______________________________________________
> sqlobject-discuss mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss