Assignment Tasks:

$1.$ Create a new branch in Git. Start by selecting the $$Git$$ menu in Android Studio and select $$Branches$.$ In the resulting dialog click $$New branch$$ and call it $$lab$\_5.$ This lab will build on lab $4$ in order to save our todo list to an SQLite DB$.$

$2.$ Create a class that extends SQLiteOpenHelper to create$/$upgrade your database. Ensure you use static variables for all column names, database name, and database version.

$3.$ When a user opens the app, it should load all of the todos they have previously saved from the database as well as their urgency.

$4.$ When the user presses the $$Add$$ button, the todo should be added to the database as well as the list of todo items from lab $4.$

$5.$ Modify the onItemLongClickHandler$()$ in the ListView so it also deletes the message from the database.

$6.$ Write a function called printCursor$($Cursor c$).$ This function will be used for debug purposes and should print the following info to the Log window every time the main activity is loaded:

a$.$ The database version number using db$.$getVersion for the version number.

b$.$ The number of columns in the cursor.

c$.$ The names of the columns in the cursor.

d$.$ The number of results in the cursor.

e$.$ Each row of results in the cursor.

$7.$ Ensure that all the labels and buttons in your app use the strings.xml files and are localized properly in both English and French. Use Google Translate to get the French translations of your English buttons if needed.

$8.$ Report format: Please take $3-5$ snapshots of your emulator output with different outputs$/$use cases$($app running with different windows$),$ add a brief explanation of your code and snapshots in a word doc. Submit the word doc on brightspace in the lab folder.

$9.$ Include a link to your GitHub repository as comment on Brightspace when submitting the assignment on BrightSpace.

Here$$s a full recording of how the app should function $($the flash is from closing and re$-$opening the app$)$

Rubric

Criteria Points

The app compiles and runs without crashing $2$

The todos are loaded from the database when the app launches $2$

Adding a new todo saves in the DB $2$

Deleting a todo deletes it from the DB $1$

Cursor information is shown in logcat window $2$

All items$/$labels are translated into French $1$

Total $10$