Autopsy  4.4.1
Graphical digital forensics platform for The Sleuth Kit and other tools.
Static Public Member Functions | Static Private Attributes | List of all members
org.sleuthkit.autopsy.centralrepository.datamodel.EamDbUtil Class Reference

Static Public Member Functions

static void closeConnection (Connection conn)
 
static void closePreparedStatement (PreparedStatement preparedStatement)
 
static void closeResultSet (ResultSet resultSet)
 
static String correlationTypeToInstanceTableName (CorrelationAttribute.Type type)
 
static String correlationTypeToReferenceTableName (CorrelationAttribute.Type type)
 
static boolean executeValidationQuery (Connection conn, String validationQuery)
 
static boolean insertDefaultCorrelationTypes (Connection conn)
 
static boolean insertSchemaVersion (Connection conn)
 
static boolean schemaVersionIsSet (Connection conn)
 
static void setUseCentralRepo (boolean centralRepoCheckBoxIsSelected)
 
static boolean useCentralRepo ()
 

Static Private Attributes

static final String CENTRAL_REPO_NAME = "CentralRepository"
 
static final String CENTRAL_REPO_USE_KEY = "db.useCentralRepo"
 
static final Logger LOGGER = Logger.getLogger(EamDbUtil.class.getName())
 

Detailed Description

Definition at line 35 of file EamDbUtil.java.

Member Function Documentation

static void org.sleuthkit.autopsy.centralrepository.datamodel.EamDbUtil.closeConnection ( Connection  conn)
static

Close the in-use connection and return it to the pool.

Parameters
connAn open connection
Exceptions
EamDbException

Definition at line 82 of file EamDbUtil.java.

