Re: [Modeling-users] Installation tests failure (datetime) - osx, pypgsql

[Mario R. <ma...@ru...>]

>> However I just had a look at the test_EditingContext_Global.py and it
>> seems that I forgot to commit some changes that can make the  
>> following 2
>> tests fail: test_06_deleteRule_nullify(), and  
>> test_999_customSQLQuery()
>> w/ pypgsql. I need to check that, I'll write back when I have some  
>> news
>> about that.
>
>   Ok, you can download the corrected test at:
> http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/*checkout*/modeling/ 
> ProjectModeling/Modeling/tests/test_EditingContext_Global.py?rev=1.12
>
>   and it should be ok.
>
> -- Sebastien.

OK, I have downloaded it. There are other errors (and they were there  
before, but I assumed they
were related to previous one -- however there are less errors now ;-).  
I have also cretaed the 2nd
db as instructed in the new README. Now first error is 'Type "datetime"  
does not exist', and I would
not say it is coming from mx.DateTime which seems properly installed  
(from interactive python command,
can import mx and DateTime ...). is it something to do with pypgsql?
I am including all the output this time...

Cheers, mario

% python ./test_EditingContext_Global.py -r
PostgresqlAdaptor: using pypgsql
Creating PostgresqlAdaptorChannel  
<PostgresqlAdaptorLayer.PostgresqlAdaptorChannel.PostgresqlAdaptorChanne 
l instance at 0x881ac0>
Transaction: BEGIN
Opening connection to the DB with conn.Dict: {'host': 'localhost',  
'password': 'YYYY', 'user': 'postgres', 'database': 'AUTHOR_BOOKS'}
Opening channel  
<PostgresqlAdaptorLayer.PostgresqlAdaptorChannel.PostgresqlAdaptorChanne 
l instance at 0x887b90> (0x887b90)
Called
Evaluating: DROP TABLE WRITER
Couldn't evaluate expression DROP TABLE WRITER. Reason:  
libpq.OperationalError:ERROR:  table "writer" does not exist

Transaction: ROLLBACK
error: Couldn't evaluate expression DROP TABLE WRITER. Reason:  
libpq.OperationalError:ERROR:  table "writer" does not exist

Transaction: BEGIN
Evaluating: DROP TABLE BOOK
Transaction: COMMIT
Transaction: BEGIN
Evaluating: CREATE TABLE WRITER (
   FIRST_NAME VARCHAR(40) ,
   LAST_NAME VARCHAR(30) NOT NULL,
   FK_WRITER_ID INTEGER ,
   AGE INTEGER ,
   BIRTHDAY DATETIME ,
   ID INTEGER NOT NULL)
Couldn't evaluate expression CREATE TABLE WRITER (
   FIRST_NAME VARCHAR(40) ,
   LAST_NAME VARCHAR(30) NOT NULL,
   FK_WRITER_ID INTEGER ,
   AGE INTEGER ,
   BIRTHDAY DATETIME ,
   ID INTEGER NOT NULL). Reason: libpq.OperationalError:ERROR:  Type  
"datetime" does not exist

Transaction: ROLLBACK
error: Couldn't evaluate expression CREATE TABLE WRITER (
   FIRST_NAME VARCHAR(40) ,
   LAST_NAME VARCHAR(30) NOT NULL,
   FK_WRITER_ID INTEGER ,
   AGE INTEGER ,
   BIRTHDAY DATETIME ,
   ID INTEGER NOT NULL). Reason: libpq.OperationalError:ERROR:  Type  
"datetime" does not exist

Transaction: BEGIN
Evaluating: CREATE TABLE BOOK (
   PRICE NUMERIC(10,2) ,
   title VARCHAR(40) NOT NULL,
   id INT NOT NULL,
   FK_WRITER_ID INTEGER )
Transaction: COMMIT
Transaction: BEGIN
Evaluating: ALTER TABLE WRITER ADD PRIMARY KEY (ID)
Couldn't evaluate expression ALTER TABLE WRITER ADD PRIMARY KEY (ID).  
Reason: libpq.OperationalError:ERROR:  Relation "writer" does not exist

Transaction: ROLLBACK
error: Couldn't evaluate expression ALTER TABLE WRITER ADD PRIMARY KEY  
(ID). Reason: libpq.OperationalError:ERROR:  Relation "writer" does not  
exist

