Commit graph

Select branches

Hide pull requests

brmbar3

db-reconnect

deployed

master

py3

sql-refactor

test_cache

Mono Color

• 1d9a2e9fac Fix buy rate updating master TMA 2025-07-26 18:26:59 +02:00
• 54c687edf3 disable slowdown in management for now TMA 2025-07-26 17:12:50 +02:00
• 9afef5bce2 maybe make something faster TMA 2025-07-26 16:57:30 +02:00
• c17aa99666 0024: drop old versions before installing new ones TMA 2025-07-26 16:02:47 +02:00
• c04d4a1f8e 0024: propagate errors in find_*_rate TMA 2025-07-26 15:50:10 +02:00
• 70c46bd950 log all sql statements TMA 2025-07-26 15:15:03 +02:00
• 114e67c445 Merge branch 'master' into deployed deployed Dominik Pantůček 2025-07-21 17:19:06 +02:00
• 8487202b8f Record to columns. Dominik Pantůček 2025-07-21 17:07:50 +02:00
• a1ec2bdb6b Debug raw inventory balance result. Dominik Pantůček 2025-07-21 17:06:13 +02:00
• 7a301379f0 0023: security definer TMA 2025-07-21 17:01:35 +02:00
• 39fe8d97fd Use inventory_balance. Dominik Pantůček 2025-07-21 16:56:50 +02:00
• 2e328e4fb3 0023: stored function for total inventory balance TMA 2025-07-21 16:49:29 +02:00
• 4f9611727b 0022: drop: add cascade TMA 2025-07-21 16:34:28 +02:00
• 3933514e86 Fix Shop keyword arguments. Dominik Pantůček 2025-07-21 15:46:26 +02:00
• 04f98147fd 0022: shop initialization stored procedure TMA 2025-07-21 15:42:53 +02:00
• dde8bd764d Use new shop init interface and black all brmbar/*.py. Dominik Pantůček 2025-07-21 15:42:40 +02:00
• a8e4b3216d Old scripts: mark them deprecated and make them exit with status 1. Dominik Pantůček 2025-07-21 15:02:09 +02:00
• 01491deec3 remove Account._transaction_split and dependents TMA 2025-07-17 17:48:36 +02:00
• 76a484ea5e 0015: find_buy_rate takes currency ID TMA 2025-07-17 17:30:09 +02:00
• f962586e3a Ensure amount in buy_for_cash is integer. Dominik Pantůček 2025-07-17 17:16:31 +02:00
• be0b50fedd Fix i_transaction_id as v_transaction_id elsewhere. TMA 2025-07-17 16:57:42 +02:00
• 95e55aef23 Fix i_transaction_id as v_transaction_id. Dominik Pantůček 2025-07-17 16:50:02 +02:00
• e31165d668 Change to receipt_reimbursement. Dominik Pantůček 2025-07-17 16:47:23 +02:00
• 5d658a7406 Rollback on generic database exceptions. Dominik Pantůček 2025-07-17 16:23:26 +02:00
• f8a265f1d2 0021: constraints on currency columns in database: numbers only TMA 2025-07-17 16:01:27 +02:00
• 6f945c3a0f Fix Shop.py transfer with more arguments. Dominik Pantůček 2025-07-17 15:27:57 +02:00
• 9f63a6760e Fix Shop.py credit -> amount Dominik Pantůček 2025-07-17 15:24:18 +02:00
• ff68817129 Moar transfer logging. Dominik Pantůček 2025-07-17 15:17:18 +02:00
• 1db6a32ceb Merge branch 'master' into deployed Dominik Pantůček 2025-07-12 19:36:48 +02:00
• afb5476c2d o_id -> i_id TMA 2025-07-12 19:11:25 +02:00
• 9d8827ccbd 0010: lookup item currency id Dominik Pantůček 2025-07-12 18:52:21 +02:00
• 8ee51a23d9 account_id -> id TMA 2025-07-12 18:25:24 +02:00
• 81366fd2bb 0010: fix v_transaction_id Dominik Pantůček 2025-07-12 18:04:56 +02:00
• ee2b945299 0010: fix other to user Dominik Pantůček 2025-07-12 17:53:33 +02:00
• 38838692c6 Database: other exceptions Dominik Pantůček 2025-07-12 17:45:06 +02:00
• 557d36cac3 Shop: not array Dominik Pantůček 2025-07-12 17:42:32 +02:00
• 343df879fb Shop: sell log res Dominik Pantůček 2025-07-12 17:40:16 +02:00
• 0a8e2b727b gui: logger Dominik Pantůček 2025-07-12 17:37:17 +02:00
• 829bab66b4 gui: fine-grained logging Dominik Pantůček 2025-07-12 17:35:38 +02:00
• c3abceac5d gui: try logging acct in acct_map better Dominik Pantůček 2025-07-12 17:33:28 +02:00
• f9230ed5bf gui: try logging acct in acct_map Dominik Pantůček 2025-07-12 17:29:08 +02:00
• 93f9b336b6 Shop.py: logging to sell Dominik Pantůček 2025-07-12 17:25:27 +02:00
• 3ab537f7d9 Try logging. Dominik Pantůček 2025-07-12 17:15:22 +02:00
• 4c65f70079 gui: remove old db initialization Dominik Pantůček 2025-07-12 15:57:41 +02:00
• 2ff7165bec gui: pass database configuration as command-line options Dominik Pantůček 2025-07-12 15:55:06 +02:00
• 15dfd0be04 gui: remove old db initialization Dominik Pantůček 2025-07-12 15:57:41 +02:00
• 5355eca6f5 gui: pass database configuration as command-line options Dominik Pantůček 2025-07-12 15:55:06 +02:00
• 3a4aaa74ce 0017: use proper account id argument - not a constant Dominik Pantůček 2025-07-12 15:15:21 +02:00
• cd9b4484c8 Shop.py: python <3.6 compatibility Dominik Pantůček 2025-07-10 16:54:45 +02:00
• 597bca87b5 Schema 0018: fix ac-c-ounts Dominik Pantůček 2025-07-10 16:24:31 +02:00
• 5e348b2463 Schema 0017: fix ac-c-ounts Dominik Pantůček 2025-07-10 16:23:25 +02:00
• 1eff329496 Schema 0017: fix semicolon before return Dominik Pantůček 2025-07-10 16:22:13 +02:00
• f7f137821b Schema 0017: fix into syntax Dominik Pantůček 2025-07-10 16:21:22 +02:00
• 3b0cb6472d Schema 0011: fix type inference for id Dominik Pantůček 2025-07-10 16:19:25 +02:00
• fba614de78 Schema 0010: fix type inference for id Dominik Pantůček 2025-07-10 16:18:39 +02:00
• ae16ebc51f Schema 0009: fix type inference for id Dominik Pantůček 2025-07-10 16:17:34 +02:00
• 903cc8f4d7 Schema 0009: fix select into Dominik Pantůček 2025-07-10 16:15:19 +02:00
• 8d2c9cb20f Schema 0009: fix DDL statements ends, fix argument delimiters in second procedure as well Dominik Pantůček 2025-07-10 16:05:19 +02:00
• a8a124835c Schema 0009: fix find_buy_rate arguments syntax Dominik Pantůček 2025-07-10 16:00:28 +02:00
• 0bff27da29 test reimplementation of brmbar.Currency.rates method TMA 2025-04-22 00:00:38 +02:00
• f0058aad68 #18: stored function for "fixing cash" transaction TMA 2025-04-21 21:14:34 +02:00
• c21b394b42 #17: stored function for "fixing" inventory transaction TMA 2025-04-21 21:14:18 +02:00
• 69c405f715 #20: stored function for undo transaction TMA 2025-04-21 19:56:39 +02:00
• c8892f825c cosmetic TMA 2025-04-21 19:56:15 +02:00
• 96027ca66a #19: stored function for "consolidation" transaction TMA 2025-04-21 19:49:07 +02:00
• aad79dafa6 fix bugs in schema version checking TMA 2025-04-21 18:45:00 +02:00
• 1df7db93e7 #16: stored function for receipt reimbursement transaction TMA 2025-04-21 18:36:50 +02:00
• 629b35655d #15: stored function for cash-based stock replenishment transaction TMA 2025-04-21 18:23:11 +02:00
• ad832fc71b #14: stored function for "credit" transfer transactions TMA 2025-04-21 17:45:40 +02:00
• e15f1646ce #13: stored function for cash withdrawal transactions TMA 2025-04-21 17:35:03 +02:00
• 7b11a8c954 #12 - stored function for cash deposit transactions - remove duplicate fn TMA 2025-04-21 17:30:57 +02:00
• f0cd8361d1 #12 - stored function for cash deposit transactions TMA 2025-04-21 17:23:24 +02:00
• 7ed7417492 schema 0010: fix header id TMA 2025-04-21 17:06:42 +02:00
• 028d4d98db #11: stored function for sale undo transaction TMA 2025-04-21 17:06:21 +02:00
• deb3faa717 minor fixes in schemata 0009 and 0010 TMA 2025-04-21 12:27:29 +02:00
• 4c7012c517 #10: stored function for cash sell transaction TMA 2025-04-21 12:22:22 +02:00
• cef95c4313 #9: stored function for sell transaction TMA 2025-04-20 23:43:52 +02:00
• aded7a5769 #8: stored function to update currency buy rate Dominik Pantůček 2025-04-20 19:27:02 +02:00
• 66870bbc8c #7: migrate to stored function for updating currency sell rate. Dominik Pantůček 2025-04-20 19:22:19 +02:00
• 9235607d4c #6: new currency stored function Dominik Pantůček 2025-04-20 19:15:23 +02:00
• 8f42145bee #5: rename account stored function Dominik Pantůček 2025-04-20 18:00:40 +02:00
• 58ab1d00be #4: add account to barcode stored procedure. Dominik Pantůček 2025-04-20 17:55:18 +02:00
• c5d1fc3402 #3: create account in SQL not in Python. Dominik Pantůček 2025-04-20 17:42:12 +02:00
• 111a8c9b63 #2: add trading account type type and fix schema migrations machinery Dominik Pantůček 2025-04-20 17:11:49 +02:00
• c04f934340 #1: add initial SQL schema as the database currently in use Dominik Pantůček 2025-04-20 17:01:05 +02:00
• 40f4abe37f Merge branch 'sql-refactor' TMA 2025-04-20 14:51:32 +02:00
• fb206b0c9f attempt to update for python3 py3 TMA 2025-04-20 14:50:32 +02:00
• 900264469a schema v2 setup script sql-refactor TMA 2025-04-20 10:13:31 +02:00
• f6ec2be215 schema v1 setup script TMA 2025-04-19 22:44:01 +02:00
• 3000731ac7 SQL schema v002 script part 1 TMA 2025-04-11 20:56:17 +02:00
• 2f601a0b1a functions for querying sequence values for read only access TMA 2025-04-11 13:39:07 +02:00
• 5f9292fd02 Merge code from deployed production version TMA 2025-03-30 20:58:03 +02:00
• e04d614e15 uncommitted changes from other people... again TMA 2025-03-30 20:55:00 +02:00
• dbd3835dfb fixed NaN issue in withdraw/charge niekt0 2024-01-30 20:18:07 +01:00
• 6749b2c97a autostock.py brmbar 2018-04-02 01:46:01 +02:00
• a1c37cb695 brmbar-cli: restock by EAN (for automated restocking) brmbar 2018-04-02 01:41:24 +02:00
• f061cc7f7b gitignore brmbar 2018-04-02 01:41:02 +02:00
• 6f3fc6767a db purge howto brmbar 2018-04-02 01:40:46 +02:00
• e2e6632df0 sample crontab file brmbar 2018-04-02 01:40:37 +02:00
• 1f3f1cdd8f disable exchange rate and balance in StockMgmt because of unbearable slowdown brmbar 2016-08-19 04:37:04 +02:00