I forgot to mention that I am using django point release 0.91.
Nick On 5/21/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hey all, I am just starting with django; I think it is really cool, a big break from Java/Struts dev for me. Anyways, I am experimenting with a simple blog app. So, on to some issues. Here is output: bastion:~ nick$ python dev/django-projects/myblog/manage.py sql blog BEGIN; CREATE TABLE "blog_authors" ( "id" serial NOT NULL PRIMARY KEY, "first_name" text NOT NULL, "last_name" text NOT NULL, "email" text NOT NULL ); CREATE TABLE "blog_articles" ( "id" serial NOT NULL PRIMARY KEY, "title" text NOT NULL, "content" text NOT NULL, "publish_date" timestamp with time zone NOT NULL, "author_id" integer NOT NULL REFERENCES "blog_authors" ("id") ); CREATE TABLE "blog_comments" ( "id" serial NOT NULL PRIMARY KEY, "title" text NOT NULL, "content" text NOT NULL, "publish_date" timestamp with time zone NOT NULL, "author_id" integer NOT NULL REFERENCES "blog_authors" ("id"), "related_article_id" integer NOT NULL REFERENCES "blog_articles" ("id") ); COMMIT; # so far so good # then... bastion:~ nick$ python dev/django-projects/myblog/manage.py shell Python 2.4.3 (#1, May 20 2006, 16:12:06) [GCC 4.0.1 (Apple Computer, Inc. build 5250)] on darwin Type "help", "copyright", "credits" or "license" for more information. (InteractiveConsole) >>> from blog.models.blog import * >>> a = Article(title='Hi', content='Double Hi', publish_date='now') >>> a.save() Traceback (most recent call last): File "<console>", line 1, in ? File "/opt/local/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/Django-0.91-py2.4.egg/django/utils/functional.py", line 3, in _curried return args[0](*(args[1:]+moreargs), **dict(kwargs.items() + morekwargs.items())) File "/opt/local/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/Django-0.91-py2.4.egg/django/core/meta/__init__.py", line 1026, in method_save ','.join(placeholders)), db_values) File "/opt/local/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/Django-0.91-py2.4.egg/django/core/db/base.py", line 10, in execute result = self.cursor.execute(sql, params) IntegrityError: ERROR: null value in column "author_id" violates not-null constraint INSERT INTO "blog_articles" ("title","content","publish_date","author_id") VALUES ('Hi','Double Hi','now',NULL) # ok. so I made a mistake. but what follows really puzzles me. >>> me = Author(first_name='Nick', last_name='Hristov', email='[EMAIL PROTECTED]') >>> me.save() Traceback (most recent call last): File "<console>", line 1, in ? File "/opt/local/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/Django-0.91-py2.4.egg/django/utils/functional.py", line 3, in _curried return args[0](*(args[1:]+moreargs), **dict(kwargs.items() + morekwargs.items())) File "/opt/local/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/Django-0.91-py2.4.egg/django/core/meta/__init__.py", line 990, in method_save cursor = db.db.cursor() File "/opt/local/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/Django-0.91-py2.4.egg/django/core/db/backends/postgresql.py", line 35, in cursor cursor.execute("SET TIME ZONE %s", [TIME_ZONE]) ProgrammingError: ERROR: current transaction is aborted, commands ignored until end of transaction block SET TIME ZONE 'GMT' # Wtf? I guess a transaction was opened in the previous save and it was not closed, so all of my following db queries are going to fail too? To some degree that sounds fine, I guess... it is fail safe. But how do I now abort the current transaction and start a fresh? # Or do my saves get batched and executed as a transaction? Given the previous save did not work, it should not be batched... Thanks for the help. Nick
X-Google-Language: ENGLISH,ASCII-7-bit Received: by 10.54.68.15 with SMTP id q15mr171422wra; Sun, 21 May 2006 08:55:25 -0700 (PDT) Return-Path: <[EMAIL PROTECTED]> Received: from ug-out-1314.google.com ([66.249.92.168]) by mx.googlegroups.com with ESMTP id v11si698395cwb.2006.05.21.08.55.24; Sun, 21 May 2006 08:55:25 -0700 (PDT) Received-SPF: pass (googlegroups.com: domain of [EMAIL PROTECTED] designates 66.249.92.168 as permitted sender) DomainKey-Status: good (test mode) Received: by ug-out-1314.google.com with SMTP id u40so1196844ugc for <django-users@googlegroups.com>; Sun, 21 May 2006 08:55:23 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Ikz7orIjkcoIC5EYcFskzU7RTPoPrub55vJ6asMqqq5wqDJheUCVZcUBMBbpu8hjf6E8pE8IsGORgtuuz4cdBssraOUKEr01PFMRdmgKu51146tLKc6fSNnZR+RRQaIPH9P0SJR5VSNtxYDUH7qoi0Q/SABsfD9JbDUbpPBfUNY= Received: by 10.78.57.11 with SMTP id f11mr939422hua; Sun, 21 May 2006 08:55:23 -0700 (PDT) Received: by 10.78.24.4 with HTTP; Sun, 21 May 2006 08:55:23 -0700 (PDT) Message-ID: <[EMAIL PROTECTED]> Date: Sun, 21 May 2006 08:55:23 -0700 From: "Nick Hristov" <[EMAIL PROTECTED]> To: "Django users" <django-users@googlegroups.com> Subject: Re: noobie db problems In-Reply-To: <[EMAIL PROTECTED]> Mime-Version: 1.0 Content-Type: text/plain References: <[EMAIL PROTECTED]> I forgot to mention that I am using django point release 0.91. Nick On 5/21/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hey all, I am just starting with django; I think it is really cool, a big break from Java/Struts dev for me. Anyways, I am experimenting with a simple blog app. So, on to some issues. Here is output: bastion:~ nick$ python dev/django-projects/myblog/manage.py sql blog BEGIN; CREATE TABLE "blog_authors" ( "id" serial NOT NULL PRIMARY KEY, "first_name" text NOT NULL, "last_name" text NOT NULL, "email" text NOT NULL ); CREATE TABLE "blog_articles" ( "id" serial NOT NULL PRIMARY KEY, "title" text NOT NULL, "content" text NOT NULL, "publish_date" timestamp with time zone NOT NULL, "author_id" integer NOT NULL REFERENCES "blog_authors" ("id") ); CREATE TABLE "blog_comments" ( "id" serial NOT NULL PRIMARY KEY, "title" text NOT NULL, "content" text NOT NULL, "publish_date" timestamp with time zone NOT NULL, "author_id" integer NOT NULL REFERENCES "blog_authors" ("id"), "related_article_id" integer NOT NULL REFERENCES "blog_articles" ("id") ); COMMIT; # so far so good # then... bastion:~ nick$ python dev/django-projects/myblog/manage.py shell Python 2.4.3 (#1, May 20 2006, 16:12:06) [GCC 4.0.1 (Apple Computer, Inc. build 5250)] on darwin Type "help", "copyright", "credits" or "license" for more information. (InteractiveConsole) >>> from blog.models.blog import * >>> a = Article(title='Hi', content='Double Hi', publish_date='now') >>> a.save() Traceback (most recent call last): File "<console>", line 1, in ? File "/opt/local/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/Django-0.91-py2.4.egg/django/utils/functional.py", line 3, in _curried return args[0](*(args[1:]+moreargs), **dict(kwargs.items() + morekwargs.items())) File "/opt/local/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/Django-0.91-py2.4.egg/django/core/meta/__init__.py", line 1026, in method_save ','.join(placeholders)), db_values) File "/opt/local/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/Django-0.91-py2.4.egg/django/core/db/base.py", line 10, in execute result = self.cursor.execute(sql, params) IntegrityError: ERROR: null value in column "author_id" violates not-null constraint INSERT INTO "blog_articles" ("title","content","publish_date","author_id") VALUES ('Hi','Double Hi','now',NULL) # ok. so I made a mistake. but what follows really puzzles me. >>> me = Author(first_name='Nick', last_name='Hristov', email='[EMAIL PROTECTED]') >>> me.save() Traceback (most recent call last): File "<console>", line 1, in ? File "/opt/local/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/Django-0.91-py2.4.egg/django/utils/functional.py", line 3, in _curried return args[0](*(args[1:]+moreargs), **dict(kwargs.items() + morekwargs.items())) File "/opt/local/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/Django-0.91-py2.4.egg/django/core/meta/__init__.py", line 990, in method_save cursor = db.db.cursor() File "/opt/local/Library/Frameworks/Python.framework/Versions/2.4/lib/python2.4/site-packages/Django-0.91-py2.4.egg/django/core/db/backends/postgresql.py", line 35, in cursor cursor.execute("SET TIME ZONE %s", [TIME_ZONE]) ProgrammingError: ERROR: current transaction is aborted, commands ignored until end of transaction block SET TIME ZONE 'GMT' # Wtf? I guess a transaction was opened in the previous save and it was not closed, so all of my following db queries are going to fail too? To some degree that sounds fine, I guess... it is fail safe. But how do I now abort the current transaction and start a fresh? # Or do my saves get batched and executed as a transaction? Given the previous save did not work, it should not be batched... Thanks for the help. Nick
--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users -~----------~----~----~----~------~----~------~--~---