Michael Hall has proposed merging lp:~mhall119/loco-directory/fixes-612997 into
lp:loco-directory.
Requested reviews:
loco-directory-dev (loco-directory-dev)
Related bugs:
#612997 IntegrityError: duplicate key value violates unique constraint
"venues_venue_longitude_2d904d039bce1526"
https://bugs.launchpad.net/bugs/612997
Remove unique constraint on longitude and latitude in venues
--
https://code.launchpad.net/~mhall119/loco-directory/fixes-612997/+merge/31638
Your team loco-directory-dev is requested to review the proposed merge of
lp:~mhall119/loco-directory/fixes-612997 into lp:loco-directory.
=== added file 'loco_directory/venues/migrations/0005_remove_lonlat_unique.py'
--- loco_directory/venues/migrations/0005_remove_lonlat_unique.py 1970-01-01 00:00:00 +0000
+++ loco_directory/venues/migrations/0005_remove_lonlat_unique.py 2010-08-03 14:02:46 +0000
@@ -0,0 +1,47 @@
+# encoding: utf-8
+import datetime
+from south.db import db
+from south.v2 import SchemaMigration
+from django.db import models
+
+class Migration(SchemaMigration):
+
+ def forwards(self, orm):
+
+ # Removing unique constraint on 'venue', fields ['latitude', 'longitude']
+ db.delete_unique('venues_venue', ['latitude', 'longitude'])
+
+
+ def backwards(self, orm):
+
+ # Adding unique constraint on 'venue', fields ['latitude', 'longitude']
+ db.create_unique('venues_venue', ['latitude', 'longitude'])
+
+
+ models = {
+ 'teams.continent': {
+ 'Meta': {'object_name': 'Continent'},
+ 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+ 'name': ('django.db.models.fields.TextField', [], {'max_length': '50'})
+ },
+ 'teams.country': {
+ 'Meta': {'object_name': 'Country'},
+ 'continents': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['teams.Continent']"}),
+ 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+ 'name': ('django.db.models.fields.TextField', [], {'max_length': '100'})
+ },
+ 'venues.venue': {
+ 'Meta': {'unique_together': "(('name', 'country', 'city'),)", 'object_name': 'Venue'},
+ 'address': ('django.db.models.fields.CharField', [], {'max_length': '150', 'null': 'True', 'blank': 'True'}),
+ 'city': ('django.db.models.fields.CharField', [], {'max_length': '150', 'null': 'True', 'blank': 'True'}),
+ 'comment': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
+ 'country': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['teams.Country']", 'null': 'True'}),
+ 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+ 'latitude': ('django.db.models.fields.FloatField', [], {'null': 'True', 'blank': 'True'}),
+ 'longitude': ('django.db.models.fields.FloatField', [], {'null': 'True', 'blank': 'True'}),
+ 'name': ('django.db.models.fields.CharField', [], {'max_length': '150'}),
+ 'venue_url': ('django.db.models.fields.URLField', [], {'max_length': '200', 'null': 'True', 'blank': 'True'})
+ }
+ }
+
+ complete_apps = ['venues']
=== modified file 'loco_directory/venues/models.py'
--- loco_directory/venues/models.py 2010-07-29 13:54:09 +0000
+++ loco_directory/venues/models.py 2010-08-03 14:02:46 +0000
@@ -24,7 +24,7 @@
comment = models.TextField(help_text=_('Comment about the Venue'), blank=True, null=True)
class Meta:
- unique_together = ( ('name', 'country', 'city'), ('longitude', 'latitude'), )
+ unique_together = ( ('name', 'country', 'city'), )
#add manager
objects = VenueManager()
_______________________________________________
Mailing list: https://launchpad.net/~loco-directory-dev
Post to : [email protected]
Unsubscribe : https://launchpad.net/~loco-directory-dev
More help : https://help.launchpad.net/ListHelp
