org.sleuthkit.autopsy.timeline.utils.TimelineDBUtils Class Reference

Public Member Functions
	TimelineDBUtils (SleuthkitCase sleuthkitCase)
String	csvAggFunction (String columnName)

Static Public Member Functions
static< X > List< X >	unGroupConcat (String groupConcat, CheckedFunction< String, X, TskCoreException > mapper) throws TskCoreException

Private Attributes
final SleuthkitCase	sleuthkitCase

Detailed Description

Utilities to help work with databases.

Definition at line 32 of file TimelineDBUtils.java.

Constructor & Destructor Documentation

org.sleuthkit.autopsy.timeline.utils.TimelineDBUtils.TimelineDBUtils

(

SleuthkitCase

sleuthkitCase

)

Create a TimelineDBUtils for the givecn SleuthlitCase.

Parameters

sleuthkitCase

The case to make utilities for. The type of the underlying database is used in the implementation of these utilities.

Definition at line 43 of file TimelineDBUtils.java.

References org.sleuthkit.autopsy.timeline.utils.TimelineDBUtils.sleuthkitCase.

Member Function Documentation

String org.sleuthkit.autopsy.timeline.utils.TimelineDBUtils.csvAggFunction

(

String

columnName

)

Wrap the given columnName in the appropiate sql function to get a comma seperated list in the result.

Parameters

columnName

Returns

An sql expression that will produce a comma seperated list of values from the given column in the result.

Definition at line 56 of file TimelineDBUtils.java.

static <X> List<X> org.sleuthkit.autopsy.timeline.utils.TimelineDBUtils.unGroupConcat ( String  groupConcat, CheckedFunction< String, X, TskCoreException >  mapper  ) throws TskCoreException

static

Take the result of a group_concat / string_agg sql operation and split it into a set of X using the mapper to convert from string to X. If groupConcat is empty, null, or all whitespace, returns an empty list.

Parameters

<X>	the type of elements to return
groupConcat	a string containing the group_concat result ( a comma separated list)
mapper	a function from String to X

Returns

a Set of X, each element mapped from one element of the original comma delimited string

Exceptions

org.sleuthkit.datamodel.TskCoreException

If the mapper throws a TskCoreException

Definition at line 77 of file TimelineDBUtils.java.

Member Data Documentation

final SleuthkitCase org.sleuthkit.autopsy.timeline.utils.TimelineDBUtils.sleuthkitCase

private

Definition at line 34 of file TimelineDBUtils.java.

Referenced by org.sleuthkit.autopsy.timeline.utils.TimelineDBUtils.TimelineDBUtils().

---

The documentation for this class was generated from the following file:

• /home/carriersleuth/repos/autopsy/Core/src/org/sleuthkit/autopsy/timeline/utils/TimelineDBUtils.java