ed25519.sql

CREATE EXTENSION IF NOT EXISTS plpython3u;

CREATE OR REPLACE FUNCTION py_create_ed25519_keypair ()
  RETURNS text[]
AS $$
  import axolotl_curve25519 as curve
  import os
  import base64

  randm32 = os.urandom(32)
  private_key = curve.generatePrivateKey(randm32)
  public_key = curve.generatePublicKey(private_key)
  return [base64.b64encode(private_key).decode('ascii'), base64.b64encode(public_key).decode('ascii')]
$$ LANGUAGE plpython3u;

CREATE OR REPLACE FUNCTION py_create_ed25519_signature (message text, private_key text)
  RETURNS text
AS $$
  import axolotl_curve25519 as curve
  import os
  import base64
  randm64 = os.urandom(64)
  signature = curve.calculateSignature(randm64, base64.b64decode(private_key), message.encode())
  return base64.b64encode(signature).decode('ascii')
$$ LANGUAGE plpython3u;

CREATE OR REPLACE FUNCTION py_verify_ed25519_signature (message text, signature text, public_key text)
  RETURNS boolean
AS $$
  import axolotl_curve25519 as curve
  import base64
  valid = (curve.verifySignature(base64.b64decode(public_key), message.encode(), base64.b64decode(signature)) == 0)
  return valid
$$ LANGUAGE plpython3u;