docleanup

docleanup.sql

BEGIN;
CREATE TEMPORARY TABLE object_display_order_album_ids ( album_id INTEGER ) ON COMMIT DROP;

INSERT INTO object_display_order_album_ids
    SELECT DISTINCT(id)
    FROM
    (
        SELECT UNNEST(object_display_order.display_order_object_id) AS id
        FROM object_display_order
        WHERE object_display_order.display_order_object_type IN (
                                                                 SELECT id
                                                                 FROM object_display_order_types 
                                                                 WHERE display_order_object_type = 62
                                                                )
    ) object_display_order_display_order_object_ids;

SELECT COUNT(*)
FROM object_display_order_album_ids AS odoa
JOIN gallery_albums AS album ON (
    album.id = odoa.album_id
)
JOIN gallery_albums AS community ON (    community.id = album.object_id)
WHERE album.object_type = 62 AND
      community.type = 'community' AND      album.gallery_image_count <= 0;

SELECT album.id, album.status, album.gallery_image_count, album.object_type, album.object_id, album.type, album.created_at, community.id
FROM object_display_order_album_ids AS odoa
JOIN gallery_albums AS album ON (
    album.id = odoa.album_id
)JOIN gallery_albums AS community ON (
    community.id = album.object_id
)
WHERE album.object_type = 62 AND
      community.type = 'community' AND
      album.gallery_image_count <= 0;

SELECT COUNT(*) FROM object_display_order_album_ids;

-- And fix them 
-- SELECT object_display_order_delete_community_album_set( album.id ) 
-- FROM object_display_order_album_ids AS odoa 
-- JOIN gallery_albums AS album ON ( 
--  album.id = odoa.album_id 
-- ) 
-- JOIN gallery_albums AS community ON ( 
-- community.id = album.object_id 
-- ) 
-- WHERE album.object_type = 62 AND 
--    community.type = 'community' AND 
--    album.gallery_image_count <= 0;
ROLLBACK;