To navigate to the scripting window, you can click the pencil icon at the top of the screen to open the stream properties window and navigate to the Execution tab:<\/p>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/07\/Basic1-min.jpg\")
<\/p>\n
For any script, the first thing you\u2019ll want to do is import the modeler API library. This can be done with a simple \u2018import\u2019 command:<\/p>\n
import modeler.api<\/p>\n
This will enable the script to use modeler-specific functions. You can also add any other Python libraries here by separating them with commas.<\/p>\n
Next, you\u2019ll want to define your stream object \u2013 or give the script a way to reference the modeler stream itself. This can be done in a single command:<\/p>\n
stream = modeler.script.stream()<\/p>\n
With this combination of loading the modeler API and defining the reference to the stream, you\u2019ll be able to run stream-specific functions like running nodes!<\/p>\n
Running a Node<\/strong><\/span><\/p>\n The command to run a node is broken into two pieces \u2013 1. Finding a node and 2. Running it. Finding a node simply gives you a way to refer to a specific node and perform operations on it. This might include setting node properties, connecting it to other nodes, or running it. The most common \u2018find\u2019 function is called findByType. This allows you to find a node based on its type (database source, filler, etc.), or its name. In this example, we\u2019ll find two nodes by their names and run them in order.<\/p>\n When scripting, it\u2019s recommended to give each node a unique name using the Annotations tab. In this stream, we\u2019ve got two branches of source nodes to export nodes called \u2018Export_1\u2019 and \u2018Export_2\u2019:<\/p>\n We can then use this unique name in the findByType function as follows:<\/p>\n exportNode1 = stream.findByType(None,’Export_1′)<\/p>\n This function takes two arguments: a node type (database source, filler, etc.) and a node name. If you\u2019re referring to a unique name, as we are in this example, you can pass in a value of None into the type argument and find the node solely on its name.<\/p>\n This will create a variable called exportNode1 that is a direct reference to the node named \u201cExport_1\u201d.<\/p>\n To run the node, we can call the run command:<\/p>\n exportNode1.run([])<\/p>\n We can then follow the same process for the second node, and run both nodes with a complete script of:<\/p>\n import modeler.api<\/p>\n stream = modeler.script.stream()<\/p>\n exportNode1 = stream.findByType(None,’Export_1′)<\/p>\n exportNode2 = stream.findByType(None,’Export_2′)<\/p>\n exportNode1.run([])<\/p>\n exportNode2.run([])<\/p>\n Scripts always run from top to bottom, so exportNode1 will run and complete before running exportNode2.<\/p>\n![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/07\/basic2-min.jpg\")
<\/p>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/07\/basic3-min.jpg\")
<\/p>\n