Hi,
I'm trying to resend this message that got lost.
Best
Physikerwelt
On Tue, Apr 15, 2014 at 1:13 PM, Moritz Schubotz <schubotz(a)tu-berlin.de> wrote:
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