Skip to content

SERG-Delft/evosql-demo

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 
 
 

Repository files navigation

EvoSQL demo

Requirements

  • MySQL 5
  • Any MySQL visual tool (e.g., Sequel)

Steps:

  1. Create a MySQL data named 'evosqldemo'

  2. Create these tables:

-- Create syntax for TABLE 'category'
CREATE TABLE `category` (
  `id` int(11) DEFAULT NULL,
  `name` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Create syntax for TABLE 'product'
CREATE TABLE `product` (
  `id` int(11) DEFAULT NULL,
  `name` varchar(500) DEFAULT NULL,
  `manufacturer` varchar(500) DEFAULT NULL,
  `price` double DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  1. Create a evosqldemo user (with evosqldemo password) with privileges to the evosqldemo database.

  2. Open your IntelliJ and configure this project.

Running the examples

  1. Go to the evosql folder.

  2. Run sh run.sh exampleN, where N is the number of the example. There are 4 available in the folder.

    • Example 1: A query with a few conditions (with integers and strings)
    • Example 2: A query with a database-specific function (reverse)
    • Example 3: A query with a JOIN
    • Example 4: A query with a subquery
    • Examples 5, 6: More string functions
  3. Go back to your IDE. A new SQLTestexampleN java file was created in the src/test/java/tutorial folder.

  4. Comment out the calls to createTables() and dropTables(). We don't need them for now.

  5. Run it! Sometimes IntelliJ complains Do not forget to make source level 8. Go to File -> Project Structure, and set the Language Level.

Slides

You can find them here: https://docs.google.com/presentation/d/1QMekg1mUI0sHXM4GR7qw8x4-daoSfhvo28jrPamZ92c/edit?usp=sharing.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published