public class SQLToJUnit
extends java.lang.Object
Modifier and Type | Field and Description |
---|---|
private int |
anonymousCount |
private static int |
AUTOCOMMIT |
private static int |
BLANK_LINE |
private static int |
CALL_STMT |
private static int |
COMMENT |
private static int |
COMMIT |
private static java.lang.String |
CONN_OBJECT_NAME |
private static int |
CONNECT |
private static java.lang.String |
CSTMT_OBJECT_NAME |
private static int |
CURSOR_CLOSE |
private static int |
CURSOR_NEXT |
private static java.lang.String[] |
DDL_NO_RC_COMMANDS |
private static java.lang.String[] |
DDL_RC_COMMANDS |
private static int |
DEFAULT_LEFT_MARGIN |
private static int |
EXEC_DDL_NO_ROW_COUNT |
private static int |
EXEC_DDL_WITH_ROW_COUNT |
private static int |
EXEC_QUERY |
private static int |
GET_CURSOR |
private static java.lang.String |
getWarningLogic |
private boolean |
gotRuntimeStatistics |
private static int |
GRANT |
private static int |
IJ_COMMAND |
private static java.lang.String[] |
IJ_COMMANDS |
private static java.lang.String |
IJ_COMMENT |
private static java.lang.String |
IJ_PROMPT |
private static java.lang.String |
IJ_WARNING |
private java.io.BufferedReader |
ijScript |
private static int |
IWARNING |
private static java.lang.String |
JAVA_COMMENT |
private java.lang.String |
jTestName |
private java.io.BufferedWriter |
junit |
private static java.lang.String |
leftMargin |
private static int |
LINE_LENGTH |
private boolean |
multipleUserConnections |
private int |
numIgnored |
private int |
numUnconverted |
private static int |
P_EXECUTE |
private static int |
PREPARE |
private int |
prevLineType |
private static java.lang.String |
PSTMT_OBJECT_NAME |
private static java.lang.String[] |
QUERY_COMMANDS |
private static int |
REMOVE |
private static int |
REVOKE |
private static int |
ROLLBACK |
private static int |
ROW_COUNT |
private static java.lang.String |
RS_META_OBJECT_NAME |
private static java.lang.String |
RS_OBJECT_NAME |
private static int |
SET_CONNECTION |
private static int |
SET_SCHEMA |
private static int |
SQL_ERROR |
private static java.lang.String |
SQL_WARN_OBJECT_NAME |
private static int |
SQL_WARNING |
private static java.lang.String |
STMT_OBJECT_NAME |
private java.lang.StringBuffer |
tmpBuf |
private static int |
UNKNOWN_LINE |
private static java.lang.String |
USER_NAME |
private java.util.Properties |
userConnections |
private int |
usersConnected |
Constructor and Description |
---|
SQLToJUnit() |
Modifier and Type | Method and Description |
---|---|
private void |
collapseQuotes(java.lang.StringBuffer aLine,
char quote) |
void |
convert(java.lang.String[] args)
Convert .sql test output to JUnit JDBC code.
|
private void |
escapeQuotes(java.lang.StringBuffer aLine) |
private java.lang.String |
extractRowCount(java.lang.StringBuffer sBuf) |
private java.lang.String |
extractSQLState(java.lang.StringBuffer errString)
Extract out the SQLSTATE.
|
private int |
getLineType(java.lang.String str) |
private int |
getLineType(java.lang.StringBuffer sBuf) |
private boolean |
getNextIjCommand(java.lang.StringBuffer aLine)
Return one ij command, or if it's a result set, return the entire result set
in the StringBuffer.
|
private boolean |
haveNonCommand(java.lang.String aLine) |
private boolean |
ignorableLine(int lineType) |
private boolean |
isDDLNoRowCount(java.lang.String str) |
private boolean |
isDDLWithRowCount(java.lang.String str) |
private boolean |
isIjCommand(java.lang.String str) |
private boolean |
isQueryStatement(java.lang.String str) |
private boolean |
loadIJScript(java.lang.String fName) |
static void |
main(java.lang.String[] args) |
private java.lang.StringBuffer |
strip(java.lang.StringBuffer sBuf,
java.lang.String toStrip) |
private java.lang.String |
strip(java.lang.String str,
java.lang.String toStrip) |
private void |
writeAssertDDLCount(java.lang.StringBuffer stmt,
java.lang.StringBuffer ddlCount,
java.lang.String stmtName) |
private void |
writeAssertResultSet(java.lang.StringBuffer rsAsText) |
private void |
writeAssertSQLState(java.lang.String sqlState,
java.lang.String objName) |
private void |
writeAssertWarning(java.lang.StringBuffer warnString) |
private void |
writeFailStatement(java.lang.StringBuffer stmt,
java.lang.String stmtName,
java.lang.StringBuffer result,
boolean compileTime) |
private void |
writeGetCursor(java.lang.StringBuffer stmt,
java.lang.String indent)
Write JDBC code for an ij statement of the form:
get cursor c1 as 'select * from t1'
|
private void |
writeJavaLine(java.lang.StringBuffer lineToWrite,
java.lang.StringBuffer followupLine) |
private void |
writeJDBCCode(java.lang.StringBuffer stmt,
java.lang.StringBuffer result) |
private void |
writeJUnitEOL() |
private void |
writeMaxLenLine(java.lang.StringBuffer aLine,
java.lang.String prefix,
java.lang.String suffix) |
private void |
writePrologue() |
private void |
writeQuotedLine(java.lang.StringBuffer line,
java.lang.String indent) |
private static final int DEFAULT_LEFT_MARGIN
private static java.lang.String leftMargin
private static final java.lang.String IJ_COMMENT
private static final java.lang.String IJ_WARNING
private static final java.lang.String JAVA_COMMENT
private static final java.lang.String RS_META_OBJECT_NAME
private static final java.lang.String RS_OBJECT_NAME
private static final java.lang.String CSTMT_OBJECT_NAME
private static final java.lang.String PSTMT_OBJECT_NAME
private static final java.lang.String SQL_WARN_OBJECT_NAME
private static java.lang.String IJ_PROMPT
private static java.lang.String CONN_OBJECT_NAME
private static java.lang.String STMT_OBJECT_NAME
private static java.lang.String USER_NAME
private static java.lang.String getWarningLogic
private static final java.lang.String[] DDL_NO_RC_COMMANDS
private static final java.lang.String[] DDL_RC_COMMANDS
private static final java.lang.String[] QUERY_COMMANDS
private static final java.lang.String[] IJ_COMMANDS
private static int EXEC_QUERY
private static int EXEC_DDL_NO_ROW_COUNT
private static int EXEC_DDL_WITH_ROW_COUNT
private static int PREPARE
private static int P_EXECUTE
private static int CALL_STMT
private static int COMMENT
private static int AUTOCOMMIT
private static int COMMIT
private static int ROLLBACK
private static int SET_SCHEMA
private static int REMOVE
private static int GRANT
private static int GET_CURSOR
private static int CURSOR_NEXT
private static int CURSOR_CLOSE
private static int CONNECT
private static int SET_CONNECTION
private static int REVOKE
private static int IJ_COMMAND
private static int ROW_COUNT
private static int BLANK_LINE
private static int SQL_ERROR
private static int SQL_WARNING
private static int IWARNING
private static int UNKNOWN_LINE
private static int LINE_LENGTH
private int prevLineType
private java.lang.String jTestName
private java.io.BufferedReader ijScript
private java.io.BufferedWriter junit
private java.lang.StringBuffer tmpBuf
private boolean gotRuntimeStatistics
private int numIgnored
private int numUnconverted
private boolean multipleUserConnections
private java.util.Properties userConnections
private int usersConnected
private int anonymousCount
public static void main(java.lang.String[] args)
public void convert(java.lang.String[] args) throws java.lang.Exception
java.lang.Exception
private boolean loadIJScript(java.lang.String fName) throws java.lang.Exception
java.lang.Exception
private void writeJavaLine(java.lang.StringBuffer lineToWrite, java.lang.StringBuffer followupLine) throws java.lang.Exception
java.lang.Exception
private void writeJDBCCode(java.lang.StringBuffer stmt, java.lang.StringBuffer result) throws java.lang.Exception
java.lang.Exception
private void writeFailStatement(java.lang.StringBuffer stmt, java.lang.String stmtName, java.lang.StringBuffer result, boolean compileTime) throws java.lang.Exception
java.lang.Exception
private void writeAssertDDLCount(java.lang.StringBuffer stmt, java.lang.StringBuffer ddlCount, java.lang.String stmtName) throws java.lang.Exception
java.lang.Exception
private java.lang.String extractRowCount(java.lang.StringBuffer sBuf) throws java.lang.Exception
java.lang.Exception
private void writeGetCursor(java.lang.StringBuffer stmt, java.lang.String indent) throws java.lang.Exception
java.lang.Exception
private void writeMaxLenLine(java.lang.StringBuffer aLine, java.lang.String prefix, java.lang.String suffix) throws java.lang.Exception
java.lang.Exception
private void escapeQuotes(java.lang.StringBuffer aLine)
private void collapseQuotes(java.lang.StringBuffer aLine, char quote)
private java.lang.String strip(java.lang.String str, java.lang.String toStrip)
private java.lang.StringBuffer strip(java.lang.StringBuffer sBuf, java.lang.String toStrip)
private int getLineType(java.lang.StringBuffer sBuf)
private int getLineType(java.lang.String str)
private boolean isDDLWithRowCount(java.lang.String str)
private boolean isDDLNoRowCount(java.lang.String str)
private boolean isQueryStatement(java.lang.String str)
private boolean isIjCommand(java.lang.String str)
private void writeAssertResultSet(java.lang.StringBuffer rsAsText) throws java.lang.Exception
java.lang.Exception
private java.lang.String extractSQLState(java.lang.StringBuffer errString) throws java.lang.Exception
java.lang.Exception
private void writeAssertSQLState(java.lang.String sqlState, java.lang.String objName) throws java.lang.Exception
java.lang.Exception
private void writeAssertWarning(java.lang.StringBuffer warnString) throws java.lang.Exception
java.lang.Exception
private void writeQuotedLine(java.lang.StringBuffer line, java.lang.String indent) throws java.lang.Exception
java.lang.Exception
private void writeJUnitEOL() throws java.io.IOException
java.io.IOException
private boolean getNextIjCommand(java.lang.StringBuffer aLine) throws java.io.IOException
java.io.IOException
private boolean haveNonCommand(java.lang.String aLine)
private boolean ignorableLine(int lineType)
private void writePrologue() throws java.io.IOException
java.io.IOException
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.