public void GetCurrentVersion_Success()
{
//Arrange
var connection = CreateConnection();
//Act
Value_Reply value_Reply = connection.GetCurrentVersion(new Empty());
//Assert
Assert.IsNotNull(value_Reply.Value);
}
public void SetSettingValueByName_Success()
{
//Arrange
var connection = CreateConnection();
//Act
Value_Reply value_Reply = connection.SetSettingValueByName(new NameValue_Request {
Name = "version", Value = "1.5" /*SETTING NAME*/
});
//Assert
Assert.IsNotNull(value_Reply.Value);
}
public override Task <Value_Reply> GetCurrentVersion(Empty request, ServerCallContext context)
{
Value_Reply value_Reply = new Value_Reply();
MySqlConnection connection = CreateDBConnection();
var cmd = connection.CreateCommand();
cmd.CommandText = $"SELECT `value` FROM trackerdb.setting WHERE `name` = 'version';";
var reader = cmd.ExecuteReader();
reader.Read();
value_Reply.Value = Convert.ToString(reader["value"]);
cmd.Dispose();
connection.Close();
connection.Dispose();
return(Task.FromResult(value_Reply));
}
public override Task <Value_Reply> SetSettingValueByName(NameValue_Request request, ServerCallContext context)
{
Value_Reply value_Reply = new Value_Reply();
MySqlConnection connection = CreateDBConnection();
var cmd = connection.CreateCommand();
cmd.CommandText = $"UPDATE trackerdb.setting SET `value` = '{request.Value}' WHERE `name` = '{request.Name}';";
cmd.ExecuteNonQuery();
cmd.CommandText = $"SELECT `value` FROM trackerdb.setting WHERE `name` = '{request.Name}';";
var reader = cmd.ExecuteReader();
reader.Read();
value_Reply.Value = Convert.ToString(reader["value"]);
cmd.Dispose();
connection.Close();
connection.Dispose();
return(Task.FromResult(value_Reply));
}
