Default database value

[qurben]

It is currently not possible to set a default value for a column in the database. There is a check in place in https://github.com/csrdelft/orm/blob/master/src/Persistence/DatabaseAdmin.php#L159 which checks the database for the default value. The default value is always null according to the orm.

PersistentAttribute already has some logic for supporting default values, reading from the class is not available yet.

[brussee]

I choose to make default values someting to be done via the Builder pattern in EntityModel->createCar() { $wheels = 4 } rather than database oriented default values, because the framwork is Entity-centric.

[qurben]

The check in place didn't work for timestamp fields, because these must have a default value in MySql for some reason.

So the check should be removed altogether and the framework should check the integrity of the data?

[brussee]

My intention of the MySql translation was to aid development in adjusting the database to the model (and vice versa = DynamicEntity). So the framework should indeed only check the schema and integrity of the data. However, if the database is forcing some default value, perhaps that should be reflected in the model or corrected like the PDO-bool fix. So a int 0 as time value should become null in the model and not epoch for example.

[brussee]

Are you sure it is not caused by NOT NULL, because the framework should make sure the database honors that setting in persistent_attributes, and the default setting is false (true = nullable).
https://github.com/csrdelft/orm/blob/master/src/Entity/PersistentEntity.php#L159