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