3liz / qgis-pgmetadata-plugin

QGIS Plugin to manage some metadata from PostgreSQL layer
GNU General Public License v2.0
12 stars 10 forks source link

Template generation #34

Closed Gustry closed 3 years ago

Gustry commented 3 years ago

This SQL is not working about the template generation :

INSERT INTO pgmetadata.dataset (table_name,schema_name,title,abstract)
VALUES ('lines','test','Test title','Test abstract.') RETURNING id;
--> 7

INSERT INTO pgmetadata.link (name,type,url,description,size,fk_id_dataset)
VALUES ('test link','pdf','https://metadata.is.good','',0.5,7)

DELETE FROM pgmetadata.html_template WHERE section IN ('main', 'link');

INSERT INTO pgmetadata.html_template (section,content)
VALUES ('main','<p>[% "title" %]</p><b>[%"abstract"%]</b><p>[% meta_links %]<p>');

INSERT INTO pgmetadata.html_template (section,content)
VALUES ('link','<p>[% "name" %] [% "description" %]</p><p>[% "size" %]</p>');

SELECT pgmetadata.get_dataset_item_html_content('test','lines');

No need to have the underlying layer behind. This SQL must work.

<p>Test title</p><b>Test abstract.</b><p><p>

I should be able to see the link. Maybe I'm missing something obvious ?

Maybe between [% "name" %] and [% name %] ?

Gustry commented 3 years ago

@drillinP Do you have an idea?

Gustry commented 3 years ago

Test case added 63f25c48132ce361c8df40a2dc445fe5b5d42d05 But the result is wrong.