Allow multiple tests of same type on one entity

[JanPeterDatakind]

Describe your maintenance task
Currently, the test result views are created with a prefix of "tr_dot_model", followed by the names of the entity and the testtype.
Hence, setting up the same testtype twice (e.g. expression is true) on the same entity leads to two views with the same name, which breaks the execution of DOT. This could maybe be prevented by implementing all conditions or specifications for multiple scenarios into one test, but this would complicate the test definition and interpretation of test results.

[bkowshik]

Example

Below are the steps I tried, not sure if this is the error and I am replicating the scenario in this issue right.

1. There is an existing test checking if price > 0 in all_flight_data entity.

2. I created another similar test, checking if price > 50 a sample threshold.

3. I get the error below when I try to save the test.

Error while adding test! ERROR: syntax error at or near "non" Position: 595

[bkowshik]

The previous error was from an issue with syntax in the Add_Test query. Post fixing that, I get the actual error detailed in this Github Issue which is below:

Error while adding test! ERROR: duplicate key value violates unique constraint "configured_tests_pkey" Detail: Key (test_id)=(c3a73e06-5c42-3fe0-8eb1-cd7e618171fd) already exists.