This provider can be used in workflows.As “step” to query data, example:
Copy
steps: - name: Query mysql provider: mysql config: "{{ provider.my_provider_name }}" with: query: {value} # Query to execute as_dict: {value} # If True, returns the results as a list of dictionaries single_row: {value} # If True, returns only the first row of the results # Arguments will me passed to the query.format(**kwargs)
As “action” to make changes or update data, example:
Copy
actions: - name: Query mysql provider: mysql config: "{{ provider.my_provider_name }}" with: query: {value} # Query to execute as_dict: {value} # If True, returns the results as a list of dictionaries single_row: {value} # If True, returns only the first row of the results # Arguments will me passed to the query.format(**kwargs)