WEBVTT

00:00.230 --> 00:07.970
So on this OK now I'm doing a split line and score intro dot.

00:08.130 --> 00:12.700
Let At read is Izzo comma.

00:13.910 --> 00:20.810
They should start an outline on the score in full on the score.

00:21.450 --> 00:30.390
Now if I print Pliner scoring for score LSD if I print that out will give me a list of two of them that

00:30.390 --> 00:34.130
is name calling X Y Z and email call calling X Y Z company dot com.

00:34.410 --> 00:39.060
I again need to find out from this from name calling X Y Z and email calling.

00:39.060 --> 00:42.020
I need to separate the name and the email.

00:42.120 --> 00:42.590
OK.

00:42.630 --> 00:47.780
So basically I want to create a dictionary of each of them.

00:47.960 --> 00:48.560
Right.

00:48.600 --> 00:54.180
Or Basically I want to create or not dictionary Basically I want to get that name and name and call

00:54.190 --> 00:57.430
him so name will be equal to.

00:57.450 --> 01:01.880
OK so name will be equal to.

01:02.100 --> 01:06.570
So basically I don't need to send the name calling and the email call in because.

01:06.630 --> 01:09.650
Because then so it doesn't make sense right.

01:09.660 --> 01:14.280
So what I need to do is I just need to send when I send it from the clients that I'm just going to send

01:14.280 --> 01:17.000
X Y Z and I'm just going to send the email.

01:17.040 --> 01:24.750
So when I do it I'll get X Y Z and I just need to store in name that his name is going to be equal to

01:25.080 --> 01:28.840
Kleiner score in for the score list of CEO.

01:28.880 --> 01:30.260
So that's going to be the name.

01:30.320 --> 01:33.980
So far the name now they're x y z.

01:34.050 --> 01:39.450
So I'm going to change my client side instead of saying instead of appending it I'm just going to say

01:39.450 --> 01:45.040
name plus comma and I'm going to send the e-mail.

01:45.120 --> 01:46.020
That's it.

01:46.020 --> 01:47.280
Some of the Silverside.

01:47.280 --> 01:48.600
I'm just going to say

01:51.480 --> 01:55.550
Klein and go zero is the name.

01:55.570 --> 02:03.160
RAZ email is going to be equal to Kleiner is control a list of what.

02:03.680 --> 02:06.470
So you have the name and the e-mail.

02:06.500 --> 02:08.960
Now you can still that in the database.

02:08.960 --> 02:09.530
OK.

02:09.560 --> 02:20.510
So along with the address so we can we can have a look at all the you know and all the addresses so

02:20.630 --> 02:24.410
basically we want to store it in the database whenever we want to store in the database.

02:24.420 --> 02:29.770
We're going to say import escalatory

02:32.440 --> 02:42.620
create a connection using escalatory dot connect great connect to database.

02:42.640 --> 02:45.560
Let's say let me see clients.

02:45.620 --> 02:46.420
I'll create

02:50.650 --> 02:51.200
chat.

02:51.270 --> 02:52.490
Easy for us to follow.

02:52.730 --> 02:53.340
OK.

02:53.660 --> 02:54.750
Create one.

02:55.010 --> 02:57.590
Connect which is good returned to me a connection.

02:59.100 --> 03:00.450
Osted a connection.

03:00.470 --> 03:02.530
I'm going to see a connection.

03:03.560 --> 03:04.550
Connection.

03:04.620 --> 03:05.840
Doctor Koso

03:08.680 --> 03:17.980
which is going to return to me a capsule and this goes can you know execute something where you can

03:17.980 --> 03:18.990
just create it.

03:19.210 --> 03:22.450
You know you can just create a table for now.

03:22.570 --> 03:23.410
So let's say

03:27.110 --> 03:31.910
personally execute.

03:32.300 --> 03:39.570
Create table clients.

03:39.800 --> 03:51.050
You're going to have things like things like you know I.T. or just the client name for now client name

03:51.050 --> 03:54.260
Karma drole come on.

03:54.270 --> 03:57.030
Chant are natural.

03:57.140 --> 03:58.190
Basically what is it.

03:58.270 --> 04:01.400
Email Khama media.

04:01.460 --> 04:07.640
These are a few things that you will get right so I can store it in that particular fashion.

04:07.810 --> 04:15.210
So and each of them are going to be that of care of 20.

04:15.520 --> 04:17.270
There's also going to be of 20

04:20.380 --> 04:27.670
and there's also going to be you kind of say wait so we going to have a couple of cars so we execute

04:27.670 --> 04:30.690
them then after we do of course it will execute.

04:30.760 --> 04:38.840
Create table clients all I have to do is let's say this time I want to give his name and his e-mail

04:38.850 --> 04:39.640
ID.

04:39.970 --> 04:43.550
Both of them needs to be displayed when I get the message right.

04:43.690 --> 04:46.150
So I want that to happen.

04:46.300 --> 04:57.590
So if I want that to happen because of that excuse but I would have to create a new customer in every

05:00.090 --> 05:01.420
in every new threat.

05:02.040 --> 05:08.150
That's that's something which is quite compulsory.

05:08.340 --> 05:09.640
Right.

05:09.710 --> 05:13.960
All I need to do is I need to put the deed up put the values in that it is not yet.

05:13.970 --> 05:15.520
So when you run a query.

05:16.000 --> 05:16.770
OK.

05:16.860 --> 05:26.900
So by the way this client got a connection can be done later but Cline's of not name that ecord because

05:27.800 --> 05:29.550
name is already here.

05:29.930 --> 05:37.210
But I need to decode this because what I've received climber's control is not client underscoring.

05:37.210 --> 05:40.370
Choice is still

05:43.110 --> 05:44.560
that de-code.

05:44.880 --> 05:50.130
So that's so bytes I need to convert it into a string.

05:50.170 --> 05:50.530
Right

05:53.030 --> 05:56.070
so Klotzbach line in full.
