Need a Place to Run Queries Against Environments - LAB?
Posted: February 15th, 2022, 5:24 pm
In EASYProcess 4.8, there was a RunSQL screen which allowed queries to be ran against the environment. I get why this is a security issue in PD, but was really useful for development in just DV/QA.
In 5.1 EP, we have made methods called DNU so there is no confusion that they are not part of the application (no real good way to tell this otherwise).
Then we promote and demote to DV and QA to get it to run. The result looks like this: The problem is that this is time consuming to promote/demote. I had a scenario where the data in DV is not useful and I have to test against QA.
Doing this meant I kept getting logged out of DV because I havent been in DV for a while, but then in making the changes I go back to QA and by then I am logged out there too.
So the next solution I had was having a RunQuery which takes the input "QueryToRun" and runs it. It feels like a workaround though
Neither of the above solutions seem intuitive. I would think LAB is where I would be able to run things and use as a scratch paper. That would also remove the need for methods named "CathyTest" and "DoNotUse". The last time I used LAB though it would not work to run the same method imported from EASYCommerce because it has references to app db table paths which point to Lab in that context.
I dont remember if I wouldve been able to just update all those references to EASYCommerce_Data table path and have that work, but it was a large enough obstacle that I just kept working in the application in "DNU" methods.
Can LAB have a feature to work as if it were running within a certain application?
Does LAB work to run methods in QA environment? and if not, can it/should it?
I think this needs some discussion on what the feature should be
In 5.1 EP, we have made methods called DNU so there is no confusion that they are not part of the application (no real good way to tell this otherwise).
Then we promote and demote to DV and QA to get it to run. The result looks like this: The problem is that this is time consuming to promote/demote. I had a scenario where the data in DV is not useful and I have to test against QA.
Doing this meant I kept getting logged out of DV because I havent been in DV for a while, but then in making the changes I go back to QA and by then I am logged out there too.
So the next solution I had was having a RunQuery which takes the input "QueryToRun" and runs it. It feels like a workaround though
Neither of the above solutions seem intuitive. I would think LAB is where I would be able to run things and use as a scratch paper. That would also remove the need for methods named "CathyTest" and "DoNotUse". The last time I used LAB though it would not work to run the same method imported from EASYCommerce because it has references to app db table paths which point to Lab in that context.
I dont remember if I wouldve been able to just update all those references to EASYCommerce_Data table path and have that work, but it was a large enough obstacle that I just kept working in the application in "DNU" methods.
Can LAB have a feature to work as if it were running within a certain application?
Does LAB work to run methods in QA environment? and if not, can it/should it?
I think this needs some discussion on what the feature should be