[QGIS-Developer] Oracle tests in CI

[Julien Cabieces]

Hi,

> On Tue, 22 Oct 2019 at 19:24, Julien Cabieces
> <julien.cabieces at oslandia.com> wrote:
>>
>>
>> Hi all,
>>
>> I propose a PR [0] to fix Oracle provider and its tests, and I would
>> like to enable running these tests in travis CI like it's done for
>> PostGis.
>>
>> I succeed to build a Oracle 18c Express edition Docker image using Oracle
>> specific instructions [1]. I would like to push this image in a Docker
>> Hub (QGIS one?, an another one?) so it could be use from CI.
>>
>> According to this license agreement [2], it looks like this is legally OK:
>> "We grant you a nonexclusive, nontransferable limited license to use the
>> programs for: (a) purposes of developing, prototyping and running your
>> applications for your own internal data processing operations;"
>>
>> Do I have a good understanding of the license agreement? Do you see any
>> reason to not enable Oracle tests in our CI?
>
> Just a warning - you'll also need to look into the license for the OCI
> client and whether there's any issues in enabling this on Travis.

I'm not a lawyer but I don't see anything in instant client license
agreement
(https://www.oracle.com/downloads/licenses/instant-client-lic.html)
about limitations on using OCI on server.

They just protect themselves from GPL contamination. Anyway, we already
deliver the oracle provider in OSGeo4W installer, so I would say we are
fine.

>
> Nyall
>
>
>>
>> To be complete, it would be probably necessary to copy QGIS Oracle
>> database files somewhere (like it's done for ccache) to be used at run
>> time in order to skip Oracle database initialisation. It's quite long (around 5
>> minutes) and would slow down the CI.
>>
>> [0] https://github.com/qgis/QGIS/pull/32337
>> [1] https://github.com/oracle/docker-images/tree/master/OracleDatabase/SingleInstance/dockerfiles/18.4.0
>> [2] https://www.oracle.com/downloads/licenses/db18c-express-license.html
>>
>> Regards,
>> Julien
>>
>>
>> _______________________________________________
>> QGIS-Developer mailing list
>> QGIS-Developer at lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer