Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT '' AS tn, '' AS md5
- UNION SELECT 'apple_mapping', md5(CAST((array_agg(t.* ORDER BY entity_uuid)) AS TEXT))
- FROM (SELECT entity_uuid, external_id, entity_type, is_deleted FROM apple_mapping ORDER BY id LIMIT 100000) t
- UNION SELECT 'spotify_mapping', md5(CAST((array_agg(t.* ORDER BY entity_uuid)) AS TEXT))
- FROM (SELECT entity_uuid, external_id, entity_type, is_deleted FROM spotify_mapping ORDER BY id LIMIT 100000) t
- UNION SELECT 'internal_mapping', md5(CAST((array_agg(t.* ORDER BY id)) AS TEXT))
- FROM (SELECT id, from_uuid, to_uuid, entity_type FROM internal_mapping ORDER BY id LIMIT 100000) t
- UNION SELECT 'apple_song_metadata_hash', md5(CAST((array_agg(t.* ORDER BY id)) AS TEXT))
- FROM (SELECT id, hash, uuid FROM apple_song_metadata_hash ORDER BY id LIMIT 100000) t
- ORDER BY tn;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement