Update buy_order() - Githubissues

Main Changes:

Added sell_stock(), buy_stock(), resolve_price_diff(),escrow_buy(), and delete_processed_order() to supabase_middleman.py
- buy_stock() function creates a entry in a user's portfolio table for the given table if they don't own it yet
Refactored buy_order.py to handle orders that have different prices using the functions above
Logs orders in active_buy_sell if market is closed or there are no valid sell orders
Removed fetch_portfolio(), fetch_profile(), and exchange_stock() from supabase_middleman.py
Fixed a potential bug with is_market_open() in supabase_middleman.py (It was returning the row of the table not the actual boolean value)

New Changes Since Initial Commits

Included an if statement in buy_order.py that handles the test case where buy & sell prices are equal, but not at the current market price
Implemented a for loop to handle >1 quantity orders
Implemented uuidv4 order ID's on the test order entries in test_data.py so >1 quantity orders can be identified/grouped

Post Review Changes

Optimized code so less supabase API calls are made within the for loop
Refactored order ID declarations to be more understandible
Created stored SQL procedures on supabase that are called via supabase.rpc() in supabase_middleman.py to improve thread safety

Latest commit:	`3717663`
Status:	✅ Deploy successful!
Preview URL:	https://92120b8d.atx-6fn.pages.dev
Branch Preview URL:	https://order-processing.atx-6fn.pages.dev

AtriEx / ATX