bool SelectPage::getSongList() { /* also erst starte ich sqlite normal auf meine musicdb dann lade ich deine datenbank dazu, also: ATTACH DATABASE "musicdb_johannes.sqlite" AS johannesdb; und der folgende befehl gibt dir alle ids und md5sums von meiner datenbank, die in deiner datenbank nicht drin sind: select id,last_changed as lol from main group by id having count(id) > (select count(*) from johannesdb.main where last_changed = lol); */ printf("%s\n",( QString("ATTACH DATABASE \"%1\" AS johannesdb;").arg(field("importDbName").toString()).toAscii().data())); QSqlQuery query = sqlhelper.exec( QString("ATTACH DATABASE \"%1\" AS johannesdb;").arg(field("importDbName").toString()) ); if(!query.isValid()) { QMessageBox::information(NULL, "Error loading database", query.lastError().text().toAscii().data()); return false; } //QSqlQuery query2; query = sqlhelper.exec("select id, titel, kuenstler, album, pfad, md5sum as lol from johannesdb.main group by id having count(id) > (select count(*) from main where md5sum = lol);"); if(!query.isValid()) { QMessageBox::information(NULL, "Sql Error", query.lastError().text().toAscii().data()); return false; } while (query.next()) { // WARNING: DO !!!NEVER!!! rely on query.size() here!!! (see qt docs...) //printf("new song: %s\n",query.value(4).toString().toAscii().data()); syncAddManager.appendItem(query.value(2).toString(), query.value(3).toString(), query.value(1).toString(), query.value(4).toString()); } return true; }
void ObjectRecord_Impl::setLastValues(const QSqlQuery& query, ProjectDatabase& projectDatabase) { OS_ASSERT(query.isValid()); OS_ASSERT(query.isActive()); OS_ASSERT(query.isSelect()); Record_Impl::setLastValues(query, projectDatabase); QVariant value; value = query.value(ObjectRecordColumns::name); OS_ASSERT(value.isValid() && !value.isNull()); m_lastName = value.toString().toStdString(); value = query.value(ObjectRecordColumns::displayName); OS_ASSERT(value.isValid() && !value.isNull()); m_lastDisplayName = value.toString().toStdString(); value = query.value(ObjectRecordColumns::description); OS_ASSERT(value.isValid() && !value.isNull()); m_lastDescription = value.toString().toStdString(); value = query.value(ObjectRecordColumns::timestampCreate); OS_ASSERT(value.isValid() && !value.isNull()); m_lastTimestampCreate = DateTime(value.toString().toStdString()); value = query.value(ObjectRecordColumns::timestampLast); OS_ASSERT(value.isValid() && !value.isNull()); m_lastTimestampLast = DateTime(value.toString().toStdString()); value = query.value(ObjectRecordColumns::uuidLast); OS_ASSERT(value.isValid() && !value.isNull()); m_lastUUIDLast = toUUID(value.toString().toStdString()); }
/** *Edits the fields from selected room in Room table *@param room is a room class item *@param fetchquery is an sql query *@param query is an sql query */ void RoomManagement::editRoom(Room room) { QSqlQuery query; QSqlQuery fetchquery; fetchquery = sqlMechanism.myQuery(); fetchquery.prepare("SELECT * FROM RoomsReservation WHERE fkRoomId= :rNum"); fetchquery.bindValue(":rNum",room.getRoomNumber()); fetchquery.exec(); fetchquery.next(); if(fetchquery.isValid()) { QMessageBox::information(0,"Input Data Error","This room can't be edited.Reservation in progress"); } else { query = sqlMechanism.myQuery(); query.prepare("update Rooms SET RoomFloor= :rFloor, Capacity= :capacity WHERE RoomNumber=:rNum"); query.bindValue(":rNum",room.getRoomNumber()); query.bindValue(":rFloor",room.getRoomFloor()); query.bindValue(":capacity",room.getCapacity()); query.exec(); } }
bool AlgorithmRecord_Impl::compareValues(const QSqlQuery& query) const { OS_ASSERT(query.isValid()); OS_ASSERT(query.isActive()); OS_ASSERT(query.isSelect()); bool result = ObjectRecord_Impl::compareValues(query); QVariant value; value = query.value(AlgorithmRecordColumns::algorithmRecordType); OS_ASSERT(value.isValid() && !value.isNull()); result = result && (m_algorithmRecordType == AlgorithmRecordType(value.toInt())); value = query.value(AlgorithmRecordColumns::complete); OS_ASSERT(value.isValid() && !value.isNull()); result = result && (m_complete == value.toBool()); value = query.value(AlgorithmRecordColumns::failed); OS_ASSERT(value.isValid() && !value.isNull()); result = result && (m_failed == value.toBool()); value = query.value(AlgorithmRecordColumns::iter); OS_ASSERT(value.isValid() && !value.isNull()); result = result && (m_iter == value.toInt()); return result; }
bool InputVariableRecord_Impl::compareValues(const QSqlQuery& query) const { OS_ASSERT(query.isValid()); OS_ASSERT(query.isActive()); OS_ASSERT(query.isSelect()); bool result = VariableRecord_Impl::compareValues(query); QVariant value; value = query.value(VariableRecordColumns::problemRecordId); if (value.isValid() && !value.isNull()) { result = result && m_problemRecordId && (*m_problemRecordId == value.toInt()); } else { result = result && !m_problemRecordId; } value = query.value(VariableRecordColumns::uncertaintyDescriptionType); if (value.isValid() && !value.isNull()) { result = result && m_uncertaintyDescriptionType && (*m_uncertaintyDescriptionType == analysis::UncertaintyDescriptionType(value.toInt())); } else { result = result && !m_uncertaintyDescriptionType; } value = query.value(VariableRecordColumns::inputVariableRecordType); OS_ASSERT(value.isValid() && !value.isNull()); result = result && (m_inputVariableRecordType == InputVariableRecordType(value.toInt())); return result; }
void AlgorithmRecord_Impl::setLastValues(const QSqlQuery& query, ProjectDatabase& projectDatabase) { OS_ASSERT(query.isValid()); OS_ASSERT(query.isActive()); OS_ASSERT(query.isSelect()); ObjectRecord_Impl::setLastValues(query,projectDatabase); QVariant value; value = query.value(AlgorithmRecordColumns::algorithmRecordType); OS_ASSERT(value.isValid() && !value.isNull()); m_lastAlgorithmRecordType = AlgorithmRecordType(value.toInt()); value = query.value(AlgorithmRecordColumns::complete); OS_ASSERT(value.isValid() && !value.isNull()); m_lastComplete = value.toBool(); value = query.value(AlgorithmRecordColumns::failed); OS_ASSERT(value.isValid() && !value.isNull()); m_lastFailed = value.toBool(); value = query.value(AlgorithmRecordColumns::iter); OS_ASSERT(value.isValid() && !value.isNull()); m_lastIter = value.toInt(); }
void ObosoblForm::editRecord() { if(indexTemp != ""){ QSqlQuery query; query.prepare("UPDATE obosobl SET obosoblname = :name WHERE obosoblid = :id"); query.bindValue(":name",editName->text()); query.bindValue(":id",indexTemp); query.exec(); }else{ QSqlQuery query; query.prepare("SELECT * FROM obosobl WHERE obosoblname = :name"); query.bindValue(":name",editName->text().simplified()); query.exec(); query.next(); if(!query.isValid()){ NumPrefix numPrefix; indexTemp = numPrefix.getPrefix("obosobl"); if(indexTemp == ""){ close(); } QSqlQuery query; query.prepare("INSERT INTO obosobl (obosoblid, obosoblname) VALUES(:id, :name)"); query.bindValue(":id",indexTemp); query.bindValue(":name",editName->text().simplified()); query.exec(); }else{ QString tempString = editName->text(); tempString += QObject::trUtf8(" is availble!"); QMessageBox::warning(this,QObject::trUtf8("Atention!!!"),tempString); } } emit accept(); close(); }
DakotaAlgorithmRecord_Impl::DakotaAlgorithmRecord_Impl(const QSqlQuery& query, ProjectDatabase& database) : AlgorithmRecord_Impl(query, database) { OS_ASSERT(query.isValid()); OS_ASSERT(query.isActive()); OS_ASSERT(query.isSelect()); QVariant value; value = query.value(DakotaAlgorithmRecord::ColumnsType::dakotaAlgorithmRecordType); OS_ASSERT(value.isValid() && !value.isNull()); m_dakotaAlgorithmRecordType = DakotaAlgorithmRecordType(value.toInt()); value = query.value(DakotaAlgorithmRecord::ColumnsType::dakotaRestartFileRecordId); if (value.isValid() && !value.isNull()) { m_dakotaRestartFileRecordId = value.toInt(); } value = query.value(DakotaAlgorithmRecord::ColumnsType::dakotaOutFileRecordId); if (value.isValid() && !value.isNull()) { m_dakotaOutFileRecordId = value.toInt(); } value = query.value(DakotaAlgorithmRecord::ColumnsType::jobUUID); if (value.isValid() && !value.isNull() && !value.toString().isEmpty()) { m_jobUUID = openstudio::UUID(value.toString()); } }
MeasureRecord_Impl::MeasureRecord_Impl(const QSqlQuery& query, const ProjectDatabase& database) : ObjectRecord_Impl(database, query) { OS_ASSERT(query.isValid()); OS_ASSERT(query.isActive()); OS_ASSERT(query.isSelect()); QVariant value; value = query.value(MeasureRecordColumns::measureRecordType); OS_ASSERT(value.isValid() && !value.isNull()); m_measureRecordType = MeasureRecordType(value.toInt()); value = query.value(MeasureRecordColumns::variableRecordId); if (value.isValid() && !value.isNull()) { m_variableRecordId = value.toInt(); } value = query.value(MeasureRecordColumns::isSelected); OS_ASSERT(value.isValid() && !value.isNull()); m_isSelected = value.toBool(); value = query.value(MeasureRecordColumns::measureVectorIndex); if (value.isValid() && !value.isNull()) { m_measureVectorIndex = value.toInt(); } }
void PSUADEDaceAlgorithmRecord_Impl::setLastValues(const QSqlQuery& query, ProjectDatabase& projectDatabase) { OS_ASSERT(query.isValid()); OS_ASSERT(query.isActive()); OS_ASSERT(query.isSelect()); DakotaAlgorithmRecord_Impl::setLastValues(query,projectDatabase); }
void QxtSqlPackage::insert(QSqlQuery query) { map.clear(); record = -1; /*query will be invalid if next is not called first*/ if (!query.isValid()) query.next(); QSqlRecord infoRecord = query.record(); int iNumCols = infoRecord.count(); QVector<QString> tableMap = QVector<QString>(iNumCols); /*first create a map of index->colname pairs*/ for (int iLoop = 0; iLoop < iNumCols; iLoop++) { tableMap[iLoop] = infoRecord.fieldName(iLoop); } /*now use this created map to get column names *this should be faster than querying the QSqlRecord every time *but that depends on the databasetype and size of the table (number of rows and cols) */ do { QHash<QString, QString> hash; for (int iColLoop = 0; iColLoop < iNumCols; iColLoop++) { hash[tableMap[iColLoop]] = query.value(iColLoop).toString(); } map.append(hash); } while (query.next()); }
bool SamplingAlgorithmRecord_Impl::compareValues(const QSqlQuery& query) const { OS_ASSERT(query.isValid()); OS_ASSERT(query.isActive()); OS_ASSERT(query.isSelect()); bool result = DakotaAlgorithmRecord_Impl::compareValues(query); QVariant value; value = query.value(SamplingAlgorithmRecord::ColumnsType::samplingAlgorithmSampleType); if (value.isValid() && !value.isNull()) { result = result && m_sampleType && (*m_sampleType == analysis::SamplingAlgorithmSampleType(value.toInt())); } else { result = result && !m_sampleType; } value = query.value(SamplingAlgorithmRecord::ColumnsType::samplingAlgorithmRNGType); if (value.isValid() && !value.isNull()) { result = result && m_rngType && (*m_rngType == analysis::SamplingAlgorithmRNGType(value.toInt())); } else { result = result && !m_rngType; } return result; }
void SamplingAlgorithmRecord_Impl::setLastValues(const QSqlQuery& query, ProjectDatabase& projectDatabase) { OS_ASSERT(query.isValid()); OS_ASSERT(query.isActive()); OS_ASSERT(query.isSelect()); DakotaAlgorithmRecord_Impl::setLastValues(query,projectDatabase); QVariant value; value = query.value(SamplingAlgorithmRecord::ColumnsType::samplingAlgorithmSampleType); if (value.isValid() && !value.isNull()) { m_lastSampleType = analysis::SamplingAlgorithmSampleType(value.toInt()); } else { m_lastSampleType.reset(); } value = query.value(SamplingAlgorithmRecord::ColumnsType::samplingAlgorithmRNGType); if (value.isValid() && !value.isNull()) { m_lastRNGType = analysis::SamplingAlgorithmRNGType(value.toInt()); } else { m_lastRNGType.reset(); } }
QString Prefix::getPath(const QString prefix_name) const{ QString value; if (prefix_name == "Default"){ value = QDir::homePath(); value.append("/.wine"); return value; } QSqlQuery query; query.prepare("SELECT path FROM prefix WHERE name=:prefix_name"); query.bindValue(":prefix_name", prefix_name); if (query.exec()){ query.first(); if (query.isValid()){ if (query.value(0).toString().isEmpty()){ value = QDir::homePath(); value.append("/.wine"); } else { value.append(query.value(0).toString()); } } } else { qDebug()<<"SqlError: "<<query.lastError(); } query.clear(); return value; }
QString World::getQRZEntityName(const QString _qrz) { // qDebug() << "World::getQRZEntityName: " << _qrz << endl; QSqlQuery query; int prefixIDNumber = getPrefixId(_qrz); queryString = "SELECT dxcc FROM prefixesofentity WHERE id=='" + QString::number(prefixIDNumber) +"'"; //qDebug() << "World::getQRZEntityName: queryString-1: " << queryString << endl; query.exec(queryString); query.next(); prefixIDNumber = (query.value(0)).toInt(); //qDebug() << "World::getQRZEntityName: " <<_qrz << " = " << (query.value(0)).toString() << endl; queryString = "SELECT name FROM entity WHERE id=='" + QString::number(prefixIDNumber) +"'"; //qDebug() << "World::getQRZEntityName: queryString-2: " << queryString << endl; query.exec(queryString); query.next(); //qDebug() << "World::getQRZEntityName end: " << _qrz << " = " << (query.value(0)).toString() << endl; if (query.isValid()){ return (query.value(0)).toString(); }else{ return ""; } return ""; }
QString toQSqlConnectionSub::version() { QString ret; try { LockingPtr<QSqlDatabase> ptr(Connection, Lock); QSqlQuery query = ptr->exec(toSQL::sql("toQSqlConnection:Version", ParentConnection)); if (query.next()) { if (query.isValid()) { QSqlRecord record = query.record(); QVariant val = query.value(record.count() - 1); ret = val.toString().toLatin1(); } } } catch (std::exception const&e) { TLOG(1, toDecorator, __HERE__) << " Ignored exception:" << e.what() << std::endl; throw e; } catch (QString const&s) { TLOG(1, toDecorator, __HERE__) << " Ignored exception:" << s << std::endl; throw s; } catch (...) { TLOG(1, toDecorator, __HERE__) << " Ignored exception." << std::endl; throw; } return ret; }
int World::getQRZCqz(const QString _qrz) { //qDebug() << "World::getQRZCqz: " << _qrz << endl; QSqlQuery query; int prefixIdNumber = getPrefixId(_qrz); queryString = "SELECT cqz FROM prefixesofentity WHERE id=='" + QString::number(prefixIdNumber) +"'"; query.exec(queryString); query.next(); //qDebug() << "World::getQRZCqz: " <<_qrz << " = " << QString::number(prefixIdNumber) << endl; if (query.isValid()){ return (query.value(0)).toInt(); }else{ return -1; } return -1; }
void InputVariableRecord_Impl::setLastValues(const QSqlQuery& query, ProjectDatabase& projectDatabase) { OS_ASSERT(query.isValid()); OS_ASSERT(query.isActive()); OS_ASSERT(query.isSelect()); VariableRecord_Impl::setLastValues(query,projectDatabase); QVariant value; value = query.value(VariableRecordColumns::problemRecordId); if (value.isValid() && !value.isNull()) { m_lastProblemRecordId = value.toInt(); } else { m_lastProblemRecordId.reset(); } value = query.value(VariableRecordColumns::uncertaintyDescriptionType); if (value.isValid() && !value.isNull()) { m_lastUncertaintyDescriptionType = analysis::UncertaintyDescriptionType(value.toInt()); } else { m_lastUncertaintyDescriptionType.reset(); } value = query.value(VariableRecordColumns::inputVariableRecordType); OS_ASSERT(value.isValid() && !value.isNull()); m_lastInputVariableRecordType = InputVariableRecordType(value.toInt()); }
ObjectRecord_Impl::ObjectRecord_Impl(const ProjectDatabase& projectDatabase, const QSqlQuery& query) : Record_Impl(projectDatabase, query) { OS_ASSERT(query.isValid()); OS_ASSERT(query.isActive()); OS_ASSERT(query.isSelect()); QVariant value; value = query.value(ObjectRecordColumns::name); OS_ASSERT(value.isValid() && !value.isNull()); m_name = value.toString().toStdString(); value = query.value(ObjectRecordColumns::displayName); OS_ASSERT(value.isValid() && !value.isNull()); m_displayName = value.toString().toStdString(); value = query.value(ObjectRecordColumns::description); OS_ASSERT(value.isValid() && !value.isNull()); m_description = value.toString().toStdString(); value = query.value(ObjectRecordColumns::timestampCreate); OS_ASSERT(value.isValid() && !value.isNull()); m_timestampCreate = DateTime(value.toString().toStdString()); value = query.value(ObjectRecordColumns::timestampLast); OS_ASSERT(value.isValid() && !value.isNull()); m_timestampLast = DateTime(value.toString().toStdString()); value = query.value(ObjectRecordColumns::uuidLast); OS_ASSERT(value.isValid() && !value.isNull()); m_uuidLast = toUUID(value.toString().toStdString()); }
FunctionRecord_Impl::FunctionRecord_Impl(const QSqlQuery& query, ProjectDatabase& database) : ObjectRecord_Impl(database, query) { OS_ASSERT(query.isValid()); OS_ASSERT(query.isActive()); OS_ASSERT(query.isSelect()); QVariant value; value = query.value(FunctionRecord::ColumnsType::problemRecordId); OS_ASSERT(value.isValid() && !value.isNull()); m_problemRecordId = value.toInt(); value = query.value(FunctionRecord::ColumnsType::functionType); OS_ASSERT(value.isValid() && !value.isNull()); m_functionType = FunctionType(value.toInt()); value = query.value(FunctionRecord::ColumnsType::functionVectorIndex); OS_ASSERT(value.isValid() && !value.isNull()); m_functionVectorIndex = value.toInt(); value = query.value(FunctionRecord::ColumnsType::functionRecordType); OS_ASSERT(value.isValid() && !value.isNull()); m_functionRecordType = FunctionRecordType(value.toInt()); }
void OrganizationForm::editRecord() { if(!editName->text().isEmpty()){ QTextStream stream(&exchangeFile); QString line; while(!stream.atEnd()){ stream.readLine(); } if(indexTemp != ""){ QSqlQuery query; query.prepare("UPDATE organization SET organizationname = :name" " WHERE organizationid = :id"); query.bindValue(":name",editName->text()); query.bindValue(":id",indexTemp); query.exec(); line += "UPDATE organization SET organizationname = '"; line += editName->text().toUtf8(); line += "' WHERE organizationid = '"; line += indexTemp; line += "'"; line += "\r\n"; stream<<line; }else{ QSqlQuery query; query.prepare("SELECT * FROM organization WHERE organizationname = :name"); query.bindValue(":name",editName->text().simplified()); query.exec(); query.next(); if(!query.isValid()){ NumPrefix numPrefix(this); indexTemp = numPrefix.getPrefix("organization"); if(indexTemp == ""){ close(); }else{ QSqlQuery query; query.prepare("INSERT INTO organization (organizationid, organizationname) " "VALUES(:id, :name)"); query.bindValue(":id",indexTemp); query.bindValue(":name",editName->text().simplified()); query.exec(); line += "INSERT INTO organization (organizationid, organizationname) VALUES('"; line += indexTemp; line += "', '"; line += editName->text().toUtf8(); line += "')"; line += "\r\n"; stream<<line; } }else{ QString tempString = editName->text(); tempString += QObject::tr(" is availble!"); QMessageBox::warning(this,QObject::tr("Attention!!!"),tempString); } } emit accept(); close(); }else{ QMessageBox::warning(this,QObject::tr("Attention!!!"),tr("Name don't be empty!")); } }
ContinuousVariableRecord_Impl::ContinuousVariableRecord_Impl(const QSqlQuery& query, ProjectDatabase& database) : InputVariableRecord_Impl(query, database) { OS_ASSERT(query.isValid()); OS_ASSERT(query.isActive()); OS_ASSERT(query.isSelect()); QVariant value; value = query.value(ContinuousVariableRecord::ColumnsType::continuousVariableRecordType); OS_ASSERT(value.isValid() && !value.isNull()); m_continuousVariableRecordType = ContinuousVariableRecordType(value.toInt()); value = query.value(ContinuousVariableRecord::ColumnsType::minimum); if (value.isValid() && !value.isNull()) { m_minimum = value.toDouble(); } value = query.value(ContinuousVariableRecord::ColumnsType::maximum); if (value.isValid() && !value.isNull()) { m_maximum = value.toDouble(); } value = query.value(ContinuousVariableRecord::ColumnsType::increment); if (value.isValid() && !value.isNull()) { m_increment = value.toDouble(); } value = query.value(ContinuousVariableRecord::ColumnsType::nSteps); if (value.isValid() && !value.isNull()) { m_nSteps = value.toInt(); } }
bool FunctionRecord_Impl::compareValues(const QSqlQuery& query) const { OS_ASSERT(query.isValid()); OS_ASSERT(query.isActive()); OS_ASSERT(query.isSelect()); bool result = ObjectRecord_Impl::compareValues(query); QVariant value; value = query.value(FunctionRecord::ColumnsType::problemRecordId); OS_ASSERT(value.isValid() && !value.isNull()); result = result && (m_problemRecordId == value.toInt()); value = query.value(FunctionRecord::ColumnsType::functionType); OS_ASSERT(value.isValid() && !value.isNull()); result = result && (m_functionType == FunctionType(value.toInt())); value = query.value(FunctionRecord::ColumnsType::functionVectorIndex); OS_ASSERT(value.isValid() && !value.isNull()); result = result && (m_functionVectorIndex == value.toInt()); value = query.value(FunctionRecord::ColumnsType::functionRecordType); OS_ASSERT(value.isValid() && !value.isNull()); result = result && (m_functionRecordType == FunctionRecordType(value.toInt())); return result; }
void CloudSessionRecord_Impl::setLastValues(const QSqlQuery& query, ProjectDatabase& projectDatabase) { OS_ASSERT(query.isValid()); OS_ASSERT(query.isActive()); OS_ASSERT(query.isSelect()); ObjectRecord_Impl::setLastValues(query,projectDatabase); QVariant value; value = query.value(CloudSessionRecord::ColumnsType::cloudSessionRecordType); OS_ASSERT(value.isValid() && !value.isNull()); m_lastCloudSessionRecordType = CloudSessionRecordType(value.toInt()); value = query.value(CloudSessionRecord::ColumnsType::sessionId); OS_ASSERT(value.isValid() && !value.isNull()); m_lastSessionId = value.toString().toStdString(); value = query.value(CloudSessionRecord::ColumnsType::serverUrlRecordId); if (value.isValid() && !value.isNull()) { m_lastServerUrlRecordId = value.toInt(); } else { m_lastServerUrlRecordId.reset(); } }
bool CloudSessionRecord_Impl::compareValues(const QSqlQuery& query) const { OS_ASSERT(query.isValid()); OS_ASSERT(query.isActive()); OS_ASSERT(query.isSelect()); bool result = ObjectRecord_Impl::compareValues(query); QVariant value; value = query.value(CloudSessionRecord::ColumnsType::cloudSessionRecordType); OS_ASSERT(value.isValid() && !value.isNull()); result = result && (m_cloudSessionRecordType == CloudSessionRecordType(value.toInt())); value = query.value(CloudSessionRecord::ColumnsType::sessionId); OS_ASSERT(value.isValid() && !value.isNull()); result = result && (m_sessionId == value.toString().toStdString()); value = query.value(CloudSessionRecord::ColumnsType::serverUrlRecordId); if (value.isValid() && !value.isNull()) { result = result && m_serverUrlRecordId && (*m_serverUrlRecordId == value.toInt()); } else { result = result && !m_serverUrlRecordId; } return result; }
void VagrantSessionRecord_Impl::setLastValues(const QSqlQuery& query, ProjectDatabase& projectDatabase) { OS_ASSERT(query.isValid()); OS_ASSERT(query.isActive()); OS_ASSERT(query.isSelect()); CloudSessionRecord_Impl::setLastValues(query,projectDatabase); }
VagrantSessionRecord_Impl::VagrantSessionRecord_Impl(const QSqlQuery& query, ProjectDatabase& database) : CloudSessionRecord_Impl(query, database) { OS_ASSERT(query.isValid()); OS_ASSERT(query.isActive()); OS_ASSERT(query.isSelect()); }
VariableRecord_Impl::VariableRecord_Impl(const QSqlQuery& query, const ProjectDatabase& database) : ObjectRecord_Impl(database, query) { OS_ASSERT(query.isValid()); OS_ASSERT(query.isActive()); OS_ASSERT(query.isSelect()); QVariant value; value = query.value(VariableRecordColumns::functionRecordId); if (value.isValid() && !value.isNull()) { m_functionRecordId = value.toInt(); } value = query.value(VariableRecordColumns::variableVectorIndex); OS_ASSERT(value.isValid() && !value.isNull()); m_variableVectorIndex = value.toInt(); value = query.value(VariableRecordColumns::functionCoefficient); if (value.isValid() && !value.isNull()) { m_functionCoefficient = value.toDouble(); } value = query.value(VariableRecordColumns::variableRecordType); OS_ASSERT(value.isValid() && !value.isNull()); m_variableRecordType = VariableRecordType(value.toInt()); }
void DBManager::deleteServerUserByName(QString a) { QSqlQuery query; query.prepare("delete from serveruser where name = (?)"); query.addBindValue(a); if(!query.isValid()) query.exec(); }
void DBManager::deleteServerUserByID(int a) { QSqlQuery query; query.prepare("delete from serveruser where userid = (?)"); query.addBindValue(a); if(!query.isValid()) query.exec(); }