Skip to content

README.md

Latest commit

 

History

History
41 lines (29 loc) · 1.24 KB

README.md

File metadata and controls

41 lines (29 loc) · 1.24 KB

Tutorial: Querying relational Databases

This folder contains the sample application written as part of the Querying MySQL tutorial.

SQL Scripts

To provision the necessary Products table, use the following SQL command:

CREATE TABLE IF NOT EXISTS Products (
  Id varchar(36) PRIMARY KEY,
  Name TEXT NOT NULL,
  Price DOUBLE PRECISION
);

Use the following SQL commands to seed sample data:

INSERT INTO Products (Id, Name, Price)
SELECT 'faac630e-a645-4459-9d7e-751df4016a6e', 'V-Neck T-Shirt', 19.99
WHERE NOT EXISTS (SELECT Id FROM Products WHERE Id = 'faac630e-a645-4459-9d7e-751df4016a6e');

INSERT INTO Products (Id, Name, Price)
SELECT 'c01dce8a-3a50-4ef6-a0f1-7f9f48a238c8', 'Hoodie with Logo', 79.99
WHERE NOT EXISTS (SELECT Id FROM Products WHERE Id = 'c01dce8a-3a50-4ef6-a0f1-7f9f48a238c8');

INSERT INTO Products (Id, Name, Price) 
SELECT '6f062dc2-bbf2-4c6c-8169-3511462cd54b', 'Belt', 14.99
WHERE NOT EXISTS (SELECT Id FROM Products WHERE Id = '6f062dc2-bbf2-4c6c-8169-3511462cd54b');

Building the Spin Application

Once you've cloned the repository, move into the tutorial folder (./tutorials/mysql-tutorial) and run spin build:

cd tutorials/mysql-tutorial
spin build