You have written a member function to your class, its going to work
like charm. But mind it your *baz* doesnt exist in class so you should
pass it into your member function. Alternatively see Django custom
managers.
On Sep 10, 12:27 am, johnny <[EMAIL PROTECTED]> wrote:
> I need to define custom sql for a model, so it is only accessible by
> model class but not by model instances.
> Where do I define is my_custom_sql, like below, inside the Person
> class (my guess is not, if need to access my_custom_sql, then I need
> to instantiate Person.):
>
> class Person(models.Model):
> first_name = models.CharField(max_length=50)
> last_name = models.CharField(max_length=50)
>
> def my_custom_sql(self):
> from django.db import connection
> cursor = connection.cursor()
> cursor.execute("SELECT foo FROM bar WHERE baz = %s", [self.baz])
> row = cursor.fetchone()
> return row
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
