Changeset ef1c1c7 for docs/P3-UseCaseModel/UseCase0004.md

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

File:

• docs/P3-UseCaseModel/UseCase0004.md (modified) (3 diffs)

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.