You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
If we want to execute a query after creating a table and add information to it along with deleting the table, we will pass to the sql property in the config yaml file a several SQL statements separate by semi colon. Currently this is not possible.
Some queries for monitoring purpose requires pre processed operations to be done along with post ones.
In the query_exporter.db.DataBase.execute_sql method we can distinguish the given sql is it multiple or not and based on that to perform single or multiple execution where the multiple one must be in one thread.
The text was updated successfully, but these errors were encountered:
You should be able to create a stored procedure which performs the necessary queries and returns the query result, so that you then only need to select * from procedure() as query.
For most of the scenarios yes. But if the user wants to make more than one query against not consistent DB where additional create and drop statements are required, currently it is not possible. Another approach is to insert a priority in each query block and based on it to execute all of the defined queries in consequential way.
If we want to execute a query after creating a table and add information to it along with deleting the table, we will pass to the sql property in the config yaml file a several SQL statements separate by semi colon. Currently this is not possible.
Some queries for monitoring purpose requires pre processed operations to be done along with post ones.
In the query_exporter.db.DataBase.execute_sql method we can distinguish the given sql is it multiple or not and based on that to perform single or multiple execution where the multiple one must be in one thread.
The text was updated successfully, but these errors were encountered: