<div dir="ltr">Hi,<div><br></div><div>what you are doing there is not correct and it would be out of the scope of this list to describe how django works but what I suggest you is to do the django tutorial available here in the django docs <a href="https://docs.djangoproject.com/en/1.10/">https://docs.djangoproject.com/en/1.10/</a> it will help you a lot.</div><div><br></div><div>regards</div></div><div class="gmail_extra"><br><div class="gmail_quote">2016-09-06 10:06 GMT+02:00 David Alda Fernandez de Lezea <span dir="ltr"><<a href="mailto:dalda@hazi.eus" target="_blank">dalda@hazi.eus</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<br>
I'm resending this email to the developers list as I think it might be more suitable. I need to have a script in GeoNode to make a query to the PostGIS DB to get some values so I've began the functionality under the geonode directory structure and following the DJANGO documentation. So far I've made something like this:<br>
<br>
-geonode<br>
<br>
├── hazi<br>
│ ├── __init__.py<br>
│ ├── models.py<br>
│ ├── urls.py<br>
│ └── views.py<br>
<br>
This is the views.py content<br>
<br>
from django.shortcuts import render_to_response<br>
from django.http import HttpResponse<br>
from models import DBAtribDistinctValues<br>
<br>
def distinctValues(request):<br>
db = PostGisdb.connect(user=<wbr>DATABASE_USER, db=DATABASE_NAME, passwd=DATABASE_PASSWORD, host=DATABASE_HOST)<br>
cursor = db.cursor()<br>
cursor.execute('SELECT distinct() FROM books ORDER BY name')<br>
names = [row[0] for row in cursor.fetchall()]<br>
db.close()<br>
return render_to_response('book_list.<wbr>html', {'names': names})<br>
<br>
def hello():<br>
return HttpResponse( "<html><body>Hello</body></<wbr>html>")<br>
<br>
This is the urls.py content<br>
<br>
from django.conf.urls import url, patterns<br>
from geonode.hazi import views<br>
<br>
urlpatterns = patterns('geonode.hazi.views',<br>
url(r'^distinctValues', 'distinctValues', name='distinctValues'),<br>
url(r'^hello', 'hello',name='hello'),<br>
)<br>
<br>
And finally de models.py<br>
<br>
from django.contrib.gis.db import models<br>
<br>
class DBAtribDistinctValues(models.<wbr>Model):<br>
distinctValues = models.CharField(max_length=<wbr>150000, blank=True, null=True)<br>
<br>
I've also added to the settings.py the module to the GEONODE_APPS array.<br>
<br>
So far don't get any response of neither functions. I can't even get the "hello" when I visit \\myip\hazi\hello<br>
<br>
I know this is a newbie question but I've no idea about Django programming. I've looking into google but without success.<br>
<br>
What I'm doing wrong? Any ideas?<br>
<br>
Thanks in advance.<br>
<br>
Regards.<br>
<br>
Agur bero bat,<br>
<br>
<br>
David Alda Fernández de Lezea<br>
Área de Sistemas de Información Geográfica, Planificación Territorial y Forestal Informazio Geografikoen Sistemak, Lurralde eta Baso Antolaketaren Arloa.<br>
dalda@hazi.eus | www.hazi.eus<br>
T 945 003 240 – M 627 923 170 – F 945 003 290<br>
Hazi | Granja Modelo de Arkaute s/n | 01192 Arkaute – Araba<br>
<br>
********************* LEGE OHARRA ******************* AVISOLEGAL ******************* DISCLAIMER *****************************<br>
Mezu hau pertsonala eta isilpekoa da eta baimenik gabeko erabilera debekatua dago legalki. Jasotzailea ez bazara ezabatu mezua, bidali eta kontserbatu gabe.<br>
Este mensaje es personal y confidencial y su uso no autorizado está prohibido legalmente. Si usted no es el destinatario, proceda a borrarlo, sin reenviarlo ni conservarlo.<br>
This message is personal and confidential, unauthorised use is legally prohibited. If you are not the intended recipient, delete it without resending or backing it.<br>
<br>
-----Mensaje original-----<br>
De: geonode-users [mailto:<a href="mailto:geonode-users-bounces@lists.osgeo.org">geonode-users-bounces@<wbr>lists.osgeo.org</a>] En nombre de David Alda Fernandez de Lezea<br>
Enviado el: viernes, 02 de septiembre de 2016 14:44<br>
Para: Paolo Corti<br>
CC: <a href="mailto:geonode-users@lists.osgeo.org">geonode-users@lists.osgeo.org</a><br>
Asunto: Re: [GeoNode-users] Advanced Styling<br>
<br>
Hi again,<br>
<br>
I'm taking up this task again and so far I've managed to identify, from the geoexplorer, the layer a its datastore with db information, but now I'd like to make a query to the table stored in the POSTGIS db but I've got no clue how or where do I have to start coding because I'm a completely newbie in Django. My idea is pretty simple, I'd like to add callable function in which I query the db and return the information to the geoexplorer.<br>
<br>
Can anyone point me to the right files to edit?<br>
<br>
Thanks in advance.<br>
<br>
Regards,<br>
<br>
Agur bero bat,<br>
<br>
<br>
David Alda Fernández de Lezea<br>
Área de Sistemas de Información Geográfica, Planificación Territorial y Forestal Informazio Geografikoen Sistemak, Lurralde eta Baso Antolaketaren Arloa.<br>
dalda@hazi.eus | www.hazi.eus<br>
T 945 003 240 – M 627 923 170 – F 945 003 290 Hazi | Granja Modelo de Arkaute s/n | 01192 Arkaute – Araba<br>
<br>
********************* LEGE OHARRA ******************* AVISOLEGAL ******************* DISCLAIMER ***************************** Mezu hau pertsonala eta isilpekoa da eta baimenik gabeko erabilera debekatua dago legalki. Jasotzailea ez bazara ezabatu mezua, bidali eta kontserbatu gabe.<br>
Este mensaje es personal y confidencial y su uso no autorizado está prohibido legalmente. Si usted no es el destinatario, proceda a borrarlo, sin reenviarlo ni conservarlo.<br>
This message is personal and confidential, unauthorised use is legally prohibited. If you are not the intended recipient, delete it without resending or backing it.<br>
<br>
<br>
-----Mensaje original-----<br>
De: Paolo Corti [mailto:<a href="mailto:pcorti@gmail.com">pcorti@gmail.com</a>] Enviado el: martes, 19 de julio de 2016 15:14<br>
Para: David Alda Fernandez de Lezea<br>
CC: <a href="mailto:geonode-users@lists.osgeo.org">geonode-users@lists.osgeo.org</a><br>
Asunto: Re: [GeoNode-users] Advanced Styling<br>
<br>
Hi David<br>
surely you can do that!<br>
GeoExplorer makes just OGC and GeoServer REST API calls, but you can add a GeoNode API to the mix The GeoExplorer version forked for GeoNode already makes some calls to GeoNode, to check permissions for a layer for example. You can use same approach.<br>
have a nice day<br>
p<br>
<br>
On Tue, Jul 19, 2016 at 5:23 AM, David Alda Fernandez de Lezea <dalda@hazi.eus> wrote:<br>
> Hi Paolo,<br>
><br>
> Thanks for your response. Yes it's something that could be really interesting. From my point of view, unless I'm wrong, this functionality could be available/usable for all the layers stored in the "geonode" database, as they are the only layers that can be styled (WMS cascaded layers, which are foreign, layers can't), it would be possible to make query to the DB via python function, for example?<br>
><br>
> Thanks.<br>
><br>
> Regards.<br>
><br>
> Agur bero bat,<br>
><br>
><br>
> David Alda Fernández de Lezea<br>
> Área de Sistemas de Información Geográfica, Planificación Territorial y Forestal Informazio Geografikoen Sistemak, Lurralde eta Baso Antolaketaren Arloa.<br>
> dalda@hazi.eus | www.hazi.eus<br>
> T 945 003 240 – M 627 923 170 – F 945 003 290 Hazi | Granja Modelo de<br>
> Arkaute s/n | 01192 Arkaute – Araba<br>
><br>
> ********************* LEGE OHARRA ******************* AVISOLEGAL ******************* DISCLAIMER *****************************<br>
> Mezu hau pertsonala eta isilpekoa da eta baimenik gabeko erabilera debekatua dago legalki. Jasotzailea ez bazara ezabatu mezua, bidali eta kontserbatu gabe.<br>
> Este mensaje es personal y confidencial y su uso no autorizado está prohibido legalmente. Si usted no es el destinatario, proceda a borrarlo, sin reenviarlo ni conservarlo.<br>
> This message is personal and confidential, unauthorised use is legally prohibited. If you are not the intended recipient, delete it without resending or backing it.<br>
><br>
><br>
> -----Mensaje original-----<br>
> De: Paolo Corti [mailto:<a href="mailto:pcorti@gmail.com">pcorti@gmail.com</a>] Enviado el: lunes, 18 de<br>
> julio de 2016 16:20<br>
> Para: David Alda Fernandez de Lezea<br>
> CC: <a href="mailto:geonode-users@lists.osgeo.org">geonode-users@lists.osgeo.org</a><br>
> Asunto: Re: [GeoNode-users] Advanced Styling<br>
><br>
> It would be an interesting feature but I don't think there is any<br>
> other way than reading all the field values with a WFS request and<br>
> then compose the distinct values list on the client. Therefore it can<br>
> be overwhelming for large datasets p<br>
><br>
> On Mon, Jul 18, 2016 at 7:55 AM, David Alda Fernandez de Lezea <dalda@hazi.eus> wrote:<br>
>> Hi list,<br>
>><br>
>> I'm looking for some custom functionalities on GeoNode and I'm thinking of allowing the "gxp_styler" to read the distinct values that has the selected attribute field that the user specifies to classify. I don't know if anyone else has tried or even completed this task.<br>
>><br>
>> In case not, I think it would be a good idea to include this in following versions of GeoNode.<br>
>><br>
>> Thanks in advance.<br>
>><br>
>> Regards,<br>
>><br>
>> Agur bero bat,<br>
>><br>
>><br>
>> David Alda Fernández de Lezea<br>
>> Área de Sistemas de Información Geográfica, Planificación Territorial y Forestal Informazio Geografikoen Sistemak, Lurralde eta Baso Antolaketaren Arloa.<br>
>> dalda@hazi.eus | www.hazi.eus<br>
>> T 945 003 240 - M 627 923 170 - F 945 003 290 Hazi | Granja Modelo de<br>
>> Arkaute s/n | 01192 Arkaute - Araba<br>
>><br>
>> ********************* LEGE OHARRA ******************* AVISOLEGAL ******************* DISCLAIMER *****************************<br>
>> Mezu hau pertsonala eta isilpekoa da eta baimenik gabeko erabilera debekatua dago legalki. Jasotzailea ez bazara ezabatu mezua, bidali eta kontserbatu gabe.<br>
>> Este mensaje es personal y confidencial y su uso no autorizado está prohibido legalmente. Si usted no es el destinatario, proceda a borrarlo, sin reenviarlo ni conservarlo.<br>
>> This message is personal and confidential, unauthorised use is legally prohibited. If you are not the intended recipient, delete it without resending or backing it.<br>
>><br>
>> ______________________________<wbr>_________________<br>
>> geonode-users mailing list<br>
>> <a href="mailto:geonode-users@lists.osgeo.org">geonode-users@lists.osgeo.org</a><br>
>> <a href="http://lists.osgeo.org/mailman/listinfo/geonode-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/<wbr>mailman/listinfo/geonode-users</a><br>
><br>
><br>
><br>
> --<br>
> Paolo Corti<br>
> Geospatial software developer<br>
> web: <a href="http://www.paolocorti.net" rel="noreferrer" target="_blank">http://www.paolocorti.net</a><br>
> twitter: @capooti<br>
> skype: capooti<br>
<br>
<br>
<br>
--<br>
Paolo Corti<br>
Geospatial software developer<br>
web: <a href="http://www.paolocorti.net" rel="noreferrer" target="_blank">http://www.paolocorti.net</a><br>
twitter: @capooti<br>
skype: capooti<br>
______________________________<wbr>_________________<br>
geonode-users mailing list<br>
<a href="mailto:geonode-users@lists.osgeo.org">geonode-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/geonode-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/<wbr>mailman/listinfo/geonode-users</a><br>
______________________________<wbr>_________________<br>
geonode-devel mailing list<br>
<a href="mailto:geonode-devel@lists.osgeo.org">geonode-devel@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/geonode-devel" rel="noreferrer" target="_blank">http://lists.osgeo.org/<wbr>mailman/listinfo/geonode-devel</a><br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature">Simone </div>
</div>