History

Bernd Verst 9095b0e7e7 Switch to Go 1.21, Updates linter, updates workflows, adds sarama 1.42.1 (#3251 ) Signed-off-by: Bernd Verst <github@bernd.dev>		2023-11-28 18:13:09 -08:00
..
components/standard	Add Azure AD support to Postgres configuration store and bindings (#2971 )	2023-07-12 15:03:18 -07:00
README.md	Postgres binding: support parametrized queries (#2972 )	2023-07-12 22:34:14 +00:00
config.yaml	Added certification tests for postgres output binding	2022-09-12 15:17:44 -07:00
docker-compose.yml	Add Azure AD support to Postgres configuration store and bindings (#2971 )	2023-07-12 15:03:18 -07:00
postgres_test.go	Switch to Go 1.21, Updates linter, updates workflows, adds sarama 1.42.1 (#3251 )	2023-11-28 18:13:09 -08:00

PostgreSQL Output Binding Certification

The purpose of this module is to provide tests that certify the PostgreSQL Output Binding as a stable component.

Test plan

Verify the postgres is created/present
- Create component spec
- Run dapr application with component
- Ensure the postgres is present
Verify the connection is established to postgres.
- Create component spec.
- Run dapr application with component.
- Ensure that you have access to postgres and connection to postgres DB is established.
Verify data is getting stored in postgres DB.
- Create component spec with the data to be stored.
- Run dapr application with component to store data in postgres as output binding.
- Read stored data from postgres.
- Ensure that read data is same as the data that was stored.
- Verify the ability to use named paramters in queries.
Verify reconnection to postgres for output binding.
- Simulate a network error before sending any messages.
- Run dapr application with the component.
- After the reconnection, send messages to postgres.
- Ensure that the messages sent after the reconnection are stored in postgres.