Commit Graph

52 Commits

Author SHA1 Message Date
Scott Idem
0f4b4d2f51 feat: Implement V3 ID Vision and fields_to_exclude_from_db across core models
This commit refactors numerous Pydantic models to align with the V3 ID Vision standard, ensuring that primary and foreign key fields are represented as clean string IDs in the API. It also introduces and populates the  ClassVar in each model to prevent view-only fields and linked objects from being inadvertently written to the database during PATCH/POST operations.

Specifically, this includes:
- Adding  to exclude view-derived or joined fields such as , , nested objects (e.g., , ), and convenience fields (e.g., ).
- Adjusting root validators to correctly map string IDs and strip internal integer IDs for API responses.
- Resolving a KeyError by adding  to .

These changes are crucial for maintaining data integrity and consistency with the V3 API architecture.
2026-02-24 16:21:27 -05:00
Scott Idem
817bb80f87 ID Vision Phase 2: Standardize Page, Post, Person, Organization, and Hosted File objects 2026-01-19 18:04:17 -05:00
Scott Idem
29b4d5ae4b Fix Person creation issues and enhance V3 CRUD robustness.
- Added Pydantic validators to Person_Base to handle null values for given_name and allow_auth_key, ensuring database NOT NULL constraints are met.
- Updated api_crud_v3.py (POST and PATCH) to filter out virtual *_id_random fields from data payloads before database operations to prevent "Unknown column" errors.
- Updated GEMINI.md with session progress.
2026-01-09 14:30:45 -05:00
Scott Idem
882c740880 Finally getting rid of the old display_name fields. Trying to use full_name and full_name_override everywhere. 2025-06-16 19:22:02 -04:00
Scott Idem
c1ff6737f4 Now with source_code field... 2024-10-10 13:21:10 -04:00
Scott Idem
4145f81850 Fixed some JSON fields 2024-07-24 17:46:57 -04:00
Scott Idem
8d7f18c734 Added some missing fields. 2024-07-24 17:16:03 -04:00
Scott Idem
a1be67d8d3 More new convenience fields for person_model 2024-07-17 12:29:47 -04:00
Scott Idem
cfe9dee433 Forgot to add new email and passcode fields 2024-06-20 12:19:12 -04:00
Scott Idem
74fdea2941 Updates to person related models 2023-10-31 13:30:00 -04:00
Scott Idem
df26128ce4 General clean up. Workon event abstracts. 2023-03-20 19:39:41 -04:00
Scott Idem
f91b50a9e8 More again. Moving ID random generation to the SQL db instead. General clean up. 2022-06-30 15:53:11 -04:00
Scott Idem
8d5b4c7fc0 Work on orders and order lines. Removing user_id related from order. Also general clean up. 2022-03-16 16:52:03 -04:00
Scott Idem
c380516855 Updates for Cvent, IDAA, and general clean up 2022-03-15 16:00:57 -04:00
Scott Idem
4752c81e7f Updates for IDAA Cvent API sync. Less debugging turned on. 2022-03-15 11:59:40 -04:00
Scott Idem
4abf02aa15 Working on general code clean up and Cvent API related 2022-02-01 12:17:25 -05:00
Scott Idem
b0537723a7 Working on order, carts, and Stripe 2022-01-23 18:31:45 -05:00
Scott Idem
ab0b900721 Still working on order and orders that are carts 2022-01-21 16:41:40 -05:00
Scott Idem
55063d0f94 A LOT of code clean up. More changes to membership tables, views, routes, methods, and models renamed. 2022-01-11 19:45:55 -05:00
Scott Idem
163e57ef76 Code clean up. More changes to membership tables, views, routes, methods, and models renamed. 2022-01-11 16:24:01 -05:00
Scott Idem
8953fc32d8 Code clean up. Membership tables, views, routes, methods, and models renamed. 2022-01-11 14:12:51 -05:00
Scott Idem
0cad4e68eb Clean up 2022-01-03 18:29:11 -05:00
Scott Idem
0866fbbed6 Clean up 2021-12-29 19:42:27 -05:00
Scott Idem
398897efe1 Just lots of work and tweeks 2021-12-15 21:51:58 -05:00
Scott Idem
30693cd629 Work on person related information, order, and order_cart 2021-11-16 14:28:22 -05:00
Scott Idem
ec401056b2 Working on file uploads and event files. 2021-10-06 23:01:56 -04:00
Scott Idem
d6892c168c Working on user login with membership for IDAA 2021-10-04 21:05:42 -04:00
Scott Idem
831ff8d4a0 Work on event person tracking and related 2021-09-27 19:14:41 -04:00
Scott Idem
adb90fd214 Minor updates 2021-09-17 17:31:41 -04:00
Scott Idem
15fd32b252 Work on a lot of things. Mainly cleaning up person and profile related fields in multiple tables. 2021-09-10 18:12:24 -04:00
Scott Idem
d0d8392817 Work on person methods and related 2021-09-08 12:22:22 -04:00
Scott Idem
5bed9aadb4 Added page routes and related methods and updated model. Also general clean up. 2021-08-20 12:53:21 -04:00
Scott Idem
4eaeb152fe Working on data importing. Mainly for IDAA membership. 2021-08-19 15:10:59 -04:00
Scott Idem
d1c7a88c64 Working on data importing. Mainly for IDAA membership. 2021-08-18 18:25:22 -04:00
Scott Idem
3310d9fc8b Change to person.contact_id and related bug fixes. 2021-08-08 11:54:57 -04:00
Scott Idem
65b5e6ade6 Bug fix in order cart line model. Need to create another _Base for order_line and order_cart_line 2021-08-07 20:27:45 -04:00
Scott Idem
562a3ffa36 Bug fix in order cart method and added email to person model. 2021-08-07 18:33:02 -04:00
Scott Idem
475239f6e9 Working on importing IDAA data 2021-07-30 18:13:31 -04:00
Scott Idem
e6451f29f8 Working on creating a person with related objects. 2021-07-20 20:18:43 -04:00
Scott Idem
49805f48c9 A lot of changes related to person and membership 2021-07-09 17:34:02 -04:00
Scott Idem
a0514b5179 Working on membership, person, user, and order 2021-06-28 14:23:06 -04:00
Scott Idem
d85ab35812 Working on membership stuff 2021-06-24 17:50:11 -04:00
Scott Idem
f5f60a403c Working on membership still... 2021-06-24 14:33:23 -04:00
Scott Idem
c1d23d15f4 Working on all module routes, methods, and models 2021-06-22 18:00:34 -04:00
Scott Idem
fe232b8cba Clean up of code... 2021-06-11 18:42:28 -04:00
Scott Idem
4e6fedcffd Work on better way to update objects. A lot of work! Also a lot of clean up. 2021-06-10 17:42:31 -04:00
Scott Idem
2788546cc8 A lot of work on event related modules 2021-06-04 17:10:09 -04:00
Scott Idem
b1effc128a Working on event related models and methods. Also, a lot of general clean up of everything. 2021-05-28 16:03:17 -04:00
Scott Idem
443d2bab77 A lot of general clean up of everything. 2021-05-28 03:52:31 -04:00
Scott Idem
2167c7e897 General clean up of everything. 2021-05-28 03:23:52 -04:00