From the course: Robot Framework Test Automation: Level 1 (Selenium)

Unlock this course with a free trial

Join today to access over 24,800 courses taught by industry experts.

Database: MS SQL and MySQL

Database: MS SQL and MySQL

There is an external database library that you can use for interacting with databases using Robot Framework. To be perfectly honest, this is the first library that gave me some troubles when I was trying to get started. Since this is an external library, you do have to install it, and normally we would just use pip install robotframework-databaselibrary. That would have worked just fine. But the problem is the latest version of this library is not available via the pip package manager, only Version 0.6 is. So the way that you install Version 0.7 is pip install robotframework-databaselibrary and we would have been done. So the other thing you need to know about this Robot Framework database library, is that it depends on one or more of these DB API libraries, which are not Robot Framework specific, they're just generic database libraries that are available in the Python world. So if you want to test SQL Server, you need to use pip install pymssql, or if you want to test MySQL, you…

Contents