Re: Running database tests with jenkins

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Re: Running database tests with jenkins

Moritz Schubotz-2
Hi,

I'm trying to resend this message that got lost.

Best
Physikerwelt

On Tue, Apr 15, 2014 at 1:13 PM, Moritz Schubotz <[hidden email]> 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
[hidden email]
https://lists.wikimedia.org/mailman/listinfo/wikitech-l