首页 > 代码库 > influxdb 命令

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 databasecurl -X POST ‘http://localhost:8086/db?u=root&p=root‘   -d ‘{"name": "site_development"}‘# drop a databasecurl -X DELETE ‘http://localhost:8086/db/site_development?u=root&p=root‘
 
cluster admin类型用户的操作:
# get list of cluster admins curlcurl ‘http://localhost:8086/cluster_admins?u=root&p=root‘# add cluster admincurl -X POST ‘http://localhost:8086/cluster_admins?u=root&p=root‘   -d ‘{"name": "paul", "password": "i write teh docz"}‘# update cluster admin passwordcurl -X POST ‘http://localhost:8086/cluster_admins/paul?u=root&p=root‘   -d ‘{"password": "new pass"}‘# delete cluster admincurl -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 usercurl -X POST ‘http://localhost:8086/db/site_dev/users?u=root&p=root‘   -d ‘{"name": "paul", "password": "i write teh docz"}‘# delete database usercurl -X DELETE ‘http://localhost:8086/db/site_dev/users/paul?u=root&p=root‘# update user‘s passwordcurl -X POST ‘http://localhost:8086/db/site_dev/users/paul?u=root&p=root‘   -d ‘{"password": "new pass"}‘# get list of database userscurl ‘http://localhost:8086/db/site_dev/users?u=root&p=root‘# add database admin privilegecurl -X POST ‘http://localhost:8086/db/site_dev/users/paul?u=root&p=root‘   -d ‘{"admin": true}‘# remove database admin privilegecurl -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

influxdb 命令