bool CWizIndexBase::SQLToDocumentAttachmentDataArray(const CString& strSQL,
CWizDocumentAttachmentDataArray& arrayAttachment)
{
try
{
CppSQLite3Query query = m_db.execQuery(strSQL);
while (!query.eof())
{
WIZDOCUMENTATTACHMENTDATA data;
data.strKbGUID = kbGUID();
data.strGUID = query.getStringField(documentattachmentATTACHMENT_GUID);
data.strDocumentGUID = query.getStringField(documentattachmentDOCUMENT_GUID);
data.strName = query.getStringField(documentattachmentATTACHMENT_NAME);
data.strURL = query.getStringField(documentattachmentATTACHMENT_URL);
data.strDescription = query.getStringField(documentattachmentATTACHMENT_DESCRIPTION);
data.tInfoModified = query.getTimeField(documentattachmentDT_INFO_MODIFIED);
data.strInfoMD5 = query.getStringField(documentattachmentATTACHMENT_INFO_MD5);
data.tDataModified = query.getTimeField(documentattachmentDT_DATA_MODIFIED);
data.strDataMD5 = query.getStringField(documentattachmentATTACHMENT_DATA_MD5);
data.nVersion = query.getInt64Field(documentattachmentVersion);
arrayAttachment.push_back(data);
query.nextRow();
}
std::sort(arrayAttachment.begin(), arrayAttachment.end());
return true;
}
catch (const CppSQLite3Exception& e)
{
return LogSQLException(e, strSQL);
}
}
void CWizAttachmentListView::resetAttachments()
{
clear();
CWizDocumentAttachmentDataArray arrayAttachment;
m_dbMgr.db(m_document.strKbGUID).GetDocumentAttachments(m_document.strGUID, arrayAttachment);
// CWizDocumentAttachmentDataArray::const_iterator it;
for (auto it = arrayAttachment.begin(); it != arrayAttachment.end(); it++) {
addItem(newAttachmentItem(*it));
}
}
bool CWizDatabase::GetAllObjectsNeedToBeDownloaded(std::deque<WIZOBJECTDATA>& arrayData)
{
CWizDocumentDataArray arrayDocument;
CWizDocumentAttachmentDataArray arrayAttachment;
GetNeedToBeDownloadedDocuments(arrayDocument);
GetNeedToBeDownloadedAttachments(arrayAttachment);
arrayData.assign(arrayAttachment.begin(), arrayAttachment.end());
arrayData.insert(arrayData.begin(), arrayDocument.begin(), arrayDocument.end());
return true;
}
void CWizDocument::PermanentlyDelete()
{
CWizDocumentAttachmentDataArray arrayAttachment;
m_db.GetDocumentAttachments(m_data.strGUID, arrayAttachment);
CWizDocumentAttachmentDataArray::const_iterator it;
for (it = arrayAttachment.begin(); it != arrayAttachment.end(); it++) {
CString strFileName = m_db.GetAttachmentFileName(it->strGUID);
::WizDeleteFile(strFileName);
m_db.DeleteAttachment(*it, true);
}
if (!m_db.DeleteDocument(m_data, true)) {
TOLOG1(_T("Failed to delete document: %1"), m_data.strTitle);
return;
}
CString strZipFileName = m_db.GetDocumentFileName(m_data.strGUID);
if (PathFileExists(strZipFileName))
{
WizDeleteFile(strZipFileName);
}
}