Add "log to database" capability

[jameswilburlewis]

When we eventually start building cron jobs around thmsoc_python utilities, we'll want to be able to log messages to the database, just like we do for ksh, php, and idl jobs. So we'll need a Python version of thmsoc_dblog.php

It will need to get login credentials from a file outside the web root and version control hierarchy. The PHP scripts get credentials by including a PHP file from a directory outside the web root and version control directories. The location of an equivalent file for thmsoc_python could be a new parameter in example_thmsoc_python_config.toml .

The Python version should be implemented as a Python function with a CLI script wrapper 'thmsoc_dblog', with the same API as thmsoc_dblog.php.

[jameswilburlewis]

A few excerpts from thmsoc_dblog.php to establish the desired API

Database details (hostname, database name, username, password) should be read from a config filename defined in thmsoc_python_config.toml.

// The command line 'Message' parameter is now optional.
// If a message is not provided on the command line, it will be read
// from standard input.  Convenient for multi-line messages.

$argcount = $_SERVER['argc'];
if (($argcount < 3) || ($argcount > 4)) {
    die("Usage: thmsoc_dblog ProcessName Severity ['Message']\n");
}

Command line arguments, get hostname where the log message is originating:

// Assign command line input variables
//
$processName = $_SERVER['argv'][1];
$severity = $_SERVER['argv'][2];

if ($argcount == 4) {
    $message = $_SERVER['argv'][3];
} else {
    $message = file_get_contents("php://stdin");
}

$machineName = gethostname();
if (($machineName === false) || ($machineName === "")) {
    $machineName = php_uname('n');

Execute a prepared statement to insert the log message into the database:

// Create a prepared statement
$stmt = mysqli_prepare($link, "INSERT INTO Thmsoc_Log (ProcessName, MachineName, TimeStamp, Severity, Message, NotifyFlag) VALUES (?, ?, NOW(), ?, ?, ?)");

if ($stmt) {
    // Bind variables to the prepared statement as parameters
    mysqli_stmt_bind_param($stmt, "sssss", $processName, $machineName, $severity, $message, $notifyFlag);

    // Execute the prepared statement
    mysqli_stmt_execute($stmt);

    // Close the statement
    mysqli_stmt_close($stmt);
} else {
    // Handle errors with the prepared statement
    echo "Error: " . mysqli_error($link);
}