Python Script (DB)

Allows execution of a Python script in a local Python installation. The path to the Python executable has to be configured in Preferences → KNIME → Python.

NOTICE: The nodes uses the JayDeBeApi library to establish a connection to the database via a JDBC connection which his included. However to use JayDeBeApi JPype needs to be installed. For Windows precompiled libraries can be download from Unofficial Windows Binaries for Python Extension Packages.

Options

Script

Editor

The script that will be executed to generate this nodes output. Execute script will execute the full script while execute selection will only execute the currently selected script.

The editor optionally provides autocompletion (CTRL + Space) if the Python module jedi is installed.

Flow variables

The list contains the available flow variables. A double click will insert the corresponding identifier at the current cursor position in the editor.

Workspace

Lists the currently defined identifiers in the running Python instance. Reset workspace will remove all definitions and reinsert only the input data.

The result of the input database query is available via the db_util object. For details about the available functions of the db_util object execute db_util.print_description() in the editor.

Console

Displays the standard and error output of the execution as well as other relevant information.

Templates

Create from editor...

Create a new template based on the script contained in the editor of the script tab.

Note: User defined templates can be found in the folder: knime-workspace/.metadata/knime/sourcecode-templates/python-script

Remove selected

Removes the selected template.

Note: Templates provided by plugins can not be removed.

Apply selected

Replaces the script contained in the editor of the script tab with the selected template.

Views

Standard output

The text sent by Python to the standard output, during the execution of this node.

Error output

The text sent by Python to the error output, during the execution of this node.

Workflows

• No workflows found

Further Links

• No further links available

Developers