org.teiid.adminshell

Class GroovySqlExtensions

java.lang.Object

org.teiid.adminshell.GroovySqlExtensions

public class GroovySqlExtensions
extends Object

Extensions of Groovy Sql support, which somewhat bridges the gap to our old adminshell sql logic

Constructor Summary

Constructors

Constructor and Description
GroovySqlExtensions()

Method Summary

Modifier and Type	Method and Description
static TeiidSql	connect()
static TeiidSql	connect(String url)
static TeiidSql	connect(String url, String user, String password)
static String	resultSetMetaDataToString(ResultSetMetaData rsmd)
static String	rowToString(ResultSet results)
static void	sqlHelp()
static void	sqlHelp(String method)

Methods inherited from class java.lang.Object

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

Constructor Detail

GroovySqlExtensions

public GroovySqlExtensions()

Method Detail

connect

@Help.Doc(text="Get a Teiid connection with a URL")
public static TeiidSql connect(@Help.Doc(text="url")
                                                                                   String url)
                                                                            throws SQLException

Throws:

SQLException

connect

@Help.Doc(text="Get a Teiid connection")
public static TeiidSql connect(@Help.Doc(text="url")
                                                                        String url,
                                                                        @Help.Doc(text="user")
                                                                        String user,
                                                                        @Help.Doc(text="password")
                                                                        String password)
                                                                 throws SQLException

Throws:

SQLException

connect

@Help.Doc(text="Get a SQL connection using the defaults from connection.properties")
public static TeiidSql connect()
                                                                                                             throws SQLException

Throws:

SQLException

rowToString

@Help.Doc(text="Alternate row to String method that pretty prints SQL/XML",
          moreText="e.g. sql.eachRow(\"select * from tables\", {row -> println rowToString(row) })")
public static String rowToString(ResultSet results)
                                                                                                                                                                                                           throws SQLException

Throws:

SQLException

resultSetMetaDataToString

@Help.Doc(text="Pretty prints the ResultSetMetadata",
          moreText={"e.g. sql.eachRow(\"select * from tables\", {rsmd -> println resultSetMetaDataToString(rsmd)},","                {row -> println rowToString(row) })"})
public static String resultSetMetaDataToString(ResultSetMetaData rsmd)
                                                                                                                                                                                                                                                                          throws SQLException

Throws:

SQLException

sqlHelp

@Help.Doc(text="Show help for all SQL Extension methods")
public static void sqlHelp()

sqlHelp

@Help.Doc(text="Show help for the given SQL Extension method")
public static void sqlHelp(@Help.Doc(text="method name")
                                                                                          String method)