X-Git-Url: http://git.osdn.net/view?a=blobdiff_plain;f=proxy%2Ftmdatabase.h;h=b60165c5c044e0fbe9fae165451d0f0e7210b0f6;hb=fc5c863e3c8872841801073eb5afe2918ac327e6;hp=e1fdc70649de0ae4b6d3b62b9465409dd0b6d11a;hpb=658be98969b857ecd401213f9a1ade846b5daf47;p=wordring-tm%2Fwordring-tm.git

diff --git a/proxy/tmdatabase.h b/proxy/tmdatabase.h
index e1fdc70..b60165c 100644
--- 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: