20 package org.sleuthkit.autopsy.commonfilesearch;
22 import java.sql.ResultSet;
23 import java.sql.SQLException;
24 import java.util.Collections;
25 import java.util.HashMap;
26 import java.util.HashSet;
27 import java.util.List;
34 import org.
sleuthkit.datamodel.SleuthkitCase.CaseDbQuery;
45 @SuppressWarnings(
"PMD.AbstractNaming")
48 private static final String FILTER_BY_MIME_TYPES_WHERE_CLAUSE =
" and mime_type in (%s)";
62 super(filterByMediaMimeType, filterByDocMimeType, percentageThreshold);
63 this.dataSourceIdToNameMap = dataSourceIdMap;
67 Map<Long, String> getDataSourceIdToNameMap() {
68 return Collections.unmodifiableMap(this.dataSourceIdToNameMap);
80 static final String SELECT_PREFIX =
"SELECT obj_id, md5, data_source_obj_id from tsk_files where";
92 protected abstract String buildSqlSelectStatement();
106 Map<String, CommonAttributeValue> commonFiles =
new HashMap<>();
111 SleuthkitCase sleuthkitCase = currentCase.getSleuthkitCase();
113 String selectStatement = this.buildSqlSelectStatement();
116 CaseDbQuery query = sleuthkitCase.executeQuery(selectStatement);
117 ResultSet resultSet = query.getResultSet()) {
119 while (resultSet.next()) {
120 Long objectId = resultSet.getLong(1);
121 String md5 = resultSet.getString(2);
122 Long dataSourceId = resultSet.getLong(3);
123 String dataSource = this.getDataSourceIdToNameMap().get(dataSourceId);
125 if (md5 == null || HashUtility.isNoDataMd5(md5)) {
129 if (commonFiles.containsKey(md5)) {
135 commonFiles.put(md5, commonAttributeValue);
140 Map<Integer, CommonAttributeValueList> instanceCollatedCommonFiles = collateMatchesByNumberOfInstances(commonFiles);
155 String determineMimeTypeFilter() {
157 Set<String> mimeTypesToFilterOn =
new HashSet<>();
158 String mimeTypeString =
"";
159 if (isFilterByMedia()) {
160 mimeTypesToFilterOn.addAll(MEDIA_PICS_VIDEO_MIME_TYPES);
162 if (isFilterByDoc()) {
163 mimeTypesToFilterOn.addAll(TEXT_FILES_MIME_TYPES);
165 StringBuilder mimeTypeFilter =
new StringBuilder(mimeTypesToFilterOn.size());
166 if (!mimeTypesToFilterOn.isEmpty()) {
167 for (String mimeType : mimeTypesToFilterOn) {
168 mimeTypeFilter.append(SINGLE_QUOTE).append(mimeType).append(SINGLE_QUTOE_COMMA);
170 mimeTypeString = mimeTypeFilter.toString().substring(0, mimeTypeFilter.length() - 1);
171 mimeTypeString = String.format(FILTER_BY_MIME_TYPES_WHERE_CLAUSE,
new Object[]{mimeTypeString});
173 return mimeTypeString;
175 static final String SINGLE_QUTOE_COMMA =
"',";
176 static final String SINGLE_QUOTE =
"'";
CommonAttributeSearchResults findMatches()
final Map< Long, String > dataSourceIdToNameMap
static Case getCurrentCaseThrows()