{"id":17,"date":"2018-10-03T15:47:00","date_gmt":"2018-10-03T15:47:00","guid":{"rendered":""},"modified":"2018-12-10T14:09:34","modified_gmt":"2018-12-10T14:09:34","slug":"how-to-use-python-with-hammerdb","status":"publish","type":"post","link":"https:\/\/www.hammerdb.com\/blog\/uncategorized\/how-to-use-python-with-hammerdb\/","title":{"rendered":"How to use Python with HammerDB"},"content":{"rendered":"
HammerDB is written in Tcl rather than Python for very specific reasons regarding thread scalability and the reasons are very well explained in this article\u00a0<\/span>Threads Done Right… With Tcl<\/a>. Nevertheless a common question is whether it is possible to use Python with HammerDB? and the answer is Yes, in fact it is pretty straightforward to extend HammerDB using a package called tclpython available here\u00a0https:\/\/github.com\/amykyta3\/tclpython<\/a>. The following example is from Red Hat 7.5.\u00a0<\/span><\/div>\n
<\/div>\n
Firstly download\u00a0<\/span>tclpython from github\u00a0<\/span>and extract the files<\/span><\/div>\n
\n
[root@vulture tclpython-master]#\r\nbuild\u00a0 LICENSE\u00a0 Makefile\u00a0 msvc\u00a0 pkg\u00a0 README.md\u00a0 src\u00a0 test\u00a0 VERSION.md<\/span><\/pre>\n
Then install python and tcl devel packages. Note that on Red Hat 7.5 this will be Tcl 8.5 however the compiled package will still work with HammerDB that uses Tcl 8.6.<\/span><\/div>\n<\/div>\n
\n
[root@vulture ~]# sudo yum install python-devel tcl-devel<\/span>\r\nLoaded plugins: langpacks, ulninfo<\/span>\r\nPackage python-devel-2.7.5-69.0.1.el7_5.x86_64 already installed and latest version<\/span>\r\n...<\/span><\/pre>\n<\/div>\n
\n
Then compile tclpython.<\/span><\/div>\n
[root@vulture tclpython-master]# make<\/span>\r\ncc -o build\/tclpython\/tclpython\/tclpython.so.5.0 build\/tclpython\/src\/tclpython.o build\/tclpython\/src\/py.o -shared -s -lpthread -ldl -lutil -lm -lpython2.7 -ltclstub8.5<\/span><\/pre>\n<\/div>\n
If everything goes right you should see the library in the tclpython directory as follows. Note that this is for Python 2 as by default Python 3 is not installed on Red Hat 7.5 (although this can be installed on Red Hat and tclpython built with Python 3 if you wish).<\/div>\n
\n
\/home\/oracle\/tclpython-master\/build\/tclpython\/tclpython<\/span>\r\n[oracle@vulture tclpython]$ ls<\/span>\r\npkgIndex.tcl\u00a0 tclpython.so.5.0<\/span><\/pre>\n
Copy this directory and its contents to the HammerDB lib directory so you have the library and the pkgIndex file.<\/div>\n
\n
[oracle@vulture lib]$ ls tclpython\/<\/span>\r\npkgIndex.tcl\u00a0 tclpython.so.5.0<\/span><\/pre>\n
You can now create an interpreter with Python and run the example commands<\/span><\/div>\n<\/div>\n
\n
[oracle@vulture HammerDB-3.1]$ .\/hammerdbcli\u00a0<\/span>\r\nHammerDB CLI v3.1<\/span>\r\nCopyright (C) 2003-2018 Steve Shaw<\/span>\r\nType \"help\" for a list of commands<\/span>\r\nThe xml is well-formed, applying configuration<\/span>\r\nhammerdb>package require tclpython<\/span>\r\n5.0<\/span>\r\nhammerdb>set interpreter [python::interp new]<\/span>\r\npython0<\/span>\r\nhammerdb>$interpreter exec {print(\"Hello World\")}<\/span>\r\nHello World<\/span>\r\nhammerdb>puts [$interpreter eval 3\/2.0]<\/span>\r\n1.5<\/span>\r\nhammerdb>python::interp delete $interpreter<\/span>\r\nhammerdb>exit<\/span><\/pre>\n
Using this method you can use Python to add your own functions to the driver scripts or write your own testing scripts. Note that in the HammerDB GUI there is functionality to capture any output written to stdout and direct it to the appropriate virtual user output and therefore any use of print in Python needs to do the same or output will be written to the command line where HammerDB was called.<\/span><\/div>\n