org.springframework.xd.greenplum.support

Class SqlUtils

java.lang.Object

org.springframework.xd.greenplum.support.SqlUtils

public abstract class SqlUtils
extends java.lang.Object

Constructor Summary

Constructors

Constructor and Description
SqlUtils()

Method Summary

Methods

Modifier and Type	Method and Description
static java.lang.String	createExternalReadableTable(LoadConfiguration config, java.lang.String prefix, java.util.List<java.lang.String> overrideLocations)
static java.lang.String	createLocationString(java.lang.String[] strings) Converts string array to greenplum friendly string.
static java.lang.String	dropExternalReadableTable(LoadConfiguration config, java.lang.String prefix)
static java.lang.String	load(LoadConfiguration config, java.lang.String prefix) Builds sql clause to load data into a database.

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlUtils

public SqlUtils()

Method Detail

createExternalReadableTable

public static java.lang.String createExternalReadableTable(LoadConfiguration config,
                                           java.lang.String prefix,
                                           java.util.List<java.lang.String> overrideLocations)

dropExternalReadableTable

public static java.lang.String dropExternalReadableTable(LoadConfiguration config,
                                         java.lang.String prefix)

Parameters:

config - the load configuration

prefix - the prefix

Returns:

the drop DDL

load

public static java.lang.String load(LoadConfiguration config,
                    java.lang.String prefix)

Builds sql clause to load data into a database.

Parameters:

config - Load configuration.

prefix - Prefix for temporary resources.

Returns:

the load DDL

createLocationString

public static java.lang.String createLocationString(java.lang.String[] strings)

Converts string array to greenplum friendly string. From new String[]{"foo","jee"} we get "'foo',jee'".

Parameters:

strings - String array to explode

Returns:

Comma delimited string with values encapsulated with apostropheres. ‘'