/* Verschlüsselung */

SELECT gen_random_uuid();

SELECT gen_random_bytes(256);

SELECT encode(gen_random_bytes(256), 'hex');
SELECT encode(gen_random_bytes(256), 'base64');

SELECT digest('geheim', 'md5');
SELECT encode(digest('geheim', 'md5'), 'hex');
-- http://md5decrypt.net/en/
-- https://crackstation.net/
-- e8636ea013e682faf61f56ce1cb1ab5c

SELECT digest('geheim', 'sha256');
SELECT encode(digest('geheim', 'sha256'), 'hex');
-- http://md5decrypt.net/en/Sha256/
-- https://crackstation.net/
-- addb0f5e7826c857d7376d1bd9bc33c0c544790a2eac96144a8af22b1298c940

SELECT digest('geheim', 'sha512');
SELECT encode(digest('geheim', 'sha512'), 'hex');
-- http://md5decrypt.net/en/Sha512/
-- https://crackstation.net/
-- 8d847e01d22baa969f71fa362b4de21c9e13c7882bcea13ba5c6a8ae0d71fc8c9700c82e0087a65c8b37bd29f536747f28c9672bec1cae7762d2c9f36b6013f2

SELECT encode(gen_random_bytes(32), 'base64');
-- SKKO6bHd8U+IQ/7TR5IQQXV+4JYhTIhi9eXMGTIDmog=
SELECT encode(digest('geheim' || 'SKKO6bHd8U+IQ/7TR5IQQXV+4JYhTIhi9eXMGTIDmog=', 'sha512'), 'hex');
-- http://md5decrypt.net/en/Sha512/  liefert das Passwort nicht mehr im Klartext
-- https://crackstation.net/
-- 9750c58338678863cd90751495ef293d8824d8acbe43172c2b4d8b100156fc82f0b63970a7ad19fecbded2e61b955c12dc8bc41b91a34044d393da7c52401f7c

-----------------------------------------------------------------------------------

-- https://www.postgresql.org/docs/current/static/pgcrypto.html
SELECT gen_salt('bf'), gen_salt('bf'), gen_salt('bf');

SELECT crypt('geheim', gen_salt('bf')),  crypt('geheim', gen_salt('bf'));

SELECT crypt('geheim', '$2a$06$pKJmBXm9ihFbTBCl3/wBM.'), '$2a$06$pKJmBXm9ihFbTBCl3/wBM.';

SELECT crypt('geheim', '§"$%fdg43TREGD54ü3245ete§$%§$%'), crypt('password', '§"$%fdg43TREGD54ü3245ete§$%§$%');
SELECT crypt('geheim', '$2a$06$pKJmBXm9ihFbTBCl3/wBM.'),  crypt('password', '$2a$06$pKJmBXm9ihFbTBCl3/wBM.');

SELECT gen_salt('bf');
SELECT gen_salt('bf',8);
SELECT gen_salt('bf',14);

SELECT crypt('geheim', gen_salt('bf'));
SELECT crypt('geheim', gen_salt('bf',8));
SELECT crypt('geheim', gen_salt('bf',14));


-- '$2a$14$5PEKjgHVsugXNVXHWbZmt.9F4ieQw1iVHKrYngZFKIeGEB2/E6GLG'

SELECT
  ( '$2a$14$5PEKjgHVsugXNVXHWbZmt.9F4ieQw1iVHKrYngZFKIeGEB2/E6GLG'
  =
    crypt
    ( 'geheim',
      '$2a$14$5PEKjgHVsugXNVXHWbZmt.9F4ieQw1iVHKrYngZFKIeGEB2/E6GLG'
    )
  ) AS password_correct;
  
SELECT
  ( '$2a$14$5PEKjgHVsugXNVXHWbZmt.9F4ieQw1iVHKrYngZFKIeGEB2/E6GLG'
  =
    crypt
    ( 'passwort',
      '$2a$14$5PEKjgHVsugXNVXHWbZmt.9F4ieQw1iVHKrYngZFKIeGEB2/E6GLG'
    )
  ) AS password_correct;