//[Fact]
public async Task Insert_data()
{
HDBClient client = new HDBClient();
string query = @"{ ""operation"":""sql"", ""sql"": ""INSERT INTO sql.dog (id, name) VALUES(1, 'Simon')"" }";
Console.Out.WriteLine("Request: " + query);
var result = await client.PostAsync(HDBConfig.HDBServer, new StringContent(query, Encoding.UTF8, "application/json"));
String responseContent = await result.Content.ReadAsStringAsync();
dynamic responseJson = JsonConvert.DeserializeObject(responseContent);
Console.Out.WriteLine("ResponseJson: " + responseJson);
}
//[Fact]
public async Task Update_Data()
{
var dir = Directory.GetCurrentDirectory();
dynamic query = JsonConvert.DeserializeObject <dynamic>(File.ReadAllText(dir + Path.DirectorySeparatorChar + @"/tests/schema/dog_update.json"));
HDBClient client = new HDBClient();
Console.Out.WriteLine("Request: " + query);
var result = await client.PostAsync(HDBConfig.HDBServer, new StringContent(query.ToString(), Encoding.UTF8, "application/json"));
String responseContent = await result.Content.ReadAsStringAsync();
dynamic responseJson = JsonConvert.DeserializeObject(responseContent);
Console.Out.WriteLine("ResponseJson: " + responseJson);
//Assert.Equal("Item not found!", responseJson.error);
}
//[Fact]
public async Task Describe_table()
{
HDBClient client = new HDBClient();
string query = @"{ ""operation"":""describe_table"", ""table"":""dog"",""schema"": ""root"" }";
Console.Out.WriteLine("Request: " + query);
var result = await client.PostAsync(HDBConfig.HDBServer, new StringContent(query, Encoding.UTF8, "application/json"));
String responseContent = await result.Content.ReadAsStringAsync();
dynamic responseJson = JsonConvert.DeserializeObject(responseContent);
Console.Out.WriteLine("Response: " + responseJson);
//Assert.Equal("Item not found!", responseJson.error);
}
public async Task sql(string sql)
{
HDBClient client = new HDBClient();
sql = "\"" + sql + "\"";
string query = @"{""operation"":""sql"",""sql"":" + sql + "}";
Console.Out.WriteLine("Request Body: " + query);
var result = await client.PostAsync(HDBConfig.HDBServer, new StringContent(query, Encoding.UTF8, "application/json"));
String responseContent = await result.Content.ReadAsStringAsync();
dynamic responseJson = JsonConvert.DeserializeObject(responseContent);
Console.Out.WriteLine("ResponseJson: " + responseJson);
}
//[Fact]
public async Task DropSchemaAndTable()
{
HDBClient client = new HDBClient();
string query = @"{ ""operation"":""drop_schema"", ""schema"": ""jsonTests"" }";
Console.Out.WriteLine("Request Body: " + query);
var result = await client.PostAsync(HDBConfig.HDBServer, new StringContent(query, Encoding.UTF8, "application/json"));
String responseContent = await result.Content.ReadAsStringAsync();
dynamic responseJson = JsonConvert.DeserializeObject(responseContent);
Console.Out.WriteLine("ResponseJson: " + responseJson);
}
//[Fact]
public async Task select_data_subdistrict()
{
HDBClient client = new HDBClient();
string query = @"{""operation"":""sql"",""sql"":""select * from thailand.subdistrict""}";
Console.Out.WriteLine("Request Body: " + query);
var result = await client.PostAsync(HDBConfig.HDBServer, new StringContent(query, Encoding.UTF8, "application/json"));
String responseContent = await result.Content.ReadAsStringAsync();
dynamic responseJson = JsonConvert.DeserializeObject(responseContent);
Console.Out.WriteLine("ResponseJson: " + responseJson);
//Assert.Equal("Item not found!", responseJson.error);
}
//[Fact]
public async Task import_csvdata_customers()
{
HDBClient client = new HDBClient();
string query = @"{""operation"":""csv_file_load"",""schema"":""northnwd"",""table"":""customers"",""file_path"": ""/home/code/databases/Customers.csv""}";
Console.Out.WriteLine("Request Body: " + query);
var result = await client.PostAsync(HDBConfig.HDBServer, new StringContent(query, Encoding.UTF8, "application/json"));
String responseContent = await result.Content.ReadAsStringAsync();
dynamic responseJson = JsonConvert.DeserializeObject(responseContent);
Console.Out.WriteLine("ResponseJson: " + responseJson);
//Assert.Equal("Item not found!", responseJson.error);
}
public async Task create_table_customers()
{
HDBClient client = new HDBClient();
string query = @"{""operation"":""create_table"",""schema"":""northnwd"",""table"":""customers"",""hash_attribute"": ""id""}";
Console.Out.WriteLine("Request Body: " + query);
var result = await client.PostAsync(HDBConfig.HDBServer, new StringContent(query, Encoding.UTF8, "application/json"));
String responseContent = await result.Content.ReadAsStringAsync();
dynamic responseJson = JsonConvert.DeserializeObject(responseContent);
Console.Out.WriteLine("ResponseJson: " + responseJson);
//Assert.Equal("Item not found!", responseJson);
}
//[Fact]
public async Task AddSimpleJson()
{
CreateSchemaAndTable().Wait();
var dir = Directory.GetCurrentDirectory();
dynamic json = JsonConvert.DeserializeObject <dynamic>(File.ReadAllText(dir + Path.DirectorySeparatorChar + @"basicjson.json"));
HDBClient client = new HDBClient();
var response = await client.PostAsync(HDBConfig.HDBServer, new StringContent(json.ToString(), Encoding.UTF8, "application/json"));
response.EnsureSuccessStatusCode();
var content = await response.Content.ReadAsStringAsync();
Console.Out.WriteLine(content);
DropSchemaAndTable().Wait();
// Assert.Equal("Test response", content);
// Assert.False(response.Headers.Contains("Server"), "Should not contain server header");
}