[ckan-dev] Empty datastore table in CKAN

Wed Feb 24 17:02:47 UTC 2016

This line:

https://github.com/ckan/ckan/blob/f74575024a472085db2c8238d8f0ff71d888ffaf/ckanext/datastore/db.py#L1169

Is removing the filters argument from data_dict. This means that when
db.delete is finally called here:

https://github.com/ckan/ckan/blob/f74575024a472085db2c8238d8f0ff71d888ffaf/ckanext/datastore/db.py#L1169

... that the database will always be deleted.

This is a bug, I will send a PR to correct this shortly.

Thank you,
Tyler Kennedy

On Wed, Feb 24, 2016 at 11:46 AM, Michael Nielsen <mic.niel84 at gmail.com>
wrote:

> Parsing 'filters': {} actually deletes the table, not just the rows.
>
> On Wed, Feb 24, 2016 at 3:06 PM, Ian Ward <ian at excess.org> wrote:
>
>> I don't think this was the question originally asked, but to remove
>> all rows with datastore_delete without deleting the table you need to
>> pass "filters": {} or similar. If you omit filters completely the
>> table iteself will be removed. Would be great to make this clearer in
>> the docs.
>>
>> We don't currently offer a way to delete rows with sql expressions
>> like ">". You could issue that kind of update directly with SQL (if
>> you have access) or iterate over all the rows to delete with separate
>> datastore_delete calls.
>>
>> On Wed, Feb 24, 2016 at 8:13 AM, Vitor Baptista <vitor at vitorbaptista.com>
>> wrote:
>> > (As answered in stackoverflow)
>> >
>> > To delete a datastore table's contents without deleting its structure,
>> you
>> > simply call "datastore_delete" without passing any "filters".
>> >
>> > On 24 February 2016 at 12:41, Michael Nielsen <mic.niel84 at gmail.com>
>> wrote:
>> >>
>> >> Question also asked at
>> >>
>> http://stackoverflow.com/questions/35598133/delete-all-records-with-id-higher-than-x-in-ckan
>> .
>> >>
>> >> I'm trying to use the datastore_api in CKAN (ckan.org) and want to
>> delete
>> >> all records with an id higher than X - my goal is simply to delete ALL
>> >> records without deleting the table.
>> >>
>> >> Docs:
>> >>
>> http://docs.ckan.org/en/ckan-2.5.1/maintaining/datastore.html?highlight=filter#ckanext.datastore.logic.action.datastore_delete
>> >>
>> >> Running the API with
>> >>
>> >> 'filters': {'_id': '0'}
>> >>
>> >> does work, but setting
>> >>
>> >> {'_id': '>0'}
>> >>
>> >> or
>> >>
>> >> {'_id': '*'} fails.
>> >>
>> >> How can I empty a table in the datastore without deleting the table?
>> >>
>> >> The SQL generated in CKAN is:
>> >>
>> >> ...9b89-7ab1c36c8e00" WHERE ("_id" = '*') ...
>> >>
>> >> So it make sense why it fails, but I don't know how to use the API
>> calls
>> >> with either wildcards or "higher than".
>> >>
>> >> _______________________________________________
>> >> 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
>> >>
>> >
>> >
>> >
>> > --
>> >
>> > Vítor Baptista
>> >
>> > http://vitorbaptista.com
>> >
>> >
>> > _______________________________________________
>> > 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
>> >
>> _______________________________________________
>> 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
>>
>
>
> _______________________________________________
> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20160224/53ad3ca3/attachment-0003.html>