I have been trying to get the unit tests to run for all vendors in
order to update the "Tests" page on the wiki. I have a few questions
in connection with this.
- In the repository there are both an "examples" and a "tests" folder,
both containing sql scripts for creating a northwind database for each
database vendor. It seems that it is the scripts from the "examples"
folder which should be used for running the unit tests (contrary to
what I would expect from the naming and contrary to what the "Unit
Tests" page in this groups says), since e.g. for the scripts in the
"tests" folder:
- - the script for the Oracle vendor will create all uppercase table
names, which will make the tests fail, since the tests uses Pascal
case, also the username/password in the script doesn't match the
credentials used in the ConnectionStrings.xml.
- - the script for the Ingres vendor will create a database where
updates fails (perhaps because of data types that are unsupported by
the data provider).
- - the script for the MySql vendor fails since the data is inserted
in the wrong order (so foreign keys prevents the data for being
inserted), tables are being dropped in the wrong order, views aren't
being dropped, and dates are in the wrong format ('mm/dd/yyyy' instead
of 'yyyy-mm-dd' see
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-types.html).
So what is the scripts in the "tests" folder used for?
- I have created a small application "TestReport" (for lack of better
name) in the "Tools" folder, that replaces the DbLinq-NUnit-test-
results.xlsx spread sheet, such that the Office software is not
required and no copy/paste is required (it searches for placeholders
in the wiki-file instead). It also includes test for more vendors (all
except the Sqlite_test_mono_strict since it fails for almost all tests
on my setup) and for the non-vendor tests, and it suppresses tests
that succeeds for all vendors. Would it be alright for me to check-in
this change?
--
Anders
--
You received this message because you are subscribed to the Google Groups
"DbLinq" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/dblinq?hl=en.
