Method get_published_public_plugins

components/stores/src/config.rs:1113–1147

(&self)

    }

    pub async fn get_published_public_plugins(&self) -> ConfigStoreResult<Vec<Plugin>> {
        let raw_plugins = sqlx::query_as!(
            DbPlugin,
            r#"SELECT id,
created_at,
name,
short_description,
long_description,
is_published,
is_official,
plugin_kind,
current_version_number,
script_published_source,
script_published_version_updated_at,
script_dev_source,
script_dev_version_updated_at,
author_id,
is_public,
discord_thread_id,
installed_guilds,
installed_guilds_updated_at
FROM plugins WHERE is_published = true AND is_public = true
ORDER BY id ASC"#,
        )
        .fetch_all(&self.pool)
        .await?;

        let mut res: Vec<Plugin> = Vec::new();
        for plugin in raw_plugins.into_iter() {
            let images = self.get_plugin_images_with_pool(plugin.id as u64).await?;
            res.push(PluginAndImages(plugin, images).into());
        }

        Ok(res)
    }

    pub async fn try_guild_add_script_plugin(
        &self,