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);