33 lines
1.3 KiB
C#
33 lines
1.3 KiB
C#
using HermesSocketLibrary.db;
|
|
using ILogger = Serilog.ILogger;
|
|
|
|
namespace HermesSocketServer.Requests
|
|
{
|
|
public class UpdateTTSVoiceState : IRequest
|
|
{
|
|
public string Name => "update_tts_voice_state";
|
|
public string[] RequiredKeys => ["voice", "state"];
|
|
private Database _database;
|
|
private ILogger _logger;
|
|
|
|
public UpdateTTSVoiceState(Database database, ILogger logger)
|
|
{
|
|
_database = database;
|
|
_logger = logger;
|
|
}
|
|
|
|
public async Task<RequestResult> Grant(string sender, IDictionary<string, object>? data)
|
|
{
|
|
data["voice"] = data["voice"].ToString();
|
|
data["state"] = data["state"].ToString() == "True";
|
|
data["user"] = sender;
|
|
|
|
string sql = "INSERT INTO \"TtsVoiceState\" (\"userId\", \"ttsVoiceId\", state) VALUES (@user, @voice, @state) ON CONFLICT (\"userId\", \"ttsVoiceId\") DO UPDATE SET state = @state";
|
|
var result = await _database.Execute(sql, data);
|
|
_logger.Information($"Updated voice's [voice id: {data["voice"]}] state [new state: {data["state"]}][channel: {data["user"]}]");
|
|
if (result > 0)
|
|
return RequestResult.Successful(null);
|
|
return RequestResult.Failed("Something went wrong when updating the database.");
|
|
}
|
|
}
|
|
} |