sentry

sentry copied to clipboard

We'd like to allow users to set default queries as their landing page. This field will be used to identify a saved query as a user's default query, i.e. there should be at most 1 row where created_by=user and is_default=True

This PR has a migration; here is the generated SQL for src/sentry/migrations/0317_add_is_default_to_saved_query_model.py ()

--
-- Add field is_default to discoversavedquery
--
ALTER TABLE "sentry_discoversavedquery" ADD COLUMN "is_default" boolean NULL;
--
-- Create constraint unique_user_default_query on model discoversavedquery
--
CREATE UNIQUE INDEX CONCURRENTLY "unique_user_default_query" ON "sentry_discoversavedquery" ("organization_id", "is_default") WHERE "is_default" = true;

Setting to draft to work out uniqueness validation.

This PR has a migration; here is the generated SQL for src/sentry/migrations/0318_add_is_default_to_saved_query_model.py ()

--
-- Add field is_default to discoversavedquery
--
ALTER TABLE "sentry_discoversavedquery" ADD COLUMN "is_default" boolean NULL;
--
-- Create constraint unique_user_default_query on model discoversavedquery
--
CREATE UNIQUE INDEX CONCURRENTLY "unique_user_default_query" ON "sentry_discoversavedquery" ("organization_id", "is_default") WHERE "is_default" = true;

This PR has a migration; here is the generated SQL for src/sentry/migrations/0318_add_is_homepage_to_saved_query_model.py ()

--
-- Add field is_homepage to discoversavedquery
--
ALTER TABLE "sentry_discoversavedquery" ADD COLUMN "is_homepage" boolean NULL;
--
-- Create constraint unique_user_homepage_query on model discoversavedquery
--
CREATE UNIQUE INDEX CONCURRENTLY "unique_user_homepage_query" ON "sentry_discoversavedquery" ("organization_id", "created_by_id", "is_homepage") WHERE "is_homepage" = true;