<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta content="text/html;charset=UTF-8" http-equiv="Content-Type"></head><body ><div style='font-size:10pt;font-family:Verdana,Arial,Helvetica,sans-serif;color:#00000;'><div><br></div><div class="zmail_extra"><div id="Zm-_Id_-Sgn1"><div>---- On Mon, 08 Oct 2018 22:27:42 +0300 <b>Radim Blazek <radim.blazek@gmail.com></b> wrote ----<br></div></div><div><br></div><blockquote style="border-left: 1px solid #cccccc; padding-left: 6px; margin:0 0 0 5px"><div><div>On Mon, Oct 8, 2018 at 8:47 PM Pēteris Brūns <pb@sungis.lv> wrote: <br></div><div>> <br></div><div>> Hi all, <br></div><div>> <br></div><div>> Pretty long time ago in similar case we developed django app able to replicate django user and group permissions to PostgreSQL roles and permissions. So each user can use the same user name and passowrd in WEB client and using QGIS/PostgreSQL, manage permissions in django auth app and the same will be replicated in postgresql. Each model is table and django permissions are translated to PostgreSQL role permissions - implementation works also with m2m and related models. <br></div><div>> <br></div><div>> In basic cases such model is OK, but ir more complex implementations we loose logic build around model in django or need to repeat it in QGIS or move to PostgreSQL. <br></div><div> <br></div><div>This is exactly what we also end up with and what we would like to <br></div><div>liberate from for the reasons you mentioned. Thank you anyway, at <br></div><div>least we know that we are not crazy alone. <br></div><div> <br></div></div></blockquote></div><div><br></div><div>You are not alone! And if you come to some good idea let us know. We
would be happy to hear and review opportunity to contribute or contribute with funding of such
functionality.<br></div><div><br></div><div>BTW, contextually not exact but similar case is
file/attachment upload from QGIS to server using, for example RESTful
API. Year ago, in Nodebo, we discussed such functionality with Mathias
and Marco.<br></div><div><br></div><div>Peteris<br></div><div><br></div><div class="zmail_extra"><blockquote style="border-left: 1px solid #cccccc; padding-left: 6px; margin:0 0 0 5px"><div><div>Radim <br></div><div> <br></div><div> <br></div><div>> If this sounds as suitable approach, I believe, we could try to review the code and make open source. <br></div><div>> <br></div><div>> Best, <br></div><div>> -- <br></div><div>> Pēteris Brūns <br></div><div>> SunGIS <br></div><div>> +371 26336691 <br></div><div>> pb@sungis.lv <br></div><div>> <br></div><div>> <br></div><div>> ---- On Fri, 05 Oct 2018 23:54:07 +0300 Olivier Dalang <olivier.dalang@gmail.com> wrote ---- <br></div><div>> <br></div><div>> Hi Radim, <br></div><div>> <br></div><div>> I didn't get this sorted in the end (ended just having the layer as read only in QGIS from postgis and users would do any modification from django admin). <br></div><div>> <br></div><div>> About a Django provider for QGIS : it is now possible to create python providers [1]. So creating a REST provider to consume a django rest framework endpoint may not be that hard anymore ? That would certainly be a great addition to QGIS !! <br></div><div>> <br></div><div>> And about a WFS-T app for Django : I don't know of any other effort than django-wfs, but I just saw there's an open PR with some a lot of changed including python 3 support, so maybe django-wfs is not as dead as it looks ? Still WFS-T would have to be added, and again not sure how hard this would be... <br></div><div>> <br></div><div>> Let us know how it goes ! <br></div><div>> <br></div><div>> Cheers, <br></div><div>> <br></div><div>> Olivier <br></div><div>> <br></div><div>> [1] https://github.com/qgis/QGIS/pull/7012 <br></div><div>> <br></div><div>> <br></div><div>> <br></div><div>> On Sat, Oct 6, 2018 at 4:24 AM Radim Blazek <radim.blazek@gmail.com> wrote: <br></div><div>> <br></div><div>> Hi, <br></div><div>> we need the same, to be precise, we need two things, to allow editing <br></div><div>> of data stored in Django/PostGIS in QGIS over the network and let QGIS <br></div><div>> Server (WMS) to read data from Django, both using Django filters etc. <br></div><div>> If we manage to get data to QGIS from Django (and back), we can use <br></div><div>> QGIS Server and WFS-T for editing. So I am looking for something like <br></div><div>> Django provider for QGIS or WFS-T application for Django. Are you <br></div><div>> aware of something like that? <br></div><div>> <br></div><div>> Olivier, what have you used in the end? [1] is not maintained and it <br></div><div>> does not support WFS-T. <br></div><div>> <br></div><div>> Alessandro, in [2] I am missing data reading from Django models. It <br></div><div>> seems like the server is launched from python, but data flow goes <br></div><div>> through standard QGIS providers? <br></div><div>> <br></div><div>> Marco, if I got it looking briefly into GeoNode code, they just run <br></div><div>> QGIS server, but they don't read data directly from Django models, <br></div><div>> right? <br></div><div>> <br></div><div>> [1] https://github.com/vascop/django-wfs <br></div><div>> [2] http://www.itopen.it/qgis-server-binding-news/lang-pref/en/ <br></div><div>> <br></div><div>> Radim <br></div><div>> <br></div><div>> On Fri, Mar 24, 2017 at 1:56 PM Marco Bernasocchi <marco@opengis.ch> wrote: <br></div><div>> > <br></div><div>> > Hi Olivier <br></div><div>> > Kartoza has been working on having geonode server running smoothly using <br></div><div>> > a qgis server in the background. <br></div><div>> > <br></div><div>> > have a look at <br></div><div>> > https://www.youtube.com/watch?v=GzX4byPkV3E <br></div><div>> > http://osgeo-org.1560.x6.nabble.com/New-Geonode-GeoSAFE-and-QGIS-work-td5303864.html <br></div><div>> > <br></div><div>> > cheers <br></div><div>> > Marco <br></div><div>> > <br></div><div>> > On 24.03.2017 13:10, Olivier Dalang wrote: <br></div><div>> > > Dear List, <br></div><div>> > > <br></div><div>> > > Does anybody here have some experience with making QGIS work with <br></div><div>> > > (Geo)Django ? <br></div><div>> > > <br></div><div>> > > I would love to be able to make them communicate, as QGIS is the <br></div><div>> > > interface of choice to do complex work on geometries and Django is <br></div><div>> > > perfect to quickly setup a complete endpoint with user management, model <br></div><div>> > > logic and web administration interface. <br></div><div>> > > <br></div><div>> > > I see two approches : <br></div><div>> > > - Using Django REST framework to create a REST endpoint - but is there a <br></div><div>> > > way to consume REST endpoints in QGIS ? <br></div><div>> > > - Developing a WFST module for Django, for which there seem to be some <br></div><div>> > > work done [1] for the non-transactionnal part. <br></div><div>> > > <br></div><div>> > > I just wanted to ask before reinventing the wheel ! <br></div><div>> > > <br></div><div>> > > Bests, <br></div><div>> > > <br></div><div>> > > Olivier <br></div><div>> <br></div><div>> _______________________________________________ <br></div><div>> QGIS-Developer mailing list <br></div><div>> QGIS-Developer@lists.osgeo.org <br></div><div>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer <br></div><div>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer <br></div><div>> <br></div><div>> <br></div><div>> <br></div></div></blockquote></div><div><br></div></div><br></body></html>