Download the PHP package artistan/zero-nullable-dates without Composer

ZNDCarbon

Laravel Models with nullable carbon dates, this also allow for returning a date object. When the value is null/zeros that will format to ''.

example

This is useful for old databases that do not have NO_ZERO_IN_DATE, NO_ZERO_DATE so they may have 0000-00-00 type dates.

Add ZNDTrait and a couple arrays to define nullable dates to allow for zero and nullable dates.

You may also set null_all_dates on your model to set all to nullable without the arrays

Ultimately you can just set them all to $nullable, the addition of $zero_datetime and $zero_date are for testing that the database is updating as expected.

The unit tests are dynamic and test 288 assertions

test for all combinations of what things are set for date columns.... all combinations of mutators, castings, and dates

notes on current laravel functionality dealing with toArray, attribute accessors, and dates

toArray vs accessor

if you use $model->{camel_key} (getAttributeValue), then it will

• model->{key} > getAttribute(key) > getAttributeFromArray(key)
  • get the original attribute
• mutate : if hasGetMutator > mutateAttribute
  • this is the accessor get{CasedKey}Attribute
  • mutate it if there is a mutator RETURN IT HERE
• cast : if hasCast > castAttribute
  • cast it if there is a cast method RETURN IT HERE
• date format : if matches getDates > asDateTime
  • finaly make a date (carbon) object from it IF NOT NULL RETURN IT HERE
• return value

note: the appends variables ARE mutated attributes that do not exist in the model attributes...

if you get attributes via $model->toArray then it will

• addDateAttributesToArray via getArrayableAttributes
  • so this is cast to a string AFTER carbon dating, no other processing will be applied
• addMutatedAttributesToArray via getMutatedAttributes
  • so AFTER dates transformed from carbon, then it will try mutating the formated data
  • can mutate the already "date formated" data since it passes that value to the mutateAttribute
• addCastAttributesToArray
  • this will cast a value to whatever type is specified
  • if date it will serialize it to the format specified
  • note, this is AFTER dates have already been carbon dated and formated by mutator
• getArrayableAppends
  • this will add any mutators that are not directly related to a model attibutue

date mutators.

these are both mutators and accessors, or mutates in and out

• get from db sends us a carbon date

data analysis

when date keys are set for dates that allow ZERO dates the formatting for 000-00-00 or variations of that fail. -0001-11-30 00:00:00 is the default result...

ZNDCarbon

using NULL as the data point when it is a zero nullable date

mysql mode

mysql

homestead box setup for testing

vim /etc/mysql/mysql.conf.d/mysqld.cnf

notes on dev package setup

• example package https://medium.com/@lasselehtinen/getting-started-on-laravel-package-development-a62110c58ba1
• package setup https://stackoverflow.com/a/44023017/372215
• test setup https://github.com/orchestral/testbench
• .env file in tests directory for configuration of your tests
• ln -s vendor/laravel/laravel/config in tests directory to allow access to config files
  • laravel does not have a seperate "config" path from the base path, damn it.