Hi, I'm trying to resend this message that got lost.
Best Physikerwelt On Tue, Apr 15, 2014 at 1:13 PM, Moritz Schubotz <[email protected]> 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-sqlite). > > 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 _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
