[Feature Request] Strip privacy columns when uploading ticket data

[tai271828]

Description

When working on #5 , we have a tool to upload ticket data like #23 . The raw data is stripped privacy-related columns manually prior to uploading. It will be great if we could have fool-proof, or something automatically stripping the columns that we don't want to upload, when uploading.

Possible Solution

Check black list of columns and remove them from data frames.

The current candidates of column to remove in my mind:

(kktix) id
order number
checkin code
qr code serial no
nickname
Contact Name
contact mobile

Please note we keep contact emails and upload their hashed version. Ref to the context: #30

[grimmerk]

@tai271828 https://pydantic-docs.helpmanual.io/ may be a good tool to handle this?

[tai271828]

@tai271828 https://pydantic-docs.helpmanual.io/ may be a good tool to handle this?

@grimmer0125 thank you for the tip. The issue was resolved earlier but I forgot to update the issue status. The tip may be used for future improvement.