public async Task Add(string database = "sampledb", string table = "sampletable") { var random = new Random(); var os = new [] { "iPhone 12", "iPhone 11", "iPhone 10", "iPhone 9", "iPhone 8", "iPhone 7", "android 11", "android 10", "android 9", "android 8", "android 7", }; using var client = new TimeStreamClient(database); for (var i = 1; i < 10000; i++) { var metadata = new[] { new RecordMetadata("hostname", Environment.MachineName), new RecordMetadata("os", os[i % os.Length]), new RecordMetadata("region", "日本"), }; var cpu = random.Next(30, 100); var cpuRecord = new RecordData(metadata, DateTimeOffset.Now, "cpu_utilization", cpu); var memory = random.Next(1000, 1500); var memoryRecord = new RecordData(metadata, DateTimeOffset.Now, "memory_utilization", memory); var records = new[] { cpuRecord, memoryRecord }; Console.WriteLine($"adding {records.Length} records to {database}.{table}"); await client.AddAsync(table, records); await Task.Delay(TimeSpan.FromSeconds(1)); } }
public async Task Read(string database = "sampledb", string table = "sampletable") { using var client = new TimeStreamClient(database); await client.ReadAsync($@"SELECT * FROM {database}.{table} WHERE os = 'iPhone 12'"); }