Referenced by org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.addArtifact(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.addReferenceInstance(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.bulkInsertArtifacts(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.bulkInsertCases(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.bulkInsertReferenceTypeEntries(), org.sleuthkit.autopsy.centralrepository.datamodel.PostgresEamDbSettings.createDatabase(), org.sleuthkit.autopsy.centralrepository.datamodel.PostgresEamDbSettings.deleteDatabase(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getArtifactInstancesByPath(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getArtifactInstancesByTypeValue(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getArtifactInstancesKnownBad(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCaseByUUID(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCases(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCorrelationTypeById(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCountArtifactInstancesByCaseDataSource(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCountArtifactInstancesByTypeValue(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCountArtifactInstancesKnownBad(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCountUniqueCaseDataSourceTuplesHavingTypeValue(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCountUniqueDataSources(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getDataSourceDetails(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getDataSources(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getDbInfo(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getDefinedCorrelationTypes(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getEnabledCorrelationTypes(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getListCasesHavingArtifactInstancesKnownBad(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getOrganizationByID(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getOrganizations(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getReferenceInstancesByTypeValue(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getReferenceSetByID(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getSupportedCorrelationTypes(), org.sleuthkit.autopsy.centralrepository.datamodel.SqliteEamDbSettings.initializeDatabaseSchema(), org.sleuthkit.autopsy.centralrepository.datamodel.PostgresEamDbSettings.initializeDatabaseSchema(), org.sleuthkit.autopsy.centralrepository.datamodel.SqliteEamDbSettings.insertDefaultDatabaseContent(), org.sleuthkit.autopsy.centralrepository.datamodel.PostgresEamDbSettings.insertDefaultDatabaseContent(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.isArtifactlKnownBadByReference(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.newCase(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.newCorrelationType(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.newDataSource(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.newDbInfo(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.newOrganization(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.newReferencelSet(), org.sleuthkit.autopsy.centralrepository.datamodel.PostgresEamDb.reset(), org.sleuthkit.autopsy.centralrepository.datamodel.SqliteEamDb.reset(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.setArtifactInstanceKnownStatus(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.updateCase(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.updateCorrelationType(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.updateDbInfo(), org.sleuthkit.autopsy.centralrepository.datamodel.PostgresEamDbSettings.verifyConnection(), org.sleuthkit.autopsy.centralrepository.datamodel.SqliteEamDbSettings.verifyConnection(), org.sleuthkit.autopsy.centralrepository.datamodel.PostgresEamDbSettings.verifyDatabaseExists(), org.sleuthkit.autopsy.centralrepository.datamodel.SqliteEamDbSettings.verifyDatabaseSchema(), and org.sleuthkit.autopsy.centralrepository.datamodel.PostgresEamDbSettings.verifyDatabaseSchema().

static void org.sleuthkit.autopsy.centralrepository.datamodel.EamDbUtil.closePreparedStatement ( PreparedStatement  preparedStatement)
static

Close the prepared statement.

Parameters
preparedStatement
Exceptions
EamDbException

Definition at line 48 of file EamDbUtil.java.

Referenced by org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.addArtifact(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.addReferenceInstance(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.bulkInsertArtifacts(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.bulkInsertCases(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.bulkInsertReferenceTypeEntries(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getArtifactInstancesByPath(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getArtifactInstancesByTypeValue(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getArtifactInstancesKnownBad(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCaseByUUID(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCases(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCorrelationTypeById(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCountArtifactInstancesByCaseDataSource(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCountArtifactInstancesByTypeValue(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCountArtifactInstancesKnownBad(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCountUniqueCaseDataSourceTuplesHavingTypeValue(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCountUniqueDataSources(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getDataSourceDetails(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getDataSources(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getDbInfo(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getDefinedCorrelationTypes(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getEnabledCorrelationTypes(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getListCasesHavingArtifactInstancesKnownBad(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getOrganizationByID(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getOrganizations(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getReferenceInstancesByTypeValue(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getReferenceSetByID(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getSupportedCorrelationTypes(), org.sleuthkit.autopsy.centralrepository.datamodel.EamDbUtil.insertDefaultCorrelationTypes(), org.sleuthkit.autopsy.centralrepository.datamodel.EamDbUtil.insertSchemaVersion(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.isArtifactlKnownBadByReference(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.newCase(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.newCorrelationType(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.newDataSource(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.newDbInfo(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.newOrganization(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.newReferencelSet(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.setArtifactInstanceKnownStatus(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.updateCase(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.updateCorrelationType(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.updateDbInfo(), and org.sleuthkit.autopsy.centralrepository.datamodel.PostgresEamDbSettings.verifyDatabaseExists().

static void org.sleuthkit.autopsy.centralrepository.datamodel.EamDbUtil.closeResultSet ( ResultSet  resultSet)
static

Close the resultSet.

Parameters
resultSet
Exceptions
EamDbException

Definition at line 65 of file EamDbUtil.java.

Referenced by org.sleuthkit.autopsy.centralrepository.datamodel.EamDbUtil.executeValidationQuery(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getArtifactInstancesByPath(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getArtifactInstancesByTypeValue(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getArtifactInstancesKnownBad(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCaseByUUID(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCases(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCorrelationTypeById(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCountArtifactInstancesByCaseDataSource(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCountArtifactInstancesByTypeValue(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCountArtifactInstancesKnownBad(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCountUniqueCaseDataSourceTuplesHavingTypeValue(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCountUniqueDataSources(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getDataSourceDetails(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getDataSources(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getDbInfo(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getDefinedCorrelationTypes(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getEnabledCorrelationTypes(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getListCasesHavingArtifactInstancesKnownBad(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getOrganizationByID(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getOrganizations(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getReferenceInstancesByTypeValue(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getReferenceSetByID(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getSupportedCorrelationTypes(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.isArtifactlKnownBadByReference(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.newCorrelationType(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.newReferencelSet(), org.sleuthkit.autopsy.centralrepository.datamodel.EamDbUtil.schemaVersionIsSet(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.setArtifactInstanceKnownStatus(), and org.sleuthkit.autopsy.centralrepository.datamodel.PostgresEamDbSettings.verifyDatabaseExists().

static String org.sleuthkit.autopsy.centralrepository.datamodel.EamDbUtil.correlationTypeToInstanceTableName ( CorrelationAttribute.Type  type)
static

Conver thte Type's DbTableName string to the *_instances table name.

Parameters
typeCorrelation Type
Returns
Instance table name for this Type.

Definition at line 233 of file EamDbUtil.java.

Referenced by org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.addArtifact(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.bulkInsertArtifacts(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getArtifactInstancesByPath(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getArtifactInstancesByTypeValue(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getArtifactInstancesKnownBad(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCountArtifactInstancesByCaseDataSource(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCountArtifactInstancesByTypeValue(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCountArtifactInstancesKnownBad(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getCountUniqueCaseDataSourceTuplesHavingTypeValue(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getListCasesHavingArtifactInstancesKnownBad(), org.sleuthkit.autopsy.centralrepository.datamodel.SqliteEamDbSettings.initializeDatabaseSchema(), org.sleuthkit.autopsy.centralrepository.datamodel.PostgresEamDbSettings.initializeDatabaseSchema(), and org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.setArtifactInstanceKnownStatus().

static String org.sleuthkit.autopsy.centralrepository.datamodel.EamDbUtil.correlationTypeToReferenceTableName ( CorrelationAttribute.Type  type)
static
static boolean org.sleuthkit.autopsy.centralrepository.datamodel.EamDbUtil.executeValidationQuery ( Connection  conn,
String  validationQuery 
)
static

Use the current settings and the validation query to test the connection to the database.

Returns
true if successfull query execution, else false.

Definition at line 205 of file EamDbUtil.java.

References org.sleuthkit.autopsy.centralrepository.datamodel.EamDbUtil.closeResultSet().

Referenced by org.sleuthkit.autopsy.centralrepository.datamodel.PostgresEamDbSettings.verifyConnection(), and org.sleuthkit.autopsy.centralrepository.datamodel.SqliteEamDbSettings.verifyConnection().

static boolean org.sleuthkit.autopsy.centralrepository.datamodel.EamDbUtil.insertDefaultCorrelationTypes ( Connection  conn)
static
static boolean org.sleuthkit.autopsy.centralrepository.datamodel.EamDbUtil.insertSchemaVersion ( Connection  conn)
static

Store the schema version into the db_info table.

This should be called immediately following the database schema being loaded.

Parameters
connOpen connection to use.
Returns
true on success, else false

Definition at line 135 of file EamDbUtil.java.

References org.sleuthkit.autopsy.centralrepository.datamodel.EamDbUtil.closePreparedStatement().

Referenced by org.sleuthkit.autopsy.centralrepository.datamodel.SqliteEamDbSettings.insertDefaultDatabaseContent(), and org.sleuthkit.autopsy.centralrepository.datamodel.PostgresEamDbSettings.insertDefaultDatabaseContent().

static boolean org.sleuthkit.autopsy.centralrepository.datamodel.EamDbUtil.schemaVersionIsSet ( Connection  conn)
static
static void org.sleuthkit.autopsy.centralrepository.datamodel.EamDbUtil.setUseCentralRepo ( boolean  centralRepoCheckBoxIsSelected)
static

Saves the setting for whether the Central Repo should be able to be configured.

Parameters
centralRepoCheckBoxIsSelected- true if the central repo can be used

Definition at line 195 of file EamDbUtil.java.

References org.sleuthkit.autopsy.coreutils.ModuleSettings.setConfigSetting().

Referenced by org.sleuthkit.autopsy.centralrepository.optionspanel.GlobalSettingsPanel.store().

static boolean org.sleuthkit.autopsy.centralrepository.datamodel.EamDbUtil.useCentralRepo ( )
static

If the Central Repos use has been enabled.

Returns
true if the Central Repo may be configured, false if it should not be able to be

Definition at line 184 of file EamDbUtil.java.

References org.sleuthkit.autopsy.coreutils.ModuleSettings.getConfigSetting().

Referenced by org.sleuthkit.autopsy.centralrepository.datamodel.EamDb.getInstance(), org.sleuthkit.autopsy.centralrepository.datamodel.EamDb.isEnabled(), and org.sleuthkit.autopsy.centralrepository.optionspanel.GlobalSettingsPanel.load().

Member Data Documentation

final String org.sleuthkit.autopsy.centralrepository.datamodel.EamDbUtil.CENTRAL_REPO_NAME = "CentralRepository"
staticprivate

Definition at line 38 of file EamDbUtil.java.

final String org.sleuthkit.autopsy.centralrepository.datamodel.EamDbUtil.CENTRAL_REPO_USE_KEY = "db.useCentralRepo"
staticprivate

Definition at line 39 of file EamDbUtil.java.

final Logger org.sleuthkit.autopsy.centralrepository.datamodel.EamDbUtil.LOGGER = Logger.getLogger(EamDbUtil.class.getName())
staticprivate

Definition at line 37 of file EamDbUtil.java.


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

Copyright © 2012-2016 Basis Technology. Generated on: Fri Sep 29 2017
This work is licensed under a Creative Commons Attribution-Share Alike 3.0 United States License.