1 #include "../../include/freenet/messagelistinserter.h"
\r
2 #include "../../include/freenet/messagexml.h"
\r
3 #include "../../include/freenet/messagelistxml.h"
\r
9 MessageListInserter::MessageListInserter()
\r
14 MessageListInserter::MessageListInserter(FCPv2 *fcp):IIndexInserter<long>(fcp)
\r
19 void MessageListInserter::CheckForNeededInsert()
\r
21 // only do 1 insert at a time
\r
22 if(m_inserting.size()==0)
\r
28 previous.SetToGMTime();
\r
30 previous.Add(0,0,0,-m_daysbackward);
\r
32 // query for identities that have messages in the past X days and we haven't inserted lists for in the past 30 minutes
\r
33 SQLite3DB::Statement st=m_db->Prepare("SELECT tblLocalIdentity.LocalIdentityID FROM tblLocalIdentity INNER JOIN tblMessageInserts ON tblLocalIdentity.LocalIdentityID=tblMessageInserts.LocalIdentityID WHERE tblMessageInserts.Day>=? AND (tblLocalIdentity.LastInsertedMessageList<=? OR tblLocalIdentity.LastInsertedMessageList IS NULL OR tblLocalIdentity.LastInsertedMessageList='');");
\r
34 st.Bind(0,previous.Format("%Y-%m-%d"));
\r
35 st.Bind(1,(now-(1.0/48.0)).Format("%Y-%m-%d %H:%M:%S"));
\r
38 if(st.RowReturned())
\r
40 int localidentityid;
\r
41 st.ResultInt(0,localidentityid);
\r
42 StartInsert(localidentityid);
\r
48 const bool MessageListInserter::HandlePutFailed(FCPMessage &message)
\r
50 std::vector<std::string> idparts;
\r
51 long localidentityid;
\r
54 StringFunctions::Split(message["Identifier"],"|",idparts);
\r
55 StringFunctions::Convert(idparts[1],localidentityid);
\r
56 StringFunctions::Convert(idparts[2],index);
\r
58 if(message["Fatal"]=="true" || message["Code"]=="9")
\r
60 SQLite3DB::Statement st=m_db->Prepare("INSERT INTO tblMessageListInserts(LocalIdentityID,Day,InsertIndex,Inserted) VALUES(?,?,?,'false');");
\r
61 st.Bind(0,localidentityid);
\r
62 st.Bind(1,idparts[4]);
\r
67 RemoveFromInsertList(localidentityid);
\r
73 const bool MessageListInserter::HandlePutSuccessful(FCPMessage &message)
\r
76 std::vector<std::string> idparts;
\r
77 long localidentityid;
\r
80 StringFunctions::Split(message["Identifier"],"|",idparts);
\r
81 StringFunctions::Convert(idparts[1],localidentityid);
\r
82 StringFunctions::Convert(idparts[2],index);
\r
84 SQLite3DB::Statement st=m_db->Prepare("INSERT INTO tblMessageListInserts(LocalIdentityID,Day,InsertIndex,Inserted) VALUES(?,?,?,'true');");
\r
85 st.Bind(0,localidentityid);
\r
86 st.Bind(1,idparts[4]);
\r
91 st=m_db->Prepare("UPDATE tblLocalIdentity SET LastInsertedMessageList=? WHERE LocalIdentityID=?;");
\r
92 st.Bind(0,now.Format("%Y-%m-%d %H:%M:%S"));
\r
93 st.Bind(1,localidentityid);
\r
96 RemoveFromInsertList(localidentityid);
\r
101 void MessageListInserter::Initialize()
\r
103 std::string tempval;
\r
105 m_fcpuniquename="MessageListInserter";
\r
107 Option::instance()->Get("MessageListDaysBackward",tempval);
\r
108 StringFunctions::Convert(tempval,m_daysbackward);
\r
111 void MessageListInserter::StartInsert(const long &localidentityid)
\r
113 FCPMessage message;
\r
116 std::string privatekey;
\r
117 std::string localidentityidstr;
\r
118 MessageListXML mlxml;
\r
119 MessageXML messxml;
\r
120 std::string xmlstr;
\r
121 std::string xmlsizestr;
\r
123 std::string indexstr;
\r
126 date.SetToGMTime();
\r
127 date.Add(0,0,0,-m_daysbackward);
\r
128 StringFunctions::Convert(localidentityid,localidentityidstr);
\r
130 SQLite3DB::Statement st=m_db->Prepare("SELECT Day, InsertIndex, MessageXML, PrivateKey FROM tblMessageInserts INNER JOIN tblLocalIdentity ON tblMessageInserts.LocalIdentityID=tblLocalIdentity.LocalIdentityID WHERE tblLocalIdentity.LocalIdentityID=? AND Day>=?;");
\r
131 st.Bind(0,localidentityid);
\r
132 st.Bind(1,date.Format("%Y-%m-%d"));
\r
135 while(st.RowReturned())
\r
139 std::string xmlstr;
\r
140 std::vector<std::string> boards;
\r
142 st.ResultText(0,day);
\r
143 st.ResultInt(1,index);
\r
144 st.ResultText(2,xmlstr);
\r
145 st.ResultText(3,privatekey);
\r
147 messxml.ParseXML(xmlstr);
\r
149 mlxml.AddMessage(day,index,messxml.GetBoards());
\r
155 // get last inserted messagelist index for this day
\r
157 st=m_db->Prepare("SELECT MAX(InsertIndex) FROM tblMessageListInserts WHERE LocalIdentityID=? AND Day=?;");
\r
158 st.Bind(0,localidentityid);
\r
159 st.Bind(1,now.Format("%Y-%m-%d"));
\r
161 if(st.ResultNull(0)==false)
\r
163 st.ResultInt(0,index);
\r
166 StringFunctions::Convert(index,indexstr);
\r
168 // actually insert message
\r
169 xmlstr=mlxml.GetXML();
\r
170 StringFunctions::Convert(xmlstr.size(),xmlsizestr);
\r
172 message.SetName("ClientPut");
\r
173 message["URI"]=privatekey+m_messagebase+"|"+now.Format("%Y-%m-%d")+"|MessageList|"+indexstr+".xml";
\r
174 message["Identifier"]=m_fcpuniquename+"|"+localidentityidstr+"|"+indexstr+"|"+message["URI"];
\r
175 message["UploadFrom"]="direct";
\r
176 message["DataLength"]=xmlsizestr;
\r
177 m_fcp->SendMessage(message);
\r
178 m_fcp->SendRaw(xmlstr.c_str(),xmlstr.size());
\r
180 m_inserting.push_back(localidentityid);
\r