Add New Info Fields to the Brother Model

[jcassarly]

The following fields should be added to the brother model

• Gaming / Social Media Handles
  • Could probably be an array like @kihashi stated below, but have tags for social media that have their own model
  • at the very least have steam and discord names
• Preferred Pronouns
• Expected Graduation Date
• List of campus groups people are a part of

[kihashi]

If you wanted to get fancy, you could add another model for Gaming / Social Media or something like that with the name and icon and then have a relation model that was like, Brother, Gaming / Social Media service, username, profile link or something like that. Then the Brother model would have an array of Social Accounts.

So it would be like

John Cleaver -> Kihashi     -> Steam
                       -> Kihashi     -> Twitter
                       -> MrKihashi -> Instagram

(Keep in mind that I am not familiar with Django, so my specific wording may not make sense)

That wouldn't be quite as flexible as just an open text box, but it would let you have a cleaner looking profile page and also let you more easily do a report page that does a reverse list showing brother's usernames grouped by service.

Cheers, John

[jcassarly]

I think that might be a good idea, assuming django supports this (I dont really see why not) that would probably be the way to go

[kihashi]

SQLAlchemy does (and so does SQL), so I don't see why Django's ORM wouldn't.

[helper08]

All of these are done with the exception of Campus Groups brothers are a part of.

[helper08]

For Campus Groups and Media Adding: search through the existing database and see if the item already exists: replace all whitespace with spaces ignore case trim whitespace on the beginning and end of the string do a 'contains' searching if anything contains the new list of chars within it's name

Send a "did you mean x" message and if they hit yes, return back to the previous form.

[kihashi]

You may look to see if there's a fuzzy search plugin for django

On Sun, Sep 20, 2020, at 20:43, helper08 wrote:

For Campus Groups and Media Adding: search through the existing database and see if the item already exists: replace all whitespace with spaces ignore case trim whitespace on the beginning and end of the string do a 'contains' searching if anything contains the new list of chars within it's name

Send a "did you mean x" message and if they hit yes, return back to the previous form.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/beta-nu-theta-chi/ox-dashboard/issues/51#issuecomment-695859168, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAEU7QSAGRUCXI3EATGHSM3SG2ORRANCNFSM4QNQQY7A.