История страницы
...
- Assemble a robot scheme consisting of actions:
Set the parameters for the "Connect Standard Db" action.
In the "DATABASE TYPE" field, select the appropriate database to which you want to connect.
Specify the database login and password.
The server host can be specified either by the IP of the host where the database is installed or by the host name.
Specify the server port, as well as the database name.
In the "Timeout" field, the value is calculated in seconds.
In the "Parameters" field specify additional parameters for connection, usually these are parameters that relate to security. Parameters are specified in the form of a dictionary.Read more about the "Transaction isolation level" parameter. The sequential database operations can be divided into transactions. A transaction is a group of operations that represent a certain boolean unit of working with the database. For example, it is necessary to perform several operations with a table in order to update the data in it. If an error occurs, you can roll back the transaction, i.e. a group of operations made, so that you do not have to figure out at what step this error occurred.
If the checkbox "Transaction isolation level" is activated, part of the performed queries to the database will be in the form of transactions.
- Set the parameters for the "Insert Recordrecord" action.
In the "Insert data" field use specify data in the form of a dictionary.
In the "List of primary key field names" field fill in the following manner:
- Click the "Start" button in the top panel.
...
The program robot completed successfully.
New text inserted in the table.
Обзор
Инструменты контента