Add Search to Legacy Application

Introduction

This is a demo project to show how to add elasticsearch to a legacy SQL project.

In this branch, you will find the current legacy version of the project.

Installation

You need to have:

• Maven
• JDK8 or higher
• Postgresql or MySQL 5.7+ up and running

Modify src/main/resources/hibernate.cfg.xml file to reflect your own database settings:

<!-- Database connection settings - postgresql -->
<property name="hibernate.connection.driver_class">org.postgresql.Driver</property>
<property name="hibernate.connection.url">jdbc:postgresql://localhost:5432/dpilato</property>
<property name="hibernate.connection.username">dpilato</property>
<property name="hibernate.connection.password"></property>
<property name="hibernate.dialect">org.hibernate.dialect.PostgreSQL9Dialect</property>

or

<!-- Database connection settings - MySQL -->
<property name="hibernate.connection.driver_class">com.mysql.cj.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://127.0.0.1:3306/person?serverTimezone=UTC&amp;useSSL=false</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password"></property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQL57Dialect</property>

If you did not create your database yet, just run:

# Postgresql
createdb person
# MySQL
mysqladmin -uroot create person

Start the server using jetty

mvn clean install
mvn jetty:run

Note that while developing, you would probably prefer running LegacySearchApp#main() which will scan your modification and will perform hot reload.

Play!

Some CRUD operations

# Create one person
curl -XPUT http://127.0.0.1:8080/api/1/person/1 -d '{"name":"David Pilato"}'

# Read that person
curl http://127.0.0.1:8080/api/1/person/_byid/1

# Update full document
curl -XPUT http://127.0.0.1:8080/api/1/person/1 -d '{"name":"David Pilato", "children":3}'

# Check
curl http://127.0.0.1:8080/api/1/person/1

# Delete
curl -XDELETE http://127.0.0.1:8080/api/1/person/1

Database Initialisation

# Initialize the database with 1 000 (default) or 10 000 persons
curl http://127.0.0.1:8080/api/1/person/_init
curl http://127.0.0.1:8080/api/1/person/_init?size=10000

Search

# Search for something (`a la google`)
curl "http://127.0.0.1:8080/api/1/person/_search?q=Joe&from=0&size=10"

You can then access the application using your browser: http://127.0.0.1:8080/. You can also look at advanced search.

RestX provides as well its own interface: http://127.0.0.1:8080/api/@/ui/. Default login / password are: admin / juma.

Next step

Look at branch 01-direct