backend/com.tecknobit.glider.services.passwords.repositories/PasswordsRepository/countPasswords

count Passwords

@Query(value = "SELECT COUNT(*) FROM " + PASSWORDS_KEY + _WHERE_ + USER_IDENTIFIER_KEY + "=:" + USER_IDENTIFIER_KEY + " AND " + TYPE_KEY + " IN (:" + TYPE_KEY + ")", nativeQuery = true )

abstract fun countPasswords(@Param(value = "user_id") userId: String, @Param(value = "type") types: Set<String>): Long

Query used to count the total passwords

Return

the total passwords as long

Parameters

userId

The identifier of the user

types

The types of the passwords to include in the count