NLinker icon

Calculate hashes for resolver tables for the first 100k

NLinker | PRO | 02/23/17 10:17:48 PM UTC | 0 ⭐ | 7418 👁️ | Never ⏰ | []
PostgreSQL |

810 B

|

None

|

0 👍

/

0 👎

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;

Comments

  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    👍

    /

    👎