void MainTest::selectPostsWithoutTitle() { auto q = db.posts()->createQuery(); q->setWhere(Post::titleField().isNull()); auto count = q->count(); qDebug() << "selectPostsWithoutTitle, count=" << count; QTEST_ASSERT(count == 0); }
void MainTest::modifyPost() { auto q = db.posts()->createQuery(); q->setWhere(Post::idField() == postId); Post *post = q->first(); QTEST_ASSERT(post != 0); post->setTitle("new name"); db.saveChanges(); q = FROM(db.posts()) WHERE(Post::idField() == postId); post = q->first(); QTEST_ASSERT(post->title() == "new name"); }
void WidgetContact::mousePressEvent( QMouseEvent * event ) { if ( event->buttons() & Qt::RightButton && m_state == Normal ) { QMenu menu; menu.addAction( "Установить " + whoStr(), this, SLOT( setWho() ) ); menu.addAction( "Установить " + whereStr(), this, SLOT( setWhere() ) ); menu.addAction( "Установить Индекс", this, SLOT( setIndex() ) ); menu.addSeparator(); menu.addAction( QIcon::fromTheme("preferences-desktop-font", QIcon(":/font.png") ), "Выбрать &шрифт", this, SLOT( selectAddressFont() ) ); contextMenu( menu ); menu.exec( event->globalPos() ); } }
void MainTest::selectPosts() { // auto q = FROM(db.posts()) // JOIN(Comment) // WHERE(Post::idField() == postId); auto q = db.posts()->createQuery(); q->join(Post::commentsTable()); q->orderBy(!Post::saveDateField() & Post::bodyField()); q->setWhere(Post::idField() == postId); auto posts = q->toList(); post = posts.at(0); post->setBody(""); QTEST_ASSERT(posts.length() == 1); QTEST_ASSERT(posts.at(0)->comments()->length() == 3); QTEST_ASSERT(posts.at(0)->title() == "post title"); QTEST_ASSERT(posts.at(0)->comments()->at(0)->message() == "comment #0"); QTEST_ASSERT(posts.at(0)->comments()->at(1)->message() == "comment #1"); QTEST_ASSERT(posts.at(0)->comments()->at(2)->message() == "comment #2"); db.cleanUp(); }
void WidgetContact::editReturned() { switch ( m_state ) { case SettingWho: m_who = m_edit->text().trimmed(); emit whoChanged( m_who ); if ( m_newly ) { setWhere(); return; } else break; case SettingWhere: m_where = m_edit->text().trimmed(); emit whereChanged( m_where ); if ( m_newly ) { setIndex(); return; } else break; case SettingIndex: m_index = m_edit->text().trimmed(); emit indexChanged( m_index ); break; default: return; } m_edit->hide(); m_state = Normal; update(); }
void ADQuery::setCondition(const QString &condition) { if ( m_cwhere.isNull() ) setWhere("'t'"); m_cwhere += " " + condition + " "; }