This is probably your first slightly larger program, so you will tackle it as a group exercise.
- Each team consists of 2-4 members.
- You must use one class
Personin your code. - You can use all the examples from previous lessons
- Create a file in either csv or json format. It should contain data for at least 5 Persons, you can create it manually or with a script.
- Each person should have a firstname, lastname, birthdate and address.
- Read the file and insert it into to a SQLite database.
Hint here is a good place to use the class Person. e.g you can create a Person object for each row, and print it with a custom __str__ method.
- Create a (SQL) query that gets all rows (select *) from the table
- Print all rows
- Create a menu with options:
- Load data from file (Use your solution from Exercise 1)
- List all persons (select *) (Use your solution from Exercise 2)
- EXTRA query the database with firstname
- EXTRA query the database with lastname
- EXTRA query the database with birthdate
- EXTRA query the database with address
- Delete a person
- EXTRA update a persons address
Create another table, i.e Vehicles, Friends or Transactions.
- Add it to your menu
- Make it possible to add data to the second table
- Query the database with a join