Re: [Wikitech-l] Running database tests with jenkins

Dear all, I had some trouble to run the database tests that worked well locally on jenkins. In the onLoadExtensionSchemaUpdates hook I check for mysql/sqllite via $type = $updater->getDB()->getType(); if ( $type == 'sqlite' ) { $type = 'mysql'; // The commands used from the updater are the same } if ( $type == 'mysql' ) { jenkins, that uses sqllite modifies -- Timestamp of the last update math_timestamp timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, to math_timestamp TEXT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, which does not look like sqllite (http://stackoverflow.com/questions/6578439/on-update-current-timestamp-with…). I think the assumption that mysql and sqllite is wrong and also not a good style. Is there an example of an extension that runs database tests with jenkins? Is there any usage statistics on how frequent the database types are. Does it make sense to mainatain 1) mysql 2) sqllite 3) mssql 4) oracle 5) pg or are some of those databases seldomly used like db2 that was removed a while ago? Best Physikerwelt