aonestar.public

Parameters

Name	Type	Mode
image	bytea	IN
stored_url	text	IN

Definition

SELECT 
	CASE 
	  WHEN stored_url LIKE 'http%' THEN stored_url
	  ELSE 
		CASE md5(image)
			WHEN '88e3a7cc90051db732c364bc70a86e5b' THEN 'https://fromas.sgp1.cdn.digitaloceanspaces.com/public/bed_images/01-single.png'
			WHEN 'ac9bb8c1d0e1e487351b2d30e6bb3e7c' THEN 'https://fromas.sgp1.cdn.digitaloceanspaces.com/public/bed_images/02-double.png'
			WHEN 'ffa2097636cbfa0b6f7f8af0b4bf1f9c' THEN 'https://fromas.sgp1.cdn.digitaloceanspaces.com/public/bed_images/03-twin.png'
			WHEN '8cddfeff986bddbed197a7d9d37baf2c' THEN 'https://fromas.sgp1.cdn.digitaloceanspaces.com/public/bed_images/04-triple.png'
			WHEN '6a5845c0949ccea1ab517ffd0db778b1' THEN 'https://fromas.sgp1.cdn.digitaloceanspaces.com/public/bed_images/05-two-doubles.png'
			WHEN 'bd9b7d95c450610e9f982a9fba7fbd88' THEN 'https://fromas.sgp1.cdn.digitaloceanspaces.com/public/bed_images/06-double-and-single.png'
			WHEN 'c5406f215fcdcabf7282ac2f3bd4e604' THEN 'https://fromas.sgp1.cdn.digitaloceanspaces.com/public/bed_images/07-double1.png'
			WHEN 'e0cf982fe277f9dd30e95584a732f548' THEN 'https://fromas.sgp1.cdn.digitaloceanspaces.com/public/bed_images/08-double2.png'
			WHEN 'd7ff46969962072daafd47a65e026cc9' THEN 'https://fromas.sgp1.cdn.digitaloceanspaces.com/public/bed_images/09-double3.png'
			WHEN 'd74ce089c46986d8c305ef584d3edf85' THEN 'https://fromas.sgp1.cdn.digitaloceanspaces.com/public/bed_images/10-double4.png'
			WHEN 'e038d2bbf931f07223c024770d222353' THEN 'https://fromas.sgp1.cdn.digitaloceanspaces.com/public/bed_images/11-double5.png'
			WHEN '1d6343a547cef1c1cd86b5caa0def862' THEN 'https://fromas.sgp1.cdn.digitaloceanspaces.com/public/bed_images/12-single2.png'
			WHEN 'cd0492845d27cbf9d8b1a033013289e3' THEN 'https://fromas.sgp1.cdn.digitaloceanspaces.com/public/bed_images/13-single3.png'
			WHEN 'c232ee2503a0d68b080f9232eef1061b' THEN 'https://fromas.sgp1.cdn.digitaloceanspaces.com/public/bed_images/14-single4.png'
		END
	END

fn_get_bed_image_url

Parameters

Definition