influxdb 命令

写入数据:
curl -X POST -d ‘[{"name":"foo","columns":["val"],"points":[[23]]}]‘ ‘http://localhost:8086/db/mydb/series?u=root&p=root‘
 
查询数据:
curl -G ‘http://localhost:8086/db/mydb/series?u=root&p=root‘ --data-urlencode "q=select * from log_lines limit 1"
 
创建和删除数据库(只有 cluster admin可以操作):
# create a database
curl -X POST ‘http://localhost:8086/db?u=root&p=root‘   -d ‘{"name": "site_development"}‘

# drop a database
curl -X DELETE ‘http://localhost:8086/db/site_development?u=root&p=root‘
 
cluster admin类型用户的操作:
# get list of cluster admins curl
curl ‘http://localhost:8086/cluster_admins?u=root&p=root‘

# add cluster admin
curl -X POST ‘http://localhost:8086/cluster_admins?u=root&p=root‘   -d ‘{"name": "paul", "password": "i write teh docz"}‘

# update cluster admin password
curl -X POST ‘http://localhost:8086/cluster_admins/paul?u=root&p=root‘   -d ‘{"password": "new pass"}‘

# delete cluster admin
curl -X DELETE ‘http://localhost:8086/cluster_admins/paul?u=root&p=root‘
 
database user(数据库用户),下文中数据库名为site_dev:
# Database users, with a database name of site_dev

# add database user
curl -X POST ‘http://localhost:8086/db/site_dev/users?u=root&p=root‘   -d ‘{"name": "paul", "password": "i write teh docz"}‘

# delete database user
curl -X DELETE ‘http://localhost:8086/db/site_dev/users/paul?u=root&p=root‘

# update user‘s password
curl -X POST ‘http://localhost:8086/db/site_dev/users/paul?u=root&p=root‘   -d ‘{"password": "new pass"}‘

# get list of database users
curl ‘http://localhost:8086/db/site_dev/users?u=root&p=root‘

# add database admin privilege
curl -X POST ‘http://localhost:8086/db/site_dev/users/paul?u=root&p=root‘   -d ‘{"admin": true}‘

# remove database admin privilege
curl -X POST ‘http://localhost:8086/db/site_dev/users/paul?u=root&p=root‘   -d ‘{"admin": false}‘
 
 
 
 
参考:http://influxdb.com/docs/v0.8/api/reading_and_writing_data.html

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。