Transaction: BEGIN
Evaluating: ALTER TABLE BOOK ADD PRIMARY KEY (id)
Transaction: COMMIT
Transaction: BEGIN
Evaluating: ALTER TABLE WRITER ADD CONSTRAINT pygmalion FOREIGN KEY  
(FK_WRITER_ID) REFERENCES WRITER(ID) INITIALLY DEFERRED
Couldn't evaluate expression ALTER TABLE WRITER ADD CONSTRAINT  
pygmalion FOREIGN KEY (FK_WRITER_ID) REFERENCES WRITER(ID) INITIALLY  
DEFERRED. Reason: libpq.OperationalError:ERROR:  Relation "writer" does  
not exist

Transaction: ROLLBACK
error: Couldn't evaluate expression ALTER TABLE WRITER ADD CONSTRAINT  
pygmalion FOREIGN KEY (FK_WRITER_ID) REFERENCES WRITER(ID) INITIALLY  
DEFERRED. Reason: libpq.OperationalError:ERROR:  Relation "writer" does  
not exist

Transaction: BEGIN
Evaluating: ALTER TABLE BOOK ADD CONSTRAINT author FOREIGN KEY  
(FK_WRITER_ID) REFERENCES WRITER(ID) INITIALLY DEFERRED
Couldn't evaluate expression ALTER TABLE BOOK ADD CONSTRAINT author  
FOREIGN KEY (FK_WRITER_ID) REFERENCES WRITER(ID) INITIALLY DEFERRED.  
Reason: libpq.OperationalError:ERROR:  Relation "writer" does not exist

Transaction: ROLLBACK
error: Couldn't evaluate expression ALTER TABLE BOOK ADD CONSTRAINT  
author FOREIGN KEY (FK_WRITER_ID) REFERENCES WRITER(ID) INITIALLY  
DEFERRED. Reason: libpq.OperationalError:ERROR:  Relation "writer" does  
not exist

Transaction: BEGIN
Evaluating: DROP SEQUENCE PK_SEQ_WRITER
Transaction: COMMIT
Transaction: BEGIN
Evaluating: DROP SEQUENCE PK_SEQ_BOOK
Transaction: COMMIT
Transaction: BEGIN
Evaluating: CREATE SEQUENCE PK_SEQ_WRITER START 1
Transaction: COMMIT
Transaction: BEGIN
Evaluating: CREATE SEQUENCE PK_SEQ_BOOK START 1
Transaction: COMMIT
Transaction: BEGIN
Evaluating: select nextval('PK_SEQ_WRITER')
Evaluating: select nextval('PK_SEQ_WRITER')
Evaluating: select nextval('PK_SEQ_WRITER')
Transaction: COMMIT
Transaction: BEGIN
Evaluating: insert into WRITER (id, age,  
last_name,first_name,birthday,fk_writer_id) values  
(1,24,'Cleese','John','1939-10-27 08:31:15',null)
Couldn't evaluate expression insert into WRITER (id, age,  
last_name,first_name,birthday,fk_writer_id) values  
(1,24,'Cleese','John','1939-10-27 08:31:15',null). Reason:  
libpq.OperationalError:ERROR:  Relation "writer" does not exist

Transaction: ROLLBACK
Traceback (most recent call last):
   File "./test_EditingContext_Global.py", line 943, in ?
     errs = main(sys.argv)
   File "./test_EditingContext_Global.py", line 927, in main
     if reinitDB_flag: reinitDB(); return
   File "./test_EditingContext_Global.py", line 846, in reinitDB
     channel.evaluateExpression(sqlExpr)
   File  
"/Users/frdricva/Desktop/ModelingCore-0.8.1/Modeling/DatabaseAdaptors/ 
AbstractDBAPI2AdaptorLayer/AbstractDBAPI2AdaptorChannel.py", line 159,  
in evaluateExpression
     raise GeneralAdaptorException, msg
Modeling.Adaptor.GeneralAdaptorException: Couldn't evaluate expression  
insert into WRITER (id, age,  
last_name,first_name,birthday,fk_writer_id) values  
(1,24,'Cleese','John','1939-10-27 08:31:15',null). Reason:  
libpq.OperationalError:ERROR:  Relation "writer" does not exist