jackalope/jackalope-doctrine-dbal — pull request #43 by cryptocompress (2012-06-28 14:31:42+00:00)
Title: adapt test infrastructure for Postgres (part 1 without tests)

- changed travis configs
- splitted PHPUnit configs
- bugfix

infrastructure is up-and-running BUT tests are not!
main reason for failing tests is the unspezified sort_order in database. i really don't know how to fix it yet.
example:

Configuration read from C:\Work\jackalope-doctrine-dbal\test7\jackalope-doctrine-dbal\tests\mysql.phpunit.xml

..w() at: C:\Work\jackalope-doctrine-dbal\test7\jackalope-doctrine-dbal\tests\Jackalope\Transport\DoctrineDBAL\ClientTest.php in l
ine: 116
0 -> array

Array
(
[0] => Array
(
[local_name] => page1
[sort_order] =>
)

[1] => Array
(
[local_name] => page2
[sort_order] =>
)

[2] => Array
(
[local_name] => page3
[sort_order] =>
)

[3] => Array
(
[local_name] => page4
[sort_order] =>
)

[4] => Array
(
[local_name] => page5
[sort_order] =>
)

)

John@20GHZ /c/Work/jackalope-doctrine-dbal/test7/jackalope-doctrine-dbal (master)
$ phpunit -c tests/pgsql.phpunit.xml tests/Jackalope/Transport/DoctrineDBAL/ClientTest.php
Updating schema...done.
PHPUnit 3.6.11 by Sebastian Bergmann.

Configuration read from C:\Work\jackalope-doctrine-dbal\test7\jackalope-doctrine-dbal\tests\pgsql.phpunit.xml

..w() at: C:\Work\jackalope-doctrine-dbal\test7\jackalope-doctrine-dbal\tests\Jackalope\Transport\DoctrineDBAL\ClientTest.php in l
ine: 116
0 -> array

Array
(
[0] => Array
(
[local_name] => page5
[sort_order] =>
)

[1] => Array
(
[local_name] => page4
[sort_order] =>
)

[2] => Array
(
[local_name] => page3
[sort_order] =>
)

[3] => Array
(
[local_name] => page2
[sort_order] =>
)

[4] => Array
(
[local_name] => page1
[sort_order] =>
)

)

so field "sort_order" is never set in this case but tests rely on the sort order. postgres revert rows from database as they are sorted ASC by NULL?
nodes do not have sort order per se as i can see. they only can be reordered. don't know how to solve this for now.