Here.
So now we are no different.
And it's time to move all the.
So you can just define the back end.
Come on it's here that will not make any change but what I'm going to do here.
I'll make an ad to fight that is back end or be white and import that one in this front end or what.
So do we work together and make the program work.
Just make a new file here.
Or simply copy that one.
Change the name it will make and be important here.
And let's begin.
So first of all I'm going to import Eskew like three maybe go then just define a function that will
connect and create my database.
So here I have removed the OTB.
That is the database for my demo project.
So that it be not kept with distance.
And this one.
Going to be a new database here.
So here we don't have any file of that one previous.
So let's begin again the five steps.
First disconnect.
Second because a third execution so Kosovo would execute.
And after that one connection to commit.
And in last close the connection there we go.
So first of all in Connect destroyed as you like three don't connect and pass the database name you
want to create several beam no baby maybe go after that one create a super connection to go Zo legal.
So here we have because a variable names.
Now execute de Come on.
CREATE TABLE.
So we'll create a table here with name Ruby after that one.
In that we have the things that we require of these things.
Date of Ning exercise the date and bite.
And in addition in addition to these I'm also adding primary key data that is going to be an I.D. that's
something like the things that I presented with numbers div so.
And that will be an integer and this one is going to be a primary key.
So the user know required to add this one it will auto increment with each of the values so a key will
be assigned to every single entry.
After that let's move to the ones that we require first of all the date which is going to be a trigger
text.
After that when we have the links.
So of Ning you go.
There is a Julie Stansell.
No that's in deja vu.
After that when we had the exercise which is text then we have the study that is also XT then night
which is also text and then in last by then go my data by ton which is also next.
David Now we have defined the table here.
Now just in lost all the dysfunction data you know if you run this one back and be David go some.
No you do not get any data notes from the previous one there.
We need to have a database here.
That's not actually here.
So let me insert something in that month and see whether this one a here or not so.
First of all I will define a function that will insert some use not just add these values here date
then we have of names then we have exercise after that was dirty then died and last bite maybe six values
provide the dots and these same five months for the insert also remove this one
and David O.
Maybe go now to insert the data just add insert in door then pass the table.
There you go.
And it values will be.
So here we are working on the database.
So first none for the primary key that will be automatically implemented and for each of these POS a
question mark there.
So here we have one and we have two three four five and six question marks.
And after getting out of discourse add there are two with these whales.
So come on C and come on b c of this one and now Edward tried to insert something in that.
So first that we try this one again.
David goes some or line I didn't and David go with that database routine baby.
So we have the database here and is showing some arrows C1 is not defined in line.
So this one also need to contain one more n so I forget to mention one more than there.
So we are done with this one.
And let me try it.
David Eagle database already exists.
So here we have our database and knowledge we tried to insert something in Denver so just insert labial
and positive values like first date 1 to say 2019 then earning say two hundred then exercise or no exercise
they will then not studied
after that one night taken
and then last did item maybe so now remove the connect right now because the connection is already established.
Go.
So this one running successfully.
We have just done a little lateral fully and that is we forget to add misplaced Miss mistakenly.
So now view come on so that we can view what we have added there.
So I copy this whole based.
This one here.
So here we have the same come on nearly just change when the execute and the second is coming.
So for this one just add select everything.
So for that one start from grouping.
Labial and just close decoders after that one remove the Comet Come on.
Or just leave that one as usual because that is something you can also work without.
So here we need to have some draws.
So Rose is equal to cause a dot fetch phone just like we had done while we are working with view and
in last just return those maybe go and in last we just only view here.
View sees maybe two so it's actually working fine.
No let me check.
What are the values do we have there.
So print do feel save and now run daily over the values one that is the primary key given by this one
and one to 2019 to under no exercise not stood a take on dead Python so perfect that one is working
perfectly fine that we try to insert one more here so that it will be shown for that so one thousand
ninety hundred and then did exercise
up to that one studied
then light taken and ideally and after that one did Python labial run that one again.
David go perfect.
And now just print view.
David go.
So we'll second entries also added there.
So this is both actually working here.
Now let me move to another one I delete Come on.
So define delete here and delete.
Here we will just take aioli and that idea will be provided by the front end.
And we'll make that one how that will put you.
This one I did do this from back.
So again just copy this.
Come on come on.
See.
Come on feet day we had this one and just a change the execute.
There we go.
So here for deletion just add delete from grouping Real I.D. equal to push and lock and then go out
the idea.
And if you remember in delete we also need to provide a quagmire because we need to delete all the values
after the idea.
That is data ending exercise study data and byte.
So save this one and I'll try to delete
I like to maybe you so not one just from the Bakken we've got some arrows so I feel to close these quotes
so all we need to close these quotes so it will not show error the here quotes save this one on it again.
David go.
So small mistakes here showing great errors.
Now we view that fine print view.
There we go.
So now we have only one entry.
Second is deleted.
So then with this one.