Broswing List Interfaces

[benlapointe]

The basic browsing list interface will look like this:

Keypad	Function
1, 2, 3	Entries 1, 2, 3
4, 5, 6	Previous, Repeat, Next
9	Main Menu

[benlapointe]

git clone https://github.com/MKotlik/BeMyReader.git git checkout -b iss2_browse_list

Terminal 1:

cd BeMyReader python -m venv venv source venv/bin/activate pip install django (maybe not needed?) pip install twilio (maybe not needed?) cd (into directory) python manage.py migrate (maybe not needed?) python manage.py runserver

Terminal 2: ngrok http 8000

[benlapointe]

• [ ] If we can return number of rows from SQLite database, then we can check which content selections are valid

  python manage.py shell from browse.models import Content all_entries = Content.objects.all() len(all_entries.values())

• [ ] How can we easily delete/add/manage entries of SQLite database?

• [ ] Update browse_content() to take entry from user, then act on that entry in the correct way.

  • If user selects 1, 2, or 3 then that will take them to the listen()
  • If user selects 4 or 6, then that will take them back to the browse_content() and present them with a different set of three entries
  • Found that each entry in the database gets automatically assigned an 'id'. I was assigning a value to 'digits', but that doesn't seem to be needed.

    all_entries.values('id','digits') <QuerySet [{'id': 1, 'digits': 1}, {'id': 2, 'digits': 2}, {'id': 3, 'digits': 3}, {'id': 4, 'digits': 4}]>

• Delete entry and view result

  all_entries.filter(id=2).delete() all_entries.values('id') <QuerySet [{'id': 1}, {'id': 3}, {'id': 4}]>

[benlapointe]

How to delete database file and start from scratch: https://stackoverflow.com/questions/42150499/how-do-i-delete-db-sqlite3-in-django-1-9-to-start-from-scratch/42150639

Modify an entry:

e = all_entries.get(id=1) e.head = "Entry 1" e.save()