How can we improve KANBOARD Plugins information?

21

Of course, this is a personal perspective, nothing more.

BTW, I had absolutely no problem when starting with KB. So what?

1 Like
22
1 Like
23

Why not?

1 Like
24

Progress so farā€¦

image
image1468Ɨ234 33.5 KB

  • filter search works, copied from kanboard websiteā€¦ its not great but it works - yet to be styled
  • this is the only information which i could pull from kanboardā€¦ surprisingly, there is no plugin-installed-related information in the database.
  • I want to sort it alphabetically by plugin name but im heavily struggling with that because of the code ā€˜foreachā€™ loop

STILL NOT READY FOR RELEASEā€¦

2 Likes
25

You can sort it by php built-in function:
https://www.php.net/manual/en/function.array-multisort.php

1 Like
26

Just an additional thought:

For me, an important plugin property would be, whether the plugin modifies the database scheme. Even if I know that this wonā€™t be cleaned up on uninstallation. Unfortunately, there are no resources for that, it always has to be done manually. This property (has Schema directory) would be helpful for users that try or test plugins frequently.

Recent example: The plugin SubtaskDescription adds a new column to the subtask table. After uninstalling the plugin, that addition remains forever, even if no longer useful.

Keep it clean and proper!ā„¢

2 Likes
27

I understand and agree with you on thatā€¦

for the schema issue, could we not adjust/adapt what @creecros did for getting the latest versio of KBā€¦

if (strpos(APP_VERSION, 'master') !== false && file_exists('ChangeLog')) { $accurate_version = trim(file_get_contents('ChangeLog', false, null, 8, 6), ' '); }

i mean could the above not be changed to check for a schema folder?

1 Like
28

Yeah, for installed plugins that should be possible. But real coolness comes up, when you know that from all plugins, in advance, before installing them.

2 Likes
29

if a schema folder exists in a plugin, its there to modify you database. would be an easy thing to check for, if you are trying to write code to detect that.

also, makes me wonder though, does it have to be there foreverā€¦never really thought about that. What would it take to undo.

thought experiment:

  1. what DB is being used
  2. find coinciding Schema
  3. read schema
$pdo->exec("ALTER TABLE `subtasks` ADD COLUMN `due_description` TEXT NOT NULL DEFAULT ''");
  1. uninstall plugin
  2. execute countermeasure:
$pdo->exec("ALTER TABLE `subtasks` DROP COLUMN `due_description`");
  1. win
2 Likes
30

Not to forget dropping the appropriate record in table ā€œplugin_schema_versionsā€.

2 Likes
31

I tried this but it didnā€™t work:

                <?php
                $pluginName = $this->text->e($plugin->getPluginName())
                ?>
            <?php if (SchemaHandler::hasSchema($pluginName)): ?>
            This plugin makes database changes
            <?php endif ?>
32

What exactly didnā€™t work?

33

it doesnt load the page

34

Quick & dirty: I think you need the full qualified name.

<?php $schema = Kanboard\Core\Plugin\SchemaHandler::hasSchema($plugin->getPluginName()); ?>
<?= $schema ? " YES" : " NO" ?>

1 Like
35

nice but this still doesnt work on 1.2.20

36

Iā€™m on the current version, and I donā€™t have any 1.2.20 running. Sorry.

1 Like
37

stop testing on old stuff :slight_smile:

2 Likes
38

getPluginName() will work on installed plugins, but it will not work on info from the Directory.

ya thats a bust, there wouldnā€™t be any way to determine the schema at all, if it is not already installedā€¦

if the info is not here:

we canā€™t conjure it. Wellā€¦maybe we could, if we check the github pageā€¦hmmm

39

Yes, I know that. I think scanning the entire directory would be too expensive for practical use.

40

Ya, weā€™d have to do more than just scan the directory, weā€™d have to scan each github repo associated with each plugin within the directory.