Initial commit

4 files changed, 158 insertions, 0 deletions

diff --git a/common/common.pri b/common/common.pri
new file mode 100644
index 0000000..e1d299f
--- /dev/null
+++ b/common/common.pri
@@ -0,0 +1,4 @@
+INCLUDEPATH += $$PWD
+DEPENDPATH += .
+
+LIBS += -L$$PWD -lmastodoncommon
diff --git a/common/common.pro b/common/common.pro
new file mode 100644
index 0000000..eec5b5f
--- /dev/null
+++ b/common/common.pro
@@ -0,0 +1,21 @@
+TEMPLATE = lib
+
+QT -= gui
+QT += sql
+
+CONFIG += link_pkgconfig
+PKGCONFIG += socialcache
+
+TARGET = mastodoncommon
+TARGET = $$qtLibraryTarget($$TARGET)
+
+HEADERS += \
+    $$PWD/mastodonpostsdatabase.h
+
+SOURCES += \
+    $$PWD/mastodonpostsdatabase.cpp
+
+TARGETPATH = $$[QT_INSTALL_LIBS]
+target.path = $$TARGETPATH
+
+INSTALLS += target
diff --git a/common/mastodonpostsdatabase.cpp b/common/mastodonpostsdatabase.cpp
new file mode 100644
index 0000000..fa6ddd3
--- /dev/null
+++ b/common/mastodonpostsdatabase.cpp
@@ -0,0 +1,87 @@
+/*
+ * Copyright (C) 2026 Open Mobile Platform LLC.
+ *
+ * This library is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU Lesser General Public
+ * License as published by the Free Software Foundation; either
+ * version 2.1 of the License, or (at your option) any later version.
+ *
+ * This library is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+ * Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public
+ * License along with this library; if not, write to the Free Software
+ * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
+ */
+
+#include "mastodonpostsdatabase.h"
+
+static const char *DB_NAME = "mastodon.db";
+static const char *ACCOUNT_NAME_KEY = "account_name";
+static const char *URL_KEY = "url";
+static const char *BOOSTED_BY_KEY = "boosted_by";
+static const char *INSTANCE_URL_KEY = "instance_url";
+
+MastodonPostsDatabase::MastodonPostsDatabase()
+    : AbstractSocialPostCacheDatabase(QStringLiteral("mastodon"), QLatin1String(DB_NAME))
+{
+}
+
+MastodonPostsDatabase::~MastodonPostsDatabase()
+{
+}
+
+void MastodonPostsDatabase::addMastodonPost(
+        const QString &identifier,
+        const QString &name,
+        const QString &accountName,
+        const QString &body,
+        const QDateTime &timestamp,
+        const QString &icon,
+        const QList<QPair<QString, SocialPostImage::ImageType> > &images,
+        const QString &url,
+        const QString &boostedBy,
+        const QString &instanceUrl,
+        int account)
+{
+    QVariantMap extra;
+    extra.insert(ACCOUNT_NAME_KEY, accountName);
+    extra.insert(URL_KEY, url);
+    extra.insert(BOOSTED_BY_KEY, boostedBy);
+    extra.insert(INSTANCE_URL_KEY, instanceUrl);
+    addPost(identifier, name, body, timestamp, icon, images, extra, account);
+}
+
+QString MastodonPostsDatabase::accountName(const SocialPost::ConstPtr &post)
+{
+    if (post.isNull()) {
+        return QString();
+    }
+    return post->extra().value(ACCOUNT_NAME_KEY).toString();
+}
+
+QString MastodonPostsDatabase::url(const SocialPost::ConstPtr &post)
+{
+    if (post.isNull()) {
+        return QString();
+    }
+    return post->extra().value(URL_KEY).toString();
+}
+
+QString MastodonPostsDatabase::boostedBy(const SocialPost::ConstPtr &post)
+{
+    if (post.isNull()) {
+        return QString();
+    }
+    return post->extra().value(BOOSTED_BY_KEY).toString();
+}
+
+QString MastodonPostsDatabase::instanceUrl(const SocialPost::ConstPtr &post)
+{
+    if (post.isNull()) {
+        return QString();
+    }
+    return post->extra().value(INSTANCE_URL_KEY).toString();
+}
diff --git a/common/mastodonpostsdatabase.h b/common/mastodonpostsdatabase.h
new file mode 100644
index 0000000..d5fdea7
--- /dev/null
+++ b/common/mastodonpostsdatabase.h
@@ -0,0 +1,46 @@
+/*
+ * Copyright (C) 2026 Open Mobile Platform LLC.
+ *
+ * This library is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU Lesser General Public
+ * License as published by the Free Software Foundation; either
+ * version 2.1 of the License, or (at your option) any later version.
+ *
+ * This library is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+ * Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public
+ * License along with this library; if not, write to the Free Software
+ * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
+ */
+
+#ifndef MASTODONPOSTSDATABASE_H
+#define MASTODONPOSTSDATABASE_H
+
+#include <socialcache/abstractsocialpostcachedatabase.h>
+
+class MastodonPostsDatabase: public AbstractSocialPostCacheDatabase
+{
+    Q_OBJECT
+public:
+    MastodonPostsDatabase();
+    ~MastodonPostsDatabase();
+
+    void addMastodonPost(const QString &identifier, const QString &name,
+                         const QString &accountName, const QString &body,
+                         const QDateTime &timestamp,
+                         const QString &icon,
+                         const QList<QPair<QString, SocialPostImage::ImageType> > &images,
+                         const QString &url, const QString &boostedBy,
+                         const QString &instanceUrl,
+                         int account);
+
+    static QString accountName(const SocialPost::ConstPtr &post);
+    static QString url(const SocialPost::ConstPtr &post);
+    static QString boostedBy(const SocialPost::ConstPtr &post);
+    static QString instanceUrl(const SocialPost::ConstPtr &post);
+};
+
+#endif // MASTODONPOSTSDATABASE_H