Advertisement
Guest User

Untitled

a guest
Jan 18th, 2018
280
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.38 KB | None | 0 0
  1. # -*- coding: utf-8 -*-
  2. """Tutorial on using the InfluxDB client."""
  3.  
  4. import argparse
  5.  
  6. from influxdb import InfluxDBClient
  7.  
  8. # curl -i -XPOST 'http://localhost:8086/write?db=smog_db' --data-binary 'smog,airQualityIndex=4,sensorId=11 pm10=0.01,pm25=0.02 14340555620000'
  9.  
  10. # curl -G 'http://localhost:8086/query?pretty=true' --data-urlencode "db=smog_db" --data-urlencode "q=SELECT * FROM \"smog\""
  11.  
  12.  
  13. # ssh -i pajtong.pem ec2-user@ec2-52-16-76-3.eu-west-1.compute.amazonaws.com
  14. # scp -i pajtong.pem ec2-user@ec2-52-16-76-3.eu-west-1.compute.amazonaws.com
  15.  
  16. # http://ec2-52-16-76-3.eu-west-1.compute.amazonaws.com:3000
  17. # admin
  18. # admin
  19.  
  20.  
  21. # curl -i -XPOST 'http://localhost:8086/write?db=smog_db' --data-binary 'smog,airQualityIndex=4,sensorId=11 pm10=0.01,pm25=0.02 14340555620000'
  22.  
  23.  
  24.  
  25. def main(host='http://ec2-52-16-76-3.eu-west-1.compute.amazonaws.com', port=8086):
  26. """Instantiate a connection to the InfluxDB."""
  27. user = ''
  28. password = ''
  29. dbname = 'smog_db'
  30. # dbuser = 'smly'
  31. # dbuser_password = 'my_secret_password'
  32. query = 'SELECT * FROM \"smog\"'
  33. json_body = []
  34.  
  35. client = InfluxDBClient(host, port, user, password, dbname)
  36.  
  37. # print("Create database: " + dbname)
  38. # client.create_database(dbname)
  39.  
  40. # print("Create a retention policy")
  41. # client.create_retention_policy('awesome_policy', '3d', 3, default=True)
  42.  
  43. # print("Switch user: " + dbuser)
  44. # client.switch_user(dbuser, dbuser_password)
  45.  
  46. # print("Write points: {0}".format(json_body))
  47. # client.write_points(json_body)
  48.  
  49. print("Querying data: " + query)
  50. result = client.query(query)
  51.  
  52. print("Result: {0}".format(result))
  53.  
  54. # print("Switch user: " + user)
  55. # client.switch_user(user, password)
  56.  
  57. print("Drop database: " + dbname)
  58. client.drop_database(dbname)
  59.  
  60.  
  61. def parse_args():
  62. """Parse the args."""
  63. parser = argparse.ArgumentParser(
  64. description='example code to play with InfluxDB')
  65. parser.add_argument('--host', type=str, required=False,
  66. default='localhost',
  67. help='hostname of InfluxDB http API')
  68. parser.add_argument('--port', type=int, required=False, default=8086,
  69. help='port of InfluxDB http API')
  70. return parser.parse_args()
  71.  
  72.  
  73. if __name__ == '__main__':
  74. args = parse_args()
  75. main(host=args.host, port=args.port)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement