Skip to content

Java implementation of a interpreter of Database with select,update,delete,insert from Txt data.

Notifications You must be signed in to change notification settings

angelfsepulveda/pseudo_database_gestor

Repository files navigation

Pseudo Database Gestor custom implementation in Java

This project use Java and its a custom implementation of MYSQL queries

Pre-requirements 📋

Libs for test

hamcrest-core-1.3.jar
junit-4.13-beta-3.jar

It can perform queries like selects, with where or without where, update, delete, and select with alias and a simple insert:

It accepts > , != , < , =
Some examples
Note: you can specify the PATH but this project was build in intellij IDEA, so the txts are in the same path as the project
Note: The alias only work with "=" because of lack of time for the implementation, because this was a project for university
  • select * from pruebas ; - where pruebas is the name of the .txt and its not necessary the ; in the query
  • Select Nombre from pruebas where Nombre!=Rebeca
  • update pruebas set Matricula=1 where Nombre=Rebeca
  • delete from pruebas where Matricula<1730042
  • delete from pruebas where Matricula>1730042
  • select pruebas.Nombre as pruebas, pruebas1.Matricula as pruebas1 from pruebas,pruebas1 where pruebas.Matricula=pruebas1.Matricula
  • insert into pruebas (Nombre,Matricula) values("Test",100)

It read a txt with information with "," as a data separator and ";" as a separator for the label in the first line

example from pruebas.txt:
Nombre ApellidoP ApellidoM Matricula;
Rebeca,Gonzalez,Batista,1730042
Angel,Sepulveda,Lozada,1430382

About

Java implementation of a interpreter of Database with select,update,delete,insert from Txt data.

Topics

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages