19 package org.sleuthkit.autopsy.datamodel;
 
   21 import java.beans.PropertyChangeEvent;
 
   22 import java.beans.PropertyChangeListener;
 
   23 import java.sql.ResultSet;
 
   24 import java.sql.SQLException;
 
   25 import java.util.ArrayList;
 
   26 import java.util.Collections;
 
   27 import java.util.HashSet;
 
   28 import java.util.LinkedHashMap;
 
   29 import java.util.List;
 
   31 import java.util.Observable;
 
   32 import java.util.Observer;
 
   34 import java.util.logging.Level;
 
   35 import org.openide.nodes.ChildFactory;
 
   36 import org.openide.nodes.Children;
 
   37 import org.openide.nodes.Node;
 
   38 import org.openide.nodes.Sheet;
 
   39 import org.openide.util.NbBundle;
 
   40 import org.openide.util.lookup.Lookups;
 
   46 import org.
sleuthkit.datamodel.BlackboardArtifact.ARTIFACT_TYPE;
 
   47 import org.
sleuthkit.datamodel.BlackboardAttribute.ATTRIBUTE_TYPE;
 
   49 import org.
sleuthkit.datamodel.SleuthkitCase.CaseDbQuery;
 
   58     private static final String 
HASHSET_HITS = BlackboardArtifact.ARTIFACT_TYPE.TSK_HASHSET_HIT.getLabel();
 
   59     private static final String 
