ソケットの終了処理追加。

[wordring-tm/wordring-tm.git] / proxy / tmdatabase.h

diff --git a/proxy/tmdatabase.h b/proxy/tmdatabase.h
index e1fdc70..b60165c 100644 (file)
--- a/proxy/tmdatabase.h
+++ b/proxy/tmdatabase.h
@@ -96,6 +96,14 @@ public:
        ~SentenceDatabase();
 
        int sentence_id(QString sentence);
+
+//     bool find_sentence_by_source_sentence(
+//                     QString sentence, QString *tsentence, QJsonArray *json = nullptr);
+       bool find_sentence_by_crc(
+                       quint32 crc, QString *tsentence, QJsonArray *json = nullptr);
+       bool find_sentence_by_source_id(
+                       int source_id, QString *tsentence, QJsonArray *json = nullptr);
+
        void insert(int source_id, QString sentence, QString json, int user_id);
 
 private:
@@ -110,6 +118,9 @@ private:
        QSqlDatabase m_database;
 
        query_pointer m_find_sentence_id;
+       query_pointer m_find_sentence;
+       query_pointer m_find_sentence_by_crc;
+       query_pointer m_find_sentence_by_source_id;
        query_pointer m_insert_sentence;
 };
 
@@ -131,9 +142,14 @@ public:
 
        void open_word_database(int code, QString name);
        int find_word_id(int code, QString word);
-
+private:
        SentenceDatabase::pointer find_sentence_database(int site_id, int code);
+public:
        int find_sentence_id(int site_id, int code, QString sentence);
+       bool find_sentence(int site_id, int scode, QString ssentence, int tcode,
+                                          QString *tsentence, QJsonArray *json);
+       void insert_sentence(int site_id, int code, int source_id,
+                                               QString sentence, QString json, int user_id);
 
        static QString root_key();
 signals: