search

AtriEx / ATX

10 stars 1 forks source link

admin flow: adding a new stock to the market #70

Closed Sovamorco closed 3 months ago

Sovamorco commented 3 months ago

create a postgres trigger to create a new stock for the market. Needs to create a new entry in the stock info table and a starting entry in the stock price table. Currently, starting price is 10.

Imported from trello Members: flonc Attachments:

Image Image

Sovamorco commented 3 months ago

Imported from trello Original author: flonc

Created trigger new_stock_info which triggers the function create_stock_price_and_history. Had to change stock_price_history_daily to delete if the record in stock_info got deleted - unsure if it was intentionally not like this.