Re: SyncDb doesn't create tables in database

On Thu, May 30, 2013 at 1:46 PM, Anas <z.anas91@gmail.com> wrote:
> I am having Neo4Django in my django based application and trying to use two
> databases at the sametime : Neo4j and PostGIS. So i configured settings.py
> as suggested in the docs (http://neo4django.readthedocs.org) and models.py
> as well.
>
> When i try to run syncdb , i am getting this message
>
> You just installed Django's auth system, which means you don't have any
> superusers defined.
> Would you like to create one now? (yes/no): yes
> Username (leave blank to use 'postgres'):
> E-mail address: postgres@gmail.com
> Password:
> Password (again):
> Superuser created successfully.
> Installing custom SQL ...
> Installing indexes ...
> Installed 0 object(s) from 0 fixture(s)
>
> but when i check if the table and the graph were created, i find nothing !
>
> i am using django 1.4 and neo4j 1.9.M05
>
>
> here is how i declared my databases in settings.py:
>
> DATABASES = {
> 'default': {
> 'ENGINE': 'django.contrib.gis.db.backends.postgis',
> 'NAME': 'geodjango',
> 'USER': 'postgres',
>
>
> }
> }
> NEO4J_DATABASES = {
> 'default' : {
> 'HOST':'127.0.0.1',
> 'PORT':7474,
> 'ENDPOINT':'/db/data/'
> }
> }
>
> DATABASE_ROUTERS = ['neo4django.utils.Neo4djangoIntegrationRouter']
>
>
> and i declared my models.py like this :
>
> from neo4django.db import models
> from django.contrib.gis.db import models as gis
>
> class Airport(models.NodeModel):
> name = models.StringProperty()
> iata = models.StringProperty()
> icao= models.StringProperty()
>
> city = models.Relationship('self',rel_type='isAT')
>
> #geographical database for storing entities coordinates
> class pointsOfInterest(gis.Model):
> nodeid = gis.IntegerField()
> longitude = gis.FloatField()
> latitude = gis.FloatField()
>
> # GeoDjango-specific: a geometry field (MultiPolygonField), and
> # overriding the default manager with a GeoManager instance.
> objects = gis.GeoManager()
>
>
> when i run `python manage.py sqlall testapp` (where testapp is my app and
> after deleting the neo4j models , otherwise it won't work ), i am getting
> that sql that permit to create the table :
>
> BEGIN;
> CREATE TABLE "testapp_pointsofinterest" (
> "id" serial NOT NULL PRIMARY KEY,
> "nodeid" integer NOT NULL,
> "longitude" double precision NOT NULL,
> "latitude" double precision NOT NULL
> )
> ;
> COMMIT;
>
> Then i try to create an instance of this table in the `python manage.py
> shell` i am getting this :
>
>
> postgres@anas-desktop:/home/anas/Desktop/testNeo4Django$ ./manage.py
> shell
> Python 2.6.5 (r265:79063, Oct 1 2012, 22:07:21)
> [GCC 4.4.3] on linux2
> Type "help", "copyright", "credits" or "license" for more information.
> (InteractiveConsole)
> >>> from testNeo4Django.testapp.models import pointsOfInterest
> >>>
> >>> poi= pointsOfInterest.objects.create()
> Traceback (most recent call last):
> File "<console>", line 1, in <module>
> File
> "/usr/local/lib/python2.6/dist-packages/django/db/models/manager.py", line
> 137, in create
> return self.get_query_set().create(**kwargs)
> File
> "/usr/local/lib/python2.6/dist-packages/django/db/models/query.py", line
> 377, in create
> obj.save(force_insert=True, using=self.db)
> File
> "/usr/local/lib/python2.6/dist-packages/django/db/models/base.py", line 463,
> in save
> self.save_base(using=using, force_insert=force_insert,
> force_update=force_update)
> File
> "/usr/local/lib/python2.6/dist-packages/django/db/models/base.py", line 551,
> in save_base
> result = manager._insert([self], fields=fields, return_id=update_pk,
> using=using, raw=raw)
> File
> "/usr/local/lib/python2.6/dist-packages/django/db/models/manager.py", line
> 203, in _insert
> return insert_query(self.model, objs, fields, **kwargs)
> File
> "/usr/local/lib/python2.6/dist-packages/django/db/models/query.py", line
> 1593, in insert_query
> return query.get_compiler(using=using).execute_sql(return_id)
> File
> "/usr/local/lib/python2.6/dist-packages/django/db/models/sql/compiler.py",
> line 912, in execute_sql
> cursor.execute(sql, params)
> File
> "/usr/local/lib/python2.6/dist-packages/django/db/backends/util.py", line
> 40, in execute
> return self.cursor.execute(sql, params)
> File
> "/usr/local/lib/python2.6/dist-packages/django/db/backends/postgresql_psycopg2/base.py",
> line 52, in execute
> return self.cursor.execute(query, args)
> IntegrityError: null value in column "nodeid" violates not-null
> constraint
>
> Any ideas about this ?
>
> thanks for your help
>

syncdb does not create tables that already exist in the database. It
also doesn't alter tables that exist if you change your models.py.

Your error traceback clearly indicates that the table exists. The
error says that the field nodeid cannot be null, as specified in your
models.py, but you have (by not passing any values) submitted
nodeid=None.

Cheers

Tom

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.