Re: [Django] #23153: 1.7 migrations' temporary tables cause problems with gis

[Django]

#23153: 1.7 migrations' temporary tables cause problems with gis
-+
 Reporter:  TomLottermann|Owner:  andrewgodwin
 Type:  Bug  |   Status:  closed
Component:  GIS  |  Version:  1.7-rc-2
 Severity:  Release blocker  |   Resolution:  fixed
 Keywords:  migrations, gis  | Triage Stage:  Accepted
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+
Changes (by timo):

 * status:  new => closed
 * resolution:   => fixed


Comment:

 In 5f6558f82f980ff1326ae0f71b4cdaa545c6f4c2"

 Stop errors on older Spatialite versions that miss some tables

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/071.965ce39e662ecfa96991750833b875d6%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #23153: 1.7 migrations' temporary tables cause problems with gis

[Django]

#23153: 1.7 migrations' temporary tables cause problems with gis
-+
 Reporter:  TomLottermann|Owner:  andrewgodwin
 Type:  Bug  |   Status:  new
Component:  GIS  |  Version:  1.7-rc-2
 Severity:  Release blocker  |   Resolution:
 Keywords:  migrations, gis  | Triage Stage:  Accepted
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+

Comment (by charettes):

 @andrewgodwin, Jenkins has moved to [http://djangoci.com/job/django-
 master/database=spatialite,python=python2.7/ djangoci.com].

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/071.6a7e1c209e2b32e9dedff6336dddbc2b%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #23153: 1.7 migrations' temporary tables cause problems with gis

[Django]

#23153: 1.7 migrations' temporary tables cause problems with gis
-+
 Reporter:  TomLottermann|Owner:  andrewgodwin
 Type:  Bug  |   Status:  new
Component:  GIS  |  Version:  1.7-rc-2
 Severity:  Release blocker  |   Resolution:
 Keywords:  migrations, gis  | Triage Stage:  Accepted
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+

Comment (by andrewgodwin):

 Can I get more information? All tests pass locally on spatialite, and
 Jenkins seems down at the moment.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/071.6dcdd947dccce21922db70637d08f72f%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #23153: 1.7 migrations' temporary tables cause problems with gis

[Django]

#23153: 1.7 migrations' temporary tables cause problems with gis
-+
 Reporter:  TomLottermann|Owner:  andrewgodwin
 Type:  Bug  |   Status:  new
Component:  GIS  |  Version:  1.7-rc-2
 Severity:  Release blocker  |   Resolution:
 Keywords:  migrations, gis  | Triage Stage:  Accepted
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+
Changes (by timo):

 * status:  closed => new
 * resolution:  fixed =>
 * stage:  Unreviewed => Accepted


Comment:

 This is causing "table already exists" test failures on spatialite.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/071.fc25f1496862a7033148fe8ffce3cccf%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #23153: 1.7 migrations' temporary tables cause problems with gis

[Django]

#23153: 1.7 migrations' temporary tables cause problems with gis
-+
 Reporter:  TomLottermann|Owner:  andrewgodwin
 Type:  Bug  |   Status:  closed
Component:  GIS  |  Version:  1.7-rc-2
 Severity:  Release blocker  |   Resolution:  fixed
 Keywords:  migrations, gis  | Triage Stage:  Unreviewed
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+

Comment (by Andrew Godwin ):

 In [changeset:"6ebfff7f667f8e30afc6fb32a4349b6d0a4aa4ba"]:
 {{{
 #!CommitTicketReference repository=""
 revision="6ebfff7f667f8e30afc6fb32a4349b6d0a4aa4ba"
 [1.7.x] Fixed #23153: Properly recreate spatialite triggers on alter table
 }}}

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/071.75edd7a843bcc1090a538edad9071bf6%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #23153: 1.7 migrations' temporary tables cause problems with gis

[Django]

#23153: 1.7 migrations' temporary tables cause problems with gis
-+
 Reporter:  TomLottermann|Owner:  andrewgodwin
 Type:  Bug  |   Status:  closed
Component:  GIS  |  Version:  1.7-rc-2
 Severity:  Release blocker  |   Resolution:  fixed
 Keywords:  migrations, gis  | Triage Stage:  Unreviewed
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+
Changes (by Andrew Godwin ):

 * status:  assigned => closed
 * resolution:   => fixed


