Could you help me fix my books.cpp so the function to add books is complete. the picture is the books.h and heres the books.cpp$.($ could you make a database$)$ please

#include "books.h$"$

#include

#include

#include

#include

#include

books::books$($QWidget $*$parent$)$ : QMainWindow$($parent$)\{$

setWindowTitle$("$Library Books"$)$;

$//$ Central widget and layout

QWidget $*$centralWidget $=$ new QWidget$($this$)$;

QVBoxLayout $*$layout $=$ new QVBoxLayout$($centralWidget$)$;

$//$ Book search list $($QTreeView$)$

bookSearchList $=$ new QTreeView$($this$)$;

layout$->$addWidget$($bookSearchList$)$;

setCentralWidget$($centralWidget$)$;

$//$ Populate the book search list from the database

populateBookSearchList$()$;

$\}$

void books::populateBookSearchList$()\{$

QSqlDatabase db $=$ QSqlDatabase::addDatabase$("$QSQLITE$")$;

db$.$setDatabaseName$("$your$\_$database.db$")$;

if $(!$db$.$open$())\{$

qDebug$()$ "Unable to open database";

return;

$\}$

QSqlQuery query;

if $($query$.$exec$("$SELECT $*$ FROM library.books ORDER BY genre"$))\{$

QStandardItemModel $*$model $=$ new QStandardItemModel$($this$)$;

QString currentGenre;

QStandardItem $*$currentGenreItem $=$ nullptr;

while $($query$.$next$())\{$

QString genre $=$ query.value$("$genre$").$toString$()$;

if $($genre $!=$ currentGenre$)\{$

$//$ New genre, create a new parent item for it

currentGenre $=$ genre;

currentGenreItem $=$ new QStandardItem$($genre$)$;

model$->$appendRow$($currentGenreItem$)$;

$\}$

$//$ Create a child item for each book in the genre

QList bookItems;

bookItems $$ new QStandardItem$($query$.$value$("$book$\_$name"$).$toString$())$;

bookItems $$ new QStandardItem$($query$.$value$("$author$").$toString$())$; $//$ Author

bookItems $$ new QStandardItem$($query$.$value$("$published$").$toString$())$; $//$ Published date

currentGenreItem$->$appendRow$($bookItems$)$;

$\}$

$//$ Set the model to the book search list

ui$->$bookSearchList$->$setModel$($model$)$;

ui$->$bookSearchList$\_2->$setModel$($model$)$;

$\}$ else $\{$

qDebug$()$ "Query failed:" $$ query.lastError$().$text$()$;

$\}$

$\}$

void books::addBookToDatabase$()\{$

QString bookId $=$ ui$->$bookid$->$text$()$;

QString name $=$ ui$->$name$->$text$()$;

QString author $=$ ui$->$author$->$text$()$;

QString genre $=$ ui$->$genre$->$text$()$;

QString publish $=$ ui$->$publish$->$text$()$;

QString status $=$ ui$->$status$->$currentText$()$;

QSqlDatabase db $=$ QSqlDatabase::database$()$;

QSqlQuery query$($db$)$;

query.prepare$("$INSERT INTO library.books $($book$\_$id$,$ book$\_$name, author, genre, published, book$\_$health$)"$

"VALUES $($:book$\_$id$,$ :book$\_$name, :author, :genre, :published, :book$\_$health$)")$;

query.bindValue$("$:book$\_$id$",$ bookId$)$;

query.bindValue$("$:book$\_$name", name$)$;

query.bindValue$("$:author", author$)$;

query.bindValue$("$:genre", genre$)$;

query.bindValue$("$:published", publish$)$;

query.bindValue$("$:book$\_$health", status$)$;

if $($query$.$exec$())\{$

qDebug$()$ "Book added successfully";

$//$ Update the book search list after adding the new book

populateBookSearchList$()$;

$\}$ else $\{$

qDebug$()$ "Error adding book:" $$ query.lastError$().$text$()$;

$\}$

$\}$