org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter Class Reference

Classes
class	ImportCaseData

Static Public Member Functions
static void	importCase (ImportCaseData icd) throws Exception

Static Private Member Functions
static void	copyImages (ImportCaseData icd) throws Exception
static void	copyResults (ImportCaseData icd) throws IOException
static void	deconflictDatabaseName (ImportCaseData icd) throws ClassNotFoundException, SQLException, Exception
static File	findInputFolder (ImportCaseData icd)
static void	fixPaths (ImportCaseData icd) throws SQLException, Exception
static String	getNullableInt (ResultSet rs, int index) throws SQLException
static String	getNullableLong (ResultSet rs, int index) throws SQLException
static Connection	getPostgreSQLConnection (ImportCaseData icd) throws SQLException
static Connection	getPostgreSQLConnection (ImportCaseData icd, String dbName) throws SQLException
static Connection	getSQLiteConnection (ImportCaseData icd) throws SQLException
static void	importDb (ImportCaseData icd) throws SQLException, ClassNotFoundException, Exception
static void	populateNullableByteArray (PreparedStatement pst, ResultSet rs, int rsIndex, int psIndex) throws SQLException
static void	populateNullableNumeric (PreparedStatement pst, ResultSet rs, int rsIndex, int psIndex) throws SQLException
static void	populateNullableString (PreparedStatement pst, ResultSet rs, int rsIndex, int psIndex) throws SQLException

Static Private Attributes
static final String	AUTOPSY_DB_FILE = "autopsy.db"
static final String	DOTAUT = CaseMetadata.getFileExtension()
static final int	MAX_DB_NAME_LENGTH = 63
static final String	MODULE_FOLDER = "ModuleOutput"
static final String	POSTGRES_DEFAULT_DB_NAME = "postgres"
static final String	TIMELINE_FILE = "events.db"
static final String	TIMELINE_FOLDER = "Timeline"

Detailed Description

Import a case from single-user to multi-user.

DO NOT USE, NEEDS TO BE UPDATED

Definition at line 49 of file SingleUserCaseConverter.java.

Member Function Documentation

static void org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.copyImages ( ImportCaseData  icd ) throws Exception

staticprivate

Get the images from the old case and stage them for the new case, if the user chose to copy images over.

Parameters

icd	the Import Case Data for the current case

Exceptions

IOException

Definition at line 971 of file SingleUserCaseConverter.java.

References org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.findInputFolder().

Referenced by org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.importCase().

static void org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.copyResults ( ImportCaseData  icd ) throws IOException

staticprivate

Copy all folders at the base level to the new scheme involving hostname. Also take care of a few files such as logs, timeline database, etc.

Parameters

icd	the Import Case Data for the current case

Exceptions

IOException

get hostname

Definition at line 255 of file SingleUserCaseConverter.java.

References org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.AUTOPSY_DB_FILE, org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.DOTAUT, org.sleuthkit.autopsy.coreutils.NetworkUtils.getLocalHostName(), org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.MODULE_FOLDER, org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.TIMELINE_FILE, and org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.TIMELINE_FOLDER.

Referenced by org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.importCase().

static void org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.deconflictDatabaseName ( ImportCaseData  icd ) throws ClassNotFoundException, SQLException, Exception

staticprivate

Checks that the database name is unique. If it is not, attempts to add numbers to it until it is unique. Gives up if it goes through all positive integers without finding a unique name.

Parameters

icd	the Import Case Data for the current case

Exceptions

Exception
SQLException
ClassNotFoundException

Definition at line 921 of file SingleUserCaseConverter.java.

References org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.getPostgreSQLConnection(), and org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.MAX_DB_NAME_LENGTH.

Referenced by org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.importDb().

static File org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.findInputFolder ( ImportCaseData  icd )

staticprivate

Figure out the input folder for images and return it.

Parameters

icd	the Import Case Data for the current case

Returns

the name of the proper Image input folder

we've found it

we've found it

Definition at line 232 of file SingleUserCaseConverter.java.

Referenced by org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.copyImages().

static void org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.fixPaths ( ImportCaseData  icd ) throws SQLException, Exception

staticprivate

Fix up any paths in the database that refer to items that have moved. Candidates include events.db, input images, reports, file paths, etc.

Parameters

icd	the Import Case Data for the current case

Exceptions

Exception
SQLExceptionException

Fix paths in reports, tsk_files_path, and tsk_image_names tables

Definition at line 995 of file SingleUserCaseConverter.java.

References org.sleuthkit.autopsy.coreutils.NetworkUtils.getLocalHostName(), and org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.getPostgreSQLConnection().

Referenced by org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.importCase().

static String org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.getNullableInt ( ResultSet  rs, int  index  ) throws SQLException

staticprivate

Return an integer from the ResultSet converted to String or NULL, by checking ResultSet.wasNull()

Parameters

rs	the ResultSet to work with
index	the index into the ResultSet to work with

Returns

the proper value, the integer, or NULL

Exceptions

SQLException

Definition at line 1051 of file SingleUserCaseConverter.java.

Referenced by org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.importDb().

static String org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.getNullableLong ( ResultSet  rs, int  index  ) throws SQLException

staticprivate

Return a long from the ResultSet converted to String or NULL, by checking ResultSet.wasNull()

Parameters

rs	the ResultSet to work with
index	the index into the ResultSet to work with

Returns

the proper value, the long, or NULL

Exceptions

SQLException

Definition at line 1071 of file SingleUserCaseConverter.java.

Referenced by org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.importDb().

static Connection org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.getPostgreSQLConnection ( ImportCaseData  icd ) throws SQLException

staticprivate

Open the PostgreSQL database

Parameters

icd	Import Case Data holding connection credentials

Returns

returns a Connection

Exceptions

SQLException

if unable to open

Definition at line 1149 of file SingleUserCaseConverter.java.

Referenced by org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.deconflictDatabaseName(), org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.fixPaths(), and org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.importDb().

static Connection org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.getPostgreSQLConnection ( ImportCaseData  icd, String  dbName  ) throws SQLException

staticprivate

Open the PostgreSQL database

Parameters

icd	Import Case Data holding connection credentials
dbName	the name of the database to open

Returns

returns a Connection

Exceptions

SQLException

if unable to open

Definition at line 1163 of file SingleUserCaseConverter.java.

static Connection org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.getSQLiteConnection ( ImportCaseData  icd ) throws SQLException

staticprivate

Open the SQLite database

Parameters

icd	Import Case Data holding database path details

Returns

returns a Connection

Exceptions

SQLException

if unable to open

Definition at line 1181 of file SingleUserCaseConverter.java.

Referenced by org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.importDb().

static void org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.importCase ( ImportCaseData  icd ) throws Exception

static

Handles the heavy lifting for importing a case from single-user to multi-user. Creates new .aut file, moves folders to the right place, imports the database, and updates paths within the database.

Parameters

icd	the Import Case Data for the current case

Exceptions

java.lang.Exception

Definition at line 161 of file SingleUserCaseConverter.java.

References org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.copyImages(), org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.copyResults(), org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.fixPaths(), org.sleuthkit.autopsy.casemodule.CaseMetadata.getCaseNotes(), org.sleuthkit.autopsy.casemodule.CaseMetadata.getCaseNumber(), org.sleuthkit.autopsy.casemodule.CaseMetadata.getCaseType(), org.sleuthkit.autopsy.casemodule.CaseMetadata.getExaminer(), org.sleuthkit.autopsy.casemodule.CaseMetadata.getExaminerEmail(), org.sleuthkit.autopsy.casemodule.CaseMetadata.getExaminerPhone(), org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.importDb(), and org.sleuthkit.autopsy.casemodule.Case.CaseType.MULTI_USER_CASE.

static void org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.importDb ( ImportCaseData  icd ) throws SQLException, ClassNotFoundException, Exception

staticprivate

Import the database from SQLite to PostgreSQL. Do not change any of the data while loading it over. Fixing paths is done once the database is completely imported.

Parameters

icd	the Import Case Data for the current case

Exceptions

Exception
SQLException
ClassNotFoundException

Migrate from SQLite to PostgreSQL

Definition at line 302 of file SingleUserCaseConverter.java.

References org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.deconflictDatabaseName(), org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.getNullableInt(), org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.getNullableLong(), org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.getPostgreSQLConnection(), org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.getSQLiteConnection(), org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.populateNullableByteArray(), org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.populateNullableNumeric(), and org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.populateNullableString().

Referenced by org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.importCase().

static void org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.populateNullableByteArray ( PreparedStatement  pst, ResultSet  rs, int  rsIndex, int  psIndex  ) throws SQLException

staticprivate

Place a NULL inside a prepared statement if needed, otherwise, place the byte array that was in the ResultSet.

Parameters

pst	the prepared statement
rs	the ResultSet to work with
rsIndex	index for the result set
psIndex	index for the prepared statement

Exceptions

SQLException

Definition at line 1111 of file SingleUserCaseConverter.java.

Referenced by org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.importDb().

static void org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.populateNullableNumeric ( PreparedStatement  pst, ResultSet  rs, int  rsIndex, int  psIndex  ) throws SQLException

staticprivate

Place a NULL inside a prepared statement if needed, otherwise, place the double that was in the ResultSet.

Parameters

pst	the prepared statement
rs	the ResultSet to work with
rsIndex	index for the result set
psIndex	index for the prepared statement

Exceptions

SQLException

Definition at line 1131 of file SingleUserCaseConverter.java.

Referenced by org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.importDb().

static void org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.populateNullableString ( PreparedStatement  pst, ResultSet  rs, int  rsIndex, int  psIndex  ) throws SQLException

staticprivate

Place a NULL inside a prepared statement if needed, otherwise, place the String that was in the ResultSet.

Parameters

pst	the prepared statement
rs	the ResultSet to work with
rsIndex	index for the result set
psIndex	index for the prepared statement

Exceptions

SQLException

Definition at line 1091 of file SingleUserCaseConverter.java.

Referenced by org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.importDb().

Member Data Documentation

final String org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.AUTOPSY_DB_FILE = "autopsy.db"

staticprivate

Definition at line 52 of file SingleUserCaseConverter.java.

Referenced by org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.copyResults().

final String org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.DOTAUT = CaseMetadata.getFileExtension()

staticprivate

Definition at line 53 of file SingleUserCaseConverter.java.

Referenced by org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.copyResults().

final int org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.MAX_DB_NAME_LENGTH = 63

staticprivate

Definition at line 57 of file SingleUserCaseConverter.java.

Referenced by org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.deconflictDatabaseName().

final String org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.MODULE_FOLDER = "ModuleOutput"

staticprivate

Definition at line 51 of file SingleUserCaseConverter.java.

Referenced by org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.copyResults().

final String org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.POSTGRES_DEFAULT_DB_NAME = "postgres"

staticprivate

Definition at line 56 of file SingleUserCaseConverter.java.

final String org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.TIMELINE_FILE = "events.db"

staticprivate

Definition at line 55 of file SingleUserCaseConverter.java.

Referenced by org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.copyResults().

final String org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.TIMELINE_FOLDER = "Timeline"

staticprivate

Definition at line 54 of file SingleUserCaseConverter.java.

Referenced by org.sleuthkit.autopsy.casemodule.SingleUserCaseConverter.copyResults().

---

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

• /home/carriersleuth/repos/autopsy/Core/src/org/sleuthkit/autopsy/casemodule/SingleUserCaseConverter.java