public async Task ServerInitizalizationStateSet(InitializationStatesEnums databaseState)
{
IDbBase dbBase = null;
try
{
var parameters = new List <TimescaleParameter> {
new TimescaleParameter
{
NpgsqlValue = (short)databaseState,
ParameterName = STATE_ID_PARAMETER_NAME,
NpgsqlDbType = NpgsqlDbType.Smallint
}
};
dbBase = _dbFactory.GetDbBase();
await dbBase.ConnectAsync();
await dbBase.ExecuteNonQueryFunctionAsync(SET_INITIALIZATION_STATE_FNC_NAME, parameters);
}
catch (Exception ex)
{
await _logsManager.ErrorAsync(new ErrorLogStructure(ex).WithErrorSource());
throw new OutputException(
ex,
StatusCodes.Status500InternalServerError,
MnemoxStatusCodes.CANNOT_SET_STATE_PARAMETER);
}
finally
{
await dbBase?.DisconnectAsync();
}
}
public async Task StoreHeartBeat(HeartBeatRequest heartBeatRequest)
{
IDbBase dbBase = null;
try
{
dbBase = _dbFactory.GetDbBase();
var parameters = new List <TimescaleParameter>
{
new TimescaleParameter
{
NpgsqlValue = heartBeatRequest.InstanceId,
ParameterName = INSTANCE_ID_PARAMETER_NAME,
NpgsqlDbType = NpgsqlDbType.Bigint
}
};
await dbBase.ConnectAsync();
await dbBase.ExecuteNonQueryFunctionAsync(ADD_HEART_BEAT_FUNCTION_NAME, parameters);
}
catch (Exception ex)
{
await _logsManager.ErrorAsync(new ErrorLogStructure(ex).WithErrorSource());
throw new HandledException(ex);
}
finally
{
if (dbBase != null)
{
await dbBase.DisconnectAsync();
}
}
}
