Skip to content

agusalex/Notarius

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

74 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Notarius - Clients and Operations CRUD with Levenshtein distance search

. Docker Hub package

Using Levenshtein distance prediction algorithm for the search bar. Vaadin as the frontend/backend and H2 for database (can also use MySQL/MariaDB see Parameters section )

Running the project:

You'll need Docker installed

docker run -e DEBUG=true -p 8080:8080/tcp agusalex/notarius

image

Building the project:

You'll need Docker and Maven installed

mvn clean build
docker build -t "notarius" .
docker run -e DEBUG=true -p 8080:8080/tcp notarius

Container Parameters

Parameter Value Example
DEBUG If this is SET it uses internal H2 DB true
URL The URL of the external DB (if DEBUG = FALSE) 127.0.0.1:3306
URL The URL of the external DB (if DEBUG = FALSE) 127.0.0.1:3306
USER The USER of the external DB (if DEBUG = FALSE) root
PASS The PASSWORD of the external DB (if DEBUG = FALSE) root

Exporting DB:

call CSVWRITE ( 'C:/MyFolder/11-7-17.txt', 'SELECT * FROM OPERACION' ) 

SELECT * FROM PERSONAS insert into PERSONAS select * from 
(SELECT * FROM CSVREAD('C:https://ESD/personas.txt'));

CREATE TABLE OPERACION2 AS SELECT * FROM CSVREAD('C:https://ESD/test.txt')
insert into OPERACION
    select * from OPERACION2;