DISPLAY_NAME = BlackboardArtifact.ARTIFACT_TYPE.TSK_HASHSET_HIT.getDisplayName();
 
   70     public <T> T accept(AutopsyItemVisitor<T> v) {
 
   88         List<String> getSetNames() {
 
   89             List<String> names = 
new ArrayList<>(hashSetHitsMap.keySet());
 
   90             Collections.sort(names);
 
   94         Set<Long> getArtifactIds(String hashSetName) {
 
   95             return hashSetHitsMap.get(hashSetName);
 
   98         @SuppressWarnings(
"deprecation")
 
  100             hashSetHitsMap.clear();
 
  102             if (skCase == null) {
 
  106             int setNameId = ATTRIBUTE_TYPE.TSK_SET_NAME.getTypeID();
 
  107             int artId = ARTIFACT_TYPE.TSK_HASHSET_HIT.getTypeID();
 
  108             String query = 
"SELECT value_text,blackboard_attributes.artifact_id,attribute_type_id "  
  109                     + 
"FROM blackboard_attributes,blackboard_artifacts WHERE "  
  110                     + 
"attribute_type_id=" + setNameId 
 
  111                     + 
" AND blackboard_attributes.artifact_id=blackboard_artifacts.artifact_id"  
  112                     + 
" AND blackboard_artifacts.artifact_type_id=" + artId; 
 
  114             try (CaseDbQuery dbQuery = skCase.executeQuery(query)) {
 
  115                 ResultSet resultSet = dbQuery.getResultSet();
 
  116                 while (resultSet.next()) {
 
  117                     String setName = resultSet.getString(
"value_text"); 
 
  118                     long artifactId = resultSet.getLong(
"artifact_id"); 
 
  119                     if (!hashSetHitsMap.containsKey(setName)) {
 
  120                         hashSetHitsMap.put(setName, 
new HashSet<Long>());
 
  122                     hashSetHitsMap.get(setName).add(artifactId);
 
  124             } 
catch (TskCoreException | SQLException ex) {
 
  125                 logger.log(Level.WARNING, 
"SQL Exception occurred: ", ex); 
 
  139             super(Children.create(
new HashsetNameFactory(), 
true), Lookups.singleton(DISPLAY_NAME));
 
  140             super.setName(HASHSET_HITS);
 
  141             super.setDisplayName(DISPLAY_NAME);
 
  142             this.setIconBaseWithExtension(
"org/sleuthkit/autopsy/images/hashset_hits.png"); 
 
  152             return v.
visit(
this);
 
  157             Sheet s = super.createSheet();
 
  158             Sheet.Set ss = s.get(Sheet.PROPERTIES);
 
  160                 ss = Sheet.createPropertiesSet();
 
  164             ss.put(
new NodeProperty<>(NbBundle.getMessage(
this.getClass(), 
"HashsetHits.createSheet.name.name"),
 
  165                     NbBundle.getMessage(
this.getClass(), 
"HashsetHits.createSheet.name.displayName"),
 
  166                     NbBundle.getMessage(
this.getClass(), 
"HashsetHits.createSheet.name.desc"),
 
  193         private final PropertyChangeListener 
pcl = 
new PropertyChangeListener() {
 
  195             public void propertyChange(PropertyChangeEvent evt) {
 
  196                 String eventType = evt.getPropertyName();
 
  212                         if (null != eventData && eventData.
getBlackboardArtifactType().getTypeID() == ARTIFACT_TYPE.TSK_HASHSET_HIT.getTypeID()) {
 
  213                             hashsetResults.update();
 
  215                     } 
catch (IllegalStateException notUsed) {
 
  230                         hashsetResults.update();
 
  231                     } 
catch (IllegalStateException notUsed) {
 
  238                     if (evt.getNewValue() == null) {
 
  251             hashsetResults.update();
 
  252             hashsetResults.addObserver(
this);
 
  260             hashsetResults.deleteObserver(
this);
 
  265             list.addAll(hashsetResults.getSetNames());
 
  275         public void update(Observable o, Object arg) {
 
  288             super(Children.create(
new HitFactory(hashSetName), 
true), Lookups.singleton(hashSetName));
 
  289             super.setName(hashSetName);
 
  292             this.setIconBaseWithExtension(
"org/sleuthkit/autopsy/images/hashset_hits.png"); 
 
  293             hashsetResults.addObserver(
this);
 
  300             super.setDisplayName(hashSetName + 
" (" + hashsetResults.getArtifactIds(hashSetName).size() + 
")");
 
  310             Sheet s = super.createSheet();
 
  311             Sheet.Set ss = s.get(Sheet.PROPERTIES);
 
  313                 ss = Sheet.createPropertiesSet();
 
  317             ss.put(
new NodeProperty<>(NbBundle.getMessage(
this.getClass(), 
"HashsetHits.createSheet.name.name"),
 
  318                     NbBundle.getMessage(
this.getClass(), 
"HashsetHits.createSheet.name.displayName"),
 
  319                     NbBundle.getMessage(
this.getClass(), 
"HashsetHits.createSheet.name.desc"),
 
  327             return v.
visit(
this);
 
  331         public void update(Observable o, Object arg) {
 
  349     private class HitFactory extends ChildFactory.Detachable<Long> implements Observer {
 
  360             hashsetResults.addObserver(
this);
 
  365             hashsetResults.deleteObserver(
this);
 
  370             list.addAll(hashsetResults.getArtifactIds(hashsetName));
 
  376             if (skCase == null) {
 
  381                 BlackboardArtifact art = skCase.getBlackboardArtifact(
id);
 
  383             } 
catch (TskException ex) {
 
  384                 logger.log(Level.WARNING, 
"TSK Exception occurred", ex); 
 
  390         public void update(Observable o, Object arg) {
 
BlackboardArtifact.Type getBlackboardArtifactType()
void removeIngestModuleEventListener(final PropertyChangeListener listener)
static synchronized IngestManager getInstance()
HashsetNameNode(String hashSetName)
static final String DISPLAY_NAME
HitFactory(String hashsetName)
boolean createKeys(List< String > list)
Node createNodeForKey(String key)
static final String HASHSET_HITS
static final Logger logger
T visit(DataSourcesNode in)
void update(Observable o, Object arg)
HashsetHits(SleuthkitCase skCase)
void removeIngestJobEventListener(final PropertyChangeListener listener)
boolean createKeys(List< Long > list)
void addIngestJobEventListener(final PropertyChangeListener listener)
final Map< String, Set< Long > > hashSetHitsMap
void update(Observable o, Object arg)
final PropertyChangeListener pcl
static synchronized void removePropertyChangeListener(PropertyChangeListener listener)
void addIngestModuleEventListener(final PropertyChangeListener listener)
static synchronized void addPropertyChangeListener(PropertyChangeListener listener)
static Case getCurrentCase()
synchronized static Logger getLogger(String name)
void update(Observable o, Object arg)
Node createNodeForKey(Long id)
final HashsetResults hashsetResults