Comment:

 In [changeset:"b508c1c317c026eeec82b04142d9e3956192619c"]:
 {{{
 #!CommitTicketReference repository=""
 revision="b508c1c317c026eeec82b04142d9e3956192619c"
 Fixed #23153: Properly recreate spatialite triggers on alter table
 }}}

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/071.c24ff2519146d2a20ac609171c4ae6d6%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #23153: 1.7 migrations' temporary tables cause problems with gis

[Django]

#23153: 1.7 migrations' temporary tables cause problems with gis
-+
 Reporter:  TomLottermann|Owner:  andrewgodwin
 Type:  Bug  |   Status:  assigned
Component:  GIS  |  Version:  1.7-rc-2
 Severity:  Release blocker  |   Resolution:
 Keywords:  migrations, gis  | Triage Stage:  Unreviewed
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+
Changes (by andrewgodwin):

 * owner:  nobody => andrewgodwin
 * status:  new => assigned


-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/071.91bd69b4099014e9c321677df758fc5a%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #23153: 1.7 migrations' temporary tables cause problems with gis

[Django]

#23153: 1.7 migrations' temporary tables cause problems with gis
-+--
 Reporter:  TomLottermann|Owner:  nobody
 Type:  Bug  |   Status:  new
Component:  GIS  |  Version:  1.7-rc-2
 Severity:  Release blocker  |   Resolution:
 Keywords:  migrations, gis  | Triage Stage:  Unreviewed
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+--

Comment (by claudep):

 I have worked a bit on Spatialite migrations recently, and ''might'' be
 able to handle this, however probably not before a week.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/071.8248f283f187486394de154ecf48b3a0%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #23153: 1.7 migrations' temporary tables cause problems with gis

[Django]

#23153: 1.7 migrations' temporary tables cause problems with gis
-+--
 Reporter:  TomLottermann|Owner:  nobody
 Type:  Bug  |   Status:  new
Component:  GIS  |  Version:  1.7-rc-2
 Severity:  Release blocker  |   Resolution:
 Keywords:  migrations, gis  | Triage Stage:  Unreviewed
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+--

Comment (by andrewgodwin):

 I can't immediately work out the issue here, but I suspect we might have
 to say that alteration isn't supported with spatialite - after all, Django
 is offering features that Spatialite itself does not. Rather a drastic
 change, but if you're developing GIS applications it's not too much an ask
 to say you should use PostGIS.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/071.a573756a3fb98efe9540facc4cd7174b%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #23153: 1.7 migrations' temporary tables cause problems with gis

[Django]

#23153: 1.7 migrations' temporary tables cause problems with gis
-+--
 Reporter:  TomLottermann|Owner:  nobody
 Type:  Bug  |   Status:  new
Component:  GIS  |  Version:  1.7-rc-2
 Severity:  Release blocker  |   Resolution:
 Keywords:  migrations, gis  | Triage Stage:  Unreviewed
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+--
Changes (by TomLottermann):

 * severity:  Normal => Release blocker


-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/071.17bc22b77d0e6bd84fbbc0f26c5de069%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #23153: 1.7 migrations' temporary tables cause problems with gis

[Django]

#23153: 1.7 migrations' temporary tables cause problems with gis
-+--
 Reporter:  TomLottermann|Owner:  nobody
 Type:  Bug  |   Status:  new
Component:  GIS  |  Version:  1.7-rc-2
 Severity:  Normal   |   Resolution:
 Keywords:  migrations, gis  | Triage Stage:  Unreviewed
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+--

