Here are some more test errors that I am running into with the Pg
tests. In the db-object-auto.t test, it looks like a sequence can
not be found. In the test file, there seem to be two different ways
of naming the sequence - with an uppercase R or a lowercase r.
Rose_db_object_test_seq
rose_db_object_test_seq
If I change all instances to use the lowercase r, then the tests pass.
db-object-auto.t
1..266
ok 1 - use Rose::DB::Object;
ok 2 - use Rose::DB::Object::Metadata::Auto::Generic;
ok 3 - perl_columns_definition eval - pg
ok 4 - perl_unique_keys_definition eval 1 - pg
ok 5 - perl_unique_keys_definition eval 2 - pg
ok 6 - perl_primary_key_columns_definition eval - pg
ok 7 - custom column class - mysql
ok 8 - metadata subclass - mysql
Name "MyMySQLMeta::auto_retrieve_primary_key_column_names" used only
once: possible typo at blib/lib/Rose/DB/Object/Metadata.pm line 3058.
Name "MyMySQLMeta::b" used only once: possible typo at
blib/lib/Rose/DB/Object/Metadata.pm line 3058.
Name "MyMySQLMeta::BEGIN" used only once: possible typo at
blib/lib/Rose/DB/Object/Metadata.pm line 3058.
Name "MyMySQLMeta::a" used only once: possible typo at
blib/lib/Rose/DB/Object/Metadata.pm line 3058.
Name "MyMySQLMeta::auto_generate_unique_keys" used only once: possible
typo at blib/lib/Rose/DB/Object/Metadata.pm line 3058.
Name "MyMySQLMeta::auto_generate_foreign_keys" used only once:
possible typo at blib/lib/Rose/DB/Object/Metadata.pm line 3058.
Name "MyMySQLMeta::import" used only once: possible typo at
blib/lib/Rose/DB/Object/Metadata.pm line 3058.
ok 9 - new() 1 - pg
DBD::Pg::st execute failed: ERROR: relation "Rose_db_object_test_seq"
does not exist
DBD::Pg::st execute failed: ERROR: null value in column "id" violates
not-null constraint
update() - DBD::Pg::st execute failed: ERROR: null value in column
"id" violates not-null constraint
at t/db-object-auto.t line 42
# Looks like you planned 266 tests but only ran 9.
# Looks like your test died just after 9.
Also, a number of the other tests are failing with some different
errors (I can give verbose output of those errors if it would be
helpful).
I haven't had a chance to analyse these issues yet, but thought I
would post them anyway. Here is a full run of the test suite with a
Pg database and a MySQL database configured (no Informix).
I am using PostgreSQL 7.4.7 (Debian 7.4.7-6sarge1)
perl 5.8.4 (Debian 5.8.4-8)
DBD::Pg 1.43
DBI 1.48
Rose::DB::Object 0.59
Rose::DB 0.56
t/00-warning.......................ok
t/column-triggers..................ok
44/259 skipped: informix tests
t/db-migration.....................NOK 24
# Failed test 'multi-pk check pk 4'
# in t/db-migration.t at line 155.
# got: '2'
# expected: '1'
No such Code where id1, id2, id3 = 1, 3, 2 at t/db-migration.t line 173
# Looks like you planned 33 tests but only ran 30.
# Looks like you failed 1 test of 30 run.
# Looks like your test died just after 30.
t/db-migration.....................dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 24, 31-33
Failed 4/33 tests, 87.88% okay
t/db-object-auto...................ok 3/266DBD::Pg::st execute failed:
ERROR: relation "Rose_db_object_test_seq" does not exist
DBD::Pg::st execute failed: ERROR: null value in column "id" violates
not-null constraint
update() - DBD::Pg::st execute failed: ERROR: null value in column
"id" violates not-null constraint
at t/db-object-auto.t line 42
# Looks like you planned 266 tests but only ran 9.
# Looks like your test died just after 9.
t/db-object-auto...................dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 10-266
Failed 257/266 tests, 3.38% okay
t/db-object-cached.................ok
84/407 skipped: various reasons
t/db-object-convention.............ok
19/159 skipped: missing Lingua::EN::Inflect 1.89
t/db-object-foreign-key-auto.......ok
72/257 skipped: various reasons
t/db-object-foreign-key............ok
56/187 skipped: various reasons
t/db-object-loader-2...............ok
17/86 skipped: informix tests
t/db-object-loader-3...............ok
12/61 skipped: informix tests
t/db-object-loader-4...............ok
17/86 skipped: informix tests
t/db-object-loader.................ok
21/79 skipped: various reasons
t/db-object-manager-bulk-ops.......ok
41/208 skipped: Informix tests
t/db-object-manager................ok
457/1939 skipped: Informix tests
t/db-object-mapper.................ok 42/315
# Failed test 'auto-generated primary key - pg_with_schema'
# in t/db-object-mapper.t at line 47.
# got: '2'
# expected: '1'
t/db-object-mapper.................NOK 80
# Failed test 'load() uk 2 - pg_with_schema'
# in t/db-object-mapper.t at line 69.
# got: '2'
# expected: '1'
t/db-object-mapper.................ok 290/315# Looks like you failed 2
tests of 315.
t/db-object-mapper.................dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 80, 87
Failed 2/315 tests, 99.37% okay (less 78 skipped tests: 235
okay, 74.60%)
t/db-object-metadata...............ok
t/db-object-relationship-auto-2....ok
18/92 skipped: informix tests
t/db-object-relationship-auto......ok
18/92 skipped: informix tests
t/db-object-relationship...........ok
363/1412 skipped: various reasons
t/db-object-std-cached.............ok
55/241 skipped: various reasons
t/db-object-std....................ok
42/185 skipped: various reasons
t/db-object........................ok 9/341
# Failed test 'pk sequence name - pg'
# in t/db-object.t at line 48.
# got: 'public.rose_db_object_test_id_seq'
# expected: 'rose_db_object_test_id_seq'
t/db-object........................ok 52/341
# Failed test 'pk sequence name - pg_with_schema'
# in t/db-object.t at line 48.
# got: 'public.rose_db_object_test_id_seq'
# expected: 'rose_db_object_test_id_seq'
# Failed test 'auto-generated primary key - pg_with_schema'
# in t/db-object.t at line 53.
# got: '2'
# expected: '1'
t/db-object........................NOK 91
# Failed test 'load() uk 2 - pg_with_schema'
# in t/db-object.t at line 75.
# got: '2'
# expected: '1'
t/db-object........................ok 310/341# Looks like you failed 4
tests of 341.
t/db-object........................dubious
Test returned status 4 (wstat 1024, 0x400)
DIED. FAILED tests 23, 89, 91, 98
Failed 4/341 tests, 98.83% okay (less 81 skipped tests: 256
okay, 75.07%)
t/lazy-columns.....................ok
15/80 skipped: informix tests
t/makemethods-db...................ok
12/51 skipped: Informix tests
t/makemethods......................ok
5/123 skipped: Not connected to Informix
t/multi-pk-sequences...............NOK 3
# Failed test 'pk sequence names 1 - pg'
# in t/multi-pk-sequences.t at line 57.
# Structures begin differing at:
# $got->[0] = 'public.rose_db_object_test_id1_seq'
# $expected->[0] = 'rose_db_object_test_id1_seq'
t/multi-pk-sequences...............NOK 9
# Failed test 'sequences 2 - pg'
# in t/multi-pk-sequences.t at line 88.
# got: 'public.rose_db_object_test_id1_seq'
# expected: 'rose_db_object_test_id1_seq'
t/multi-pk-sequences...............NOK 27
# Failed test 'pk sequence names 1 - pg_with_schema'
# in t/multi-pk-sequences.t at line 57.
# Structures begin differing at:
# $got->[1] = 'Rose_db_object_private.rdbo_seq2'
# $expected->[1] = 'rose_db_object_private.rdbo_seq2'
# Failed test 'sequences 3 - pg_with_schema'
# in t/multi-pk-sequences.t at line 90.
# got: 'Rose_db_object_private.rdbo_seq2'
# expected: 'rose_db_object_private.rdbo_seq2'
# Failed test 'pk sequence names 2 - pg_with_schema'
# in t/multi-pk-sequences.t at line 95.
# Structures begin differing at:
# $got->[1] = 'Rose_db_object_private.rdbo_seq2_2'
# $expected->[1] = 'rose_db_object_private.rdbo_seq2_2'
t/multi-pk-sequences...............NOK 35
# Failed test 'sequences 6 - pg_with_schema'
# in t/multi-pk-sequences.t at line 127.
# got: 'Rose_db_object_private.rdbo_seq2_2'
# expected: 'rose_db_object_private.rdbo_seq2_2'
t/multi-pk-sequences...............NOK 42# Looks like you failed 6 tests of 50.
t/multi-pk-sequences...............dubious
Test returned status 6 (wstat 1536, 0x600)
DIED. FAILED tests 3, 9, 27, 34-35, 42
Failed 6/50 tests, 88.00% okay
t/pod..............................ok
t/schema-override..................NOK 3
# Failed test 'flex schema 2'
# in t/schema-override.t at line 33.
# got: '2'
# expected: '1'
t/schema-override..................NOK 7
# Failed test 'single photos table 2'
# in t/schema-override.t at line 46.
# Structures begin differing at:
# $got->[0] = Does not exist
# $expected->[0] = '1.1'
# Looks like you failed 2 tests of 8.
t/schema-override..................dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 3, 7
Failed 2/8 tests, 75.00% okay
t/spot-check-01....................ok
16/82 skipped: informix tests
t/spot-check-02....................ok
6/32 skipped: informix tests
t/spot-check-03....................ok
t/spot-check-04....................ok
1/6 skipped: informix tests
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/db-migration.t 255 65280 33 7 21.21% 24 31-33
t/db-object-auto.t 255 65280 266 514 193.23% 10-266
t/db-object-mapper.t 2 512 315 2 0.63% 80 87
t/db-object.t 4 1024 341 4 1.17% 23 89 91 98
t/multi-pk-sequences.t 6 1536 50 6 12.00% 3 9 27 34-35 42
t/schema-override.t 2 512 8 2 25.00% 3 7
1550 subtests skipped.
Failed 6/32 test scripts, 81.25% okay. 275/7233 subtests failed, 96.20% okay.
make: *** [test_dynamic] Error 255
Cheers,
Cees
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_idv37&alloc_id865&op=click
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
