Changeset ef1c1c7 for docs/P3-UseCaseModel

Timestamp:

09/24/26 17:43:19 (5 days ago)

Author:

Stefan <trsunovstefan@…>

Branches:

main

Children:

0cee8ec

Parents:

a531b45

Message:

Wiki docs, phase 6 and phase 7 added

Location:

docs/P3-UseCaseModel

Files:

• UseCase0004.md (modified) (3 diffs)
• UseCase0005.md (modified) (1 diff)
• UseCase0007.md (modified) (2 diffs)
• wiki/UseCase0001.md (added)
• wiki/UseCase0002.md (added)
• wiki/UseCase0003.md (added)
• wiki/UseCase0004.md (added)
• wiki/UseCase0005.md (added)
• wiki/UseCase0006.md (added)
• wiki/UseCase0007.md (added)
• wiki/UseCaseModel.md (added)
• wiki/UseCaseModelAIUsage.md (added)

docs/P3-UseCaseModel/UseCase0004.md

@@ -10 +10 @@
 
 1. Trader chooses "Place market BUY order".
-2. System lists the available markets with their latest price:
+2. System lists the active markets, numbered, with their latest price:
 
    ```sql
-   SELECT m.id, c.symbol, m.quote_currency, COALESCE(lp.price, 0)
+   SELECT m.id, c.id, c.symbol, m.quote_currency,
+          COALESCE(lp.price, 0) AS price
      FROM project.markets m
      JOIN project.crypto  c  ON c.id = m.crypto_id
@@ -20 +21 @@
     ORDER BY c.symbol;
    ```
-3. Trader enters a market symbol, e.g. `ETH`.
-4. System resolves the market and looks up the latest price:
+3. Trader picks the market by its number in the listed markets, e.g. `2` (BTC).
+4. System takes the chosen row's market id and crypto id from the list (no lookup by
+   symbol) and looks up the latest price:
 
    ```sql
-   SELECT m.id, c.id AS crypto_id, c.symbol, m.quote_currency
-     FROM project.markets m
-     JOIN project.crypto c ON c.id = m.crypto_id
-    WHERE upper(c.symbol) = upper($1) AND m.is_active = true;
-
-   SELECT price FROM project.v_latest_prices WHERE market_id = $2;
+   SELECT price FROM project.v_latest_prices WHERE market_id = $1;
    ```
 5. Trader enters a quantity.
@@ -91 +88 @@
 If `available_balance < notional`, the entire transaction rolls back and system shows "Insufficient funds: need X, have Y."
 
-### Alternate flow 4a — market not found
+### Alternate flow 3a — number not in the list
 
-If the entered symbol does not match any active market, system shows "market X not found" and returns to the authenticated menu without opening a transaction.
+If the entered number is not one of the listed market numbers, system shows "Invalid choice, enter a number from 1 to N." and returns to the authenticated menu without opening a transaction.

docs/P3-UseCaseModel/UseCase0005.md

@@ -26 +26 @@
 
 1. Trader chooses "Place market SELL order".
-2. System lists markets (same SQL as UC0004 step 2).
-3. Trader enters market symbol and quantity.
-4. System resolves the market and looks up the latest price (same SQL as UC0004 step 4).
+2. System lists, numbered, the Trader's holdings that still have a quantity free to
+   sell (not reserved by an open sell order), with the quantity held, the free
+   quantity and the latest price:
+
+   ```sql
+   SELECT m.id, c.id, c.symbol, m.quote_currency,
+          h.quantity, h.quantity - h.reserved_quantity AS free,
+          COALESCE(lp.price, 0) AS price
+     FROM project.holdings h
+     JOIN project.crypto  c ON c.id = h.crypto_id
+     JOIN project.markets m ON m.crypto_id = c.id AND m.is_active = true
+     LEFT JOIN project.v_latest_prices lp ON lp.market_id = m.id
+    WHERE h.user_id = $1
+      AND h.quantity - h.reserved_quantity > 0
+    ORDER BY c.symbol;
+   ```
+3. Trader picks the holding by its number in the listed holdings, e.g. `2` (ETH), and
+   enters the quantity.
+4. System takes the chosen row's market id and crypto id from the list (no lookup by
+   symbol) and looks up the latest price:
+
+   ```sql
+   SELECT price FROM project.v_latest_prices WHERE market_id = $1;
+   ```
 5. System opens a transaction:
 

docs/P3-UseCaseModel/UseCase0007.md

@@ -40 +40 @@
 ### Add a crypto
 
+The Trader picks the crypto by its number from the listed cryptos that are not on the watchlist yet:
+
 ```sql
--- 1. resolve the symbol to a crypto_id
-SELECT id FROM project.crypto WHERE upper(symbol) = upper($1);
+-- 1. list, numbered, the cryptos not yet on the watchlist
+SELECT c.id, c.symbol, c.name
+  FROM project.crypto c
+ WHERE NOT EXISTS (SELECT 1 FROM project.watchlist_items wi
+                    WHERE wi.watchlist_id = $1 AND wi.crypto_id = c.id)
+ ORDER BY c.symbol;
 
--- 2. insert the item; do nothing if it's already there
+-- 2. insert the chosen crypto ($2 = its id from the list); do nothing if it's already there
 INSERT INTO project.watchlist_items (watchlist_id, crypto_id)
-VALUES ($watchlist_id, $crypto_id)
+VALUES ($1, $2)
 ON CONFLICT (watchlist_id, crypto_id) DO NOTHING;
 ```
@@ -52 +58 @@
 ### Remove a crypto
 
+The Trader picks the crypto by its number from the listed cryptos on the watchlist:
+
 ```sql
+-- 1. list, numbered, the cryptos on the watchlist
+SELECT c.id, c.symbol, c.name
+  FROM project.watchlist_items wi
+  JOIN project.crypto c ON c.id = wi.crypto_id
+ WHERE wi.watchlist_id = $1
+ ORDER BY c.symbol;
+
+-- 2. delete the chosen crypto ($2 = its id from the list)
 DELETE FROM project.watchlist_items
- WHERE watchlist_id = $1
-   AND crypto_id = (
-       SELECT id FROM project.crypto
-        WHERE upper(symbol) = upper($2)
-   );
+ WHERE watchlist_id = $1 AND crypto_id = $2;
 ```
 
-If the delete affects zero rows, system shows "Not in watchlist."
+If the entered number is not one of the listed numbers, system shows "Invalid choice, enter a number from 1 to N." and nothing is changed.