reset.sql

--  This file is part of the eliona project.
--  Copyright © 2023 LEICOM iTEC AG. All Rights Reserved.
--  ______ _ _
-- |  ____| (_)
-- | |__  | |_  ___  _ __   __ _
-- |  __| | | |/ _ \| '_ \ / _` |
-- | |____| | | (_) | | | | (_| |
-- |______|_|_|\___/|_| |_|\__,_|
--
--  THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING
--  BUT NOT LIMITED  TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
--  NON INFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM,
--  DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
--  OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

-- This idempotent script resets the database to a defined state ready for testing.
-- The only thing that remains after testing then are the incremented auto-increment values and app
-- registration (which you can optionally remove as well by uncommenting the last command).

INSERT INTO public.eliona_store (app_name, category, version)
VALUES ('thingdust', 'app', '1.0.0')
    ON CONFLICT (app_name) DO UPDATE SET version = '1.0.0';

INSERT INTO public.eliona_app (app_name, enable)
VALUES ('thingdust', 't')
    ON CONFLICT (app_name) DO UPDATE SET initialized_at = null;

DROP SCHEMA IF EXISTS thingdust CASCADE;

DELETE FROM public.heap
WHERE asset_id IN (
	SELECT asset_id
	FROM public.asset
	WHERE asset_type LIKE E'thingdust\\_%'
);

DELETE FROM public.attribute_schema
WHERE asset_type LIKE E'thingdust\\_%';

DELETE FROM public.asset
WHERE asset_type LIKE E'thingdust\\_%';

DELETE FROM public.asset_type
WHERE asset_type LIKE E'thingdust\\_%';

DELETE FROM public.widget_data
WHERE widget_id IN (
    SELECT public.widget.id
    FROM public.widget JOIN public.dashboard USING (dashboard_id)
    WHERE public.dashboard.name LIKE 'Thingdust%'
);

DELETE FROM public.widget
WHERE dashboard_id IN (
    SELECT dashboard_id
    FROM public.dashboard
    WHERE name LIKE 'Thingdust%'
);

DELETE FROM public.dashboard
WHERE name LIKE 'Thingdust%'

-- DELETE FROM public.eliona_app WHERE app_name = 'thingdust';