Add list argument to CLI talk command

[jameskunjoolee]

Project proposal

• [x] List existing talk titles
• [x] List other relevant fields: ID, speaker, event
• [x] Format list printing
• [x] Add tabulate to requirements.txt
• [x] Handles empty talk table case
• [x] Use column names to print table headers
• [x] Clean up and squash

[jameskunjoolee]

Currently lists title of talks without any sort of formatting. Use: python -m freeseer talk list. Should any other field be printed (such as presenter, event, etc.)? Also, should the print statement be formatted a certain way?

I am also having trouble adding talks via the command python -m freeseer talk.

[dideler]

@jameskunjoolee some of your questions were answered on the mailing list, see https://groups.google.com/forum/#!topic/freeseer/Mof0iLrLgA0.

I am also having trouble adding talks via the command python -m freeseer talk.

What kind of trouble? The command freeseer talk opens the talk editor.

[jameskunjoolee]

Ah, thanks @dideler. For adding talks, I open the talk editor and try adding a talk, but nothing actually gets added to the existing list. It works fine on some of my other branches.

[dideler]

@jameskunjoolee sounds like a bug. Can you open a new issue with steps to reproduce.

[zxiiro]

@dideler it's not a bug. @jameskunjoolee you need to delete your database (presentations.db) or the easy way just reset your freeseer. Either delete ~/.freeseer directory yourself or run "python -m freeseer config reset all".

The reason is the database schema changed after we merged Laura's code so your system is missing the updated schema.

[dideler]

@jameskunjoolee btw, you can add talks via the CLI using the talk add command.

freeseer talk add --title "Title" --speaker "Name" --room "Room" --event "Event"

[jameskunjoolee]

@zxiiro Thanks, it works fine now. @dideler I tried that as well, but now it works after resetting freeseer.

[jameskunjoolee]

I opted to use tabular as @dideler suggested. Should I include this in dev_requirements.txt?

Also, I noticed that since I grab the ID value from the database it doesn't behave exactly like the talk editor's "id" field when removing talks: when you remove a talk in the talk editor the number associated with each talk gets updated, but the printed version will not do this since the ID is directly received from the database.

[dideler]

@jameskunjoolee that should go in requirements.txt, since it's a necessary dependency for all users, not just developers.

[dideler]

Thanks for your contribution @jameskunjoolee.