Custom Query (2152 matches)

Filters
 
Or
 
  
 
Columns

Show under each result:


Results (1813 - 1815 of 2152)

Ticket Resolution Summary Owner Reporter
#1208 fixed Webstore: a datastore with web API rgrp rgrp

Reported by rgrp, 3 years ago.

Description
  • SQLite based
  • Use Cyclone for async http server on top with auth
  • Designed to not be specific to CKAN or anything else

Current code is here: https://github.com/okfn/webstore.

API Spec

Read

Two basic ways to query::

    GET: /{owner}/{db-name}/?sql=...
    GET: /{owner}/{db-name}/?table=...&attr=value&attr=value&limit=...

Returns::

  {
      u'keys': [u'id', u'name'],
      u'data': [
          [1, u'jones'],
          [u'aaa', u'jones']
          ]
  }

Write

POST to::

/{owner/{database}/{table}

Payload is json data structured as follows::

{

unique_keys: [list of key attributes] data: {dict of values}

}

Authentication and Authorization

Authentication: use basic auth header.

Authorization:

  • Default: all read, owner can write
  • Restricted: owner can read and write, everyone can do nothing

Possible future: config file can specify a python method (TODO: method signature)

Integration with Other Systems

TODO: Specify how to delegate authenatication to user database in some other system.

#1822 fixed Weight mulilingual searches correctly kindly kindly

Reported by kindly, 2 years ago.

Description

Dismax query across languages. Titles and selected languages, weighted more highly.

#61 fixed When dumping data to json do not dump private information like API keys rgrp rgrp

Reported by rgrp, 5 years ago.

Description

Cost: 1h

Note: See TracQuery for help on using queries.