void dataeditfrm::newentry() { //prepare supplier entry int i, ii; QString supl = ""; for(i=0;i<tabsuppliers->rowCount();i++) { for(ii=0; ii<tabsuppliers->columnCount(); ii++) { QTableWidgetItem *item = new QTableWidgetItem; item = tabsuppliers->item(i, ii); if(item != 0) supl += tabsuppliers->item(i, ii)->text() + ":#:"; supl = supl.leftJustified(supl.length()-1, '.', true) + "#:"; } } QString state = "0"; if(chkactive->isChecked()) state = "1"; QString connstr = QString("INSERT INTO `"+lbldatatab->text()+"` (`ID`, `col1`, `col2`, `col3`, `col4`, `col5`, `col6`, `col7`, `col8`, `col9`, `col10`, `col11`, `col12`, `col13`, `col14`, `col15`, `col16`, `col17`, `col18`, `col19`, `col20`, `col21`) VALUES (NULL, '%1', '%2', '%3', '%4', '%5', '%6', '%7', '%8', '%9'").arg(txtlabel->text()).arg(txtdescription->toPlainText()).arg(txtstock->text()).arg(txtminquantity->text()).arg(txtunit->text()).arg(txtorderquantity->text()).arg(txtpurchaseprice->text()).arg(txtsellprice->text()).arg(supl); connstr += QString(", '%1', '%2', '%3', '%4', '%5', '%6'").arg(txtpackage->text()).arg(txtweight->text()).arg(cmbvat->currentIndex()).arg(state).arg(txtwebname->text()).arg(txtwebimage->text()); connstr += QString(", '%1', '%2', '%3', '%4', '%5', '%6');").arg(txtweburl->text()).arg(QDate::currentDate().toString("yyyy-MM-dd")).arg(QDate::currentDate().toString("yyyy-MM-dd")).arg(txtsalesdate->date().toString("yyyy-MM-dd")).arg(txtcomments->toPlainText()).arg(txtstockpos->text()); QSqlQuery query(connstr); QSqlError qerror = query.lastError(); if(qerror.isValid()) QMessageBox::information ( 0, tr ( "Error during update..." ), qerror.text() ); }
void QuranDbHelper::loadTranslationLanguages(){ QString query = "SELECT * from translations"; if (!mDb.isOpen()){ if (!initDatabase()) { qDebug() << "fail to open database " << AyatDataModel::mQuranDatabase; } else { qDebug() << "succes open database " << AyatDataModel::mQuranDatabase; } } // Execute the query. QSqlQuery sqlQuery(query, mDb); QSqlError err = sqlQuery.lastError(); if (err.isValid()) { qWarning() << "SQL reported an error for query: " << query << " error: " << mDb.lastError().text(); return; }else{ // tidak ada error while(sqlQuery.next()){ qDebug() << "Result: " << sqlQuery.value(0).toString() << sqlQuery.value(1).toString(); } } }
std::vector< Score > DatabaseFacade::getHightScores( const QString& gameName_, int limit_ ) { std::vector< Score > scores; if(!connected) { qDebug() << "Not connected to database"; return scores; } QSqlQuery query; query.exec(queryGetHighScores.arg(gameName_)); QSqlError err = query.lastError(); if(err.isValid()) qDebug() << err.databaseText() << "\n" << err.driverText() << "\n" << err.nativeErrorCode(); while (query.next()) { QString name = query.value(0).toString(); QPixmap picture; picture.loadFromData(query.value(1).toByteArray()); int score = query.value(2).toInt(); scores.emplace_back(name, picture, score); } query.clear(); return scores; }
std::vector< Profile > DatabaseFacade::getUsers() { std::vector<Profile> profiles; if(!connected) { qDebug() << "Not connected to database"; return profiles; } QSqlQuery query; query.exec("SELECT * FROM Gamers"); QSqlError err = query.lastError(); if(err.isValid()) qDebug() << err.databaseText() << "\n" << err.driverText() << "\n" << err.nativeErrorCode(); while (query.next()) { int id = query.value(0).toInt(); QString name = query.value(1).toString(); QPixmap picture; picture.loadFromData(query.value(2).toByteArray()); profiles.emplace_back(id, name, picture); } query.clear(); return profiles; }
QSqlError QrSqlHelper::call_query(QrSqlQuery &query, QSqlDatabase *database /* = nullptr */) { QSqlError dbError; if (dbError.isValid()) { return dbError; } QSqlQuery qQuery = QSqlQuery(*database); qQuery.setForwardOnly(true); QTime timeQuery; timeQuery.start (); qQuery.prepare (query.query ()); query.resolve(qQuery); if (! qQuery.exec ()) { qDebug() << "query exec fail, " << query.query (); return qQuery.lastError (); } query.resolveOutput(qQuery, true); int ms = timeQuery.elapsed (); // set is print sql query statement or not if (QrSqlConfig::getInstance ()->getTraceSqlQuery ()) { qDebug() << "custom sql query "<< "(" <<ms << " ms) : " << query.query () << " by " << database; } return QSqlError(); }
int PushDAO::add(const Push &push) { int insertId = -1; QSqlQuery sqlQuery(SQLConnection()); const QString query("INSERT INTO push (seqnum, pushdate, type, pushtime, extension, content, unread)" "VALUES(:seqnum, :pushdate, :type, :pushtime, :extension, :content, :unread)"); sqlQuery.prepare(query); sqlQuery.bindValue(":pushdate", push.pushDateAsString()); sqlQuery.bindValue(":type", push.contentType()); sqlQuery.bindValue(":pushtime", push.pushTime()); sqlQuery.bindValue(":extension", push.fileExtension()); sqlQuery.bindValue(":content", push.content().toBase64(), QSql::In | QSql::Binary); sqlQuery.bindValue(":unread", push.unread()); sqlQuery.exec(); const QSqlError err = sqlQuery.lastError(); if (err.isValid()) { qWarning() << "Error executing SQL statement: " << query << ". ERROR: " << err.text(); } else { if (sqlQuery.lastInsertId().isValid()) { insertId = sqlQuery.lastInsertId().toInt(); } } return insertId; }
void SQLiteDriver::setLastError(const QSqlError& e) { #if defined(SQLITEDRIVER_DEBUG) if (e.isValid()) qDebug() << "SQLite error:" << e.driverText() << e.databaseText(); #endif QSqlDriver::setLastError(e); }
QString Query::lastErrorText() const { QString ret; QSqlError err = lastError(); if(err.isValid()) { ret = err.text(); } return ret; }
void checkMySQLError(QSqlQuery& q) { QSqlError e = q.lastError(); if(!e.isValid()) return;//no error qDebug()<<"got MySQL-Error"<<e.number()<<e.text()<<"/"<<e.databaseText()<<"/"<<e.driverText(); qDebug()<<"on query"<<q.lastQuery(); qDebug()<<"Terminating Application"; QCoreApplication::quit(); }
//Return Values //True: Error Occurred //False: No Error Occurred / Detected //------------------------------------------------------------------------ bool DRCDB::ExtractError(const QSqlError &error_object) { DB_ERROR = error_object.isValid(); if (DB_ERROR) LastErrors.push_back(error_object.text()); return DB_ERROR; }
void UniPAX::mysql::MySQLManager::exec(QSqlQuery& query, QString error) { query.exec(); QSqlError e = query.lastError(); if (e.isValid()) { throw std::runtime_error(error.toStdString() + ": " + e.text().toStdString() + " -- " + query.lastQuery().toStdString()); } }
void templateeditfrm::inserttemplate() { QString qstr = QString("INSERT INTO `templates` ( `ID` , `name` , `description` , `data` , `created_by` , `created` ) VALUES ('', '%1', '%2', '%3', '%4', '%5');").arg(txtname->text()).arg(txtdescription->toPlainText()).arg(txtdata->toPlainText().replace("\\", "\\\\")).arg(username).arg(QDate::currentDate().toString("yyyy-MM-dd")); QSqlQuery query(qstr); QSqlError qerror = query.lastError(); if(qerror.isValid()) QMessageBox::warning ( 0, tr ( "Template not saved..." ), qerror.text()); QMessageBox::information( 0, tr ( "Template saved..." ), tr ( "Template successfully saved in the database." ) ); this->close(); }
void PlanningModel::removeLieu(Lieu lieu) { QSqlError error = qx::dao::delete_by_id(lieu); if( ! error.isValid()) { qDebug() << error; } qx::dao::fetch_all(lieux); emit refresh(); }
void PlanningModel::removeOrga(Orga orga) { QSqlError error = qx::dao::delete_by_id(orga); if( ! error.isValid()) { qDebug() << error; } qx::dao::fetch_all(orgas); emit refresh(); }
void PlanningModel::removeCategorie(Categorie categorie) { QSqlError error = qx::dao::delete_by_id(categorie); if( ! error.isValid()) { qDebug() << error; } qx::dao::fetch_all(categories); emit refresh(); }
void PlanningModel::removeEquipe(Equipe equipe) { QSqlError error = qx::dao::delete_by_id(equipe); if( ! error.isValid()) { qDebug() << error; } qx::dao::fetch_all(equipes); emit refresh(); }
QVariant Database::exec(const QString & q) { QVariant result; if (! isReady()) return result; QSqlQuery query = mSqlDatabase.exec(q); QSqlError error = query.lastError(); return ! error.isValid(); }
QSqlQuery UniPAX::mysql::MySQLManager::exec(QString sql, QString error) { QSqlQuery q = qdatabase.exec(sql); QSqlError e = q.lastError(); if (e.isValid()) { throw std::runtime_error(error.toStdString() + ": " + e.text().toStdString() + " -- " + sql.toStdString()); } return q; }
QSqlError pki_x509req::deleteSqlData() { XSqlQuery q; QSqlError e = pki_x509super::deleteSqlData(); if (e.isValid()) return e; SQL_PREPARE(q, "DELETE FROM requests WHERE item=?"); q.bindValue(0, sqlItemId); q.exec(); return q.lastError(); }
void templateeditfrm::updatetemplate() { QString qstr = QString("UPDATE templates SET `name` = '%1', `description`='%2', `data`='%3' , `modificated_by`='%4', `modificated`='%5' WHERE `ID`='%6';").arg(txtname->text()).arg(txtdescription->toPlainText()).arg(txtdata->toPlainText().replace("\\", "\\\\")).arg(username).arg(QDate::currentDate().toString("yyyy-MM-dd")).arg(templateid); QSqlQuery query(qstr); QSqlError qerror = query.lastError(); if(qerror.isValid()) QMessageBox::warning ( 0, tr ( "Template not saved..." ), qerror.text()); QMessageBox::information( 0, tr ( "Template saved..." ), tr ( "Template successfully saved in the database." ) ); templateid = ""; this->close(); }
void DatabaseFacade::addUserStat( int userId, const QString& gameName_, int score_ ) { if(!connected) { qDebug() << "Not connected to database"; return; } QSqlQuery query; QSqlQuery query2; qDebug() << "Executing query : \n\t" << queryGetGamerHighScore.arg(gameName_).arg(userId); query.exec(queryGetGamerHighScore.arg(gameName_).arg(userId)); QSqlError err = query.lastError(); if(err.isValid()) qDebug() << err.databaseText() << "\n" << err.driverText() << "\n" << err.nativeErrorCode(); if(query.next()) { if(query.value(1).toInt() < score_) { qDebug() << "Executing query : \n\t" << queryUpdateHighScore.arg(score_).arg(query.value(0).toString()).arg(userId); query2.exec(queryUpdateHighScore.arg(score_).arg(query.value(0).toString()).arg(userId)); err = query2.lastError(); if(err.isValid()) qDebug() << err.databaseText() << "\n" << err.driverText() << "\n" << err.nativeErrorCode(); } } else { qDebug() << "Executing query : \n\t" << queryInsertHighScore.arg(userId).arg(gameName_).arg(score_); query2.exec(queryInsertHighScore.arg(userId).arg(gameName_).arg(score_)); err = query2.lastError(); if(err.isValid()) qDebug() << err.databaseText() << "\n" << err.driverText() << "\n" << err.nativeErrorCode(); } }
bool BaseCommandExecutionService::executeQuery(const QString &queryString, const CommandExecutionContext &context) const { ::qDebug() << LOG_PREFIX << "complete query-string looks like:"; ::qDebug() << LOG_PREFIX << queryString; const QSqlQuery query = context.database().exec(queryString); const QSqlError error = query.lastError(); if (error.isValid()) { ::qWarning() << LOG_PREFIX << "Error while executing query!"; ::qWarning() << LOG_PREFIX << error.text(); return false; } return true; }
QVariantMap ScriptQuery::lastError() { QVariantMap m; QSqlError err = _query.lastError(); m.insert("databaseText", err.databaseText()); m.insert("driverText", err.driverText()); m.insert("text", err.text()); m.insert("number", err.number()); m.insert("type", err.type()); m.insert("isValid", QVariant(err.isValid(), 0)); return m; }
void PlanningModel::addEquipe(Equipe equipe, bool update) { QSqlError error; if(update) error = qx::dao::update(equipe); else error = qx::dao::insert(equipe); if( ! error.isValid()) { qDebug() << error; } qx::dao::fetch_all(equipes); emit refresh(); }
void PlanningModel::addCategorie(Categorie categorie, bool update) { QSqlError error; if(update) error = qx::dao::update(categorie); else error = qx::dao::insert(categorie); if( ! error.isValid()) { qDebug() << error; } qx::dao::fetch_all(categories); emit refresh(); }
QSqlError pki_x509req::insertSqlData() { XSqlQuery q; QSqlError e = pki_x509super::insertSqlData(); if (e.isValid()) return e; SQL_PREPARE(q, "INSERT INTO requests (item, hash, signed, request) " "VALUES (?, ?, 0, ?)"); q.bindValue(0, sqlItemId); q.bindValue(1, hash()); q.bindValue(2, i2d_b64()); q.exec(); return q.lastError(); }
void PlanningModel::addOrga(Orga orga, bool update) { QSqlError error; if(update) error = qx::dao::update(orga); else error = qx::dao::insert(orga); if( ! error.isValid()) { qDebug() << error; } qx::dao::fetch_all(orgas); emit refresh(); }
void PlanningModel::addLieu(Lieu lieu, bool update) { QSqlError error; if(update) error = qx::dao::update(lieu); else error = qx::dao::insert(lieu); if( ! error.isValid()) { qDebug() << error; } qx::dao::fetch_all(lieux); emit refresh(); }
QSqlDatabase QrSqlDatabase::createDatabase(QSqlError &dbError) { QString connectionName_ = connectionName(); dbError = QSqlError(); dbFileIsCreated = false; qDebug() << "create database:" << getDatabasePath () << "," << connectionName_; if (! QrFiler::fileExists (getDatabasePath ())) { // qDebug() << "database path is not exist:" << getDatabasePath (); // dbError = QSqlError("'database file is not exist!'", "", QSqlError::ConnectionError); // Q_ASSERT(false); // return QrSqlDatabase::null; dbFileIsCreated = true; qDebug() << "database file is not exist, ready to creating..."; } const QrSqlDatabaseParams ¶ms = getParams (); Q_ASSERT(!params.driverName.isEmpty () && !params.databaseName.isEmpty ()); QSqlDatabase db = QSqlDatabase::addDatabase (params.driverName, connectionName_); db.setConnectOptions (params.connectOptions); db.setDatabaseName (getDatabasePath ()); db.setUserName (params.username); db.setPassword (params.password); db.setHostName (params.hostname); if (-1 != params.port){ db.setPort (params.port); } if (! db.open ()) { qDebug() << "fail to open database"; QrSqlDatabaseError::displayLastError (db, "unable to open connection to database"); dbError = db.lastError (); if (!dbError.isValid ()) { dbError = QSqlError("'unable to open connection to database'", "", QSqlError::UnknownError); } QSqlDatabase::removeDatabase (connectionName_); return QrSqlDatabase::null; } Qt::HANDLE curThreadIdHandle = QThread::currentThreadId (); listDbByThread.insert (curThreadIdHandle, connectionName_); QString curThreadId = QrStringCvter<Qt::HANDLE, QrIsPointer<Qt::HANDLE>::value>::toString (curThreadIdHandle); qDebug() << "create new database connection of " << params.databaseName << "in thread " << curThreadId << " with key " << connectionName_; return QSqlDatabase::database(connectionName_); }
bool PushDAO::removeAll() { const QString query("DROP TABLE push;"); // Execute the query. QSqlQuery sqlQuery(query, SQLConnection()); const QSqlError err = sqlQuery.lastError(); if (err.isValid()) { qWarning() << "Error executing SQL statement: " << query << ". ERROR: " << err.text(); return false; } return true; }