Exemplo n.º 1
0
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;
}
Exemplo n.º 2
0
  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();
             }
 }
Exemplo n.º 4
0
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;
}
Exemplo n.º 5
0
  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;
  }
Exemplo n.º 6
0
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();
}
Exemplo n.º 7
0
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();
}
Exemplo n.º 8
0
  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());
    }
  }
Exemplo n.º 9
0
  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);
}
Exemplo n.º 11
0
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());
}
Exemplo n.º 12
0
  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;
  }
Exemplo n.º 13
0
  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();
    }
  }
Exemplo n.º 14
0
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;
}
Exemplo n.º 15
0
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 "";
}
Exemplo n.º 16
0
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;
}
Exemplo n.º 17
0
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;




}
Exemplo n.º 18
0
  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());
  }
Exemplo n.º 19
0
  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());
  }
Exemplo n.º 20
0
  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());
  }
Exemplo n.º 21
0
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();
    }

  }
Exemplo n.º 23
0
  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;
  }
Exemplo n.º 24
0
  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();
    }
  }
Exemplo n.º 25
0
  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;
  }
Exemplo n.º 26
0
  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);
  }
Exemplo n.º 27
0
 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());
 }
Exemplo n.º 28
0
  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());
  }
Exemplo n.º 29
0
void DBManager::deleteServerUserByName(QString a)
{
    QSqlQuery query;
    query.prepare("delete from serveruser where name  =  (?)");
    query.addBindValue(a);
    if(!query.isValid())
        query.exec();
}
Exemplo n.º 30
0
void DBManager::deleteServerUserByID(int a)
{
    QSqlQuery query;
    query.prepare("delete from serveruser where userid  =  (?)");
    query.addBindValue(a);
    if(!query.isValid())
        query.exec();
}