delete_profile = {

  label = "Delete Profile"
  shortcut = "dp"
  requires_profile = true
  parameters = {
    delete_database = {
      shortcut = "ddb"
      required = false
      default = false
    }
    drop_sql_database = {
      shortcut = "dsd"
      required = false
      default = false
    }
  }
  expression = `

#echo("delete_profile");

include "lib.database";

# Get the profile node
string profile_name = command_line.profile;
node profile_node = 'profiles'{command_line.profile};

# Delete the database, if required
if (delete_database) then (
  echo("Deleting database");
  string database_directory = get_database_directory(profile_node);
  echo("database_directory=" . database_directory);
  delete_directory(database_directory);
);

# Delete the SQL database, if required
if (drop_sql_database) then (
  echo("Dropping SQL database");
  string sql_database_name = @profile_node{"database"}{"options"}{"server"}{"database_name"};
  echo("sql database name: " . sql_database_name); 
  string query = "drop database " . sql_database_name;
  echo("Dropping SQL database with query: " . query);
  database_sql_query("USE Master", false, false);
  database_sql_query(query, false, false);
);

# Delete the profile
delete_node(profile_node);

# Generate the XML result, for use in network action
node result = new_action_result(command_line.action);
@result{"Result"} = "Success";
@result{"Profile"} = profile_name;
@result{"DeletedDatabase"} = delete_database;
string xml_result = action_result_to_xml(result);
echo("xml_result: " . xml_result);
xml_result;

` # expression
  
} # delete_profile