<div>What bug?<br><div class="gmail_quote"><div>Il giorno mer 8 mar 2017 alle 20:46 Paolo Corti <<a href="mailto:pcorti@gmail.com">pcorti@gmail.com</a>> ha scritto:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi<br class="gmail_msg">
Shouldn't we file a bug here and fix it in the code base?<br class="gmail_msg">
p<br class="gmail_msg">
<br class="gmail_msg">
On Wed, Mar 8, 2017 at 8:09 AM, Eloi <<a href="mailto:eloi@openmailbox.org" class="gmail_msg" target="_blank">eloi@openmailbox.org</a>> wrote:<br class="gmail_msg">
> Thanks for your quick reply Simone.<br class="gmail_msg">
><br class="gmail_msg">
> It was very helpful. Now I can see in a SQL query how Documents and Layers<br class="gmail_msg">
> relate:<br class="gmail_msg">
><br class="gmail_msg">
> SELECT d.resourcebase_ptr_id AS doc_id,<br class="gmail_msg">
> l.resourcebase_ptr_id AS lay_id,<br class="gmail_msg">
> d.title_en AS doc_title,<br class="gmail_msg">
> l.title_en AS lay_title<br class="gmail_msg">
> FROM documents_document AS d<br class="gmail_msg">
> LEFT JOIN layers_layer AS l ON l.resourcebase_ptr_id = d.object_id<br class="gmail_msg">
> ORDER BY l.title_en;<br class="gmail_msg">
><br class="gmail_msg">
> And I was wrong when I said "every time I run the command "python manage.py<br class="gmail_msg">
> updatelayers" all established relations (between a layers and a documents)<br class="gmail_msg">
> disappear". That is not true, they did disappear because I have delete the<br class="gmail_msg">
> layers in order to restore them again in the update. So my fault. Still<br class="gmail_msg">
> learning.<br class="gmail_msg">
><br class="gmail_msg">
> Thank you very much for the help.<br class="gmail_msg">
><br class="gmail_msg">
> Cheers,<br class="gmail_msg">
><br class="gmail_msg">
> Eloi<br class="gmail_msg">
><br class="gmail_msg">
><br class="gmail_msg">
> On 2017-03-08 11:50, Simone Dalmasso wrote:<br class="gmail_msg">
><br class="gmail_msg">
>> Hi,<br class="gmail_msg">
>><br class="gmail_msg">
>> The layers are actually saved in the layer_layer table but the relation is<br class="gmail_msg">
>> in document_document and points to the ContentType model. It is a generic<br class="gmail_msg">
>> relation since it can point to any other geonode resource. The two fields<br class="gmail_msg">
>> that you have to compile in the document table are the contenty_type (the id<br class="gmail_msg">
>> if the layer content type in your case) and object_id(the id of the target<br class="gmail_msg">
>> layer.)<br class="gmail_msg">
>><br class="gmail_msg">
>> Hope this helps<br class="gmail_msg">
>><br class="gmail_msg">
>> 2017-03-08 10:05 GMT+01:00 Eloi <<a href="mailto:eloi@openmailbox.org" class="gmail_msg" target="_blank">eloi@openmailbox.org</a>>:<br class="gmail_msg">
>><br class="gmail_msg">
>>> Good morning,<br class="gmail_msg">
>>><br class="gmail_msg">
>>> I would like to establish the relation between a layer and a document<br class="gmail_msg">
>>> using the GeoNode database and not using the web interface.<br class="gmail_msg">
>>> I saw that the layers are listed in table 'base_resourcebase' and<br class="gmail_msg">
>>> documents in 'documents_document'. So I wonder in which table the relation<br class="gmail_msg">
>>> between the previous two is recorded. Then I would just run my SQL code to<br class="gmail_msg">
>>> define does relations.<br class="gmail_msg">
>>><br class="gmail_msg">
>>> Why I want to do this? Because every time I run the command "python<br class="gmail_msg">
>>> manage.py updatelayers" all established relations (between a layers and a<br class="gmail_msg">
>>> documents) disappear.<br class="gmail_msg">
>>><br class="gmail_msg">
>>> Thank you in advance!<br class="gmail_msg">
>>><br class="gmail_msg">
>>> Cheers,<br class="gmail_msg">
>>><br class="gmail_msg">
>>> Eloi<br class="gmail_msg">
><br class="gmail_msg">
><br class="gmail_msg">
> _______________________________________________<br class="gmail_msg">
> geonode-users mailing list<br class="gmail_msg">
> <a href="mailto:geonode-users@lists.osgeo.org" class="gmail_msg" target="_blank">geonode-users@lists.osgeo.org</a><br class="gmail_msg">
> <a href="https://lists.osgeo.org/mailman/listinfo/geonode-users" rel="noreferrer" class="gmail_msg" target="_blank">https://lists.osgeo.org/mailman/listinfo/geonode-users</a><br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
--<br class="gmail_msg">
Paolo Corti<br class="gmail_msg">
Geospatial software developer<br class="gmail_msg">
web: <a href="http://www.paolocorti.net" rel="noreferrer" class="gmail_msg" target="_blank">http://www.paolocorti.net</a><br class="gmail_msg">
twitter: @capooti<br class="gmail_msg">
skype: capooti<br class="gmail_msg">
_______________________________________________<br class="gmail_msg">
geonode-users mailing list<br class="gmail_msg">
<a href="mailto:geonode-users@lists.osgeo.org" class="gmail_msg" target="_blank">geonode-users@lists.osgeo.org</a><br class="gmail_msg">
<a href="https://lists.osgeo.org/mailman/listinfo/geonode-users" rel="noreferrer" class="gmail_msg" target="_blank">https://lists.osgeo.org/mailman/listinfo/geonode-users</a><br class="gmail_msg">
</blockquote></div></div><div dir="ltr">-- <br></div><div data-smartmail="gmail_signature">Simone </div>