[QGIS-Developer] oracle provider (testing)

2020-11-02 Thread Richard Duivenvoorde
Hi Devs,

Is anybody feeling self responsible (more or less) for the Oracle driver?

Myself I apparently introduce an issue in it: 
https://github.com/qgis/QGIS/issues/39759 which seems easy to fix, but my 
problem is I do not have Oracle running

Are there any Oracle provider tests? And if so: which instance against are 
these tested against?

Idea: use a QGIS server to install Oracle XE (dev/free edition isn't it?) and 
provide ssh access to the machine. Then users with a ssh key (Travis?) can 
create a ssh tunnel to the machine and connect to that (test) db?
Thought to propose issues.qgis.org for that, as that is a beefy machine doing 
nothing (except keeping old issues/Redmine afloat). But.. that is a Debian 
8.10, not sure if recent Oracle's can still run on it...

Input?

Regards,

Richard Duivenvoorde

___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] How to call a custom algorithm provider in stand alone application with pyqgis

2020-11-02 Thread nagyrobi_r
 Did you set up the environmental variables to run it as a standalone script in 
python?
Like in section 1.4.3?
https://docs.qgis.org/testing/en/docs/pyqgis_developer_cookbook/intro.html#using-pyqgis-in-standalone-scripts
 On Monday, November 2, 2020, 06:02:11 PM GMT+1, Etienne Trimaille 
 wrote:  
 
 As you are using QGIS 3.14, I would suggest you to use qgis_process if you 
can.Do you really want to use PyQGIS?

But if you really need PyQGIS, maybe the path where your script is located is 
not known to your standalone script ?

Le lun. 2 nov. 2020 à 17:33, PALMIER Patrick (Responsable de groupe) - 
CEREMA/DTerNP/DATHa/MT  a écrit :

  Hello,
 
 I work with Qgis 3.14 in Windows 10
 
 I try to call a processing algorithm from a python stand alone app, 
 I want to run the following script from the custom Networks algorithm provider 
