I'm a developer on a web-based application that has the following requirements for a load test:
1) Log in as one of 100 preset users
2) Navigate to a dynamic URL based on values in a table in a database
2) Process at that URL
Among other things. However, I'm struggling with retrieving the data from the database and also creating that URL. The URL is of the format /Site/Controller/Function/ID, the same as almost any MVC application, but I see no place where I can choose a datasource for the original URL (e.g., http://mysite.com/site/case/edit/190723). Further uses find the dynamic target correctly, but I need to change that original ID in the first request after login. The ID is normally selected via a Telerik grid, but I also can't figure out how to get the link from the grid either.
I'm also struggling with the lack of multiple data sources. At this point, I feel as though I have to merge my two data sets (users and data values) and query from that. However, I have concerns about multiple VU's overwriting each other, which isn't a true test, and leads me to my next question:
Assuming that I use a database-driven test, when is that query executed? Every time a new VR is created? When the test first runs and never again? Every time a variable is retrieved?
Thank you for your assistance with this.