--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/parts/django/tests/regressiontests/custom_columns_regress/models.py Sat Jan 08 11:20:57 2011 +0530
@@ -0,0 +1,36 @@
+"""
+Regression for #9736.
+
+Checks some pathological column naming to make sure it doesn't break
+table creation or queries.
+
+"""
+
+from django.db import models
+
+class Article(models.Model):
+ Article_ID = models.AutoField(primary_key=True, db_column='Article ID')
+ headline = models.CharField(max_length=100)
+ authors = models.ManyToManyField('Author', db_table='my m2m table')
+ primary_author = models.ForeignKey('Author', db_column='Author ID', related_name='primary_set')
+
+ def __unicode__(self):
+ return self.headline
+
+ class Meta:
+ ordering = ('headline',)
+
+class Author(models.Model):
+ Author_ID = models.AutoField(primary_key=True, db_column='Author ID')
+ first_name = models.CharField(max_length=30, db_column='first name')
+ last_name = models.CharField(max_length=30, db_column='last name')
+
+ def __unicode__(self):
+ return u'%s %s' % (self.first_name, self.last_name)
+
+ class Meta:
+ db_table = 'my author table'
+ ordering = ('last_name','first_name')
+
+
+