query

query

WIP: query TXN2 data by account, model and index pattern. Save queries and execute saved queries.

Examples

Start server:

go run ./cmd/query.go --tokenKey=$TOKEN_KEY --esServer=http://elasticsearch:9200

Run / Test a query:

curl -X POST \
  http://localhost:8080/run/xorg \
  -H 'Authorization: Bearer $TOKEN' \
  -d '{
    "machine_name": "all_los_angeles_parking_citations",
    "display_name": "All Los Angeles Parking Citations",
    "description_brief": "Gets all Los Angeles parking citation records available.",
    "description": "This is a dataset hosted by the city of Los Angeles. The organization has an open data platform found [here](https://data.lacity.org/)",
    "query_class": "table",
    "model": "los_angeles_parking_citations",
    "idx_pattern": "-testset",
    "query": {
	  "query": {
	    "match_all": {}
	  }
	}
}'

Upsert a query:

curl -X POST \
  http://localhost:8080/upsert/xorg \
  -H 'Authorization: Bearer $TOKEN' \
  -d '{
    "machine_name": "all_los_angeles_parking_citations",
    "display_name": "All Los Angeles Parking Citations",
    "description_brief": "Gets all Los Angeles parking citation records available",
    "description": "This is a dataset hosted by the city of Los Angeles. The organization has an open data platform found [here](https://data.lacity.org/)",
    "query_class": "table",
    "model": "los_angeles_parking_citations",
    "idx_pattern": "-testset",
    "query": {
	  "query": {
	    "match_all": {}
	  }
	}
}'

Search for queries:

curl -X POST \
  http://localhost:8080/search/xorg \
  -H 'Authorization: Bearer $TOKEN' \
  -d '{
  "size": 10,
  "query": {
    "match_all": {}
  }
}'

Get a query:

curl -X GET \
  http://localhost:8080/get/xorg/all_los_angeles_parking_citations \
  -H 'Authorization: Bearer $TOKEN'