QString FacebookPostsDatabase::attachmentDescription(const SocialPost::ConstPtr &post)
{
if (post.isNull()) {
return QString();
}
return post->extra().value(ATTACHMENT_DESCRIPTION_KEY).toString();
}
QString FacebookPostsDatabase::attachmentUrl(const SocialPost::ConstPtr &post)
{
if (post.isNull()) {
return QString();
}
return post->extra().value(ATTACHMENT_URL_KEY).toString();
}
bool FacebookPostsDatabase::allowComment(const SocialPost::ConstPtr &post)
{
if (post.isNull()) {
return false;
}
return post->extra().value(ALLOW_COMMENT_KEY).toBool();
}
QString FacebookPostsDatabase::clientId(const SocialPost::ConstPtr &post)
{
if (post.isNull()) {
return QString();
}
return post->extra().value(CLIENT_ID_KEY).toString();
}
QString TwitterPostsDatabase::consumerSecret(const SocialPost::ConstPtr &post)
{
if (post.isNull()) {
return QString();
}
return post->extra().value(CONSUMER_SECRET_KEY).toString();
}
QString TwitterPostsDatabase::retweeter(const SocialPost::ConstPtr &post)
{
if (post.isNull()) {
return QString();
}
return post->extra().value(RETWEETER_KEY).toString();
}
QString TwitterPostsDatabase::screenName(const SocialPost::ConstPtr &post)
{
if (post.isNull()) {
return QString();
}
return post->extra().value(SCREEN_NAME_KEY).toString();
}
void posts()
{
QDateTime time1(QDate(2013, 1, 2), QTime(12, 34, 56));
QDateTime time2(QDate(2012, 3, 4), QTime(10, 11, 12));
const QString id1 = QLatin1String("id1");
const QString id2 = QLatin1String("id2");
const QString id3 = QLatin1String("id3");
const QString name1 = QLatin1String("name1");
const QString name2 = QLatin1String("name2");
const QString name3 = QLatin1String("name3");
const QString body1 = QLatin1String("body1");
const QString body2 = QLatin1String("body2");
const QString body3 = QLatin1String("body3");
const QString icon1 = QLatin1String("/icon.jpg");
const QString image1 = QLatin1String("http://example.com/image1.jpg");
const QString image2 = QLatin1String("http://example.com/image2.jpg");
const QString image3 = QLatin1String("http://example.com/image3.jpg");
const QString screen1 = QLatin1String("screen1");
const QString retweeter1 = QLatin1String("retweeter1");
const QString key1 = QLatin1String("key1");
const QString secret1 = QLatin1String("secret1");
TwitterPostsDatabase database;
database.addTwitterPost(
id1, name1, body1, time1, icon1,
QList<QPair<QString, SocialPostImage::ImageType> >()
<< qMakePair(image1, SocialPostImage::Photo)
<< qMakePair(image2, SocialPostImage::Video),
screen1, retweeter1, key1, secret1, 1);
database.addTwitterPost(
id1, name1, body1, time1, icon1,
QList<QPair<QString, SocialPostImage::ImageType> >()
<< qMakePair(image1, SocialPostImage::Photo)
<< qMakePair(image2, SocialPostImage::Video),
screen1, retweeter1, key1, secret1, 2);
database.addTwitterPost(
id2, name2, body2, time2, icon1,
QList<QPair<QString, SocialPostImage::ImageType> >()
<< qMakePair(image3, SocialPostImage::Photo),
screen1, retweeter1, key1, secret1, 1);
database.addTwitterPost(
id3, name3, body3, time2, icon1,
QList<QPair<QString, SocialPostImage::ImageType> >(),
screen1, retweeter1, key1, secret1, 2);
database.commit();
database.wait();
QCOMPARE(database.writeStatus(), AbstractSocialCacheDatabase::Finished);
database.refresh();
database.wait();
QCOMPARE(database.readStatus(), AbstractSocialCacheDatabase::Finished);
QList<SocialPost::ConstPtr> posts;
posts = database.posts();
QCOMPARE(posts.count(), 3);
SocialPost::ConstPtr post;
do {
post = posts.takeFirst();
} while (post->identifier() != id1 && posts.count() > 0);
QCOMPARE(post->identifier(), id1);
QCOMPARE(post->name(), name1);
QCOMPARE(post->body(), body1);
QCOMPARE(post->timestamp(), time1);
QCOMPARE(post->icon(), icon1);
QCOMPARE(post->images().count(), 2);
QCOMPARE(TwitterPostsDatabase::screenName(post), screen1);
QCOMPARE(TwitterPostsDatabase::retweeter(post), retweeter1);
QCOMPARE(TwitterPostsDatabase::consumerKey(post), key1);
QCOMPARE(TwitterPostsDatabase::consumerSecret(post), secret1);
QCOMPARE(post->accounts().count(), 2);
database.removePosts(2);
database.commit();
database.refresh();
database.wait();
QCOMPARE(database.writeStatus(), AbstractSocialCacheDatabase::Finished);
QCOMPARE(database.readStatus(), AbstractSocialCacheDatabase::Finished);
posts = database.posts();
QCOMPARE(posts.count(), 2);
database.removePosts(1);
database.commit();
database.refresh();
database.wait();
QCOMPARE(database.writeStatus(), AbstractSocialCacheDatabase::Finished);
QCOMPARE(database.readStatus(), AbstractSocialCacheDatabase::Finished);
posts = database.posts();
QCOMPARE(posts.count(), 0);
}
void posts()
{
QDateTime time1(QDate(2013, 1, 2), QTime(12, 34, 56));
QDateTime time2(QDate(2012, 3, 4), QTime(10, 11, 12));
const QString id1 = QLatin1String("id1");
const QString id2 = QLatin1String("id2");
const QString id3 = QLatin1String("id3");
const QString name1 = QLatin1String("name1");
const QString name2 = QLatin1String("name2");
const QString name3 = QLatin1String("name3");
const QString body1 = QLatin1String("body1");
const QString body2 = QLatin1String("body2");
const QString body3 = QLatin1String("body3");
const QString icon1 = QLatin1String("/icon.jpg");
const QString image1 = QLatin1String("http://example.com/image1.jpg");
const QString image2 = QLatin1String("http://example.com/image2.jpg");
const QString image3 = QLatin1String("http://example.com/image3.jpg");
const QString attachment1 = QLatin1String("attachment1");
const QString caption1 = QLatin1String("caption1");
const QString description1 = QLatin1String("description1");
const QString url1 = QLatin1String("http://example.com/attachment.png");
const QString client1 = QLatin1String("client1");
FacebookPostsDatabase database;
database.addFacebookPost(
id1, name1, body1, time1, icon1,
QList<QPair<QString, SocialPostImage::ImageType> >()
<< qMakePair(image1, SocialPostImage::Photo)
<< qMakePair(image2, SocialPostImage::Video),
attachment1, caption1, description1, url1,
true, true, client1, 1);
database.addFacebookPost(
id1, name1, body1, time1, icon1,
QList<QPair<QString, SocialPostImage::ImageType> >()
<< qMakePair(image1, SocialPostImage::Photo)
<< qMakePair(image2, SocialPostImage::Video),
attachment1, caption1, description1, url1,
true, true, client1, 2);
database.addFacebookPost(
id2, name2, body2, time2, icon1,
QList<QPair<QString, SocialPostImage::ImageType> >()
<< qMakePair(image3, SocialPostImage::Photo),
QString(), QString(), QString(), QString(),
false, false, client1, 1);
database.addFacebookPost(
id3, name3, body3, time2, icon1,
QList<QPair<QString, SocialPostImage::ImageType> >(),
QString(), QString(), QString(), QString(),
true, true, client1, 2);
database.commit();
database.wait();
QCOMPARE(database.writeStatus(), AbstractSocialCacheDatabase::Finished);
database.refresh();
database.wait();
QCOMPARE(database.readStatus(), AbstractSocialCacheDatabase::Finished);
QList<SocialPost::ConstPtr> posts;
posts = database.posts();
QCOMPARE(posts.count(), 3);
SocialPost::ConstPtr post;
do {
post = posts.takeFirst();
} while (post->identifier() != id1 && posts.count() > 0);
QCOMPARE(post->identifier(), id1);
QCOMPARE(post->name(), name1);
QCOMPARE(post->body(), body1);
QCOMPARE(post->timestamp(), time1);
QCOMPARE(post->icon(), icon1);
QCOMPARE(post->images().count(), 2);
QCOMPARE(FacebookPostsDatabase::attachmentName(post), attachment1);
QCOMPARE(FacebookPostsDatabase::attachmentCaption(post), caption1);
QCOMPARE(FacebookPostsDatabase::attachmentDescription(post), description1);
QCOMPARE(FacebookPostsDatabase::attachmentUrl(post), url1);
QCOMPARE(FacebookPostsDatabase::allowLike(post), true);
QCOMPARE(FacebookPostsDatabase::allowComment(post), true);
QCOMPARE(FacebookPostsDatabase::clientId(post), client1);
QCOMPARE(post->accounts().count(), 2);
database.removePosts(2);
database.commit();
database.refresh();
database.wait();
QCOMPARE(database.writeStatus(), AbstractSocialCacheDatabase::Finished);
QCOMPARE(database.readStatus(), AbstractSocialCacheDatabase::Finished);
posts = database.posts();
QCOMPARE(posts.count(), 2);
database.removePosts(1);
database.commit();
database.refresh();
database.wait();
QCOMPARE(database.writeStatus(), AbstractSocialCacheDatabase::Finished);
QCOMPARE(database.readStatus(), AbstractSocialCacheDatabase::Finished);
posts = database.posts();
QCOMPARE(posts.count(), 0);
}