but I have the message that the algorithm is not known
 
 How to register the provider in the processing registry to be able to call it?
 
 
     QgsApplication.setPrefixPath("C:/Program Files/QGIS 3.14/apps/qgis", True)
     qgs = QgsApplication([], False)
 
     qgs.initQgis()
     import processing
     from processing.core.Processing import Processing
     Processing.initialize()
 
 
 
     processing.run("Networks:musliw_simple_matrix", 
{'NODES':'G:/BD_DREAL/2020/script_modele_resmultimodal_light   
/noeuds_light_hdf_be.gpkg','NUM':'num','START_POINT':'708675.425564,7063676.157556
 
[EPSG:2154]','END_POINT':'708675.425564,7063676.157556[EPSG:2154]','DEMAND':1,'DAY':1,'TIME':'09:00:00','DEPARTURE':1,'OUTPUT':'G:/BD_DREAL/2020/script_modele_resmultimodal_light/matrice.txt','WRITE_MODE':0})
 
 Thanks
 
 Best regards
 
 
 -- 
 
 
|  
  Patrick Palmier 
  Responsable du groupe Mobilités et Territoires 
 DATHa / MT 
  Tél.: +33(0)3 20 49 60 70- Port : +33(0)7 77 34 25 07   
  |
|   
  Cerema Nord-Picardie / 44 ter rue Jean-Bart - CS20275 - 59019 LILLE cedex 
  
   |

  ___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer  ___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] How to call a custom algorithm provider in stand alone application with pyqgis

2020-11-02 Thread Etienne Trimaille
As you are using QGIS 3.14, I would suggest you to use qgis_process if you
can.
Do you really want to use PyQGIS?

But if you really need PyQGIS, maybe the path where your script is located
is not known to your standalone script ?

Le lun. 2 nov. 2020 à 17:33, PALMIER Patrick (Responsable de groupe) -
CEREMA/DTerNP/DATHa/MT  a écrit :

> Hello,
>
> I work with Qgis 3.14 in Windows 10
>
> I try to call a processing algorithm from a python stand alone app,
> I want to run the following script from the custom Networks algorithm
> provider but I have the message that the algorithm is not known
>
> How to register the provider in the processing registry to be able to call
> it?
>
>
> QgsApplication.setPrefixPath("C:/Program Files/QGIS 3.14/apps/qgis",
> True)
> qgs = QgsApplication([], False)
>
> qgs.initQgis()
> import processing
> from processing.core.Processing import Processing
> Processing.initialize()
>
>
>
> processing.run("Networks:musliw_simple_matrix",
> {'NODES':'G:/BD_DREAL/2020/script_modele_resmultimodal_light
> /noeuds_light_hdf_be.gpkg','NUM':'num','START_POINT':'708675.425564,7063676.157556
> [EPSG:2154]','END_POINT':'708675.425564,7063676.157556
> [EPSG:2154]','DEMAND':1,'DAY':1,'TIME':'09:00:00','DEPARTURE':1,'OUTPUT':'G:/BD_DREAL/2020/script_modele_resmultimodal_light/matrice.txt','WRITE_MODE':0})
>
> Thanks
>
> Best regards
>
>
> --
>
> * Patrick Palmier *
>
> * Responsable du groupe Mobilités et Territoires DATHa / MT *
> * Tél.: +33(0)3 20 49 60 70- Port : +33(0)7 77 34 25 07 *
>
> Cerema Nord-Picardie / 44 ter rue Jean-Bart - CS20275 - 59019 LILLE cedex
>
> ___
> QGIS-Developer mailing list
> QGIS-Developer@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

[QGIS-Developer] How to call a custom algorithm provider in stand alone application with pyqgis

2020-11-02 Thread Responsable de groupe

Hello,

I work with Qgis 3.14 in Windows 10

I try to call a processing algorithm from a python stand alone app,
I want to run the following script from the custom Networks algorithm 
provider but I have the message that the algorithm is not known


How to register the provider in the processing registry to be able to 
call it?



QgsApplication.setPrefixPath("C:/Program Files/QGIS 
3.14/apps/qgis", True)

qgs = QgsApplication([], False)

qgs.initQgis()
import processing
from processing.core.Processing import Processing
Processing.initialize()



processing.run("Networks:musliw_simple_matrix", 
{'NODES':'G:/BD_DREAL/2020/script_modele_resmultimodal_light 
/noeuds_light_hdf_be.gpkg','NUM':'num','START_POINT':'708675.425564,7063676.157556 
[EPSG:2154]','END_POINT':'708675.425564,7063676.157556 
[EPSG:2154]','DEMAND':1,'DAY':1,'TIME':'09:00:00','DEPARTURE':1,'OUTPUT':'G:/BD_DREAL/2020/script_modele_resmultimodal_light/matrice.txt','WRITE_MODE':0})


Thanks

Best regards


--

*Patrick Palmier *
*Responsable du groupe Mobilités et Territoires
DATHa / MT *
*Tél.: +33(0)3 20 49 60 70- Port : +33(0)7 77 34 25 07 *


Cerema Nord-Picardie / 44 ter rue Jean-Bart - CS20275 - 59019 LILLE cedex

___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] [Qgis-user] Refresh layer at interval

2020-11-02 Thread nagyrob...@yahoo.com
Thank you a lot! 

Sent from Yahoo Mail on Android 
 
  On Mon, Nov 2, 2020 at 12:25 PM, Richard Duivenvoorde 
wrote:   
Ah, and to reproduce, I created a temporary(!) service:

https://duif.net/geotest/points.geojson

which gives you one random point on the world every time you refresh

Regards,

Richard


On 11/2/20 12:23 PM, Richard Duivenvoorde wrote:
> I think you hit an old issue:
> 
> https://github.com/qgis/QGIS/issues/28282
> and
> https://github.com/qgis/QGIS/issues/28744
> 
> Not sure if I can tackle it, but I can give it a try.
> If a core-dev has a clue, please let me know...
> 
> I think this should work, as this makes it supereasy to have a 'moving map'..
> 
> Regards,
> 
> Richard Duivenvoorde
> 
> 
> On 11/1/20 9:24 PM, nagyrob...@yahoo.com wrote:
>>
>>    Hi All!
>>
>>    I am trying to understand the behavior of Layer->Render-> Refresh layer 
>>at interval in QGIS
>>
>>      1. I sat up a flask rest api which serves a geojson.
>>      2. I added the geojson to QGIS via Add Layer-> 
>>          1. a. Protocol HTTP/cloud/etc 
>>          2. b. Type: HTTP 
>>          3. c.URI: localhost/points.geojson The points are represented on 
>>the map correctly
>>      3. I changed the layer->Properties->Rendering-> Refresh layer at 
>>interval (5 sec)
>>
>>    I would have expected that there would be a call every 5 seconds towards 
>>the server and the map data would be updated accordingly. But the layer does 
>>not get refreshed. I don't see any changes neither when I remove a point from 
>>the json file on my local drive, nor if I change an attribute. If I press F5 
>>then the canvas refreshes and it automatically loads the new data and I can 
>>see the changes. Is this the behavior that is wanted or am I misunderstanding 
>>the function of this tool? It seems like the data is cached somewhere?
>>
>>    |from flask import Flask from flask_restful import Api, Resource import 
>>json app = Flask(__name__) api = Api(app) class point(Resource): def 
>>get(self): with open('C:/points/venv/src/points.geojson') as json_file: data 
>>= json.load(json_file) return data api.add_resource(point,"/points.geojson") 
>>if __name__=="__main__": app.run(debug=True)|
>>
>>    |Robert Nagy|
>>
>>
>> ___
>> Qgis-user mailing list
>> qgis-u...@lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>
> 
> ___
> QGIS-Developer mailing list
> QGIS-Developer@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> 

  
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] Changes in Travis-CI billing

2020-11-02 Thread Even Rouault
> QGIS might not be affected by this since we don't have more than 5
> concurrent builds.

That's not my understanding. The 1, 2 or 5 concurrent builds plans are paying 
plans if you look at https://travis-ci.com/organizations/qgis/plan .
The free plan of QGIS is subject to the 10,000 credits system.

For reference, OSGeo has a premium plan for 10 concurrent builds that costs 
5379 USD/year, and we have a 30% discount on it due to OSGeo being a non-
profit, bringing it to 3765 USD. (I've just written to Travis support to 
confirm that the OSGeo plan isn't affected by the changes)

> Anyway, I guess we could slowly move everything to Github workflows as we
> have had much better experience lately than on Travis.

That's going to be a urgent topic if my understanding is correct. Probably 
asking Travis support for one month worth of credits could be done for the 
time to transition, but not sure they'll be enthusiastic to do so if it isn't 
to switch to a paying plan.

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] Changes in Travis-CI billing

2020-11-02 Thread Matthias Kuhn
Hi Even, Denis,

I guess with the upcoming dependency bump we need to touch this anyway.
There is already a full qgis build against Qt 5.14, enabling tests there is
a few lines of code (and then dealing with the fallouts of tests that have
different results because of library changes which is what I'm most afraid
of. But that will happen regardless of the underlying CI engine).

Matthias

On Mon, Nov 2, 2020 at 3:20 PM Denis Rouzaud 
wrote:

> Hi Even,
>
> Thanks a lot for the pointer.
>
> QGIS might not be affected by this since we don't have more than 5
> concurrent builds.
> Or am I wrongly understanding the document?
>
> Anyway, I guess we could slowly move everything to Github workflows as we
> have had much better experience lately than on Travis.
>
> Cheers,
> Denis
>
>
> Le lun. 2 nov. 2020 à 15:06, Even Rouault  a
> écrit :
>
>> Hi,
>>
>> I was pointed to
>> https://blog.travis-ci.com/2020-11-02-travis-ci-new-billing
>>
>> If my understanding is correct (which I'm not completely sure given all
>> the
>> subtelties), QGIS builds will now have a initial credit of 1000 minutes
>> of
>> build time (so only 17 hours), and then we'd have to beg for more, but I
>> can't
>> imagine we can ask every day a renewal of this credit...
>>
>> Looks like Travis-CI won't be a realistic option any more unless paying.
>>
>> Even
>>
>> --
>> Spatialys - Geospatial professional services
>> http://www.spatialys.com
>> ___
>> QGIS-Developer mailing list
>> QGIS-Developer@lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>
> ___
> QGIS-Developer mailing list
> QGIS-Developer@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] Unable to build QGIS master due to multiple definitions of sipQgs3DAlgorithms

2020-11-02 Thread DelazJ
Hi Saber,

Thanks. I'll give it a try this evening and let you know.

Greetings,
Harrissou

Le dim. 1 nov. 2020 à 08:34, Saber Razmjooei <
saber.razmjo...@lutraconsulting.co.uk> a écrit :

> Hi Harrissou,
>
> Here is my working one on Ubuntu 20.04:
> -DCMAKE_PREFIX_PATH=~/src/QGIS_master/external/qt3dextra-headers/cmake/Qt53DExtras
> -DQT5_3DEXTRA_INCLUDE_DIR=~/src/QGIS_master/external/qt3dextra-headers -D
> QT5_3DEXTRA_LIBRARY=/usr/lib/x86_64-linux-gnu/libQt53DExtras.so
> -DWITH_3D=True
> -DQt53DExtras_DIR=~/src/QGIS_master/external/qt3dextra-headers/cmake/Qt53DExtras
>
> I hope that works for you!
>
> Kind regards
> Saber
>
>
> On Sat, 31 Oct 2020 at 08:34, DelazJ  wrote:
>
>> Hi all,
>> Thanks Peter. I got some time to give it another try. So I trashed my
>> build dir and restarted.
>> Now I'm stuck at
>>
>> *In file included from ../src/3d/qgsskyboxsettings.h:*
>> *23, from ../src/3d/qgs3dmapsettings.h:*
>> *33, from src/3d/qgis_3d_autogen/**EWIEGA46WW/moc_*
>> *qgs3dmapsettings.cpp:9, from
>> src/3d/qgis_3d_autogen/mocs_*
>> *compilation.cpp:9:../src/3d/qgsskyboxentity.h:*
>>
>>
>>
>> *22:10: fatal error: Qt3DExtras/QCuboidMesh: Aucun fichier ou dossier de
>> ce type   22 | #include |
>> ^~~~compilation terminated.[52/2925] Building CXX
>> object src/3d/CMakeFiles/qgis_3d.dir/**qgsabstractvectorlayer3drender*
>> *er.cpp.oninja: build stopped: subcommand failed.*
>>
>> I don't know if it has anything to do but I had to fight against the "
>> Qt53DExtras" error to enable 3D
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> * CMake Error at /usr/lib/x86_64-linux-gnu/cmake/Qt5/Qt5Config.cmake:28
>> (find_package):   Could not find a package configuration file provided by
>> "Qt53DExtras" with   any of the following names:
>>  Qt53DExtrasConfig.cmake qt53dextras-config.cmake   Add the
>> installation prefix of "Qt53DExtras" to CMAKE_PREFIX_PATH or set
>>  "Qt53DExtras_DIR" to a directory containing one of the above files.  If
>>  "Qt53DExtras" provides a separate development package or SDK, be sure it
>>  has been installed. Call Stack (most recent call first):
>>  CMakeLists.txt:404 (FIND_PACKAGE)*
>>
>> Recipes I found in the list and the install file didn't seem to fix the
>> cmake so I set  set the QT53DExtras_DIR to
>> /pathtoQGISrepo/external/qt3dextra-headers/cmake*/Qt53DExtras* (in which
>> I found the missing file)
>>
>> Thanks for any suggestion.
>>
>> Harrissou
>>
>> Le jeu. 29 oct. 2020 à 14:01, Peter Petrik <
>> peter.pet...@lutraconsulting.co.uk> a écrit :
>>
>>> Hi,
>>>
>>> can you please remove completely the build folder and start again?
>>>
>>> Thanks.
>>> P/
>>>
>>> On Thu, Oct 29, 2020 at 1:57 PM DelazJ  wrote:
>>>
 Hi devs,

 Since yesterday, I'm unable to build QGIS on Ubuntu 20.04 using ninja.
 It used to work a couple of days ago.
 I'm getting a bunch of errors of the type:

 /usr/bin/ld :
 python/CMakeFiles/python_module_qgis__3d.dir/3d/sip_3dpart10.cpp.o : dans
 la fonction « sipQgs3DAlgorithms::sipProtect_isSignalConnected(QMetaMethod
 const&) const » :
 /media/delazj/dev/github/QGIS/build_ninja/python/3d/sip_3dpart10.cpp:4735 :
 définitions multiples de
 « sipQgs3DAlgorithms::sipProtect_isSignalConnected(QMetaMethod const&)
 const »;
 python/CMakeFiles/python_module_qgis__3d.dir/3d/sip_3dpart8.cpp.o:/media/delazj/dev/github/QGIS/build_ninja/python/3d/sip_3dpart8.cpp:892
  :
 défini pour la première fois ici
 /usr/bin/ld :
 python/CMakeFiles/python_module_qgis__3d.dir/3d/sip_3dpart10.cpp.o : dans
 la fonction
 « sipQgs3DAlgorithms::sipProtect_addAlgorithm(QgsProcessingAlgorithm*) » :
 /media/delazj/dev/github/QGIS/build_ninja/python/3d/sip_3dpart10.cpp:4740 :
 définitions multiples de
 « sipQgs3DAlgorithms::sipProtect_addAlgorithm(QgsProcessingAlgorithm*) »;
 python/CMakeFiles/python_module_qgis__3d.dir/3d/sip_3dpart8.cpp.o:/media/delazj/dev/github/QGIS/build_ninja/python/3d/sip_3dpart8.cpp:897
  :
 défini pour la première fois ici
 /usr/bin/ld :
 python/CMakeFiles/python_module_qgis__3d.dir/3d/sip_3dpart10.cpp.o : dans
 la fonction « sipQgs3DAlgorithms::sipProtectVirt_loadAlgorithms(bool) » :
 /media/delazj/dev/github/QGIS/build_ninja/python/3d/sip_3dpart10.cpp:4745 :
 définitions multiples de
 « sipQgs3DAlgorithms::sipProtectVirt_loadAlgorithms(bool) »;
 python/CMakeFiles/python_module_qgis__3d.dir/3d/sip_3dpart8.cpp.o:/media/delazj/dev/github/QGIS/build_ninja/python/3d/sip_3dpart8.cpp:902
  :
 défini pour la première fois ici
 /usr/bin/ld :
 python/CMakeFiles/python_module_qgis__3d.dir/3d/sip_3dpart10.cpp.o:(.data.rel.local+0x2c0)
  :
 définitions multiples de « sipTypeDef__3d_Qgs3DAlgorithms »;
 python/CMakeFiles/python_module_qgis__3d.dir/3d/sip_3dpart8.cpp.o:(.data.rel.local+0x160)
  :
 défini pour la première fois ici
 collect2: 

Re: [QGIS-Developer] Changes in Travis-CI billing

2020-11-02 Thread Denis Rouzaud
Hi Even,

Thanks a lot for the pointer.

QGIS might not be affected by this since we don't have more than 5
concurrent builds.
Or am I wrongly understanding the document?

Anyway, I guess we could slowly move everything to Github workflows as we
have had much better experience lately than on Travis.

Cheers,
Denis


Le lun. 2 nov. 2020 à 15:06, Even Rouault  a
écrit :

> Hi,
>
> I was pointed to
> https://blog.travis-ci.com/2020-11-02-travis-ci-new-billing
>
> If my understanding is correct (which I'm not completely sure given all
> the
> subtelties), QGIS builds will now have a initial credit of 1000 minutes of
> build time (so only 17 hours), and then we'd have to beg for more, but I
> can't
> imagine we can ask every day a renewal of this credit...
>
> Looks like Travis-CI won't be a realistic option any more unless paying.
>
> Even
>
> --
> Spatialys - Geospatial professional services
> http://www.spatialys.com
> ___
> QGIS-Developer mailing list
> QGIS-Developer@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

[QGIS-Developer] Changes in Travis-CI billing

2020-11-02 Thread Even Rouault
Hi,

I was pointed to
https://blog.travis-ci.com/2020-11-02-travis-ci-new-billing

If my understanding is correct (which I'm not completely sure given all the 
subtelties), QGIS builds will now have a initial credit of 1000 minutes of 
build time (so only 17 hours), and then we'd have to beg for more, but I can't 
imagine we can ask every day a renewal of this credit...

Looks like Travis-CI won't be a realistic option any more unless paying.

Even

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] [Qgis-user] Refresh layer at interval

2020-11-02 Thread Richard Duivenvoorde
This is getting worse...

https://github.com/qgis/QGIS/issues/28282#issuecomment-720484251

Something smelling there :-(

Regards,

Richard Duivenvoorde


On 11/2/20 12:27 PM, nagyrob...@yahoo.com wrote:
> Thank you a lot! 
> 
> Sent from Yahoo Mail on Android 
> 
> 
> On Mon, Nov 2, 2020 at 12:25 PM, Richard Duivenvoorde
>  wrote:
> 
> Ah, and to reproduce, I created a temporary(!) service:
> 
> https://duif.net/geotest/points.geojson
> 
> which gives you one random point on the world every time you refresh
> 
> Regards,
> 
> Richard
> 
> 
> On 11/2/20 12:23 PM, Richard Duivenvoorde wrote:
> > I think you hit an old issue:
> >
> > https://github.com/qgis/QGIS/issues/28282
> > and
> > https://github.com/qgis/QGIS/issues/28744
> >
> > Not sure if I can tackle it, but I can give it a try.
> > If a core-dev has a clue, please let me know...
> >
> > I think this should work, as this makes it supereasy to have a 'moving 
> map'..
> >
> > Regards,
> >
> > Richard Duivenvoorde
> >
> >
> > On 11/1/20 9:24 PM, nagyrob...@yahoo.com  
> wrote:
> >>
> >>    Hi All!
> >>
> >>    I am trying to understand the behavior of Layer->Render-> Refresh 
> layer at interval in QGIS
> >>
> >>      1. I sat up a flask rest api which serves a geojson.
> >>      2. I added the geojson to QGIS via Add Layer-> 
> >>          1. a. Protocol HTTP/cloud/etc 
> >>          2. b. Type: HTTP 
> >>          3. c.URI: localhost/points.geojson The points are represented 
> on the map correctly
> >>      3. I changed the layer->Properties->Rendering-> Refresh layer at 
> interval (5 sec)
> >>
> >>    I would have expected that there would be a call every 5 seconds 
> towards the server and the map data would be updated accordingly. But the 
> layer does not get refreshed. I don't see any changes neither when I remove a 
> point from the json file on my local drive, nor if I change an attribute. If 
> I press F5 then the canvas refreshes and it automatically loads the new data 
> and I can see the changes. Is this the behavior that is wanted or am I 
> misunderstanding the function of this tool? It seems like the data is cached 
> somewhere?
> >>
> >>    |from flask import Flask from flask_restful import Api, Resource 
> import json app = Flask(__name__) api = Api(app) class point(Resource): def 
> get(self): with open('C:/points/venv/src/points.geojson') as json_file: data 
> = json.load(json_file) return data api.add_resource(point,"/points.geojson") 
> if __name__=="__main__": app.run(debug=True)|
> >>
> >>    |Robert Nagy|
> >>
> >>
> >> ___
> >> Qgis-user mailing list
> >> qgis-u...@lists.osgeo.org 
> >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >>
> >
> > ___
> > QGIS-Developer mailing list
> > QGIS-Developer@lists.osgeo.org 
> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> 
> > Unsubscribe:
> https://lists.osgeo.org/mailman/listinfo/qgis-developer
> 
> >
> 

___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] [Qgis-user] Refresh layer at interval

2020-11-02 Thread Richard Duivenvoorde

Ah, and to reproduce, I created a temporary(!) service:

https://duif.net/geotest/points.geojson

which gives you one random point on the world every time you refresh

Regards,

Richard


On 11/2/20 12:23 PM, Richard Duivenvoorde wrote:
> I think you hit an old issue:
> 
> https://github.com/qgis/QGIS/issues/28282
> and
> https://github.com/qgis/QGIS/issues/28744
> 
> Not sure if I can tackle it, but I can give it a try.
> If a core-dev has a clue, please let me know...
> 
> I think this should work, as this makes it supereasy to have a 'moving map'..
> 
> Regards,
> 
> Richard Duivenvoorde
> 
> 
> On 11/1/20 9:24 PM, nagyrob...@yahoo.com wrote:
>>
>> Hi All!
>>
>> I am trying to understand the behavior of Layer->Render-> Refresh layer 
>> at interval in QGIS
>>
>>  1. I sat up a flask rest api which serves a geojson.
>>  2. I added the geojson to QGIS via Add Layer-> 
>>  1. a. Protocol HTTP/cloud/etc 
>>  2. b. Type: HTTP 
>>  3. c.URI: localhost/points.geojson The points are represented on 
>> the map correctly
>>  3. I changed the layer->Properties->Rendering-> Refresh layer at 
>> interval (5 sec)
>>
>> I would have expected that there would be a call every 5 seconds towards 
>> the server and the map data would be updated accordingly. But the layer does 
>> not get refreshed. I don't see any changes neither when I remove a point 
>> from the json file on my local drive, nor if I change an attribute. If I 
>> press F5 then the canvas refreshes and it automatically loads the new data 
>> and I can see the changes. Is this the behavior that is wanted or am I 
>> misunderstanding the function of this tool? It seems like the data is cached 
>> somewhere?
>>
>> |from flask import Flask from flask_restful import Api, Resource import 
>> json app = Flask(__name__) api = Api(app) class point(Resource): def 
>> get(self): with open('C:/points/venv/src/points.geojson') as json_file: data 
>> = json.load(json_file) return data api.add_resource(point,"/points.geojson") 
>> if __name__=="__main__": app.run(debug=True)|
>>
>> |Robert Nagy|
>>
>>
>> ___
>> Qgis-user mailing list
>> qgis-u...@lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>
> 
> ___
> QGIS-Developer mailing list
> QGIS-Developer@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> 

___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] [Qgis-user] Refresh layer at interval

2020-11-02 Thread Richard Duivenvoorde
I think you hit an old issue:

https://github.com/qgis/QGIS/issues/28282
and
https://github.com/qgis/QGIS/issues/28744

Not sure if I can tackle it, but I can give it a try.
If a core-dev has a clue, please let me know...

I think this should work, as this makes it supereasy to have a 'moving map'..

Regards,

Richard Duivenvoorde


On 11/1/20 9:24 PM, nagyrob...@yahoo.com wrote:
> 
> Hi All!
> 
> I am trying to understand the behavior of Layer->Render-> Refresh layer 
> at interval in QGIS
> 
>  1. I sat up a flask rest api which serves a geojson.
>  2. I added the geojson to QGIS via Add Layer-> 
>  1. a. Protocol HTTP/cloud/etc 
>  2. b. Type: HTTP 
>  3. c.URI: localhost/points.geojson The points are represented on the 
> map correctly
>  3. I changed the layer->Properties->Rendering-> Refresh layer at 
> interval (5 sec)
> 
> I would have expected that there would be a call every 5 seconds towards 
> the server and the map data would be updated accordingly. But the layer does 
> not get refreshed. I don't see any changes neither when I remove a point from 
> the json file on my local drive, nor if I change an attribute. If I press F5 
> then the canvas refreshes and it automatically loads the new data and I can 
> see the changes. Is this the behavior that is wanted or am I misunderstanding 
> the function of this tool? It seems like the data is cached somewhere?
> 
> |from flask import Flask from flask_restful import Api, Resource import 
> json app = Flask(__name__) api = Api(app) class point(Resource): def 
> get(self): with open('C:/points/venv/src/points.geojson') as json_file: data 
> = json.load(json_file) return data api.add_resource(point,"/points.geojson") 
> if __name__=="__main__": app.run(debug=True)|
> 
> |Robert Nagy|
> 
> 
> ___
> Qgis-user mailing list
> qgis-u...@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> 

___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] [Qgis-user] Refresh layer at interval

2020-11-02 Thread Aron Gergely

Hi Robert,

I do not know the answer to your question, but I think you are asking in 
the wrong list.
You may have better success on `qgis-developer` (I added it in, so this 
is getting cross-posted)


On 01/11/2020 21:24, nagyrob...@yahoo.com wrote:


Hi All!

I am trying to understand the behavior of Layer->Render-> Refresh
layer at interval in QGIS

 1. I sat up a flask rest api which serves a geojson.
 2. I added the geojson to QGIS via Add Layer->
 1. a. Protocol HTTP/cloud/etc
 2. b. Type: HTTP
 3. c.URI: localhost/points.geojson The points are represented
on the map correctly
 3. I changed the layer->Properties->Rendering-> Refresh layer at
interval (5 sec)

I would have expected that there would be a call every 5 seconds
towards the server and the map data would be updated accordingly.
But the layer does not get refreshed. I don't see any changes
neither when I remove a point from the json file on my local
drive, nor if I change an attribute. If I press F5 then the canvas
refreshes and it automatically loads the new data and I can see
the changes. Is this the behavior that is wanted or am I
misunderstanding the function of this tool? It seems like the data
is cached somewhere?

|from flask import Flask from flask_restful import Api, Resource
import json app = Flask(__name__) api = Api(app) class
point(Resource): def get(self): with
open('C:/points/venv/src/points.geojson') as json_file: data =
json.load(json_file) return data
api.add_resource(point,"/points.geojson") if __name__=="__main__":
app.run(debug=True)|

|Robert Nagy|


___
Qgis-user mailing list
qgis-u...@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user


--
Email Signature Kind Regards,

Aron Gergely
+31 (0) 6 38 70 97 66

*Rasterra* | www.rasterra.nl 
<>___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] WFS-T, postgis and triggers

2020-11-02 Thread Régis Haubourg
Hi,
Le lun. 2 nov. 2020 à 07:29, Denis Rouzaud  a
écrit :

> But couldn't we just add an option to the layer to re-fetch the data once
> inserted?
>
> I think the layer dependencies options could be adapted to refetch the wfs
data when activated. They are made to refecth the data and refresh the
snapping cache for layer potentially modified on the data provider side.
That would avoir adding yet another option.
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] WFS-T, postgis and triggers

2020-11-02 Thread Bo Victor Thomsen

Good idea -

But make it an option for the specific layers, so it's possible to turn 
it "off" or "on" depending of the situation. And "off" should be the 
default.


--
Med venlig hilsen / Kind regards

Bo Victor Thomsen

Den 02-11-2020 kl. 07:29 skrev Denis Rouzaud:
But couldn't we just add an option to the layer to re-fetch the data 
once inserted?


Le dim. 1 nov. 2020 à 10:39, Carlo A. Bertelli (Charta s.r.l.) 
mailto:carlo.berte...@gmail.com>> a écrit :


I suppose we could benefit from the help of another Alessandro,
the father of Spatialite. I think he is already working on WFS3.
Maybe this could lead to an enhancement of libspatialite to make
XML/JSON sources a more interactive part of Spatialite itself or a
virtualwms data provider for Spatialite (like virtualpg).
c

On Sun, Nov 1, 2020 at 9:58 AM Régis Haubourg
mailto:regis.haubo...@gmail.com>> wrote:

Hi,
+1 with Denis, this is a quite common scenario, but the
caching issue, combined with the good old WFS-T implementation
spatialite provider issues looked like a big challenge.

I think the future transactional version of WFS3 - OGC APIF
should speed up and simplify a lot the protocol part. On my
side, I was just waiting fo it to happen to raise the topic again.

Concerning the client side caching, I'm not up to date with
the potential spatialite provider enhancement.

Having a reliable and efficient way to edit WFS-T would be
really nice. But as Alessandro points out, our application
with a lot of database intelligence will trigger a lot of data
refresh in any case and we will have then some lags.

Best
Régis






Le jeu. 29 oct. 2020 à 15:11, Denis Rouzaud
mailto:denis.rouz...@gmail.com>> a
écrit :



Le jeu. 29 oct. 2020 à 15:07, Alessandro Pasotti
mailto:apaso...@gmail.com>> a écrit :

