[ckan-dev] datastore upsert api

[Matthew Fullerton]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20150625/0d4d8adb/attachment-0003.html>