[ckan-dev] OpenSearch

Wed Feb 3 17:12:01 UTC 2016

Given that you have defined your ORM classes (i.e Python classes mapping to
relational tables), you
can initialize the schema using only sqlalchemy.

Before trying anyhing, it would be helpfull to read this:
http://docs.sqlalchemy.org/en/latest/core/metadata.html#creating-and-dropping-database-tables

On Wed, Feb 3, 2016 at 6:57 PM, Pedro G Silva <pedro.gracio at deimos.com.pt>
wrote:

> I saw the custom apster commands at
> https://github.com/PublicaMundi/ckanext-publicamundi/blob/592e3863c4e20012ee30b9d8e1eab00dc80ced00/ckanext/publicamundi/commands.py#L126
> I just fail to understand how that gets inserted into the db. Sorry, im
> not familiar with SQLAlchemy
>
> On Wed, Feb 3, 2016 at 4:54 PM, michail alexakis <drmalex07 at gmail.com>
> wrote:
>
>> If by "add" you mean "create", then all CSW-related tables must be
>> created in advance.
>>
>> In our case, we do it using some custom Paster commands when setting up
>> the extension.
>>
>> In your case (since you dont install the whole extension), you can find
>> all ORM table definitions at
>> https://github.com/PublicaMundi/ckanext-publicamundi/blob/master/ckanext/publicamundi/model/csw_record.py.
>>
>>
>> So, you can use standard sqlalchemy tools to initialize this part of the
>> database schema, i.e create the needed tables/indices.
>>
>>
>> On Wed, Feb 3, 2016 at 6:24 PM, Pedro G Silva <pedro.gracio at deimos.com.pt
>> > wrote:
>>
>>> Can you tell me where to find the relevant code to add the tables to the
>>> db? I'm struggling with it
>>>
>>> On Wed, Feb 3, 2016 at 2:05 PM, michail alexakis <drmalex07 at gmail.com>
>>> wrote:
>>>
>>>> Hello Pedro,
>>>>
>>>> They fire up at the following events of a dataset lifecycle:
>>>>
>>>> * after_update
>>>> * after_create
>>>> * after_delete
>>>>
>>>> These hooks are provided to any plugin declaring that implements
>>>> `IPackageController` interface.
>>>>
>>>> See, for example:
>>>>
>>>> https://github.com/PublicaMundi/ckanext-publicamundi/blob/master/ckanext/publicamundi/plugins.py#L680
>>>>
>>>>
>>>> On Wed, Feb 3, 2016 at 3:33 PM, Pedro G Silva <
>>>> pedro.gracio at deimos.com.pt> wrote:
>>>>
>>>>> Hi Angelos and Michail,
>>>>> I'm currently just trying to isolate the relevant CSW code to a
>>>>> separate extension. So far, using latest stable ckan, I had some problems,
>>>>> btu I think I was able to fix them. Can you tell me the conditions that
>>>>> fire a syncronization to the CSW server? I'm still not sure I'm capable of
>>>>> doing this, but I'm trying.
>>>>>
>>>>> Thanks
>>>>>
>>>>> On Wed, Feb 3, 2016 at 11:40 AM, Angelos Tzotsos <
>>>>> gcpp.kalxas at gmail.com> wrote:
>>>>>
>>>>>> Hi Pedro,
>>>>>>
>>>>>> The ckanext-publicamundi extension includes many plugins, targeting
>>>>>> automation for publishing OGC services from CKAN.
>>>>>> The feature list can be found here:
>>>>>> http://publicamundi.eu/?page_id=542
>>>>>>
>>>>>> This extension is powering the Greek Open Data catalog:
>>>>>> http://geodata.gov.gr/
>>>>>>
>>>>>> Yes, we have fully integrated pycsw to reflect all datasets (native
>>>>>> and harvested).
>>>>>> In order to do this we implemented a plugin to fully support ISO
>>>>>> 19115 metadata (including a metadata editor) in order to be able to
>>>>>> synchronize the datasets to pycsw database:
>>>>>>
>>>>>> https://github.com/PublicaMundi/ckanext-publicamundi#update-ckan-configuration
>>>>>>
>>>>>> Please let me know if you have more questions about this.
>>>>>> We are in the process of making those plugins stand-alone in order to
>>>>>> be able to use separately, but this takes a while :)
>>>>>>
>>>>>> Best,
>>>>>> Angelos
>>>>>>
>>>>>>
>>>>>> On 02/03/2016 01:01 PM, Pedro G Silva wrote:
>>>>>>
>>>>>> I found a plugin https://github.com/PublicaMundi/ckanext-publicamundi which
>>>>>> provides CSW out of the box for all datasets. I am in the process of trying
>>>>>> to extract the relevant code and maybe try and create and extension which
>>>>>> ckan itself could use? Or myabe the authors could do it? Is this of
>>>>>> interest to ckan?
>>>>>>
>>>>>> On Thu, Jan 28, 2016 at 10:07 PM, Tom Kralidis <tomkralidis at gmail.com> <tomkralidis at gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>
>>>>>> FYI the pycsw endpoint provides OpenSearch (and OAI-PMH and SRU)
>>>>>> support our of the box. In all cases this is against harvested
>>>>>> content. We could implement a custom OpenSearch endpoint however It
>>>>>> would be valuable to look into enhancing CSW/etc access beyond just
>>>>>> harvested content.
>>>>>>
>>>>>> ..Tom
>>>>>>
>>>>>> On Thu, Jan 28, 2016 at 12:30 PM, Pedro G Silva<pedro.gracio at deimos.com.pt> <pedro.gracio at deimos.com.pt> wrote:
>>>>>>
>>>>>> Hi All
>>>>>> I'm looking for something that implements or adds opensearch like
>>>>>>
>>>>>> queries to CKAN. I found out about the ckan-harvest plugin with the spatial
>>>>>> one, using pycsw, but this adds the inconvienet of having to write my own
>>>>>> harvester (I explored that front, but the documentation on this is not
>>>>>> great). On http://ckan.org/open-standards/ it states CKAN "includes a CSW
>>>>>> server to present a CSW interface to its own data" . Is this misleading? Or
>>>>>> is a reference to the spatial CSW support?
>>>>>>
>>>>>> --
>>>>>>
>>>>>>
>>>>>> Pedro Gracio Silva
>>>>>> Aerospace Systems / Production Center
>>>>>>
>>>>>> Av. D. Joao II, Lt 1.17.01, 10 • 1998-023 Lisboa, Portugal
>>>>>> Ph: +351 21 893 3020 • Fax: +351 21 896 9099
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> ckan-dev mailing listckan-dev at lists.okfn.orghttps://lists.okfn.org/mailman/listinfo/ckan-dev
>>>>>> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>>>>>>
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> ckan-dev mailing listckan-dev at lists.okfn.orghttps://lists.okfn.org/mailman/listinfo/ckan-dev
>>>>>> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Angelos Tzotsos, PhD
>>>>>> OSGeo Charter Memberhttp://users.ntua.gr/tzotsos
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>>
>>>>>
>>>>> [image: DEIMOS Engenharia, SA] <http://www.deimos.pt>
>>>>> *Pedro Gracio Silva*
>>>>> Aerospace Systems / Production Center
>>>>>
>>>>> *Av. D. Joao II, Lt 1.17.01, 10 • 1998-023 Lisboa, Portugal*
>>>>> Ph: +351 21 893 3020 • Fax: +351 21 896 9099
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> ckan-dev mailing list
>>>>> ckan-dev at lists.okfn.org
>>>>> https://lists.okfn.org/mailman/listinfo/ckan-dev
>>>>> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>>>>>
>>>>>
>>>>
>>>
>>>
>>> --
>>>
>>>
>>> [image: DEIMOS Engenharia, SA] <http://www.deimos.pt>
>>> *Pedro Gracio Silva*
>>> Aerospace Systems / Production Center
>>>
>>> *Av. D. Joao II, Lt 1.17.01, 10 • 1998-023 Lisboa, Portugal*
>>> Ph: +351 21 893 3020 • Fax: +351 21 896 9099
>>>
>>>
>>
>
>
> --
>
>
> [image: DEIMOS Engenharia, SA] <http://www.deimos.pt>
> *Pedro Gracio Silva*
> Aerospace Systems / Production Center
>
> *Av. D. Joao II, Lt 1.17.01, 10 • 1998-023 Lisboa, Portugal*
> Ph: +351 21 893 3020 • Fax: +351 21 896 9099
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20160203/3541dda7/attachment-0003.html>