Wsrtjtyk

In a project I have 2 REST controllers, one intended to be used by third parties and one intended to be used by internal staff. Both of the controllers return the same entities, but the third parties get a filtered subset of what the internal staff see. The filtereing is done based on an entity-type field of the entity.

My current implementation is as follows

@Entity

@Table("TABLENAME")

@Inheritance(strategy = InheritanceType.SINGLE_TABLE)

@DiscriminatorFormula("0")

@DiscriminatorValue("0")

public class Entity {

    @Id

    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "EntitySeq")

    @SequenceGenerator(name = "EntitySeq", sequenceName = "ENTITY_SEQ", allocationSize = 20)

    private Long id;



    //@Column("ENTITY_TYPE")

    //private EntityType entityType; //EntityType is an enumerator

}



@Entity

@Table("TABLENAME")

@Where("ENTITY_TYPE in ('A', 'B', 'C')

@DiscriminatorValue("00")   //Found at https://stackoverflow.com/questions/6572814/single-table-inheritance-without-discriminator-column

public class LimitedEntity extends Entity {}

The repository is written as followed:

public interface EntityRepository<T extends Entity> extends PagingAndSortingRepository<T, long> {

    List<T> findAll();

    List<T> findAll(Date from, Date to, Pageable pageable);



}

To test this all, I've written a test as follows:

@RunWith(SpringRunner.class)

@DataJpaTest

@ActiveProfiles({"local", "h2db"})

public class EntityRepositoryTest {

    @Autowired

    private TestEntityManager entityManager;



    @Autowired

    private EntityRepository<Entity> entityEntityRepository;



    @Autowired

    private EntityRepository<LimitedEntity> limitedEntityEntityRepository;



    @Before

    public void setup() {

        //Insert a record in the database for each possible value of entityType

    }



    @Test

    public void vacatureTypeFilterTest() {

        Date from = new GregorianCalendar(2018, 11, 5).getTime();

        Date to = new GregorianCalendar(2018, 11, 6).getTime();



        Assertions.assertThat(entityEntityRepository.countAllVacatures(from , to)).isEqualTo(EntityType.values().length);

        Assertions.assertThat(limitedEntityEntityRepository.countAllVacatures(from , to)).isEqualTo(3);

    }

}

As written in the test, I was expecting that the results would be 9 and 3 respectively, but it turns out they're both 9.

Why is this not working as expected? What is the/a proper way to have global filtering?