CSharp操作Influxdb

管理组

通过orgApi对象可以对组织进行增删改查

InfluxDBClient influxDBClient = new InfluxDBClient("http://xxxxx:7999", "1xJM7-EcQIM4fgWap1kD5s_E83q_D9rIPspQbbhA-tzDe_pLrHxR1XmHRA31vS30DKErOdg9cpGXAOSYo4Pu4w==");
var orgApi = influxDBClient.GetOrganizationsApi();
var orgList = orgApi.FindOrganizationsAsync().Result;
Console.WriteLine("=========================================");
orgList.ForEach(it =>
{
	Console.WriteLine(it.Name);
});
Console.WriteLine("=========================================");

管理桶

[TestMethod]
public void TestMethod_Bucket()
{
	InfluxDBClient influxDBClient = new InfluxDBClient("http://xxxx:7999", "1xJM7-EcQIM4fgWap1kD5s_E83q_D9rIPspQbbhA-tzDe_pLrHxR1XmHRA31vS30DKErOdg9cpGXAOSYo4Pu4w==");
	var bucketApi = influxDBClient.GetBucketsApi();
	var bucketList = bucketApi.FindBucketsByOrgNameAsync("yuannao").Result;
	Console.WriteLine("=========================================");
	bucketList.ForEach(it =>
	{
		Console.WriteLine($"{it.Name}:{it.Id}");
	});
	Console.WriteLine("=========================================");
}

管理用户

[TestMethod]
public void TestMethod_User()
{
	InfluxDBClient influxDBClient = new InfluxDBClient("http://xxxx:7999", "1xJM7-EcQIM4fgWap1kD5s_E83q_D9rIPspQbbhA-tzDe_pLrHxR1XmHRA31vS30DKErOdg9cpGXAOSYo4Pu4w==");
	var user_api = influxDBClient.GetUsersApi();
	var userlist = user_api.FindUsersAsync().Result;
	Console.WriteLine("=========================================");
	userlist.ForEach(it =>
	{
		Console.WriteLine($"{it.Name}:{it.Id}");
	});
	Console.WriteLine("=========================================");
}
var user = user_api.CreateUserAsync("inspur").Result;
user_api.UpdateUserPasswordAsync(user, "", "12345678").Wait();
//使用org_api添加用户到组织里

CSV数据写入

influx客户端写入

example.csv

date,sighted,loc
2024-07-01,12,Boise
2024-07-02,78,Boise
2024-07-01,54,Seattle
2024-07-02,112,Seattle
2024-07-01,9,Detroit
2024-07-02,135,Detroit

将csv数据写入Influxdb

influx write -o orgname -b example-bucket \
  -f /root/example.csv \
  --header "#constant measurement,birds" \
  --header "#datatype dateTime:2006-01-02,long,tag"

CSharp写入csv文件

[TestMethod]
public void Test_Method_WriteCSV()
{
	var csv2Path = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Files", "birds.csv");
	var csv2Parser = new CsvParser<Birds>(new CsvParserOptions(true, ','), new CsvBirdsMapping());
	var birdsResult = csv2Parser
		  .ReadFromFile(csv2Path, Encoding.ASCII)
		  .ToList();
	var birdsArray = birdsResult.Select(map => map.Result).ToArray();
	const string bucket = "my-bucket";
	const string org = "yuannao";

	var client = new InfluxDBClient("http://10.141.17.15:7999", "0scexCRkr5QI9oWb0INhCBkozs-yen512lGxKW4RPt0pDnEGC3PtL-8jSWnqFOl0ib1QtssxLHaJcdon-PihYA==");
	var writeApiAsync = client.GetWriteApiAsync();
	writeApiAsync.WriteMeasurementsAsync<Birds>(birdsArray, WritePrecision.S, bucket, org).Wait();
}