assertj / assertj/assertj-db

How to check value on a Postgres JsonB field?

Abierto
#101 3 comentarios 0 reacciones 1 asignado Reclamado por @VanRoy Ver en GitHub
enhancement question
Lenguaje dominante
Java
Estrellas
130
Forks
21
Métricas de merge de PR
Sin PR fusionados en 30 d

Descripción

I trying to check the values inserted on a table where a field is of the type `jsonb`.

When I run something like this:
```java
assertThat(eventsTable)
.row(0)
.value("data").isEqualTo("{\"key\": \"value\"}");
```
I get the following error:
```
[Value at index 0 (column name : DATA) of Row at index 0 of events table]
Expecting:
<{"key": "value"}>
to be of type
<[TEXT, NUMBER, DATE, TIME, DATE_TIME, UUID]>
but was of type
(org.postgresql.util.PGobject)
```

Here is the table content:
```
[events table]
|-----------|---------|-------------------------------------------------------|
| | | |
| | PRIMARY | DATA |
| | KEY | (NOT_IDENTIFIED : class org.postgresql.util.PGobject) |
| | | Index : 0 |
|-----------|---------|-------------------------------------------------------|
| Index : 0 | | {"key": "value"} |
|-----------|---------|-------------------------------------------------------|
```
Using assertj-db 2.0.0

Is there any way I can check the content of a PostgreSQL `jsonb` column?

Guía de contribución

Abrir la guía de contribución

Evaluación

Este issue todavía no se ha evaluado.

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.