bool MainWindow::openDB()
{
    db  = (QSqlDatabase::addDatabase("QPSQL"));
    db.setHostName("localhost");
    db.setDatabaseName("storagebox");
    db.setUserName("postgre");

    bool ok = db.open();

    return ok;
}

void MainWindow::addpub()
{

    QString args = "INSERT INTO shelf VALUES (' ";;
    bool ret = false;
    bool lck = openDB();
    args.append(ui->titleline->text()); args.append("','");
    args.append(ui->authorline->text()); args.append("','");
    args.append(ui->publisherline->text()); args.append("','");
    args.append(ui->isbnline->text()); args.append("','");
    args.append(ui->genreline->text()); args.append( " '); ");

    ui->resultline->setText("Pub insertion starting");
    if(lck)
    {
        ui->resultline->setText("Pub is being inserted");
        QSqlQuery query;
        ret = query.exec(args);

        if(ret)
        {
            qDebug() <<"Pub has been inserted";
            ui->resultline->setText("Pub has been inserted");
        }
        db.close();
    }


}