Automating Plugin Management in Sisense: A Bash Script Solution | Help and How-To

Taras Skvarko · 2024-05-06T15:45:22.316000Z

Introduction:Managing plugins in Sisense, particularly in scenarios where multiple plugins need to be updated or reverted, can be a time-consuming task. However, by leveraging bash scripting, this process can be automated to save time and ensure consistency across plugins. In this article, we'll provide two bash scripts designed to update and revert changes to plugin configurations in Sisense - particularly changing the enabled/disabled state. These scripts are intended to be executed in the `/opt/sisense/storage/plugins` folder, where all plugins(add-ons) and their subfolders reside.Prerequisites:Before using the provided scripts, ensure you have the following:1. Access to the Sisense server with permission to modify plugin files.2. Basic understanding of bash scripting.3. Familiarity with JSON file structure.Script Overview:The provided scripts consist of two parts:1. Search and Update Script: This script searches for `plugin.json` files within subfolders of the `/opt/sisense/storage/plugins` directory. It updates the `isEnabled` key to `false` if it's `true` and logs the corresponding folder names in a separate file. #!/bin/bash # Clean the file before writing to it > updated_plugin_names.txt # Function to search for plugin.json and update "isEnabled" value search_and_update() { # Loop through subfolders for dir in */; do if [ -f "$dir/plugin.json" ]; then # Extract folder name folderName=$(jq -r '.folderName' "$dir/plugin.json") # Store name in separate file isEnabled=$(jq -r '.isEnabled' "$dir/plugin.json") if [ "$isEnabled" == "true" ]; then # Update "isEnabled" to false jq '.isEnabled = false' "$dir/plugin.json" > temp.json && mv temp.json "$dir/plugin.json" # Log name only for updated plugin.json echo "\"folderName\": \"$folderName\"" >> updated_plugin_names.txt fi fi done } search_and_update 2. Revert Changes Script: This script reverts the changes made by the first script. It reads the folder names from the log file generated by the first script and sets the `isEnabled` key back to `true` for the corresponding plugins. #!/bin/bash # Function to revert changes made by the first script revert_changes() { # Read plugin names from file while IFS= read -r folderName; do # Remove quotes and extract folder name folderName=$(echo "$folderName" | sed 's/"folderName": "$.*$"/\1/') # Find plugin directory by name dir=$(find . -maxdepth 1 -type d -name "*$folderName*") if [ -n "$dir" ]; then # Check if plugin.json exists and set "isEnabled" to true if [ -f "$dir/plugin.json" ]; then jq '.isEnabled = true' "$dir/plugin.json" > temp.json && mv temp.json "$dir/plugin.json" fi fi done < updated_plugin_names.txt } revert_changes Using the Scripts:Follow these steps to use the scripts:Copy Scripts to the Sisense Plugins Directory: Place both scripts (`search_and_update.sh` and `revert_changes.sh`) in the `/opt/sisense/storage/plugins` directory.Make Scripts Executable: Ensure that both scripts have execute permissions. You can set execute permissions using the `chmod` command: chmod +x search_and_update.sh chmod +x revert_changes.sh Execute the Search and Update Script: Run the `search_and_update.sh` script to update the `plugin.json` files: ./search_and_update.shThis script will update the `isEnabled` key to `false` for plugins with the corresponding folders and log the folder names in `updated_plugin_names.txt`. Execute the Revert Changes Script (if needed): If you need to revert the changes made by the first script, run the `revert_changes.sh` script: ./revert_changes.shThis script will read the folder names from `updated_plugin_names.txt` and set the `isEnabled` key back to `true` for the corresponding plugins. Conclusion:By utilizing bash scripting, managing Sisense plugins becomes more efficient and less error-prone. These scripts automate the process of updating and reverting plugin configurations, saving time and ensuring consistency across your Sisense environment. Make sure to test these scripts in a safe environment before applying them to a production environment.

MoreDiscussions

Automating Plugin Management in Sisense: A Bash Script Solution | Help and How-To | Sisense Community