[GeoNode-users] How to establish a relation between a layer and a document in the GeoNode database

[Paolo Corti]

Hi
Shouldn't we file a bug here and fix it in the code base?
p

On Wed, Mar 8, 2017 at 8:09 AM, Eloi <eloi at openmailbox.org> wrote:
> Thanks for your quick reply Simone.
>
> It was very helpful. Now I can see in a SQL query how Documents and Layers
> relate:
>
> SELECT d.resourcebase_ptr_id AS doc_id,
>        l.resourcebase_ptr_id AS lay_id,
>        d.title_en AS doc_title,
>        l.title_en AS lay_title
> FROM documents_document AS d
> LEFT JOIN layers_layer  AS l ON l.resourcebase_ptr_id = d.object_id
> ORDER BY l.title_en;
>
> And I was wrong when I said "every time I run the command "python manage.py
> updatelayers" all established relations (between a layers and a documents)
> disappear". That is not true, they did disappear because I have delete the
> layers in order to restore them again in the update. So my fault. Still
> learning.
>
> Thank you very much for the help.
>
> Cheers,
>
> Eloi
>
>
> On 2017-03-08 11:50, Simone Dalmasso wrote:
>
>> Hi,
>>
>> The layers are actually saved in the layer_layer table but the relation is
>> in document_document and points to the ContentType model. It is a generic
>> relation since it can point to any other geonode resource. The two fields
>> that you have to compile in the document table are the contenty_type (the id
>> if the layer content type in your case) and object_id(the id of the target
>> layer.)
>>
>> Hope this helps
>>
>> 2017-03-08 10:05 GMT+01:00 Eloi <eloi at openmailbox.org>:
>>
>>> Good morning,
>>>
>>> I would like to establish the relation between a layer and a document
>>> using the GeoNode database and not using the web interface.
>>> I saw that the layers are listed in table 'base_resourcebase' and
>>> documents in 'documents_document'. So I wonder in which table the relation
>>> between the previous two is recorded. Then I would just run my SQL code to
>>> define does relations.
>>>
>>> Why I want to do this? Because every time I run the command "python
>>> manage.py updatelayers" all established relations (between a layers and a
>>> documents) disappear.
>>>
>>> Thank you in advance!
>>>
>>> Cheers,
>>>
>>> Eloi
>
>
> _______________________________________________
> geonode-users mailing list
> geonode-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/geonode-users



-- 
Paolo Corti
Geospatial software developer
web: http://www.paolocorti.net
twitter: @capooti
skype: capooti