Debug python DB code exception through robot framework

Tools PyCharm
1

Hello, I worked on robot framework recently and there is an existing project to test.

Run command line in git bash as follows (from security purpose, I could not give exact info)
powershell .build/xxx.ps1 -{var1} val1 -{var2} val2 … -testName “Test that at Head of Line…”

I got a exception from python DB code. I wonder

  1. Is it possible that I could see trace stack? for example, which python files and which lines throws exception from bottom to top,
  2. how to debug this test case by Pycharm or other IDE? (some screenshoot woudl be great!)

Thanks for the help.
Shenyi

Test that at Head of Line … (robot framwork test case)
…
| FAIL | (could not find any track stack info, I even don’t know which file or line throwns exception)
DBAPIError: (pyodbc.Error) (‘HY000’, '[HY000] [DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engine]UPDATE failed: Unable to update column XXX (python library calls DB update)

2

If you use the RF LSP plugin, you can put breakpoints in the RF or Python code and step through etc. The plugin can be found here:
Robot Framework Language Server - IntelliJ IDEs Plugin | Marketplace (jetbrains.com)

3

Thank you for the reply robinmackaij. I found the best IDE is vs code instead of pycharm. Here is my repo GitHub - bobydo/robot-framework-testautomationu to show what extensions are required. some tips came from Introduction to Robot Framework and others came from internet research. it is sloved. thanks again!

4

I will try to debug python created keywords and update here later.