thirdparty/google_appengine/lib/django/tests/modeltests/reserved_names/models.py
changeset 109 620f9b141567
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/thirdparty/google_appengine/lib/django/tests/modeltests/reserved_names/models.py	Tue Aug 26 21:49:54 2008 +0000
@@ -0,0 +1,56 @@
+"""
+18. Using SQL reserved names
+
+Need to use a reserved SQL name as a column name or table name? Need to include
+a hyphen in a column or table name? No problem. Django quotes names
+appropriately behind the scenes, so your database won't complain about
+reserved-name usage.
+"""
+
+from django.db import models
+
+class Thing(models.Model):
+    when = models.CharField(maxlength=1, primary_key=True)
+    join = models.CharField(maxlength=1)
+    like = models.CharField(maxlength=1)
+    drop = models.CharField(maxlength=1)
+    alter = models.CharField(maxlength=1)
+    having = models.CharField(maxlength=1)
+    where = models.DateField(maxlength=1)
+    has_hyphen = models.CharField(maxlength=1, db_column='has-hyphen')
+    class Meta:
+       db_table = 'select'
+
+    def __str__(self):
+        return self.when
+
+__test__ = {'API_TESTS':"""
+>>> import datetime
+>>> day1 = datetime.date(2005, 1, 1)
+>>> day2 = datetime.date(2006, 2, 2)
+>>> t = Thing(when='a', join='b', like='c', drop='d', alter='e', having='f', where=day1, has_hyphen='h')
+>>> t.save()
+>>> print t.when
+a
+
+>>> u = Thing(when='h', join='i', like='j', drop='k', alter='l', having='m', where=day2)
+>>> u.save()
+>>> print u.when
+h
+
+>>> Thing.objects.order_by('when')
+[<Thing: a>, <Thing: h>]
+>>> v = Thing.objects.get(pk='a')
+>>> print v.join
+b
+>>> print v.where
+2005-01-01
+>>> Thing.objects.order_by('select.when')
+[<Thing: a>, <Thing: h>]
+
+>>> Thing.objects.dates('where', 'year')
+[datetime.datetime(2005, 1, 1, 0, 0), datetime.datetime(2006, 1, 1, 0, 0)]
+
+>>> Thing.objects.filter(where__month=1)
+[<Thing: a>]
+"""}