SQL Support Sample

Note

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.