コード例 #1
0
ファイル: engineerexam.cpp プロジェクト: ppkt/EngineerExam
void EngineerExam::parseQuestions(QString filename) {
    QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
    db.setDatabaseName(filename);
    if (!db.open()) {
	qCritical() << trUtf8("Nie można otworzyć bazy danych!");
    }

    QSqlTableModel question;
    question.setTable("Question");
    question.select();

    QSqlTableModel answers;
    answers.setTable("Answer");
    answers.select();

    QStringList qsl;

    int i = 0;
    while (question.canFetchMore()) {
	question.fetchMore();
	for (; i < question.rowCount(); ++i) {
	    qsl.clear();

	    quint32 id = question.record(i).value("Id").toUInt();
	    QString text = question.record(i).value("Text").toString();
	    Question q;
	    q.setId(id);
	    q.setQuestion(text);

	    answers.setFilter(QString("`id_Question` = %1").arg(id));
	    QString a1 = answers.record(0).value("Text").toString();
	    QString a2 = answers.record(1).value("Text").toString();
	    QString a3 = answers.record(2).value("Text").toString();
	    qsl << a1 << a2 << a3;

	    bool correct1 = answers.record(0).value("IsTrue").toBool();
	    bool correct2 = answers.record(1).value("IsTrue").toBool();
	    bool correct3 = answers.record(2).value("IsTrue").toBool();

	    if (correct1) {
		q.setCorrectAnswer(0);
	    } else if (correct2) {
		q.setCorrectAnswer(1);
	    } else if (correct3) {
		q.setCorrectAnswer(2);
	    }
	    q.setAnswers(qsl);
	    tmpList.append(q);
	}
    }
}
コード例 #2
0
ファイル: theme.cpp プロジェクト: TheCodingArt/QTester
Question Theme::selectQuestion( const QSqlQuery &query ) const
{ // reject into new method.  Question makeQuestion(const QSqlQueru &query)
    using namespace Tables::Question::Field;
    Question issue;

    QString id = query.value( query.record().indexOf( QUESTION_ID ) ).toString(),
        text = query.value( query.record().indexOf( TEXT ) ).toString(),
        type = query.value( query.record().indexOf( QUESTION_TYPE ) ).toString();
    bool caseSens = query.value( query.record().indexOf( CASE_SENS ) ).toBool(),
        stripSpace = query.value( query.record().indexOf( STRIP_SPACE ) ).toBool();

    QTime time = query.value( query.record().indexOf( RECOMENDED_TIME ) ).toTime();

    issue.setId( id );
    issue.setText( text );
    issue.setType( type );
    issue.setTime( time );
    issue.setCaseSensitivity( caseSens );
    issue.setStripSpaces( stripSpace );
    return issue;
}