Forum Discussion

progz's avatar
progz
Occasional Contributor
8 years ago
Solved

How do I send MySQL queries to a database within a test?

Hello everyone,   I am currently testing a POS software that works on the side with a MySQL 5.5 MyISAM engine type database. Within my project I have several tests that I can do. The program is wor...
  • tristaanogre's avatar
    tristaanogre
    8 years ago

    I'm assuming, to date, you've been using mainly Keyword Tests to create your project. 

    It is not impossible to do SQL queries and stuff in KeywordTests... but I find it cumbersome.  It feels much easier and intuitive to me to use, as you mention, "a programming language". 

    When you created your project, you selected a programming language.  Even though you aren't using it to write your tests, you've already taken that step.  

     

    There are some examples showing, briefly, how to do this... check out https://support.smartbear.com/viewarticle/18441/

     

    I also created a Script Extension some time back that does what you want...I don't have any documentation written up for it (yet) but, if you want to try it, you can download it at https://bitbucket.org/tristaanogre/tabledrivenframework/downloads/SQLUtilities.tcx and then just send me a private message for how to use it.

    But yes... to do a TRUNCATE TABLE you're going to want do something a bit more than just a keyword test.

     

     

     

     

tristaanogre's avatar
tristaanogre
Esteemed Contributor

I'm assuming, to date, you've been using mainly Keyword Tests to create your project. 

It is not impossible to do SQL queries and stuff in KeywordTests... but I find it cumbersome.  It feels much easier and intuitive to me to use, as you mention, "a programming language". 

When you created your project, you selected a programming language.  Even though you aren't using it to write your tests, you've already taken that step.  

 

There are some examples showing, briefly, how to do this... check out https://support.smartbear.com/viewarticle/18441/

 

I also created a Script Extension some time back that does what you want...I don't have any documentation written up for it (yet) but, if you want to try it, you can download it at https://bitbucket.org/tristaanogre/tabledrivenframework/downloads/SQLUtilities.tcx and then just send me a private message for how to use it.

But yes... to do a TRUNCATE TABLE you're going to want do something a bit more than just a keyword test.

 

 

 

 

progz's avatar
progz
Occasional Contributor
8 years ago

Thank you for all the information you have posted. The thing is, I did see that url ( https://support.smartbear.com/viewarticle/18441/#_ga=1.58098088.346800190.1479231266 ) before posting this thread. The programming code that I select to start doing the 'recorded' test were with C++, which I did not see how that page. Because of that, I was not sure if I could still use the ones listed on the website. I did download the extension though and would love to learn how to use it. Will PM you after this post.

  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor
    8 years ago

    The syntax for C++ is pretty similar to the JScript syntax posted on that page... so you should be able to work with that, at least for starters.

    I'll look for your PM.  It might not be until later this evening that I'll be able to dedicate time to it but I'll certainly do what I can.

    • Colin_McCrae's avatar
      Colin_McCrae
      Community Hero
      8 years ago

      I'll need to grab that extension and have a look at it myself.

       

      I have some SQL stuff in my own extensions. I do DB restores as well. The way I do it to use a stored baseline snapshot (you can also make a new snapshot using the extension I have) and simply restore that. Which, assuming the snapshot restored to is the one from the very start of the run, resets everything to baseline.

       

      I use it a lot. Most tests on this particular application. Use it at least once.

       

      (Mine are written in such a way to provide a certain syntax that fits in with the rest of my keyword driven framework so probably not of much use to the general community I'm afraid.)

       

      If you happen to have anything in the way of docs for your TCX tristaanogre, I'd be grateful if you could PM them my way also. Thanks.