[ckan-dev] datastore upsert api

[Matthew Fullerton]

Just to revive this a little, I've noticed two things:
- Setting a primary key doesn't require restating the columns
- Restating the columns (with or without adding a new column) does not
allow you to try and change their types. No error for integer->float, just
ignored.


On 14 July 2015 at 21:40, Sam Leitner <sam.leitner at gmail.com> wrote:

> Right, and annoyingly it looks like I need to name all previous
> columns/fields when using _create to make a new one?
>
> Also, it looks like the datastore_info API is no longer present in the
> code, but is still in the docs?
>
> Thanks,
> Sam
>
> On Thu, Jun 25, 2015 at 12:27 AM, Matthew Fullerton <
> matt.fullerton at gmail.com> wrote:
>
>> A related problem is that this issue comes up when you try to use the API
>> to insert records into a datastore table created by the user
>> interface/datapusher. I'm not sure why the automatically created _id column
>> cannot be set as the datastore primary key automatically.
>>
>> As you've probably noticed, I got the impression when experimenting that
>> _create doesn't just function as create but also as alter, in the case of
>> adding a primary key; the data in the table doesn't get lost.
>>
>> Best.
>> Matt
>>
>> Hi all,
>>
>> I'm having trouble using the datastore_upsert API. I get complaints from
>> CKAN about needing a unique key to update:
>>
>>  [error] [client 10.0.2.2] File
>> '/usr/lib/ckan/default/src/ckan/ckanext/datastore/db.py', line 664 in
>> upsert_data
>> [error] [client 10.0.2.2]   'table': [u'table does not have a unique key
>> defined']
>> [error] [client 10.0.2.2] ValidationError: None - {'table': [u'table does
>> not have a unique key defined']}
>>
>>  but I don't see a parameter in the docs to produce a unique key when
>> creating the datastore table (
>> http://docs.ckan.org/en/latest/maintaining/datastore.html#ckanext.datastore.logic.action.datastore_create
>> indicates that I can create primary_keys, but then I see "AND
>> idx.indisprimary = false" in datastore/db.py).
>>
>> Here's a gist of some jinja2 code that produces my problem in the app
>> (residing in package/snippet/resource_form.html):
>> https://gist.github.com/sleitner/2c079e435c04afe52c53
>>
>> And here's a similar gist of curl commands written into a bash script
>> that you can use to reproduce the issue:
>> https://gist.github.com/sleitner/e222a0499a8290f64db7
>>
>> What am I missing?
>>
>> Thanks for your help!
>> Sam
>>
>> _______________________________________________
>> 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/20151012/4c80653e/attachment-0002.html>