Create Cleaning Jobs for Plugins

[aljawaid]

• Create JSON file to store all relevant plugin information
• Create helper
• Create model
• Create controller for modal form
• Add job to template

[aljawaid]

JSON Examples:

JSON for Plugins with Database Tables

"1": {
        "plugin_name": "metamagik",
        "plugin_author": "Craig Crosby",
        "plugin_url": "https://github.com/creecros/MetaMagik",
        "checked_upto_plugin_version": "1.5.5",
        "plugin_tables": ["metadata_has_type", "metadata_types"],
        "plugin_schema_version": 7
    }

JSON for Plugins with Database Tables and Additional Core Columns

"2": {
        "plugin_name": "costcontrol",
        "plugin_author": "aljawaid",
        "plugin_url": "https://github.com/aljawaid/CostControl",
        "checked_upto_plugin_version": "1.1",
        "plugin_tables": ["hourly_rates", "budget_lines"],
        "core_table_columns": [
            {"currencies": ["last_modified", "comment", "live_rate", "live_rate_updated"]}
        ],
        "plugin_schema_version": 1
    }

JSON for Plugins with Database Tables and Entries in Core Tables

"6": {
        "plugin_title": "Wiki",
        "plugin_name": "wiki",
        "plugin_author": "lastlink",
        "plugin_url": "https://github.com/funktechno/kanboard-plugin-wiki",
        "checked_upto_plugin_version": "0.3.3",
        "plugin_tables": ["wikipage", "wikipage_has_files", "wikipage_editions"],
        "core_table_entries": [
            {"settings": ["persistEditions"]}
        ],
        "plugin_schema_version": 8
    }

[aljawaid]

JSON Keys:

• "2": {
  • Identification number to match the cleaning job number
• "plugin_name":
  • Plugin name as saved in plugin_schema_versions table
• "plugin_author":
  • Plugin author name
• "plugin_url":
  • URL is needed in case of forks/plugins with the same name
  • Will be shown in the template
• "checked_upto_plugin_version":
  • For easy reference and future updates
  • Will be shown in the template
• "plugin_tables":
  • Database tables which are added by the plugin
  • Will be shown as a list in the template
  • Will be shown as a count in the template
• "core_table_columns":
  • Additional columns in core database tables
  • Will be shown as a list in the template
  • Will be shown as a count in the template
• "core_table_entries":
  • Entries in core database tables which need to be deleted
• "plugin_schema_version":
  • The schema version set for the plugin in plugin_schema_versions table
  • Will be used to delete the entry from the table matching the plugin name

[aljawaid]

Rough draft of template

[aljawaid]

024a4cf

74bc48f

[aljawaid]

@creecros The frontend for the plugin jobs is done. Any tips of how to do the functioning for deleting the stuff?

I think I can re-use functions like delete table or delete column... am sure I saw them in the code.

Any tips?

[aljawaid]

Screenshots c2d4b12

[aljawaid]

@creecros still busy?

[creecros]

Yes and no, I'll try and get back into it