github.com/Goboolean/common@v0.0.0-20231130153141-cb54596b217d/api/sql/queries.sql (about) 1 -- name: CreateAccessInfo :exec 2 INSERT INTO store_log (product_id, "status") VALUES ($1, $2); 3 4 5 -- name: InsertNewStockMeta :exec 6 INSERT INTO product_meta (id, "name", symbol, "description", "type", exchange, "location") 7 VALUES ($1, $2, $3, $4, $5, $6, $7); 8 9 -- name: InsertNewStockPlatformMeta :exec 10 INSERT INTO product_platform (product_id, platform_name, identifier) 11 VALUES ($1, $2, $3); 12 13 14 -- name: CheckStockExist :one 15 SELECT EXISTS(SELECT 1 FROM product_meta WHERE id = ($1)); 16 17 -- name: GetStockMeta :one 18 SELECT id, "name", symbol, "description", "type", exchange, "location" FROM product_meta WHERE id = ($1); 19 20 -- name: GetAllStockMetaList :many 21 SELECT id, "name", symbol, "description", "type", exchange, "location" FROM product_meta; 22 23 -- name: GetStockMetaWithPlatform :one 24 SELECT product_meta.id, "name", symbol, "description", "type", exchange, "location" , platform_name, identifier 25 FROM product_meta 26 JOIN product_platform 27 ON product_meta.id = product_platform.product_id 28 WHERE product_meta.id = ($1); 29 30 -- name: UpdatePlatformIdentifier :exec 31 UPDATE product_platform SET identifier = ($1) WHERE product_id = ($2) AND platform_name = ($3); 32 33 -- name: DeletePlatformInfo :exec 34 DELETE FROM product_platform WHERE product_id = ($1) AND platform_name = ($2); 35 36 -- name: InsertPlatformInfo :exec 37 INSERT INTO product_platform (product_id, platform_name, identifier) VALUES ($1, $2, $3); 38 39 -- name: GetStockIdBySymbol :one 40 SELECT id FROM product_meta WHERE symbol = ($1);