Compare database tables and models |
Hello,
I would like to know if there is a way to check the current database tables and if the CI4 models implements all columns correctly. My team and I are create, update many tables and we would like to do tests that check if our models linked to a table match its state (same number and same names for the columns). Any help is welcome !
In my understanding, CI4 Model don't know table column names except $allowedFields.
The column names are often hard coded in Model code. So it seems difficult to check all column names in Model. You can list the columns in a table: https://www.codeigniter.com/user_guide/d...in-a-table
Thank you for your answers,
Finally I created a base class that I can inherit with each test file associated with a model. Here is my (draft) code: PHP Code: <?php And here the implementation sample : PHP Code: <?php NB: This code is not completely complete but it is a sort of proof of concept. |
Welcome Guest, Not a member yet? Register Sign In |