All language subtitles for 2. Route, Migration & Model Settings

OK, welcome to the course of Lavallade EPA Dalat material, this is Potami 11 and satisfied you will

continue all about our EPA development phase.

When and inside this video, we will do a route model and migration settings.

So if I go back to slide here in the last video, we discussed that for the EPA and phase one we are

discussing over these employees table inside this employee table, the columns will have called Idy

Neame email, phone number and and age.

Science had this video, first of all, will create a migration.

That migration file basically creates these columns and in the next will create some roads.

And inside our road configuration file, we will use get request type post request.

I put request type Asla delete request.

I also will do model settings.

So step by step, all these things we will do inside this video.

So first of all, we to create a migration file, so to terminal we will use in command to create migration

file.

So BHB addition, it's a Megg migration and will use create employee dbl.

So if I press enter.

As you can see here, migration created successfully back to Ed Go and Delord Database Migration's,

and here we have our employee table, so we want the table name Asport allowing naming convention.

That DeBelin always be plural.

So we want misguidance employees and employees.

So here, by default, the columns we have called Idee, which is Oddone Agreement Panichi.

Next we have the timestamp columns like we have created at and updated.

And so as we had discussed, that we need only these columns.

So I've got now next week to create these reste columns.

So back to Ed.

Let's add that DBL.

Now, the second column we have got, if I go here, this is Neme, so back to Ed read to pass me and

we won't let's say the name values would be 120 characters in land Akin if I copy this line based do

more times.

The second one we want for the email address.

Or if I copy back to Ed, this is for email address listed.

The email value should be 50 cactus inland.

Now next we want something phone number.

So if I copy go here.

This is phone number and we want the phone numbers.

Should be twenty five cactus and land.

The other two columns we have called gentle and age.

So for this gentle reward enumeration day to day because inside this case we have only few options available

that is mean female and others.

Otherwise the ease column should contain the integer value.

So back to Petito now if I go it's a table rehab for the Inam type called in a method inside these the

first value we need to pass the column names.

So the column name we have called Gentil inside second to McEnery in which we will post a values.

So we want that inside this column we have the value either it is male or female or others.

Now, next, the final column we have called each and the eight is going to contain the Intisar value

each and it is unsigned value so successfully now we have created the structure or the schema of employee

stable.

So after creating migration file next week to migrate inside our database, Sabbat Terminal simply type

the command, call BHP in migrate.

Now if I press enter, it will go and join all the pending migrations and create a table inside database.

So if we go here, this is our database.

Click on this structure and as you can see that by default these all tables generated by larible.

But here we have our custom table call employees and inside this employee stable, we have the columns,

last name, immi, phone number, gender, age created out and updated.

Add one more thing.

We don't want these timestamps value, so we need to remove that.

How can you remove back to Ed and remove this time estimator here again even to run.

So back here let's of BHP additions my migrate and simply title flack refresh.

So if I press enter this command will roll back all the tables and migrate again.

So if I go here, click on a structure and as you can see that the timestamp values now removed from

employee table.

So after creating table now next we want some root configuration to create a roads or before out let's

create a model.

So this is employee stable.

We want the model.

And as for the naming, convention model should be singular.

So we need to create employee model.

So if I back the terminal, first of all, it's clear this console will use the partition command.

So BHB partition, let's make model and we to pass the model name.

So the modelling we want something employee.

Now if I press enter model created successfully, if I had to go into your district restructure.

So we will get the model inside this app models folder.

And here we have employee dot BHP.

Now inside this file, inside this glass file, we will configure some member variables, litter the

first something protected.

And the table we are using for this employee model is something employees.

So if I copy the table name, go ahead and say this model.

So this is the table we're using and one more property that is fillable.

So fillable, why we use this valuable property here, fillable property law to Assignment's Moss and

Moss assignment's of all the columns, what we're assigning it here.

So if I nightlights any email, we have something for no gender and age.

So when we assign the values via model to all these columns to insert new roadside table, so this fillable

property to allow my assignment to all these columns.

So that's why we're using fillable property here so successfully.

We have done two settings, one for the migration and second for the model.

So if I go inside for the root configuration inside Trotz folder, as you can see, we have a file called

Epidaurus, BHP.

So when we create any Epper inside Laravel, all the episodes should be configured inside this Epidaurus.

We and when we call this when we called all the roads by default API prefix should be added inside each

of the round.

So let's create Voltio.

So here I will call it as epiphyseal of fun.

And inside this we want our roads.

So in the last few to if I close these two files, open up our control file, that is, we have created

API controller and inside this controller file, look at all these, Mathilde's create employee lists,

employees, a single employee update, employ and delete employee.

So we need to create output all these methods back to update.

So what what is the request type for all these matters?

So to create employee as we know that we will send some parameters inside body, so we will use force

request I because we want to send data here.

We do list of all the employees, what we have inside, inside our database table.

So for this case we will use get request I acking here we are getting the single employee detail by

the help of this employee ID.

So in this case will use get request type.

So it should be get by now next year.

So this update Epper method, we are sending body parameters as well as of update ID, so it should

be put request I.

And for that to lead, if I close this file because I have lost control, still not for the delete API,

we won't delete request I.

So on the basis of all these matters type, we need to create EPA wrote inside this EPA dot BHP.

So if I see this file first, go inside this EPA dot BHP.

First of all we to load this controller.

So let's say use EPA control.

Look at the part we're getting EPA control from Controllers Fulda and EPA food.

Now if I go he'll blitzers out.

Will you get request I and the EPA to do something.

Let's the list employees making an array inside these lists.

The EPA controller.

It's a class and here this EPA means that failing to list all the employees so it will call list employs

methods to copy the matter.

Nemko and BCT your now next.

If I copy pasting it to a Kindle Fire using get request type.

But this time this is for single employee Soheil.

We will have a single employee and one more thing for will pass employee ID into humoral.

So here I disvalue will pass.

Inside this case we will use the matinées, get a single employee.

So if I copy go and pasted here now next if I copy this route go and be still now narced.

Inside this case we are going to use Borst request I and this is Lizzi at employee for this road.

We are using EPA control and the mother will use call uit employee if I copy and CVT or this time we

have used Borst request.

I again if I copy paste initio and next we want the road for update employ method so we are using put

request I Soheil instead of forced lid's Miggy does put request.

I do something instead of add it should be updated.

Employee add one more thing inside this update.

Employee also we are passing request via passing request.

Were able to get X over body Parramatta's as well as via passing update ID.

So back to EP Petrify and inside this road we will pass our employee ID on the behalf of this ID.

We will update data now it will use controller and inside this update employee is the method now next

if I copy re to create for the delete employee.

So this time we have the request type as delete the rule, do something.

Let's say delete hyphen employee inside this matter as we know that we need to pass employee ID.

So here we have the employee ID, we are using EPA control and the method in this case is something

delete employee so successfully.

Guys, we have configured our roads, we have configured our model as well as we had done the migration

not from the next few to fully start EP development that is forced API call create API so far this session.

Guys, thanks for watching and have a great.