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;
}
