{% ckan_extends %} {% block custom %} {{ super() }} {% if examples %} {% call register_example('python', 'request_filter_custom') %}
from ckanapi import RemoteCKAN

ck = RemoteCKAN('{{ h.url_for('home.index', qualified=True) }}', apikey=API_TOKEN)
result = ck.action.datastore_search(
    resource_id="{{ resource_id }}",
    filters={{ examples.text_column_filters_object | tojson(indent=4) | indent(4) }},
)
print(result['records'])
{% endcall %} {% call register_example('python', 'request_sql_custom') %}
from ckanapi import RemoteCKAN

ck = RemoteCKAN('{{ h.url_for('home.index', qualified=True) }}', apikey=API_TOKEN)
rresult = ck.action.datastore_search_sql(
    sql="""SELECT * from "{{resource_id}}" WHERE {{ examples.text_column_name_sql }} LIKE 'jones'"""
)
print(result['records'])
{% endcall %} {% call register_example('python', 'request_insert') %}
from ckanapi import RemoteCKAN

ck = RemoteCKAN('{{ h.url_for('home.index', qualified=True) }}', apikey=API_TOKEN)
result = ck.action.datastore_upsert(
    resource_id="{{ resource_id }}",
    method="insert",
    records=[{{ examples.insert_record_object | tojson(indent=4) | indent(4) }}]
)
{% endcall %} {% call register_example('python', 'request_update') %}
from ckanapi import RemoteCKAN

ck = RemoteCKAN('{{ h.url_for('home.index', qualified=True) }}', apikey=API_TOKEN)
result = ck.action.datastore_upsert(
    resource_id="{{ resource_id }}",
    method="update",
    records=[{{ examples.update_record_object | tojson(indent=4) | indent(4) }}]
)
{% endcall %} {% call register_example('python', 'request_delete') %}
from ckanapi import RemoteCKAN

ck = RemoteCKAN('{{ h.url_for('home.index', qualified=True) }}', apikey=API_TOKEN)
result = ck.action.datastore_records_delete(
    resource_id="{{ resource_id }}",
    filters={{ examples.unique_filter_object | tojson(indent=4) | indent(4) }}
)
{% endcall %} {% endif %} {% endblock %}