Package org.postgresql.pljava.example.annotation

Class Enumeration

java.lang.Object

org.postgresql.pljava.example.annotation.Enumeration

@SQLAction(provides="mood type",install="CREATE TYPE mood AS ENUM (\'sad\', \'ok\', \'happy\')",remove="DROP TYPE mood") @SQLAction(requires={"textToMood","moodToText","textsToMoods","moodsToTexts"},install={"SELECT textToMood(\'happy\')","SELECT moodToText(\'happy\'::mood)","SELECT textsToMoods(array[\'happy\',\'happy\',\'sad\',\'ok\'])","SELECT moodsToTexts(array[\'happy\',\'happy\',\'sad\',\'ok\']::mood[])"})
public class Enumeration
extends Object

Confirms the mapping of PG enum and Java String, and arrays of each, as parameter and return types.

Constructor Summary

Constructors

Constructor	Description
Enumeration()

Method Summary

Modifier and Type	Method	Description
static Iterator<String>	moodsToTexts(String[] ss)
static String	moodToText(String s)
static Iterator<String>	textsToMoods(String[] ss)
static String	textToMood(String s)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

Enumeration

public Enumeration()

Method Detail

textToMood

@Function(requires="mood type",
          provides="textToMood",
          type="mood")
public static String textToMood(String s)

moodToText

@Function(requires="mood type",
          provides="moodToText")
public static String moodToText(@SQLType("mood")
                                String s)

textsToMoods

@Function(requires="mood type",
          provides="textsToMoods",
          type="mood")
public static Iterator<String> textsToMoods(String[] ss)

moodsToTexts

@Function(requires="mood type",
          provides="moodsToTexts")
public static Iterator<String> moodsToTexts(@SQLType("mood[]")
                                            String[] ss)