CentralRepoAccount.java

Go to the documentation of this file.

/*
 * Central Repository
 *
 * Copyright 2020 Basis Technology Corp.
 * Contact: carrier <at> sleuthkit <dot> org
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package org.sleuthkit.autopsy.centralrepository.datamodel;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Collections;
import java.util.Objects;
import org.sleuthkit.datamodel.Account;
import org.sleuthkit.datamodel.CommunicationsUtils;
import static org.sleuthkit.datamodel.CommunicationsUtils.normalizeEmailAddress;
import org.sleuthkit.datamodel.TskCoreException;

public final class CentralRepoAccount {

    // primary key in the Accounts table in CR database
    private final long accountId;

    private final CentralRepoAccountType accountType;

    // type specific unique account identifier
    private final String typeSpecificIdentifier;

    public static final class CentralRepoAccountType {

        // id is the primary key in the account_types table
        private final int accountTypeId;
        private final Account.Type acctType;
        private final int correlationTypeId;

        CentralRepoAccountType(int acctTypeID, Account.Type acctType, int correlationTypeId) {
            this.acctType = acctType;
            this.correlationTypeId = correlationTypeId;
            this.accountTypeId = acctTypeID;
        }

        public Account.Type getAcctType() {
            return acctType;
        }

        public int getCorrelationTypeId() {
            return this.correlationTypeId;
        }

        public int getAccountTypeId() {
            return this.accountTypeId;
        }

        @Override
        public int hashCode() {
            int hash = 5;
            hash = 29 * hash + this.accountTypeId;
            hash = 29 * hash + Objects.hashCode(this.acctType);
            hash = 29 * hash + this.correlationTypeId;
            return hash;
        }

        @Override
        public boolean equals(Object obj) {
            if (this == obj) {
                return true;
            }
            if (obj == null) {
                return false;
            }
            if (getClass() != obj.getClass()) {
                return false;
            }
            final CentralRepoAccountType other = (CentralRepoAccountType) obj;
            if (this.accountTypeId != other.getAccountTypeId()) {
                return false;
            }
            if (this.correlationTypeId != other.getCorrelationTypeId()) {
                return false;
            }
            return Objects.equals(this.acctType, other.getAcctType());
        }

    }

    public CentralRepoAccount(long accountId, CentralRepoAccountType accountType, String typeSpecificIdentifier) {
        this.accountId = accountId;
        this.accountType = accountType;
        this.typeSpecificIdentifier = typeSpecificIdentifier;
    }

    public String getIdentifier() {
        return this.typeSpecificIdentifier;
    }

    public CentralRepoAccountType getAccountType() {
        return this.accountType;
    }

    public long getId() {
        return this.accountId;
    }

    @Override
    public int hashCode() {
        int hash = 5;
        hash = 43 * hash + (int) (this.accountId ^ (this.accountId >>> 32));
        hash = 43 * hash + (this.accountType != null ? this.accountType.hashCode() : 0);
        hash = 43 * hash + (this.typeSpecificIdentifier != null ? this.typeSpecificIdentifier.hashCode() : 0);
        return hash;
    }

    @Override
    public boolean equals(Object obj) {
        if (this == obj) {
            return true;
        }
        if (obj == null) {
            return false;
        }
        if (getClass() != obj.getClass()) {
            return false;
        }
        final CentralRepoAccount other = (CentralRepoAccount) obj;
        if (this.accountId != other.getId()) {
            return false;
        }
        if (!Objects.equals(this.typeSpecificIdentifier, other.getIdentifier())) {
            return false;
        }
        return Objects.equals(this.accountType, other.getAccountType());
    }

    private static class AccountsQueryCallback implements CentralRepositoryDbQueryCallback {

        Collection<CentralRepoAccount> accountsList = new ArrayList<>();

        @Override
        public void process(ResultSet rs) throws CentralRepoException, SQLException {

            while (rs.next()) {

                // create account
                Account.Type acctType = new Account.Type(rs.getString("type_name"), rs.getString("display_name"));
                CentralRepoAccountType crAccountType = new CentralRepoAccountType(rs.getInt("account_type_id"), acctType, rs.getInt("correlation_type_id"));

                CentralRepoAccount account = new CentralRepoAccount(
                        rs.getInt("account_id"),
                        crAccountType,
                        rs.getString("account_unique_identifier"));

                accountsList.add(account);
            }
        }

        Collection<CentralRepoAccount> getAccountsList() {
            return Collections.unmodifiableCollection(accountsList);
        }
    };

    private static final String ACCOUNTS_QUERY_CLAUSE
            = "SELECT accounts.id as account_id,  "
            + " accounts.account_type_id as account_type_id, accounts.account_unique_identifier as account_unique_identifier,"
            + " account_types.id as account_type_id, "
            + " account_types.type_name as type_name, account_types.display_name as display_name, account_types.correlation_type_id as correlation_type_id  "
            + " FROM accounts "
            + " JOIN account_types as account_types on accounts.account_type_id = account_types.id ";

    public static Collection<CentralRepoAccount> getAccountsWithIdentifierLike(String accountIdentifierSubstring) throws CentralRepoException {

        String queryClause = ACCOUNTS_QUERY_CLAUSE
                + " WHERE LOWER(accounts.account_unique_identifier) LIKE LOWER('%" + accountIdentifierSubstring + "%')";

        AccountsQueryCallback queryCallback = new AccountsQueryCallback();
        CentralRepository.getInstance().executeSelectSQL(queryClause, queryCallback);

        return queryCallback.getAccountsList();
    }

    public static Collection<CentralRepoAccount> getAccountsWithIdentifier(String accountIdentifier) throws CentralRepoException {

        String normalizedAccountIdentifier;

        try {
            normalizedAccountIdentifier = normalizeAccountIdentifier(accountIdentifier);
        } catch (TskCoreException ex) {
            throw new CentralRepoException("Failed to normalize account identifier.", ex);
        }

        String queryClause = ACCOUNTS_QUERY_CLAUSE
                + " WHERE LOWER(accounts.account_unique_identifier) = LOWER('" + normalizedAccountIdentifier + "')";

        AccountsQueryCallback queryCallback = new AccountsQueryCallback();
        CentralRepository.getInstance().executeSelectSQL(queryClause, queryCallback);

        return queryCallback.getAccountsList();
    }

    public static Collection<CentralRepoAccount> getAllAccounts() throws CentralRepoException {

        String queryClause = ACCOUNTS_QUERY_CLAUSE;

        AccountsQueryCallback queryCallback = new AccountsQueryCallback();
        CentralRepository.getInstance().executeSelectSQL(queryClause, queryCallback);

        return queryCallback.getAccountsList();
    }

    private static String normalizeAccountIdentifier(String accountIdentifier) throws TskCoreException {
        String normalizedAccountIdentifier = accountIdentifier;
        if (CommunicationsUtils.isValidPhoneNumber(accountIdentifier)) {
            normalizedAccountIdentifier = CommunicationsUtils.normalizePhoneNum(accountIdentifier);
        } else if (CommunicationsUtils.isValidEmailAddress(accountIdentifier)) {
            normalizedAccountIdentifier = normalizeEmailAddress(accountIdentifier);
        }
        return normalizedAccountIdentifier;
    }
}