Package org.teiid.deployers

Class PgCatalogMetadataStore.FunctionMethods

java.lang.Object

org.teiid.deployers.PgCatalogMetadataStore.FunctionMethods

Enclosing class:

PgCatalogMetadataStore

public static class PgCatalogMetadataStore.FunctionMethods
extends Object

Constructor Summary

Constructors

Constructor	Description
FunctionMethods()

Method Summary

Modifier and Type	Method	Description
static String	array_to_string(CommandContext cc, Object[] array, String delim)
static BlobType	asBinary2(GeometryType geom, String encoding)
static BlobType	asBinary3(GeographyType geog, String encoding)
static Object	asPGVector(Object obj)
static String	colDescription(CommandContext cc, int oid, int column_number)
static String[]	current_schemas(CommandContext cc, boolean include_implicit)
static String	currentSchema(CommandContext cc)
static ClobType	encode(BlobType value, String encoding)
static String	formatType(CommandContext cc, Integer oid, Integer typmod)
static String	getExpr2(String text, Integer oid)
static String	getExpr3(String text, Integer oid, Boolean prettyPrint)
static Integer	getOid(CommandContext cc, String uid)
static String	getUserById(int user)
static Boolean	hasPerm(Integer oid, String permission)
static boolean	hasSchemaPrivilege(CommandContext cc, String name, String privilege)
static boolean	hasTablePrivilege(CommandContext cc, String name, String privilege)
static String	objDescription(CommandContext cc, int oid)
static String	objDescription2(CommandContext cc, int oid, String type)
static String	pg_client_encoding(CommandContext cc)
static String	pg_encoding_to_char(int code)
static String	pg_get_constraintdef(CommandContext cc, int oid, boolean pretty)
static String	pg_get_indexdef(CommandContext cc, int index_oid, short column_no, boolean pretty_bool)
static String	pg_get_ruledef(Integer ruleoid)
static Long	pg_relation_size(Integer reloid)
static Long	pg_stat_get_numscans(Integer reloid)
static boolean	pg_table_is_visible(int oid)
static Long	pg_total_relation_size(Integer reloid)
static boolean	pg_type_is_visible(int oid)
static boolean	pgHasRole(CommandContext cc, int userOid, String privilege)
static String	postgisGeosVersion()
static String	postgisLibVersion()
static String	postgisProjVersion()
static String	postgisVersion()
static Integer	regClass(CommandContext cc, String name)
static String	version()

Methods inherited from class java.lang.Object

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

Constructor Detail

FunctionMethods

public FunctionMethods()

Method Detail

encode

public static ClobType encode(BlobType value,
                              String encoding)
                       throws SQLException,
                              IOException

Throws:

SQLException

IOException

postgisLibVersion

public static String postgisLibVersion()

postgisVersion

public static String postgisVersion()

postgisGeosVersion

public static String postgisGeosVersion()

postgisProjVersion

public static String postgisProjVersion()

hasPerm

public static Boolean hasPerm(Integer oid,
                              String permission)

getExpr2

public static String getExpr2(String text,
                              Integer oid)

getExpr3

public static String getExpr3(String text,
                              Integer oid,
                              Boolean prettyPrint)

asPGVector

public static Object asPGVector(Object obj)

getOid

public static Integer getOid(CommandContext cc,
                             String uid)

pg_client_encoding

public static String pg_client_encoding(CommandContext cc)

regClass

public static Integer regClass(CommandContext cc,
                               String name)
                        throws TeiidComponentException,
                               QueryResolverException,
                               ParseException

Throws:

TeiidComponentException

QueryResolverException

ParseException

objDescription

public static String objDescription(CommandContext cc,
                                    int oid)

objDescription2

public static String objDescription2(CommandContext cc,
                                     int oid,
                                     String type)

getUserById

public static String getUserById(int user)

hasSchemaPrivilege

public static boolean hasSchemaPrivilege(CommandContext cc,
                                         String name,
                                         String privilege)

hasTablePrivilege

public static boolean hasTablePrivilege(CommandContext cc,
                                        String name,
                                        String privilege)

currentSchema

public static String currentSchema(CommandContext cc)

formatType

public static String formatType(CommandContext cc,
                                Integer oid,
                                Integer typmod)
                         throws SQLException

Throws:

SQLException

colDescription

public static String colDescription(CommandContext cc,
                                    int oid,
                                    int column_number)

pgHasRole

public static boolean pgHasRole(CommandContext cc,
                                int userOid,
                                String privilege)

asBinary2

public static BlobType asBinary2(GeometryType geom,
                                 String encoding)
                          throws FunctionExecutionException

Throws:

FunctionExecutionException

asBinary3

public static BlobType asBinary3(GeographyType geog,
                                 String encoding)
                          throws FunctionExecutionException

Throws:

FunctionExecutionException

pg_table_is_visible

public static boolean pg_table_is_visible(int oid)
                                   throws FunctionExecutionException

Throws:

FunctionExecutionException

pg_get_constraintdef

public static String pg_get_constraintdef(CommandContext cc,
                                          int oid,
                                          boolean pretty)
                                   throws SQLException

Throws:

SQLException

pg_type_is_visible

public static boolean pg_type_is_visible(int oid)
                                  throws FunctionExecutionException

Throws:

FunctionExecutionException

version

public static String version()

pg_encoding_to_char

public static String pg_encoding_to_char(int code)

current_schemas

public static String[] current_schemas(CommandContext cc,
                                       boolean include_implicit)

pg_get_indexdef

public static String pg_get_indexdef(CommandContext cc,
                                     int index_oid,
                                     short column_no,
                                     boolean pretty_bool)
                              throws TeiidSQLException,
                                     SQLException

Throws:

TeiidSQLException

SQLException

array_to_string

public static String array_to_string(CommandContext cc,
                                     Object[] array,
                                     String delim)

pg_total_relation_size

public static Long pg_total_relation_size(Integer reloid)

pg_relation_size

public static Long pg_relation_size(Integer reloid)

pg_stat_get_numscans

public static Long pg_stat_get_numscans(Integer reloid)

pg_get_ruledef

public static String pg_get_ruledef(Integer ruleoid)