Autopsy
4.4.1
Graphical digital forensics platform for The Sleuth Kit and other tools.
|
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()) |
Definition at line 35 of file EamDbUtil.java.
|
static |
Close the in-use connection and return it to the pool.
conn | An open connection |
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 |
Close the prepared statement.
preparedStatement |
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 |
Close the resultSet.
resultSet |
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 |
Conver thte Type's DbTableName string to the *_instances table name.
type | Correlation 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 |
Convert the Type's DbTableName string to the reference_* table name.
type | Correlation Type |
Definition at line 244 of file EamDbUtil.java.
Referenced by org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.addReferenceInstance(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.bulkInsertReferenceTypeEntries(), org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.getReferenceInstancesByTypeValue(), org.sleuthkit.autopsy.centralrepository.datamodel.SqliteEamDbSettings.initializeDatabaseSchema(), org.sleuthkit.autopsy.centralrepository.datamodel.PostgresEamDbSettings.initializeDatabaseSchema(), and org.sleuthkit.autopsy.centralrepository.datamodel.AbstractSqlEamDb.isArtifactlKnownBadByReference().
|
static |
Use the current settings and the validation query to test the connection to the database.
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 |
Insert the default correlation types into the database.
conn | Open connection to use. |
Definition at line 99 of file EamDbUtil.java.
References org.sleuthkit.autopsy.centralrepository.datamodel.EamDbUtil.closePreparedStatement(), and org.sleuthkit.autopsy.centralrepository.datamodel.CorrelationAttribute.getDefaultCorrelationTypes().
Referenced by org.sleuthkit.autopsy.centralrepository.datamodel.SqliteEamDbSettings.insertDefaultDatabaseContent(), and org.sleuthkit.autopsy.centralrepository.datamodel.PostgresEamDbSettings.insertDefaultDatabaseContent().
|
static |
Store the schema version into the db_info table.
This should be called immediately following the database schema being loaded.
conn | Open connection to use. |
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 |
Query to see if the SCHEMA_VERSION is set in the db.
Definition at line 157 of file EamDbUtil.java.
References org.sleuthkit.autopsy.centralrepository.datamodel.EamDbUtil.closeResultSet().
Referenced by org.sleuthkit.autopsy.centralrepository.datamodel.SqliteEamDbSettings.verifyDatabaseSchema(), and org.sleuthkit.autopsy.centralrepository.datamodel.PostgresEamDbSettings.verifyDatabaseSchema().
|
static |
Saves the setting for whether the Central Repo should be able to be configured.
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 |
If the Central Repos use has been enabled.
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().
|
staticprivate |
Definition at line 38 of file EamDbUtil.java.
|
staticprivate |
Definition at line 39 of file EamDbUtil.java.
|
staticprivate |
Definition at line 37 of file EamDbUtil.java.
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.