Method publish_script_plugin_version

components/stores/src/config.rs:964–1020

(
        &self,
        plugin_id: u64,
        new_source: String,
    )

    }

    pub async fn publish_script_plugin_version(
        &self,
        plugin_id: u64,
        new_source: String,
    ) -> ConfigStoreResult<Vec<Id<GuildMarker>>> {
        let plugin = sqlx::query_as!(
            DbPlugin,
            r#"UPDATE plugins SET
script_published_source = $2, 
script_published_version_updated_at = now(),
current_version_number = current_version_number +1
WHERE id = $1
RETURNING 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
"#,
            plugin_id as i64,
            new_source,
        )
        .fetch_one(&self.pool)
        .await?;

        struct Row {
            guild_id: i64,
        }

        let updated_guilds = sqlx::query_as!(
            Row,
            "UPDATE guild_scripts SET original_source = $2, plugin_version_number = $3 WHERE \
             plugin_id = $1 AND plugin_auto_update RETURNING guild_id",
            plugin_id as i64,
            new_source,
            plugin.current_version_number,
        )
        .fetch_all(&self.pool)
        .await?;

        Ok(updated_guilds
            .into_iter()
            .map(|v| Id::new(v.guild_id as u64))
            .collect())
    }