Changeset 379:dfe775e5d7fc

Timestamp:

05/18/2009 10:59:47 PM (3 years ago)

Author:

Dmitry Nezhevenko <dion@…>

Branch:

default

Message:

Calculate sentences statistic

Files:

• sql/update/pgsql/00374.sql (modified) (1 diff)
• src/plugins/muc/jidstat.cpp (modified) (2 diffs)
• src/plugins/muc/jidstat.h (modified) (1 diff)
• src/plugins/muc/mucplugin.cpp (modified) (1 diff)

sql/update/pgsql/00374.sql

@@ -8 +8 @@
   lastaction int NOT NULL default '0',
   lastreason varchar(200) NULL,
+
+  msg_count int NOT NULL default 0,
+  msg_chars int NOT NULL default 0,
+  msg_words int NOT NULL default 0,
+  msg_sentences int NOT NULL default 0,
+  msg_me int NOT NULL default 0,
+  msg_reply int NOT NULL default 0,
 
   cnt_join int NOT NULL default 0,

src/plugins/muc/jidstat.cpp

@@ -26 +26 @@
 #include <QSqlError>
 #include <QVariant>
+#include <QRegExp>
 
 JidStat::JidStat(int jidId)
@@ -197 +198 @@
 
 }
+
+void JidStat::statMessage(const QString& message)
+{
+        if (id_ <= 0)
+                return;
+        QString msg = message.trimmed();
+        int msgChars = msg.length();
+        int msgWords = 0;
+        int msgSentences = 0;
+        int msgMe = 0;
+        if (msg.toLower().startsWith("/me "))
+                msgMe = 1;
+        bool hasWord = false;
+        for (int i = 0; i < msgChars; ++i )
+        {
+                QChar chr = msg[i];
+                if (chr == '.' || chr == '?' || chr == '!')
+                {
+                        if (hasWord)
+                        {
+                                ++msgSentences;
+                                ++msgWords;
+                        }
+                        hasWord = false;
+                        continue;
+                }
+                else if (chr.isSpace())
+                {
+                        if (hasWord)
+                                ++msgWords;
+                        hasWord = false;
+                        continue;
+                }
+                hasWord = true;
+        }
+        if (hasWord)
+        {
+                ++msgWords;
+                ++msgSentences;
+        }
+
+        QSqlQuery q = DataStorage::instance()->prepareQuery(
+                "UPDATE conference_jidstat SET msg_count = msg_count + 1,"
+                " msg_chars = msg_chars + ?, msg_words = msg_words + ?,"
+                " msg_sentences = msg_sentences + ?, msg_me = msg_me + ? WHERE id=?");
+        q.addBindValue(msgChars);
+        q.addBindValue(msgWords);
+        q.addBindValue(msgSentences);
+        q.addBindValue(msgMe);
+        q.addBindValue(id_);
+        if (!q.exec())
+        {
+                qDebug() << "ERROR: Unable to stat sentence: " << q.lastError().text();
+        }
+}
+
+void JidStat::statReply()
+{
+        if (id_ <= 0)
+                return;
+
+        QSqlQuery q = DataStorage::instance()->prepareQuery(
+                "UPDATE conference_jidstat SET msg_reply = msg_reply + 1 WHERE id=?");
+        q.addBindValue(id_);
+        if (!q.exec())
+        {
+                qDebug() << "ERROR: Unable to stat reply: " << q.lastError().text();
+        }
+}
+

src/plugins/muc/jidstat.h

@@ -55 +55 @@
         void setVersion(const QString& version);
         void updateOnlineTime();
+        void statMessage(const QString& msg);
+        void statReply();
 private:
         int id_;

src/plugins/muc/mucplugin.cpp

@@ -532 +532 @@
         nick->updateLastActivity();
         nick->commit();
+
+        QString msgBody = QString::fromStdString(s->body());
+        JidStat *stat = nick->jidStat();
+        if (stat)
+                stat->statMessage(msgBody);
+
+        if (msgBody.contains(':'))
+        {
+                // Calc also highlights
+                QString dstNickStr = msgBody.section(':', 0, 0);
+                Nick *dstNick=conf->nicks()->byName(dstNickStr);
+                if (dstNick && nick != dstNick && dstNick->jidStat())
+                        dstNick->jidStat()->statReply();
+        }
 
         checkMember(s, conf, nick);