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
• JDK17 or higher
• Docker

Run MySQL database using docker with:

./mysql.sh

Build the application:

mvn clean install

Then run it with:

java -jar target/legacy-search-9.2-SNAPSHOT.jar

Or directly run from Maven:

mvn clean spring-boot:run

Note that while developing, you would probably prefer running LegacySearchApp#main() from your IDE to get hot reload of the application.

Play!

Some CRUD operations

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

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

# Update full document
curl -XPUT http://127.0.0.1:8080/api/1/person/1 -H "Content-Type: application/json" -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

# Check (you should get a 404 error)
curl 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"

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

Next step

Look at branch 01-direct