gudusoft.gsqlparser.util

Class SQLUtil

Object

gudusoft.gsqlparser.util.SQLUtil

public class SQLUtil
extends Object

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	SQLUtil.UnicodeInputStream This inputstream will recognize unicode BOM marks and will skip bytes if getEncoding() method is called before any of the read(...) methods.

Constructor Summary

Constructors

Constructor and Description
SQLUtil()

Method Summary

Modifier and Type	Method and Description
static void	appendToFile(File file, String string)
static boolean	compareIdentifier(EDbVendor dbVendor, ESQLDataObjectType sqlDataObjectType, String identifier1, String identifier2)
static void	deltree(File root)
static String	endTrim(String input)
static void	endTrim(StringBuilder buffer)
static String	getFileContent(File file)
static String	getFileContent(String filePath)
static String	getIdentifierNormalColumnName(EDbVendor dbVendor, String name)
static String	getIdentifierNormalName(EDbVendor dbVendor, String name, ESQLDataObjectType sqlDataObjectType)
static String	getIdentifierNormalTableName(EDbVendor dbVendor, String name)
static String	getIdentifierNormalTableName(String name)
static String	getInputStreamContent(InputStream is, boolean close)
static InputStream	getInputStreamWithoutBom(String file)
static boolean	isEmpty(String value)
static boolean	isTempTable(table table)
static File[]	listFiles(File sqlFiles)
static File[]	listFiles(File sqlFiles, FileFilter filter)
static void	listFiles(File rootFile, List<File> children)
static void	listFiles(File rootFile, List<File> children, FileFilter filter)
static void	main(String[] args)
static String	mergeSegments(List<String> segments, int index)
static String	normalizeIdentifier(EDbVendor dbVendor, ESQLDataObjectType objectType, String identifier)
static List<String>	parseNames(String nameString)
static List<String>	parseNames(String nameString, EDbVendor vendor)
static String	readFile(File file)
static String	stringToMD5(String plainText)
static String	trimColumnStringQuote(String string)
static String	trimSingleQuote(String columnAlias)
static void	writeToFile(File file, InputStream source, boolean close)
static void	writeToFile(File file, String string)

Methods inherited from class Object

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

Constructor Detail

SQLUtil

public SQLUtil()

Method Detail

isEmpty

public static boolean isEmpty(String value)

getFileContent

public static String getFileContent(File file)

getInputStreamContent

public static String getInputStreamContent(InputStream is,
                                           boolean close)

getFileContent

public static String getFileContent(String filePath)

trimColumnStringQuote

public static String trimColumnStringQuote(String string)

parseNames

public static List<String> parseNames(String nameString)

parseNames

public static List<String> parseNames(String nameString,
                                      EDbVendor vendor)

main

public static void main(String[] args)

writeToFile

public static void writeToFile(File file,
                               InputStream source,
                               boolean close)

writeToFile

public static void writeToFile(File file,
                               String string)
                        throws IOException

Throws:

IOException

appendToFile

public static void appendToFile(File file,
                                String string)
                         throws IOException

Throws:

IOException

deltree

public static void deltree(File root)

getInputStreamWithoutBom

public static InputStream getInputStreamWithoutBom(String file)
                                            throws IOException

Parameters:

file - the filePath

Returns:

the UTFFileHandler.UnicodeInputStream

Throws:

IOException

compareIdentifier

public static boolean compareIdentifier(EDbVendor dbVendor,
                                        ESQLDataObjectType sqlDataObjectType,
                                        String identifier1,
                                        String identifier2)

normalizeIdentifier

public static String normalizeIdentifier(EDbVendor dbVendor,
                                         ESQLDataObjectType objectType,
                                         String identifier)

getIdentifierNormalColumnName

public static String getIdentifierNormalColumnName(EDbVendor dbVendor,
                                                   String name)

getIdentifierNormalTableName

public static String getIdentifierNormalTableName(String name)

getIdentifierNormalTableName

public static String getIdentifierNormalTableName(EDbVendor dbVendor,
                                                  String name)

getIdentifierNormalName

public static String getIdentifierNormalName(EDbVendor dbVendor,
                                             String name,
                                             ESQLDataObjectType sqlDataObjectType)

mergeSegments

public static String mergeSegments(List<String> segments,
                                   int index)

isTempTable

public static boolean isTempTable(table table)

listFiles

public static File[] listFiles(File sqlFiles)

listFiles

public static File[] listFiles(File sqlFiles,
                               FileFilter filter)

listFiles

public static void listFiles(File rootFile,
                             List<File> children)

listFiles

public static void listFiles(File rootFile,
                             List<File> children,
                             FileFilter filter)

readFile

public static String readFile(File file)

stringToMD5

public static String stringToMD5(String plainText)

trimSingleQuote

public static String trimSingleQuote(String columnAlias)

endTrim

public static String endTrim(String input)

endTrim

public static void endTrim(StringBuilder buffer)