Zest™
Introduction
Tutorials
Javadoc
Samples
Core
Libraries
Extensions
Tools
Glossary 

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.

Browse Source

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.