ORM

Kata

Write a contacts program they use an ORM to read and write Persons from an sqlite3 database

Person has 3 attributes :

we want to have one test DB named tests.db and one production db file set by environment variable DB_URL

In production Data base we have all this contacts :

add a version schema in your code and database

Add attribute email and manage the production migration database. The migration should be automatic in 2 ways :

if code version schema is under the production database schema the program can revert the migration
if code version schema is upper the production database schema the program apply the migrations

Add a business Person value object they has an address attribute with these rules:

The address in Business Person object is only the last address of person
In database we want to keep the addresses history, to do that we will build a new table with 3 attributes, the id of person, the creation date and the address

A person has an unique National Identifier, add the national unique number structure build like in France with :

A Person can know have many phone numbers, add a collections of phones numbers as attribute to Person and a new table Phones in database

A person has 2 parents and 0 or more children, manage that in your business and in your database.

We have now 2 types of persons:

Student and Employee extends Person.

Save all this information in your database.

Use a postgres or mysql as Production database.

Edit