/
PostgresqlConnectionErrorsIntegrationTests.java
74 lines (58 loc) · 2.76 KB
/
PostgresqlConnectionErrorsIntegrationTests.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
/*
* Copyright 2020 the original author or authors.
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* https://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package io.r2dbc.postgresql;
import io.r2dbc.postgresql.api.PostgresqlConnection;
import io.r2dbc.postgresql.api.PostgresqlResult;
import io.r2dbc.postgresql.client.Client;
import io.r2dbc.postgresql.client.TransactionStatus;
import io.r2dbc.spi.R2dbcBadGrammarException;
import io.r2dbc.spi.R2dbcException;
import org.junit.jupiter.api.Test;
import reactor.test.StepVerifier;
import java.lang.reflect.Field;
import static org.assertj.core.api.Assertions.assertThat;
/**
* Integration tests for various error cases using {@link PostgresqlConnection}.
*/
final class PostgresqlConnectionErrorsIntegrationTests extends AbstractIntegrationTests {
@Test
void commitShouldRecoverFromFailedTransaction() {
this.connection.beginTransaction().as(StepVerifier::create).verifyComplete();
this.connection.createStatement("error").execute().flatMap(PostgresqlResult::getRowsUpdated).as(StepVerifier::create).verifyError(R2dbcBadGrammarException.class);
this.connection.commitTransaction().as(StepVerifier::create).verifyErrorSatisfies(throwable -> {
assertThat(throwable).isInstanceOf(R2dbcException.class);
Client client = extractClient();
assertThat(client.getTransactionStatus()).isEqualTo(TransactionStatus.IDLE);
});
assertThat(this.connection.isAutoCommit()).isTrue();
}
private Client extractClient() {
try {
Field field = io.r2dbc.postgresql.PostgresqlConnection.class.getDeclaredField("client");
field.setAccessible(true);
return (Client) field.get(this.connection);
} catch (ReflectiveOperationException e) {
throw new RuntimeException(e);
}
}
@Test
void rollbackShouldRecoverFromFailedTransaction() {
this.connection.beginTransaction().as(StepVerifier::create).verifyComplete();
this.connection.createStatement("error").execute().flatMap(PostgresqlResult::getRowsUpdated).as(StepVerifier::create).verifyError(R2dbcBadGrammarException.class);
this.connection.rollbackTransaction().as(StepVerifier::create).verifyComplete();
assertThat(this.connection.isAutoCommit()).isTrue();
}
}