damiant has asked for the wisdom of the Perl Monks concerning the following question:

Salut. I want to create a database oracle healtcheck script that will contain or call multiple sql bash scripts and the output I want to be in the html format. The bash scripts will check the operating system kernel values and displays verfication status like failed/passed. The sql scripts will make queries on the database and the output should be in tables. I didn`t work so far with perl, I have only experience with databases and SQL language. There are already softs created by Oracle that do this but I want to create my own tool. I allready have the sql scripts and the bash scripts. The big challenge for me is the integration of the SQL, bash in Perl and display the result in a html file. I will be very grateful for any advice, starting point. Thank you.
  • Comment on integrate sql/bash script in perl with html output

Replies are listed 'Best First'.
Re: integrate sql/bash script in perl with html output
by choroba (Cardinal) on Jun 04, 2013 at 19:53 UTC
    To run shell scripts from Perl, use system or qx.

    Nevertheless, I would recommend DBI to communicate with the database directly from Perl; and some kind of a framework (Dancer, Mojolicious) to build the web application.

    لսႽ† ᥲᥒ⚪⟊Ⴙᘓᖇ Ꮅᘓᖇ⎱ Ⴙᥲ𝇋ƙᘓᖇ