Python Script (DB)
DeprecatedKNIME Python nodes version 4.2.0.v202006261130 by KNIME AG, Zurich, Switzerland
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.
Input Ports
- An input database connection that provides all relevant information needed to connect to the database and an input SQL query used to initially fetch data from the database. In the Python script, it is available as DBUtil object under the name db_util.
Output Ports
- A database connection with the result table containing data from the database. The data in the result table is fetched either using the automatically defined output SQL query by the db_util or using the output SQL query defined by the user by executing the db_util.set_output_query() method.
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.
Best Friends (Incoming)
- Database Table Connector (legacy) (29 %)
- Database Table Selector (legacy) (14 %)
- Database Connector (legacy) (14 %)
- PostgreSQL Connector (legacy) (10 %)
Python Script (DB)(10 %) Deprecated- Show all 11 recommendations
Best Friends (Outgoing)
Python Script (DB)(40 %) Deprecated- Database Query (legacy) (33 %)
- Database Connection Table Reader (legacy) (7 %)
- Database Reader (legacy) (7 %)
- Database SQL Executor (legacy) (7 %)
- Show all 6 recommendations
Installation
To use this node in KNIME, install KNIME Python Integration (deprecated) from the following update site:
A zipped version of the software site can be downloaded here. Read our FAQs to get instructions about how to install nodes from a zipped update site.
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.