Public Talk Outline List

[JoelMon]

Public Talk List Design

Need to come up with a design for dealing with public talk outline titles. Namely, the problem that an outline -- although rare -- may be retired in the future has to be dealt with. A design needs to be implemented that keeps data integrity when a title is retired.

Poor Solutions

Hard Coding Outline into pyTalkManager

• Delete talks that are retired.
  • Retired talks can't be deleted from the database for obvious reasons.
• Change a value in the database to mark the talk as unassignable.
  • This solution is problematic because it will affect updates to pyTalkManager. Future updates to PyTalkManager will have to include the retired talks in order not to break databases created before the retirement of the outline.

    Potential Solutions

    Importing Outlines from File

• Provide a text file along with pyTalkManager with all outline titles.
  • A file can contain all talk titles and numb

    Public Talk List Design

A design for dealing with public talk outline titles is needed. Namely, the problem that an outline -- although rare -- may be retired in the future has to be dealt with. A design needs to be implemented that keeps data integrity when a title is retired.

Poor Solutions

Hard Coding Outline into pyTalkManager

• Delete talks that are retired.
  • Retired talks can't be deleted from the database for obvious reasons.
• Change a value in the database to mark the talk as unassignable.
  • This solution is problematic because it will affect updates to pyTalkManager. Future updates to PyTalkManager will have to include the retired talks in order not to break databases created before the retirement of the outline.

    Potential Solutions

    Importing Outlines from File

• Provide a text file along with pyTalkManager with all outline titles.
  • A file can contain all talk titles and number. The user can then use pyTalkManager to import said file. pyTalkManager will populate the database with the file. If talks are retired, then the talks can be removed from the list. New databases created will not contain the retired outlines, databases that were created before the outline was retired will continue to function as normal (The user does not need to import the outline list).
  • The negative: a little cumbersome, also there's the potential of a user accidentally importing the updated outline file when updating pyTalkManager, compromising data integrity in their database.

[JoelMon]

I began work on the Talk Manager in commit d40c55bff2b but I ran into an issue. Read the commit message for more information.

I plan on adding an Import button that is only visible when there's no outlines entered into the database. If the there is outlines entered into the database then the Import button will be invisible.

[JoelMon]

This issue was implemented in pull #112 although a few