Commit graph

3860 commits

Author SHA1 Message Date
Lance Edgar f198726f2c Update changelog 2023-02-24 20:03:36 -06:00
Lance Edgar 589acf6f1b Fix bug when receiving from PO + invoice, w/ multi-lines per item
when overlaying the invoice data onto the batch (first populated from
PO), and multiple rows match a given invoice line item, it was always
returning the first match.  now tries to match on quantity too
2023-02-24 19:55:48 -06:00
Lance Edgar 41c54227da Update changelog 2023-02-22 21:59:42 -06:00
Lance Edgar 87a1153969 Add table for tracking sample vendor files
always need a place to keep track of these since formats can change
over time; might as well track directly in the app
2023-02-22 21:58:20 -06:00
Lance Edgar ea3eede450 Use versioning workaround when populating purchase batch 2023-02-22 12:49:18 -06:00
Lance Edgar 738c973a27 Modify ORM backrefs for BatchRow/Product, per SA 2.0 warnings 2023-02-22 12:04:50 -06:00
Lance Edgar 2eff397395 Modify ORM backrefs for User/Role, per SA 2.0 warnings 2023-02-21 20:42:40 -06:00
Lance Edgar 4e4bcbeaf3 Update changelog 2023-02-20 21:49:28 -06:00
Lance Edgar e058bbce9e Avoid import error when setting Email.model attr 2023-02-17 13:24:00 -06:00
Lance Edgar e50961288e Avoid/delay import in case SQLAlchemy not installed 2023-02-17 13:21:42 -06:00
Lance Edgar 90b9591bdf Avoid/delay import for cache_model()
in case SQLAlchemy is not installed
2023-02-17 13:19:25 -06:00
Lance Edgar 49f4a0bd1a Avoid import error when setting EmailHandler.model attr 2023-02-17 13:16:36 -06:00
Lance Edgar 8833fb8643 Declare cache_ok = True for custom SQL data types
per SA 1.4, cf.
https://docs.sqlalchemy.org/en/14/core/custom_types.html#sqlalchemy.types.TypeDecorator.cache_ok
2023-02-14 17:29:16 -06:00
Lance Edgar 66e78456dd Deprecate the get_product_by_upc() "api" function 2023-02-14 17:28:25 -06:00
Lance Edgar d594b1c706 Remove unused find_products_by_key() method from ProductHandler 2023-02-14 16:40:25 -06:00
Lance Edgar 10ea436c46 Update changelog 2023-02-12 12:14:41 -06:00
Lance Edgar c463d4d086 Avoid engine.execute() and use sa.text(sql) for literals 2023-02-12 12:10:29 -06:00
Lance Edgar f57b187497 Fix error when normalizing product 2023-02-12 11:52:18 -06:00
Lance Edgar 8d8fb8ed2a Update changelog 2023-02-12 10:03:35 -06:00
Lance Edgar aa72861fcd More refactoring, Query.get() => Session.get() 2023-02-12 09:32:37 -06:00
Lance Edgar 6d388044ce Stop running tests for python 3.5; also run for 3.9 2023-02-12 09:28:01 -06:00
Lance Edgar af807063a8 Refactor Query.get() => Session.get() per SQLAlchemy 1.4 2023-02-11 21:54:47 -06:00
Lance Edgar f46fb3aa20 Officially require SQLAlchemy 1.4.x
drop support for 1.3.x, not yet ready to support 1.5.x
2023-02-11 20:11:41 -06:00
Lance Edgar b122a2fe0d Update changelog 2023-02-11 10:16:25 -06:00
Lance Edgar e3befbb395 Fix typo 2023-02-11 10:16:04 -06:00
Lance Edgar 5376d40ccf Update changelog 2023-02-11 09:59:08 -06:00
Lance Edgar 2eb2eaf92b Add property for Person.user
too many references to the old relationship still in the wild...
2023-02-11 09:58:30 -06:00
Lance Edgar 9a40e2bec7 Update changelog 2023-02-11 07:47:44 -06:00
Lance Edgar 7ced9181a6 Remove reference to old Person.user relationship 2023-02-11 07:46:51 -06:00
Lance Edgar 6e2ccef01b Update changelog 2023-02-10 20:23:55 -06:00
Lance Edgar 477797503c Fix error handler bug 2023-02-10 10:18:04 -06:00
Lance Edgar 33b569bfa2 Only make "missing" credits for purchase batch, when product is known 2023-02-09 12:15:14 -06:00
Lance Edgar ec95805e79 Avoid error when borg create exits with code 1
per docs, that signifies "warning" only and not "error"
2023-02-09 11:16:30 -06:00
Lance Edgar 7304eaff59 Do not cache label printer, formatter
the label handler may be long-lived and so must avoid cache to reflect
changes made in real-time
2023-02-08 20:18:17 -06:00
Lance Edgar a6ac2fe305 Address a warning from SQLAlchemy for declarative_base
as of 1.4 that has moved
2023-02-08 10:56:10 -06:00
Lance Edgar 2d3a62fa9c test commit for buildbot hook 2023-02-07 21:57:59 -06:00
Lance Edgar b8ef605c90 Remove python2 stuff from tox.ini
thankfully no reason to test that anymore
2023-02-07 21:01:23 -06:00
Lance Edgar e5110f240e Avoid deprecated SessionExtension for newer SQLAlchemy
we already use a different mechanism so just need to avoid the older
logic when 1.4+ is in use
2023-02-07 12:45:42 -06:00
Lance Edgar 85c72d5704 Bump version cap for SQLAlchemy to 1.4.x
hopefully can jump ahead further soon, but let's make sure all dust
has settled on this jump first

had to adjust some relationships to avoid FK "overlap" - cf. also
https://docs.sqlalchemy.org/en/14/errors.html#error-qzyx
2023-02-07 12:17:47 -06:00
Lance Edgar d7c35295ae Update changelog 2023-02-04 17:31:29 -06:00
Lance Edgar 7c423c0d7f Fix bytes vs. string issue for mailmon on python3 2023-02-04 17:20:14 -06:00
Lance Edgar bcd54bb8b6 Update changelog 2023-02-03 17:37:40 -06:00
Lance Edgar e56cbfcc94 Avoid error when fetching all upgrade systems
this logic is invoked when showing the Upgrades listing in tailbone,
so do not want error there unless something "really" wrong
2023-02-03 15:17:15 -06:00
Lance Edgar 553709f630 Officially drop support for python2 2023-02-02 23:21:15 -06:00
Lance Edgar f47174b91b Update changelog 2023-02-02 16:50:29 -06:00
Lance Edgar 2a97439607 Tweaks to email bounce handler per python3 2023-02-01 11:54:34 -06:00
Lance Edgar a12ba8fccd Update changelog 2023-01-30 21:05:02 -06:00
Lance Edgar 863a3b7fcf Expose sale/tpr/current prices when normalizing product 2023-01-29 18:45:30 -06:00
Lance Edgar dc7ff54739 Add basic aggregation support for receiving multiple invoices
i.e. merge duplicated products into a single row
2023-01-29 12:44:44 -06:00
Lance Edgar 10bf202029 Update changelog 2023-01-25 15:16:22 -06:00