Robot Framework and Apache Ant

This tutorial is meant to show how easy you can use Robot Framework with Apache Ant. You can use later the build file for example with Jenkins.



My folder structure looks like this:

Project structure

Within the folder “report” all logs and reports should be stored. Inside the folder “testsuite” are all Robot Framework files. The “build.xml” looks like this:

The content of the build.xml is self-explanatory. Now opening a terminal and run Apache Ant.


Yosemite – Apache and PHP at user level

Mac OS X include Apache server and PHP, but since some version by default only at root level. To start the Apache on root level simple use the following commands.

After starting the Apache server, on browser you can use the URL “http://localhost”. You should see something like: “It Works”. The location for files is “/Library/WebServer/Documents/”.

Small note
I have to apologize! The security policies of my provider do not allow the usage or combination for special words. Therefore, at various points images were used.

User level

Now we create the Apache on user level with a few configuration steps.

Inside this folder create a simple PHP file (index.php)

In the third step, the configuration file of the user is created. The name always includes the user name!

Add the following content and save

Check the access permissions for “-rw-r–r–” or “664”! To enable the configuration, open the “httpd-userdir.conf” and uncomment one line above <IfModule>.


In the last step, only the correct modules must be loaded.


Now uncomment the LoadModule lines for “” and “” and include for user home.

user home include

Thats it! If you now start/restart the Apache and call the URL “http://localhost/~<username>/” in your browser, you should see the parsed content of PHP file.

Minimize CSS and JavaScript files

To speed up the performance of your website, all CSS and JavaScript files should be minimized. That means, all CSS and JavaScript should delivered without unnecessary comments, spaces, line breaks and tabs. It should of course take place in the build process, otherwise your developers work is much harder! This tutorial shows how easily you can  minimize files, by using the YUI Compressor.


Minimize one file

Minimize multiple files

For more options show the help!

Run programming languages from finder

On double-click the Mac OS X finder opens the default editor for script files. With the Automator you can very easy create services, which run these scripts. This example shows how to run python direct from finder.


Start Automator and select “Service”

automator service

The service should receive “Files and Folder” on “Finder”.

Service receive files and folders

Now add from library “Run as Shellscript” with following content.

Run Shell Script

Now save your Automator workflow. The location should be automatically set to: “/Users/<user>/Library/Services”. Now select a python file, over the context menu or navigation item service, you can run it directly. My service is called “RunAsPython.

automator service for python

PyCharm Community Edition and Database Navigator

For the Community Editition there is a plugin that allows to edit or query databases directly from PyCharm. Currently MySQL, Oracle and Postgres are supported. The benefit, You as a tester (or developer) need to use no other tools.


  • PyCharm is installed
  • Running Postgres server
  • Download latest JDBC driver (PostgreSQL)


Search and install the “Database Navigator”. Restart PyCharm after installation.

PyCharm Database Navigator

Setup the connection. The following example shows a connection to Postgres.

Postgres connection
Insert all needed values. As driver library select the JDBC jar file. The URL should follow the syntax like:

To verify your settings, use the test button.

Now you can query, just select the schema and insert your SQL statements.

Database Navigator usage