(5.1.a.1) As DEVELOPERS we want to SWITCH OUR DATABASE TO FILEBASED SQLITE DATA such that ALL OUR CHEEPS ARE NOT JUST STORED LOCALLY

[Thyme-Cat]

Acceptance criteria: (not necessarily set up in the right order)

• Retire the CSV database as we will not require it anymore (when to do this, might depend on whether we wanna save these specific cheeps or not)
• Modify the code in CheepService.cs so that it retrieves cheeps and their authors from an SQLite database.
  • (Use the two links in the bottom for this. Or look at the blue slides for lesson 5)
  • For local development, you can import that data into new database, for example, by running this script (https://github.com/itu-bdsa/lecture_notes/blob/main/sessions/session_05/scripts/initDB.sh) from the command-line, e.g., via ./initDB.sh

Advice: The script as referenced above, is just these 2/3 lines of code. #!/usr/bin/env bash sqlite3 /tmp/chirp.db < data/schema.sql sqlite3 /tmp/chirp.db < data/dump.sql

https://github.com/itu-bdsa/lecture_notes/blob/main/sessions/session_05/data/schema.sql https://github.com/itu-bdsa/lecture_notes/blob/main/sessions/session_05/data/dump.sql