mirror of
https://gh.wpcy.net/https://github.com/discourse/discourse.git
synced 2026-05-04 15:13:41 +08:00
bcb0949a2f
Redesigns the Data Explorer `/queries/new` page to be AI-first, with a non-AI fallback if AI is disabled. Instead of the old dual-form layout (manual create + separate AI generate that redirects to the edit page), the new page lets you describe what you want, generates the SQL inline, and saves when you're ready. Reviewer notes: - there's no database record created until user clicks "Save query" - new POST /queries/generate endpoint for query generation, no DB record - agent rework - related PR https://github.com/discourse/discourse-ai-evals/pull/16 - switched to agentic execution mode - removed ValidateSql tool (redundant with RunSql) - added full Data Explorer parameter type reference - evaluator for the DE agent
53 lines
2.4 KiB
Ruby
53 lines
2.4 KiB
Ruby
# frozen_string_literal: true
|
|
|
|
DiscourseDataExplorer::Engine.routes.draw do
|
|
root to: "query#index"
|
|
get "queries" => "query#index"
|
|
get "queries/new" => "query#index"
|
|
get "queries/:id" => "query#show", :constraints => { id: /-?\d+/ }
|
|
|
|
scope "/", defaults: { format: :json } do
|
|
get "schema" => "query#schema"
|
|
get "groups" => "query#groups"
|
|
post "queries/generate" => "query#generate_with_ai"
|
|
post "queries" => "query#create"
|
|
put "queries/:id" => "query#update"
|
|
delete "queries/:id" => "query#destroy"
|
|
post "queries/:id/run" => "query#run", :constraints => { format: /(json|csv)/ }
|
|
end
|
|
end
|
|
|
|
Discourse::Application.routes.draw do
|
|
get "/g/:group_name/reports" => "discourse_data_explorer/query#group_reports_index"
|
|
get "/g/:group_name/reports/:id" => "discourse_data_explorer/query#group_reports_show"
|
|
post "/g/:group_name/reports/:id/run" => "discourse_data_explorer/query#group_reports_run"
|
|
|
|
# Public API to fetch query results via GET with permission checks
|
|
get "/data-explorer/queries/:id/run" => "discourse_data_explorer/query#public_run",
|
|
:constraints => {
|
|
format: /(json|csv)/,
|
|
}
|
|
|
|
mount DiscourseDataExplorer::Engine, at: "/admin/plugins/discourse-data-explorer"
|
|
get "/admin/plugins/explorer" => redirect("/admin/plugins/discourse-data-explorer")
|
|
get "/admin/plugins/explorer/queries" =>
|
|
redirect("/admin/plugins/discourse-data-explorer/queries")
|
|
get "/admin/plugins/explorer/queries/:id" =>
|
|
redirect("/admin/plugins/discourse-data-explorer/queries/%{id}")
|
|
|
|
# Legacy /admin/plugins/explorer/ API routes - route directly to controller
|
|
# since redirects don't preserve POST/PUT/DELETE request bodies
|
|
scope "/", defaults: { format: :json } do
|
|
get "/admin/plugins/explorer/schema" => "discourse_data_explorer/query#schema"
|
|
get "/admin/plugins/explorer/groups" => "discourse_data_explorer/query#groups"
|
|
post "/admin/plugins/explorer/queries/generate" =>
|
|
"discourse_data_explorer/query#generate_with_ai"
|
|
post "/admin/plugins/explorer/queries" => "discourse_data_explorer/query#create"
|
|
put "/admin/plugins/explorer/queries/:id" => "discourse_data_explorer/query#update"
|
|
delete "/admin/plugins/explorer/queries/:id" => "discourse_data_explorer/query#destroy"
|
|
post "/admin/plugins/explorer/queries/:id/run" => "discourse_data_explorer/query#run",
|
|
:constraints => {
|
|
format: /(json|csv)/,
|
|
}
|
|
end
|
|
end
|
