Method addAccount

Projects/CoX/Utilities/dbtool/DBConnection_AddUser.cpp:31–77

! * @brief Add an account to the database * @param[in] Username as String * @param[in] Plain text password to be hashed herein * @param[in] Access Level ranging from 0-9 * @returns Returns an enum value based upon result, 0 == SUCCESS */

 * @returns     Returns an enum value based upon result, 0 == SUCCESS
 */
DBToolResult DBConnection::addAccount(const QString &username, const QString &password, uint16_t access_level)
{
    qInfo().noquote() << "Adding new account to" << getName() << "database";

    if(!m_query->prepare("INSERT INTO accounts (username,passw,access_level,salt,creation_date) VALUES (?,?,?,?,?);"))
    {
        qDebug() << "SQL_ERROR:" << m_query->lastError();
        return DBToolResult::QUERY_PREP_FAILED;
    }

    PasswordHasher hasher;
    QByteArray salt = hasher.generateSalt();
    QByteArray password_array = hasher.hashPassword(password.toUtf8(), salt);
    QString created_date = QDateTime::currentDateTime().toString();
    m_query->bindValue(0, username);
    m_query->bindValue(1, password_array);
    m_query->bindValue(2, access_level);
    m_query->bindValue(3, salt);
    m_query->bindValue(4, created_date);

    if(!m_query->exec())
    {
        int sqlErrorCode = m_query->lastError().nativeErrorCode().toInt();
        if(sqlErrorCode == 19 || sqlErrorCode == 1062 || sqlErrorCode == 23503)
        {
            // Unique constraint error.
            // SQLite:        19
            // MySQL:       1062
            // PostgreSQL: 23503
            qWarning() << "Error: Username already taken. Please try another name.";
            return DBToolResult::USERNAME_TAKEN;
        }
        qDebug() << "SQL_ERROR:" << m_query->lastError(); // Why the query failed
        return DBToolResult::QUERY_FAILED;
    }

    // attempt to commit transaction
    if(!m_db->commit())
    {
        qWarning() << "Commit unsuccessful, rolling back database.";
        m_db->rollback();
        return DBToolResult::QUERY_FAILED;
    }

    qInfo() << "Successfully added user" << username << "to database";
    return DBToolResult::SUCCESS;
}

//! @}