Hello,
I have added DB related details in project settings -> database screen. It shows connection successful.
Now, I want to use that in my script to execute query, get result at script level and use it in next / further test steps.
Can you please help to share link / example for the same?
Thank you in advance.
Regards,
Ketul Shah
I connect to SQL server and run a stored procedure to return the values I need. In this example I create a connection, call the Stored procedure, then clean up the response to a string I can use.
This is setup as a Custom keyword so I can simply call it when needed. You could add a variable for the Stored Procedure name, if you have many different call to make.
import groovy.sql.Sql //you need this
@Keyword
def Useyourname()
{
def configuration = [
‘dbInstance’ : ‘Server Name’,
‘dbPort’ : 1433,
‘dbName’ : ‘DBname’,
‘dbUser’ : ‘username’,
‘dbPass’ : ‘password’
]
def sql = Sql.newInstance(
“jdbc:sqlserver://${configuration.dbInstance}:${configuration.dbPort};” +
“databaseName=” + configuration.dbName,
configuration.dbUser, configuration.dbPass,
‘com.microsoft.sqlserver.jdbc.SQLServerDriver’)
new Sql(sql).call (“Sequence;”) //name of my stored proc
def res = (sql.rows(“select WebCallSequence from WebCallSequence;”).toString())
def numb = res.substring(res.lastIndexOf(":") + 1) //cleaning the return string
def counter = (numb.substring(0, numb.length()-2)) //cleaning the return string
return counter //return the value
}
I have the same concern, any one here not even try this?