Skip to content

Latest commit

 

History

History
269 lines (177 loc) · 3.49 KB

Doc.md

File metadata and controls

269 lines (177 loc) · 3.49 KB
Raw

/keyspace (get all keyspace)

params
return：Json array
example：
curl \
  -X GET \
  http://localhost/keyspace \
  -H 'Content-Type: application/json'
/table (get all table in keyspace)
params
  • keyspace
return：Json array
example：
curl \
  -X GET \
  http://localhost/table?keyspace=abc \
  -H 'Content-Type: application/json'
/row (get all row in table)
params
  • table
  • page
  • pagesize
return：Json object
example：
curl \
  -X GET \
  http://localhost/row?table=ca.abc&limit=5&token_key=a&next_token=Serenity \
  -H 'Content-Type: application/json'
/rowtoken (get all row in table by token)
params
  • table
  • item
  • prevnext
  • pagesize
return：Json object
example：
curl \
  -X POST \
  http://localhost/rowtoken \
  -H 'Content-Type: application/json' \
  -d '{"table":"table_name", "item":"{field1:value1, field2:value2}", "prevnext": "next", "pagesize": 10}'
/query (cql query)
params
  • query cql query
return：Json object
example：
curl \
  -X POST \
  http://localhost/query \
  -H 'Content-Type: application/json' \
  -d '{"query":"cql query"}'
/save (eidt Save)
params
  • table
  • item
return：Json object
example：
curl \
  -X POST \
  http://localhost/save \
  -H 'Content-Type: application/json' \
  -d '{"table":"table_name", "item":"{field1:value1, field2:value2}"}'
/describe (cqlsh describe)
params
  • table
return：string
example：
curl \
  -X GET \
  http://localhost/describe?table=ca.abc
  -H 'Content-Type: application/json' \
/columns (get table columns)
params
  • keyspace
  • table
return：Json object
example：
curl \
  -X GET \
  http://localhost/columns \
  -H 'Content-Type: application/json' \
  -d '{"keyspace":"system_auth", "table":"roles"}'
/delete (delete table row)
params
  • table
  • item
return：Json object
example：
curl \
  -X POST \
  http://localhost/delete \
  -H 'Content-Type: application/json' \
  -d '{"table":"table_name", "item":"{field1:value1, field2:value2}"}'
/Find (find table row)
params
  • table
  • item
  • order_by array[object{name:columns_name,order:asc|desc}] only clustering key and by order
  • pagesize
  • page
return：Json object
example：
curl \
  -X POST \
  http://localhost/find \
  -H 'Content-Type: application/json' \
  -d '{"table":"tablename","item":{"order_id":{"operator":"=","value":"123"},"order_time":{"operator":"=","value":"456"}}, "page": 1, "pagesize": 10}'
/Export (export file table data)
params
  • table
return：file
example：
curl \
  -X POST \
  http://localhost/export?table=keyspace.table \
  -H 'Content-Type: application/json' \
/Import (import file table data)
form-data params
  • table
  • file
return：Josn object
example：
curl \
  -X POST \
  http://localhost/import \
  -F "table=keyspace.table" \
  -F "filecomment=This is an image file" \
  -F "file=@/home/user/Desktop/importfile" \
/truncate (truncate table data)
params
  • table
return：Json object
example：
curl \
  -X POST \
  http://localhost/truncate \
  -H 'Content-Type: application/json' \
  -d '{"table":"table_name"}'