robotframework - How to use database library with Robot Framework on temporary sql server -
i using robot framework's database library supports database validation.
i tried execute basic command:
***variables*** ***settings*** suite setup suite teardown test setup test teardown library databaselibrary ***testcases*** uc_db_validation to connect database i'm using:
dbapimodulename=mysqldb dbname='bigetestsrv' dbusername='ravitest' dbpassword='welcome' dbhost='10.73.92.18' when running connection string command prompt using pybot following error:
"no module named mysqldb" i using query express valid credentials , not have sql server installed in machine.
how can connect db?
i got .....
i approaching in wrong way database library (apache license) http://franz-see.github.com/robotframework-database-library/ using tested postgresql using psycopg2, may or may not work other rdbms. tried connect pymssql db, supporting bydefualt , worked.
i used connect database using custom params pymssql 'dbname', 'username', 'password', 'host'
as prerequisite need install pymssql (gnu lesser general public license) http://pymssql.sourceforge.net/license.php
thanks
Comments
Post a Comment