Commit graph

137 commits

Author SHA1 Message Date
Lance Edgar 0d81a41b54 Add User model for office_op 2021-09-07 15:45:51 -05:00
Lance Edgar 69c7be6356 Update changelog 2021-08-31 22:42:22 -05:00
Lance Edgar 092884eab3 Add lane_op model for Department 2021-08-31 22:40:58 -05:00
Lance Edgar 07e3c62b6c Update changelog 2021-08-02 09:07:50 -05:00
Lance Edgar e4c46b3fa4 Add schema for TableSyncRules 2021-08-02 08:56:05 -05:00
Lance Edgar b4a07f9875 Update changelog 2021-07-21 20:17:56 -05:00
Lance Edgar 178acdac31 Add basic 'lane_op' DB schema
just the 'products' table so far
2021-07-21 20:02:17 -05:00
Lance Edgar 0d3d007bd1 Update changelog 2021-06-11 18:04:42 -05:00
Lance Edgar 170f0a769a Remove duplicated column name 2021-05-07 11:12:44 -05:00
Lance Edgar d94189c404 Add FK constraint for ProductLikeCode.upc
not sure why that wasn't already present?
2021-05-04 20:10:14 -05:00
Lance Edgar b40fbf7cab Add the Product.complete_size convenience attribute
also define `str(VendorItem)`
2021-02-15 12:59:21 -06:00
Lance Edgar 7cf4ec1295 Fetch single vendorItems record by sku instead of upc
b/c that is what we must use as PK when updating the record etc.
2021-02-09 16:11:50 -06:00
Lance Edgar 76f743f3b8 Add set_vendor_item() method for API client 2021-02-09 14:25:18 -06:00
Lance Edgar 1757d09781 Add schema model for Purchase Orders 2021-02-01 15:35:22 -06:00
Lance Edgar ee9451588c Add basic support for Stores schema and API 2021-01-27 22:19:38 -06:00
Lance Edgar d398e706c4 Add MemberBarcode to op model 2021-01-13 19:18:17 -06:00
Lance Edgar 19d62b535f Tweak that thing again... 2020-12-31 19:25:33 -06:00
Lance Edgar 52d9595331 Fix Department.see_id field definition
this is not a flag, but a minimum age requirement
2020-12-31 19:01:40 -06:00
Lance Edgar ff428c4635 Misc. tweaks to product-related schema, for sake of generating SQL
e.g. from IFPS data
2020-12-09 13:09:58 -06:00
Lance Edgar 29638c062c Remove "default" values from Product model definition
i'm a bit torn about this.  on the one hand i like there being some default
values here, but realistically they didn't all make sense.  also it could be
said that default values amount to business logic and that should stay in CORE
basically.

but in the end, i needed these to go away in order to simplify generating some
SQL INSERT statements.  was using SQLAlchemy core and it kept insisting that
all fields with a "default" defined should be part of the INSERT statement, but
really i didn't want them to be.  so they no longer have defaults.
2020-12-07 17:41:01 -06:00
Lance Edgar 9dd5813520 Update changelog 2020-09-16 19:43:35 -05:00
Lance Edgar 286df47c22 Add get_vendor_items() and get_vendor_item() methods for web API 2020-09-04 19:07:41 -05:00
Lance Edgar 963f544b02 Expose some "new" columns for ScaleItem model
may need to revisit this again, when an "old" DB is encountered
2020-09-02 11:25:10 -05:00
Lance Edgar 74a28514dc Tweak relationship for Department._super_parents
since there can be more than one
2020-08-20 14:41:08 -05:00
Lance Edgar e2dc00b469 Add model for SuperDepartment 2020-08-20 14:26:46 -05:00
Lance Edgar 472f43896b Add basic batch models 2020-08-16 16:57:54 -05:00
Lance Edgar 9299cd445f Add "origin" models for office_op schema 2020-08-10 15:57:32 -05:00
Lance Edgar ef1a25f0dc Make sure MemberInfo.customers is sorted by person number
also improve the str() method a bit
2020-07-30 11:11:17 -05:00
Lance Edgar 4c7b208e6e Add Suspension and ReasonCodes to model 2020-07-22 20:25:20 -05:00
Lance Edgar 365d679d76 Add split_street() method for MemberInfo 2020-07-21 15:07:28 -05:00
Lance Edgar 13b8380527 Declare foreign key for CustData.member_type 2020-07-15 22:15:11 -05:00
Lance Edgar 257ed82d6d Bring __version__ into root namespace
can't remember why that wouldn't already be there..?  maybe just forgot
2020-07-15 21:42:28 -05:00
Lance Edgar 68ab8ff55d Add CustomerAccount.customer_type reference, to MemberType
not 100% sure about the best naming here, hopefully this is good
2020-07-13 11:03:32 -05:00
Lance Edgar 07291b3fa7 Add MemberNote and MemberInfo.notes to data model 2020-07-13 11:02:59 -05:00
Lance Edgar beb73dc668 Add Product.last_sold to schema
hopefully that's a good idea..
2020-04-17 00:24:53 -05:00
Lance Edgar 4b971c289e Add LikeCode and ProductLikeCode models 2020-04-10 14:09:38 -05:00
Lance Edgar 87fd5367a1 Add table_exists() util function 2020-03-31 14:09:51 -05:00
Lance Edgar d818100da3 Fix id field for TaxRateComponent 2020-03-31 14:09:39 -05:00
Lance Edgar 14a182c675 Disable TaxRate.sales_code attribute, for now
since some older DBs don't have it
2020-03-30 13:44:22 -05:00
Lance Edgar 64e4b18cf0 Add FloorSection and ProductPhysicalLocation models 2020-03-30 13:18:10 -05:00
Lance Edgar acc85ba8de Add ProductUser model 2020-03-30 13:18:08 -05:00
Lance Edgar 6ecfbf4e1a Add ScaleItem model 2020-03-30 12:00:52 -05:00
Lance Edgar 5f3ad79a95 Add VendorDepartment and VendorItem models 2020-03-30 11:39:57 -05:00
Lance Edgar 9b429eb293 Revert "Try out the "synonym" approach for all Vendor model fields"
This reverts commit deea31597c.

we'll keep the synonym in place for `vendorID` but the rest of these just
caused problems, e.g. with tailbone grids
2020-03-30 11:29:21 -05:00
Lance Edgar 3a440d20bc Add enum for product price method 2020-03-30 00:05:26 -05:00
Lance Edgar 07c24b63dc Fix how we interpret Product.id_enforced values
will be an age, not a flag
2020-03-29 23:36:37 -05:00
Lance Edgar e0058c003d Add Product.subdepartment relationship 2020-03-29 23:36:29 -05:00
Lance Edgar 9466b16b64 Add DB models for TaxRate, TaxRateComponent 2020-03-27 20:50:00 -05:00
Lance Edgar 573595497e Add get_members() API method 2020-03-18 11:28:19 -05:00
Lance Edgar d8e93c9d2e Add set_member() API method
also rename `get_customer()` to `get_member`
2020-03-17 16:04:22 -05:00