Tag "database" tricks

Migration file sample for Pivot table

Append array in $request::all() while saving data in laravel 5.2

When you have a model with unique value column and tries seeder your table using a big amout, sometimes the QueryException is thrown, because Faker doesn't know what values was previously generated and the number of combinations is limited.

Get a List of Recent queries that have been run on your app

You can see SQL Query of your DB table on Laravel App, by Event listener.

Migrate Laravel database in Codeception

inside the testing folder add a database.php film with the following configuration:

adding default current timestamp.

This is how to add a Foreign Keys in the Migration.