WEBVTT

00:01.410 --> 00:06.210
So let's take care of inserting a customer into the database and right now, I mean, models don't go

00:06.210 --> 00:09.260
and have the insert order function in front of me.

00:09.660 --> 00:14.160
And since insert customers, basically the same thing with just a couple of changes to save some time,

00:14.160 --> 00:21.360
I'll copy this and paste it right here and we'll rename it to Insert Customer

00:24.270 --> 00:31.530
and it will take one parameter C, which is of type customer, C for customer, and it does return an

00:31.530 --> 00:32.880
inch and potentially an error.

00:32.910 --> 00:38.600
So let's fix the sequel insert into customers and basically there are fewer fields.

00:38.600 --> 00:44.960
So let's delete these and insert first name, last name and email.

00:46.320 --> 00:49.830
And that is one, two, three, four, five fields'.

00:50.100 --> 00:53.190
So one, two, three, four, five.

00:53.190 --> 00:56.310
And we can delete these two placeholders.

00:56.890 --> 00:57.520
So those are gone.

00:58.170 --> 01:00.600
Now let's fix that to see that first name.

01:04.210 --> 01:08.200
Last name, Ceder Email,

01:12.680 --> 01:16.800
and we can delete these too, and everything else should stay the same.

01:16.910 --> 01:19.880
So now we have this insert function and Mulwaree models here.

01:19.930 --> 01:23.120
Let's just get rid of this blank line while we're in models.

01:23.130 --> 01:27.860
Let's go back up and find transaction because we actually added a couple of fields to the database and

01:27.860 --> 01:29.250
we need them here in the model as well.

01:30.050 --> 01:32.630
And those were the.

01:34.530 --> 01:43.950
Expiry date, expiry month, which will be an end and in general called our expiry month

01:46.590 --> 01:48.450
duplicator and the expiry year.

01:56.410 --> 02:02.090
OK, format this and save it, and now we have our models ready to go.

02:02.110 --> 02:07.240
So that means in the next lecture or two, we can start taking care of these things in the handlers,

02:07.270 --> 02:11.860
creating a customer and saving it, creating an order and saving it and creating a transaction and saying,

02:11.950 --> 02:16.180
I don't think that's quite the right order, but we'll take care of that in the next lecture or two.