Java Doc for TestMySQL.java in  » Database-ORM » Torque » com » workingdogs » village » Java Source Code / Java DocumentationJava Source Code and Java Documentation

In order to do the testing, you will need to be able to connect via JDBC to your database. Since I use MySQL, this testing suite is best for that database. I also use the mm MySQL drivers mm MySQL drivers because it is the best driver that I have found for MySQL.

Note that Village should work with any JDBC compliant driver.

Here is the schema that this test expects (you should be able to copy and paste it into your MySQL database that you want to use):

 CREATE TABLE test
 (
 a TINYINT null,
 b SMALLINT null,
 c MEDIUMINT null,
 d INT null,
 e INTEGER null,
 f BIGINT null,
 g REAL null,
 h DOUBLE null,
 i FLOAT null,
 j DECIMAL(8,1) null,
 k NUMERIC(8,1) null,
 l CHAR(255) null,
 m VARCHAR(255) null,
 n DATE null,
 o TIME null,
 p TIMESTAMP null,
 q DATETIME null,
 r TINYBLOB null,
 s BLOB null,
 t MEDIUMBLOB null,
 u LONGBLOB null,
 v TINYTEXT null,
 w TEXT null,
 x MEDIUMTEXT null
 );
 

Note that presently this class is hardcoded to use a MySQL database named "village" with a username of "village" and a password of "village". It is a modified version of Jon's original Unit test that apparently pre-dated JUnit!