Hi, I was working on moving an old site from php to django and found that I was using INSERT...SELECT... queries in a couple places. The point of these queries is to take a group of rows using the SELECT subquery and insert them all at once without having to iterate over them in your code. Ideally, you save some time since the database never has to send you anything, and all you have to send it is a single INSERT...SELECT... statement.
I couldn't find anything like this in django's database API, but I was told to check qs-rf. I still couldn't find anything like this, so I decided to hack my own out into qs-rf. Since this is a major change, I didn't want to submit it as a patch. I'm also not completely sure it doesn't already exist somehow. The syntax on it works like this: http://dpaste.com/41473/ You create 1 or more QuerySets and then pass them and some keywords into batch_create on the class you want to add to. You use tuples to specify class and attribute names if you want the new rows to be taken from the QuerySets you passed in. Otherwise, you can specify literals if you would like one of the fields of all of the new rows to be the same. Here's the diff. I'd be glad to continue working on it (error checking, documenting, and more input types) if anyone thinks it might be useful. http://dpaste.com/41475/ Thanks, Brian Armstrong --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
