This sample use PostgreSQL and drop all of its data once run in order to be runnable multiple times.
Sample of how to fully use Zest™ SQL support : SQL Library, SQL EntityStore and SQL Index/Query.
Here are the steps needed to setup the database using the psql utility command:
user@host $ psql postgres postgres=# CREATE USER jdbc_test_login WITH PASSWORD 'password'; CREATE ROLE postgres=# CREATE DATABASE jdbc_test_db; CREATE DATABASE postgres=# GRANT ALL PRIVILEGES ON DATABASE jdbc_test_db TO jdbc_test_login; GRANT postgres=# \q user@host $ psql -d jdbc_test_db</strong> postgres=# CREATE EXTENSION ltree; CREATE EXTENSION postgres=# \q user@host $
A gradle task runSample is defined in this module as a shortcut to run the example. See Build System.