Skip to content

Latest commit

 

History

History

postgresql-tutorial

README.md

Tutorial: Querying PostgreSQL

This folder contains the sample application written as part of the Querying PostgreSQL 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/postgresql-tutorial) and run spin build:

cd tutorials/postgresql-tutorial
spin build