Labels Milestones

New issue

SQL schema modernization + transactional business logic

• Modernize schema to support versioning
• Modernize schema to support currency trading accounts (like Gnucash)
• Wrap business logic into stored procedures

17

To Do

migrate to stored function: Account.py:41:create_account

#3 by tma was closed 2025-04-20 17:42:28 +02:00

migrate to stored function: Account.py:70:add_barcode

#4 by tma was closed 2025-04-20 17:55:46 +02:00

migrate to stored function: Account.py:74:rename

#5 by tma was closed 2025-04-20 18:00:49 +02:00

migrate to stored function: Currency.py:32:create

#6 by tma was closed 2025-04-20 19:15:47 +02:00

migrate to stored function: Currency.py:71:update_sell_rate

#7 by tma was closed 2025-04-20 19:27:18 +02:00

migrate to stored function: Currency.py:73:update_buy_rate

#8 by tma was closed 2025-04-20 19:27:24 +02:00

migrate to stored function: Shop.py:27:sell

#9 by tma was closed 2025-04-20 23:51:46 +02:00

migrate to stored function: Shop.py:41:sell_for_cash (only different description)

#10 by tma was closed 2025-04-21 12:28:22 +02:00

migrate to stored function: Shop.py:55:undo_sale

#11 by tma was closed 2025-04-21 17:07:08 +02:00

migrate to stored function: Shop.py:69:add_credit

#12 by tma was closed 2025-04-21 17:26:48 +02:00

migrate to stored function: Shop.py:75:withdraw_credit

#13 by tma was closed 2025-04-21 17:38:16 +02:00

migrate to stored function: Shop.py:81:transfer_credit

#14 by tma was closed 2025-04-21 17:45:56 +02:00

migrate to stored function: Shop.py:85:buy_for_cash

#15 by tma was closed 2025-04-21 18:23:34 +02:00

migrate to stored function: Shop.py:97:receipt_to_credit

#16 by tma was closed 2025-04-21 18:37:12 +02:00

migrate to stored function: Shop.py:160:fix_inventory

#17 by tma was closed 2025-04-21 21:14:56 +02:00

migrate to stored function: Shop.py:186:fix_cash

#18 by tma was closed 2025-04-21 21:15:05 +02:00

migrate to stored function: Shop.py:206:consolidate

#19 by tma was closed 2025-04-21 19:49:27 +02:00

3

In Progress

SQL schema versioning

#1 by tma was closed 2025-04-20 17:01:55 +02:00

add currency trading account to account type type

#2 by tma was closed 2025-04-20 17:12:53 +02:00

migrate to stored function: Shop.py:221:undo

#20 by tma was closed 2025-04-21 19:56:53 +02:00

0

Done

0

Uncategorized