1 #include "../../include/freenet/messageinserter.h"
\r
2 #include "../../include/freenet/messagexml.h"
\r
4 MessageInserter::MessageInserter()
\r
9 MessageInserter::MessageInserter(FCPv2 *fcp):IIndexInserter<std::string>(fcp)
\r
14 void MessageInserter::CheckForNeededInsert()
\r
16 // only do 1 insert at a time
\r
17 if(m_inserting.size()==0)
\r
19 SQLite3DB::Statement st=m_db->Prepare("SELECT MessageUUID FROM tblMessageInserts INNER JOIN tblLocalIdentity ON tblMessageInserts.LocalIdentityID=tblLocalIdentity.LocalIdentityID WHERE tblLocalIdentity.PrivateKey IS NOT NULL AND tblLocalIdentity.PrivateKey <> '' AND tblMessageInserts.Inserted='false';");
\r
22 if(st.RowReturned())
\r
24 std::string messageuuid;
\r
25 st.ResultText(0,messageuuid);
\r
26 StartInsert(messageuuid);
\r
31 const bool MessageInserter::HandlePutFailed(FCPMessage &message)
\r
34 int localidentityid;
\r
35 std::vector<std::string> idparts;
\r
36 StringFunctions::Split(message["Identifier"],"|",idparts);
\r
37 StringFunctions::Convert(idparts[2],localidentityid);
\r
38 StringFunctions::Convert(idparts[3],index);
\r
40 // fatal put - or data exists - insert bogus index into database so we'll try to insert this message again
\r
41 if(message["Fatal"]=="true" || message["Code"]=="9")
\r
43 SQLite3DB::Statement st=m_db->Prepare("INSERT INTO tblMessageInserts(LocalIdentityID,Day,InsertIndex,Inserted) VALUES(?,?,?,'true');");
\r
44 st.Bind(0,localidentityid);
\r
45 st.Bind(1,idparts[6]);
\r
50 RemoveFromInsertList(idparts[1]);
\r
55 const bool MessageInserter::HandlePutSuccessful(FCPMessage &message)
\r
59 int localidentityid;
\r
61 std::vector<std::string> idparts;
\r
62 StringFunctions::Split(message["Identifier"],"|",idparts);
\r
63 StringFunctions::Convert(idparts[3],index);
\r
64 StringFunctions::Convert(idparts[2],localidentityid);
\r
66 SQLite3DB::Statement st=m_db->Prepare("UPDATE tblMessageInserts SET Day=?, InsertIndex=?, Inserted='true' WHERE MessageUUID=?;");
\r
67 st.Bind(0,idparts[6]);
\r
69 st.Bind(2,idparts[1]);
\r
72 // insert record into temp table so MessageList will be inserted ASAP
\r
74 st=m_db->Prepare("INSERT INTO tmpMessageListInsert(LocalIdentityID,Date) VALUES(?,?);");
\r
75 st.Bind(0,localidentityid);
\r
76 st.Bind(1,date.Format("%Y-%m-%d"));
\r
79 // update the messageuuid to the real messageuuid
\r
80 st=m_db->Prepare("SELECT MessageXML FROM tblMessageInserts WHERE MessageUUID=?;");
\r
81 st.Bind(0,idparts[1]);
\r
83 if(st.RowReturned())
\r
85 std::string xmldata="";
\r
86 st.ResultText(0,xmldata);
\r
87 xml.ParseXML(xmldata);
\r
88 xml.SetMessageID(idparts[4]);
\r
90 SQLite3DB::Statement st2=m_db->Prepare("UPDATE tblMessageInserts SET MessageUUID=?, MessageXML=? WHERE MessageUUID=?;");
\r
91 st2.Bind(0,idparts[4]);
\r
92 st2.Bind(1,xml.GetXML());
\r
93 st2.Bind(2,idparts[1]);
\r
97 RemoveFromInsertList(idparts[1]);
\r
99 m_log->WriteLog(LogFile::LOGLEVEL_DEBUG,"MessageInserter::HandlePutSuccessful successfully inserted message "+message["Identifier"]);
\r
104 void MessageInserter::Initialize()
\r
106 m_fcpuniquename="MessageInserter";
\r
109 void MessageInserter::StartInsert(const std::string &messageuuid)
\r
111 MessageXML xmlfile;
\r
114 SQLite3DB::Statement st=m_db->Prepare("SELECT MessageXML,PrivateKey,tblLocalIdentity.LocalIdentityID,PublicKey FROM tblMessageInserts INNER JOIN tblLocalIdentity ON tblMessageInserts.LocalIdentityID=tblLocalIdentity.LocalIdentityID WHERE MessageUUID=?;");
\r
115 st.Bind(0,messageuuid);
\r
118 if(st.RowReturned())
\r
120 int localidentityid;
\r
123 std::string xmlsizestr;
\r
124 std::string privatekey;
\r
125 std::string publickey;
\r
126 FCPMessage message;
\r
127 std::string indexstr;
\r
130 st.ResultText(0,xml);
\r
131 st.ResultText(1,privatekey);
\r
132 st.ResultInt(2,localidentityid);
\r
133 st.ResultText(3,publickey);
\r
134 StringFunctions::Convert(localidentityid,idstr);
\r
136 st=m_db->Prepare("SELECT MAX(InsertIndex) FROM tblMessageInserts WHERE Day=? AND LocalIdentityID=?;");
\r
137 st.Bind(0,now.Format("%Y-%m-%d"));
\r
138 st.Bind(1,localidentityid);
\r
141 if(st.ResultNull(0)==false)
\r
143 st.ResultInt(0,index);
\r
146 StringFunctions::Convert(index,indexstr);
\r
148 // recreate messageuuid in xml - UUID of message will not match entry in MessageInserts table until we successfully insert it
\r
149 // see HandlePutSuccessful
\r
150 xmlfile.ParseXML(xml);
\r
151 // if we don't already have an @sskpart - add it
\r
152 if(xmlfile.GetMessageID().find("@")==std::string::npos)
\r
154 // remove - and ~ from publickey part
\r
155 std::string publickeypart=StringFunctions::Replace(StringFunctions::Replace(publickey.substr(4,43),"-",""),"~","");
\r
156 xmlfile.SetMessageID(xmlfile.GetMessageID()+"@"+publickeypart);
\r
158 xml=xmlfile.GetXML();
\r
160 StringFunctions::Convert(xml.size(),xmlsizestr);
\r
162 message.SetName("ClientPut");
\r
163 message["URI"]=privatekey+m_messagebase+"|"+now.Format("%Y-%m-%d")+"|Message|"+indexstr+".xml";
\r
164 message["Identifier"]=m_fcpuniquename+"|"+messageuuid+"|"+idstr+"|"+indexstr+"|"+xmlfile.GetMessageID()+"|"+message["URI"];
\r
165 message["UploadFrom"]="direct";
\r
166 message["DataLength"]=xmlsizestr;
\r
167 m_fcp->SendMessage(message);
\r
168 m_fcp->SendRaw(xml.c_str(),xml.size());
\r
170 m_inserting.push_back(messageuuid);
\r
172 m_log->WriteLog(LogFile::LOGLEVEL_DEBUG,"MessageInserter::StartInsert started message insert "+message["URI"]);
\r