On Thu, Oct 29, 2020 at 2:59 PM Denis Rouzaud
mailto:denis.rouz...@gmail.com>> wrote:
>
> Hi all,
>
> I have a WFS-T layer with a Postgis DB behind it.
> On my table, I have an insert trigger (before
insert) which sets a field.
> When I create a feature on this layer in QGIS, I
don't get back the value of this field (I have to
refresh the data, by re-opening QGIS for instance).
>
> Is this expected?

Yes. The features are locally cached in a SQLite layer
and a newly
created feature will be stored locally and not
retrieve from the
server.

> Is there anything we can fix?

Of course yes but it would require re-fetching the
feature(s) after an
insert or an update, I think it will slow things down.


This could be done asynchronously?
It sounds like a quite common scenario (or not if nobody
complained...).

Thanks for the answer anyway.


Besides that there is no perfect solution to
server-side changes: if
some other user will trigger a data change on the DB
we will of course
miss it anyway.


> Am I doing something wrong?

No.

Cheers


-- 
Alessandro Pasotti

QCooperative: www.qcooperative.net

ItOpen: www.itopen.it 

___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org

List info:
https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe:
https://lists.osgeo.org/mailman/listinfo/qgis-developer

___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org

List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe:
https://lists.osgeo.org/mailman/listinfo/qgis-developer

___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org 
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer


___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: