public async Task ChangeReceiveStateAsync(MediumMessage message, StatusName state) { var collection = _database.GetCollection <ReceivedMessage>(_options.Value.ReceivedCollection); var updateDef = Builders <ReceivedMessage> .Update .Set(x => x.Retries, message.Retries) .Set(x => x.ExpiresAt, message.ExpiresAt) .Set(x => x.StatusName, state.ToString("G")); await collection.UpdateOneAsync(x => x.Id == long.Parse(message.DbId), updateDef); }
public async Task ChangePublishStateAsync(MediumMessage message, StatusName state) { var collection = _database.GetCollection <PublishedMessage>(_options.Value.PublishedCollection); var updateDef = Builders <PublishedMessage> .Update .Set(x => x.Content, _serializer.Serialize(message.Origin)) .Set(x => x.Retries, message.Retries) .Set(x => x.ExpiresAt, message.ExpiresAt) .Set(x => x.StatusName, state.ToString("G")); await collection.UpdateOneAsync(x => x.Id == long.Parse(message.DbId), updateDef); }
public async Task ChangeReceiveStateAsync(MediumMessage message, StatusName state) { var sql = $"UPDATE {_recName} SET Retries=@Retries,ExpiresAt=@ExpiresAt,StatusName=@StatusName WHERE Id=@Id"; var connection = this.DbConnection; await connection.ExecuteAsync(sql, new { Id = message.DbId, message.Retries, message.ExpiresAt, StatusName = state.ToString("G") }, DbTransaction); }
public async Task ChangeReceiveStateAsync(MediumMessage message, StatusName state) { var sql = $"UPDATE {_recName} SET \"Retries\"=@Retries,\"ExpiresAt\"=@ExpiresAt,\"StatusName\"=@StatusName WHERE \"Id\"=@Id"; await this.DbConnection.ExecuteAsync(sql, new { Id = long.Parse(message.DbId), message.Retries, message.ExpiresAt, StatusName = state.ToString("G") }, transaction : DbTransaction); }
public async Task ChangeReceiveStateAsync(MediumMessage message, StatusName state) { var sql = $"UPDATE {_recName} SET \"Retries\"=@Retries,\"ExpiresAt\"=@ExpiresAt,\"StatusName\"=@StatusName WHERE \"Id\"=@Id"; using var connection = new NpgsqlConnection(_options.Value.ConnectionString); await connection.ExecuteAsync(sql, new { Id = long.Parse(message.DbId), message.Retries, message.ExpiresAt, StatusName = state.ToString("G") }); }
public async Task ChangeReceiveStateAsync(MediumMessage message, StatusName state) { await using var connection = new MySqlConnection(_options.Value.ConnectionString); var sql = $"UPDATE `{_initializer.GetReceivedTableName()}` SET `Retries` = @Retries,`ExpiresAt` = @ExpiresAt,`StatusName`=@StatusName WHERE `Id`=@Id;"; await connection.ExecuteAsync(sql, new { Id = message.DbId, message.Retries, message.ExpiresAt, StatusName = state.ToString("G") }); }
public async Task ChangeReceiveStateAsync(MediumMessage message, StatusName state) { var sql = $"UPDATE {_recName} SET Retries=@Retries,ExpiresAt=@ExpiresAt,StatusName=@StatusName WHERE Id=@Id"; using var connection = new SqlConnection(_options.Value.ConnectionString); await connection.ExecuteAsync(sql, new { Id = message.DbId, message.Retries, message.ExpiresAt, StatusName = state.ToString("G") }); }
public async Task ChangeReceiveStateAsync(MediumMessage message, StatusName state) { var connection = this.DbConnection; var sql = $"UPDATE `{_initializer.GetReceivedTableName()}` SET `Retries` = @Retries,`ExpiresAt` = @ExpiresAt,`StatusName`=@StatusName WHERE `Id`=@Id;"; await connection.ExecuteAsync(sql, new { Id = message.DbId, message.Retries, message.ExpiresAt, StatusName = state.ToString("G") }, transaction : DbTransaction); }
public async Task ChangePublishStateAsync(MediumMessage message, StatusName state) { var sql = $"UPDATE {_pubName} SET Retries=@Retries,ExpiresAt=@ExpiresAt,StatusName=@StatusName WHERE Id=@Id"; // using var connection = new SqlConnection(_options.Value.ConnectionString); var connection = this.DbConnection; await connection.ExecuteAsync(sql, new { Id = message.DbId, message.Retries, message.ExpiresAt, StatusName = state.ToString("G") }, DbTransaction); }
private async Task ChangeMessageStateAsync(string tableName, MediumMessage message, StatusName state) { var sql = $"UPDATE `{tableName}` SET `Retries` = @Retries,`ExpiresAt` = @ExpiresAt,`StatusName`=@StatusName WHERE `Id`=@Id;"; object[] sqlParams = { new MySqlParameter("@Id", message.DbId), new MySqlParameter("@Retries", message.Retries), new MySqlParameter("@ExpiresAt", message.ExpiresAt), new MySqlParameter("@StatusName", state.ToString("G")) }; await using var connection = new MySqlConnection(_options.Value.ConnectionString); connection.ExecuteNonQuery(sql, sqlParams: sqlParams); }
private async Task ChangeMessageStateAsync(string tableName, MediumMessage message, StatusName state) { var sql = $"UPDATE {tableName} SET \"Content\"=@Content,\"Retries\"=@Retries,\"ExpiresAt\"=@ExpiresAt,\"StatusName\"=@StatusName WHERE \"Id\"=@Id"; object[] sqlParams = { new NpgsqlParameter("@Id", long.Parse(message.DbId)), new NpgsqlParameter("@Content", _serializer.Serialize(message.Origin)), new NpgsqlParameter("@Retries", message.Retries), new NpgsqlParameter("@ExpiresAt", message.ExpiresAt), new NpgsqlParameter("@StatusName", state.ToString("G")) }; await using var connection = new NpgsqlConnection(_options.Value.ConnectionString); connection.ExecuteNonQuery(sql, sqlParams: sqlParams); }
private async Task ChangeMessageStateAsync(string tableName, MediumMessage message, StatusName state) { var sql = $"UPDATE {tableName} SET \"Retries\"=:Retries,\"ExpiresAt\"=:ExpiresAt,\"StatusName\"=:StatusName WHERE \"Id\"=:Id"; object[] sqlParams = { new OracleParameter(":Retries", message.Retries), new OracleParameter(":ExpiresAt", message.ExpiresAt.HasValue?(object)message.ExpiresAt:DBNull.Value), new OracleParameter(":StatusName", state.ToString("G")), new OracleParameter(":Id", long.Parse(message.DbId)) }; using var connection = new OracleConnection(_options.Value.ConnectionString); connection.ExecuteNonQuery(sql, sqlParams: sqlParams); await Task.CompletedTask; }
public async Task ChangeReceiveStateAsync(MediumMessage message, StatusName state) { var sql = $"UPDATE `{_initializer.GetReceivedTableName()}` SET `Retries` = @Retries,`ExpiresAt` = @ExpiresAt,`StatusName` = @StatusName WHERE `Id` = @Id"; var sqlParam = new { Id = message.DbId, Retries = message.Retries, ExpiresAt = message.ExpiresAt, StatusName = state.ToString("G") }; using (var connection = new SqliteConnection(_options.Value.ConnectionString)) { await connection.ExecuteAsync(sql, sqlParam); }; }
private async Task ChangeMessageStateAsync(string tableName, MediumMessage message, StatusName state) { var sql = $"UPDATE `{tableName}` SET `Retries`=@Retries,`ExpiresAt`=@ExpiresAt,`StatusName`=@StatusName WHERE `Id`=@Id"; object[] sqlParams = { new SqliteParameter("@Retries", message.Retries), new SqliteParameter("@ExpiresAt", message.ExpiresAt.HasValue?(object)message.ExpiresAt:DBNull.Value), new SqliteParameter("@StatusName", state.ToString("G")), new SqliteParameter("@Id", long.Parse(message.DbId)) }; using var connection = new SqliteConnection(_options.Value.ConnectionString); connection.ExecuteNonQuery(sql, sqlParams: sqlParams); await Task.CompletedTask; }
private async Task ChangeMessageStateAsync(string tableName, MediumMessage message, StatusName state) { var sql = $@"UPDATE ""{tableName}"" SET ""Retries"" = :P_Retries,""ExpiresAt"" = :P_ExpiresAt,""StatusName"" = :P_StatusName WHERE ""Id"" = :P_Id"; object[] sqlParams = { new OracleParameter(":P_Retries", message.Retries), new OracleParameter(":P_ExpiresAt", message.ExpiresAt), new OracleParameter(":P_StatusName", state.ToString("G")), new OracleParameter(":P_Id", message.DbId) }; using var connection = new OracleConnection(_options.Value.ConnectionString); connection.ExecuteNonQuery(sql, sqlParams: sqlParams); await Task.CompletedTask; }
private async Task ChangeMessageStateAsync(string tableName, MediumMessage message, StatusName state) { var sql = $"UPDATE {tableName} SET Retries=@Retries,ExpiresAt=@ExpiresAt,StatusName=@StatusName WHERE Id=@Id"; object[] sqlParams = { new SqlParameter("@Id", message.DbId), new SqlParameter("@Retries", message.Retries), new SqlParameter("@ExpiresAt", message.ExpiresAt), new SqlParameter("@StatusName", state.ToString("G")) }; using var connection = new SqlConnection(_options.Value.ConnectionString); connection.ExecuteNonQuery(sql, sqlParams: sqlParams); await Task.CompletedTask; }
public async Task ChangePublishStateAsync(MediumMessage message, StatusName state) => await _capRepository.ChangeMessageStateAsync(_pubName, message.DbId, message.Retries, message.ExpiresAt, state.ToString("G"));
public async Task ChangeReceiveStateAsync(MediumMessage message, StatusName state) => await _capRepository.ChangeMessageStateAsync(_recName, message.DbId, message.Retries, message.ExpiresAt, state.ToString("G"), _serializer.Serialize(message.Origin));