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