Hi.
The bravest lecturers of air in our category author and publisher data and our combo books.
First we need to connect every one of this function to our add new function like our new category with
short categories of combos.
Then we will a scoring or add new book function.
That's a start.
First of all the will Let's all read now free.
Go to the books we have for a publisher three publisher and then we go to the settings and then we added
a new publisher.
Let's see.
Let us read and add the new model shall we have for a publisher and we if we want to books since the
publisher we only have three.
We need to fix this issue so that every time I add a new publisher author category does.
Then you read it is loaded in the comics.
So first we will move to add new publisher and publisher.
And here we will both sell to the true publisher of comic books and in the end author.
We will also import show author comics and add new categories.
We will also on board this missile show category combos.
So now every time we add a new category the letter is being rolled again.
So in settings with the open to the publisher we can see for publishers.
We went to the settings publisher and he added new mobile show like say ad new publisher.
We have new publisher.
We want the books the publisher.
We can see new publisher but we can see that the new there is a blockade in that lake and this name
is being replicated again and so on.
So we need to clean the comic books first then add a new order.
So first of all we need to for every function of those function we need.
Let's model for sure publisher Herschel Walker and so on.
First we need to clean the combo books then add a new debt.
So let's move it.
This is show category combo books.
So here we're going to save some of the combo books.
Not clear if this will clean the combo box everytime you add it you try to add a new information to
it.
Let's not this is more complex.
Number four this is for combos.
Number five was thrown out of court the now we have like two authors.
Let's add another one.
What are we going to see this name a new author.
We have a new author to fill in books.
We can see the three authors we have with no obligation.
This is OK.
Now we've added or fixed this issue.
Now we need to add a new book to our database.
So let's move to the end.
New book function
add new book Words collected the information from that site.
We've got name.
We need a description.
Yeah.
Wouldn't a good description.
So here I'm going to see book this corruption that quote for self not Linthicum said it.
That was a blimp accident.
Let's go back.
We need to lift the splint exited and we need to get the tickets at
not just like this.
It's in this vein then edit we need to remove this plane accident and we need to get to accidents.
Does this look seamless.
And here they take this.
Not to blame.
Text.
Yes.
To get a text from a text editor used to blame text.
OK now we need to execute an insert statement to our database so many say so.
That that.
That excuse
and want to see insert
into
and she is going to see values and do here.
We will do that for my string.
So here we need to give it the table name.
So we have the books the book table name we have book.
So we have the table numbers book.
So when I see four there you will give it the name of the columns or we can remove this and the values
we have.
How many columns we have in the books we have one two three four five six seven.
So we need to add seven for my strength
and likeness and then we need to have the values in the same order in the database.
So first we have book Name Description code so book name
title
name should be book title book Name Description look code and names corruption code category calls for
a publisher plus category
author
publisher and price
and we need two men to commit this Commission to the database so served with immediate comment.
And we need to show a message so that status both the show message and your book it.
So let's run this
mean an object has no attribute group Box three words.
Yeah.
Control three
we deleted the two books
yeah.
This girl books.
I'm sorry.
Let's move to the new book.
We need to move this and that it take us in it
this is my fault
that symbol of this and let's make sure the name of this text said it.
So let's run our code.
Now we have our code.
We can add a new book.
So let's start here.
Let's see
space throw
the book.
What is the original one.
It's uh let's see.
Giving the author and the publisher on the basis of one hundred dollars.
This is a book for space travel.
Yeah.
Let's see if I've got an native cucumber.
Books object has not reviewed current text.
This is because of this
so I say that it is within this
utter those category author publisher takes an end to it.
So we need to change this to a current index and a sort of a set of text sorry.
So let's ring in the new space travel.
We need to this their new book is Strong called the 0 0 1 One hundred dollars.
This is a book for space travel.
So let's see what another Earth cucumber book says a little bit.
Current index I a single like this current current index.
Yeah.
The sea is not a capital letter.
So let's try
the new book is called space.
This book there is 0 1 100.
Let's save over another column does not match very count a true one
so we need to add the column name.
So we need to add book name description called category and so on.
So here's I'm going to write a book called name book on their score description
book under school code book school category book underscored.
Author and book under school publisher and
book the school price.
And let's run out.
Good.
Let's say that a new book Space code 0 0 1.
Price 100 space travel.
What's it says new book Addict.
Let's.
Sure that error and the variables we should see.
There is a new book of errors.
We have a new book called this name description code and so on.
This is awesome.
And the com books added the index.
So when the book to get resume book author of the year and so on.
So let's add another book.
I'm going in says and let's change all of this zero.
And here's BIS truffle too.
And this is this crop of so this is dated 0 0 to let's say it's safe.
So now free richer from that era we have a new book called New category new author your publisher.
So this is awesome.
But now we need to clean all of this information when we add new debt.
So here of the Red adding We need to set this information to an empty escape the symptoms text equal
to empty and then we need to take this.
Also
this also
since this is settling this opportunity and this of current index we're going to do this insert current
index equal to zero.
And for this four or five
story here and
and this lender told
Don so the thickest quote to empty.
So now let's say in your book let's see
by some quoting the civil for let's say support this aroma data for discipline and let's book those
for the simplicity and the publisher price.
Let's say 50 dollars
based on materials let's say it's a new book edit and all the widgets being cleaner.
OK.
Now we've added an e-book where you need to learn how could we edit or delete in your book.
But first we need to search for this book then we need to retrieve this information from the database
here.
And when we get at it we need to save it and then we did not modify this categories but chose that combo.
So we need to edit and we will do all of this from the next election.
So your next.