Comment (by TomLottermann):

 I now was able to reconstruct this error in a smaller sample.
 My project is structured in the following way: projectfolder "gistest"
 with app "sample"
 My settings.py looks like this:

 {{{
 """
 Django settings for gistest project.

 For more information on this file, see
 https://docs.djangoproject.com/en/dev/topics/settings/

 For the full list of settings and their values, see
 https://docs.djangoproject.com/en/dev/ref/settings/
 """

 # Build paths inside the project like this: os.path.join(BASE_DIR, ...)
 import os
 BASE_DIR = os.path.dirname(os.path.dirname(__file__))


 # Quick-start development settings - unsuitable for production
 # See https://docs.djangoproject.com/en/dev/howto/deployment/checklist/

 # SECURITY WARNING: keep the secret key used in production secret!
 SECRET_KEY = 'k+=9bmpz)2+3v9(&+e6#x+iuqk!bz@g2!vl+fc7x$2blan+r9j'

 # SECURITY WARNING: don't run with debug turned on in production!
 DEBUG = True

 TEMPLATE_DEBUG = True

 ALLOWED_HOSTS = []


 # Application definition

 INSTALLED_APPS = (
 'django.contrib.admin',
 'django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.messages',
 'django.contrib.staticfiles',
 'django.contrib.gis',
 'gistest.sample',
 )

 MIDDLEWARE_CLASSES = (
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.middleware.common.CommonMiddleware',
 'django.middleware.csrf.CsrfViewMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'django.contrib.auth.middleware.SessionAuthenticationMiddleware',
 'django.contrib.messages.middleware.MessageMiddleware',
 'django.middleware.clickjacking.XFrameOptionsMiddleware',
 )

 ROOT_URLCONF = 'gistest.urls'

 WSGI_APPLICATION = 'gistest.wsgi.application'


 # Database
 # https://docs.djangoproject.com/en/dev/ref/settings/#databases

 DATABASES = {
 'default': {
 'ENGINE' : 'django.contrib.gis.db.backends.spatialite',
 'NAME'   : 'gistest.db',
 'TEST': {
 'NAME': '/path/to/test.db',
 }
 }
 }

 # Internationalization
 # https://docs.djangoproject.com/en/dev/topics/i18n/

 LANGUAGE_CODE = 'en-us'

 TIME_ZONE = 'UTC'

 USE_I18N = True

 USE_L10N = True

 USE_TZ = True


 # Static files (CSS, JavaScript, Images)
 # https://docs.djangoproject.com/en/dev/howto/static-files/

 STATIC_URL = '/static/'

 }}}

 My sample/models.py:

 {{{
 #!/usr/bin/env python
 # -*- coding: utf-8 -*-

 from django.db import models
 from django.utils.translation import ugettext_lazy as _

 from django.contrib.gis.db import models as gis_models

 class Target(models.Model):
 pass

 class Location(models.Model):
 """
 Represents a named location.
 """

 objects = gis_models.GeoManager()

 name = models.TextField(verbose_name=_(u'name'))

 position = gis_models.PointField(verbose_name=_(u'position'))

 fk = models.ForeignKey(Target, blank=True, null=True)

 def __unicode__(self):
 return self.name

 }}}

 My sample/tests.py:

 {{{
 #!/usr/bin/env python
 # -*- coding: utf-8 -*-

 from django.test import TestCase

 from django.contrib.auth.models import User

 from gistest.sample.models import Location

 class LocationTestCase(TestCase):
 def test_location(self):
 location = Location.objects.create(
 name="name",
 position='POINT(1 1)'
 )

 }}}

 Now after having created the initial migrations, executing manage.py test
 throws this exception:

 {{{
 ==
 ERROR: test_location (gistest.sample.tests.LocationTestCase)
 --
 Traceback (most recent call last):
   File
 
"/home/thomas/Dokumente/Softwareprojekte/boozter/django17gistest/gistest/gistest/sample/tests.py",
 line 14, in test_location
 position='POINT(1 1)'
   File
 "/home/thomas/Dokumente/Softwareprojekte/boozter/ENV/local/lib/python2.7
 /site-packages/django/db/models/manager.py", line 92, in manager_method
 return getattr(self.get_queryset(), name)(*args, **kwargs)
   File
 

Re: [Django] #23153: 1.7 migrations' temporary tables cause problems with gis

[Django]

#23153: 1.7 migrations' temporary tables cause problems with gis
-+--
 Reporter:  TomLottermann|Owner:  nobody
 Type:  Bug  |   Status:  new
Component:  GIS  |  Version:  1.7-rc-2
 Severity:  Normal   |   Resolution:
 Keywords:  migrations, gis  | Triage Stage:  Unreviewed
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+--
Changes (by TomLottermann):

 * needs_better_patch:   => 0
 * component:  Migrations => GIS
 * needs_tests:   => 0
 * needs_docs:   => 0


-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/071.ac363eee16a3d231688d8cee8d688b94%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.