DjSelect - get Model objects from cooked SQL select statements

[noelbk]

Django's QuerySet objects are nice, but I always run into problem
where I need to write a real SQL query that they don't support.  For
example, I wanted to sort by names in a left joined table.  Sort()
won't work withou joining the table, but select_related() didn't do it
for me (since my ForeignKey could be null).  I looked at Q queries,
but they made my head hurt.  I knew exactly the SQL I wanted to write,
but how would I get Django Model objects out of it?

So, I wrote a SQL-to-Django SQL processor object: DjSelect.  I prefer
this kind of programming to QuerySet methods, because you can get the
full power of SQL.

You're welcome to download it from 
http://www.burton-krahn.com/~noel/djselect.py.
Is there a place to post code to contrib?

Here's an excerpt from the docs:

class DjSelect:
    Parse SQL select statements to return Django Model objects.

    Synopsis
    --------
        select = DjSelect('''
            from {MyModel1:model1}, {MyModel2:model2}
            where {model1}.attr1 = ?
            and {model2}.attr2 = ?
            ''')
        for model1, model2 in select.execute(param1, param2):
            print("model1=%s, model2=%s" % (model1, model2))

    Examples
    --------

      The examples below illustrate how the SQL processing works.
      Once you've got your SQL, you can use it in DjSelect like so::

        for model1, model2 in DjSelect(sql).execute(params):
            print("fetched django objects: %s" % ((model1,model2)))

      SQL to return a tuple (owner, pet) per row::

        from {Owner:owner}, {Pet:pet}
        where {owner}.id = {pet}.owner_id

      SQL to return one Pet object per row, with the (possibly null)
      owner in the pet.owner attribute::

        from {Pet:pet}
          left join {Owner:pet.owner}
            on {pet.owner}.id = {pet}.owner_id
        where {pet}.birthday < ?
        order by {owner}.name


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---