<!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>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>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 id="Zm-_Id_-Sgn"><div>--<br></div><div>Pēteris Brūns<br></div><div>SunGIS<br></div><div>+371 26336691<br></div><div><a href="mailto:pb@sungis.lv">pb@sungis.lv</a><br></div></div><div><br></div><div class="zmail_extra"><div id="Zm-_Id_-Sgn1"><div><br></div><div>---- On Fri, 05 Oct 2018 23:54:07 +0300 <b>Olivier Dalang <olivier.dalang@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 dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><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><div dir="ltr"><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><div dir="ltr"><br></div><div>Cheers,<br></div><div><br></div><div>Olivier<br></div><div dir="ltr"><div dir="ltr"><div><br></div><div>[1] <a target="_blank" href="https://github.com/qgis/QGIS/pull/7012">https://github.com/qgis/QGIS/pull/7012</a><br></div><div><br></div><div><br></div></div></div></div></div><div><br></div><div class="x_-272373480gmail_quote"><div dir="ltr">On Sat, Oct 6, 2018 at 4:24 AM Radim Blazek <<a target="_blank" href="mailto:radim.blazek@gmail.com">radim.blazek@gmail.com</a>> wrote:<br></div><blockquote style="margin: 0 0 0 0.8ex; border-left: 1px rgb(204, 204, 204) solid; padding-left: 1ex" class="x_-272373480gmail_quote"><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] <a target="_blank" href="https://github.com/vascop/django-wfs">https://github.com/vascop/django-wfs</a><br></div><div> [2] <a target="_blank" href="http://www.itopen.it/qgis-server-binding-news/lang-pref/en/">http://www.itopen.it/qgis-server-binding-news/lang-pref/en/</a><br></div><div> <br></div><div> Radim<br></div><div> <br></div><div> On Fri, Mar 24, 2017 at 1:56 PM Marco Bernasocchi <<a target="_blank" href="mailto:marco@opengis.ch">marco@opengis.ch</a>> 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> > <a target="_blank" href="https://www.youtube.com/watch?v=GzX4byPkV3E">https://www.youtube.com/watch?v=GzX4byPkV3E</a><br></div><div> > <a target="_blank" href="http://osgeo-org.1560.x6.nabble.com/New-Geonode-GeoSAFE-and-QGIS-work-td5303864.html">http://osgeo-org.1560.x6.nabble.com/New-Geonode-GeoSAFE-and-QGIS-work-td5303864.html</a><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></blockquote></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></blockquote></div><div><br></div></div><br></body></html>