/*
* Convert a date in the format MM/DD/YYYY to YYYYMMDD
*/
public static String toYMD(String inputDate)
{
String day, month;
FieldTokenizer ft;
String[] ftFields;
ft = new FieldTokenizer(inputDate, '/', false);
ftFields = ft.getFields();
if (ftFields.Length == 1)
{
return(inputDate);
}
else if (ftFields.Length == 3)
{
month = ftFields[0];
if (month.length() == 1)
{
month = "0" + month;
}
day = ftFields[1];
if (day.length() == 1)
{
day = "0" + day;
}
return(ftFields[2] + month + day);
}
return(inputDate);
}
public static void readLongNames(String inputDataDir)
{
String fullPath, longNameRecord;
String[] fields;
FieldTokenizer ft;
java.io.File longColumnNameFile;
dataDir = inputDataDir;
java.io.BufferedReader longNameReader = (java.io.BufferedReader)null;
fullPath = dataDir + fileSep + "TINYSQL_LONG_COLUMN_NAMES.dat";
longColumnNames = new java.util.Vector <Object>();
longColumnNameFile = new java.io.File(fullPath);
if (longColumnNameFile.exists())
{
try
{
longNameReader = new java.io.BufferedReader(new java.io.FileReader(fullPath));
while ((longNameRecord = longNameReader.readLine()) != null)
{
ft = new FieldTokenizer(longNameRecord, '|', false);
fields = ft.getFields();
longColumnNames.addElement(fields[0]);
longColumnNames.addElement(fields[1]);
}
longNameReader.close();
longNamesInFileCount = longColumnNames.size() / 2;
if (debug)
{
java.lang.SystemJ.outJ.println("Long Names read: " + longNamesInFileCount);
}
}
catch (Exception readEx)
{
java.lang.SystemJ.outJ.println("Reader exception " + readEx.getMessage());
longNamesInFileCount = 0;
}
}
}
/*
* This method evaluates the value of functions. This step must be kept
* separate from the update of individual columns to prevent evaluation
* of summary functions such as COUNT and SUM more than once, or when
* the row being processed will ultimately fail a where clause condition.
*/
public void updateFunctions()
//throws tinySQLException
{
int i, startAt, charCount, day, monthAt, month, year;
TsColumn argColumn;
java.lang.StringBuffer concatBuffer;
FieldTokenizer ft;
String[] ftFields;
String months = "-JAN-FEB-MAR-APR-MAY-JUN-JUL-AUG-SEP-OCT-NOV-DEC-",
monthName, dayField, monthField, yearField;
if (isConstant)
{
return;
}
if (functionName == (String)null)
{
return;
}
if (functionName.equals("CONCAT"))
{
concatBuffer = new java.lang.StringBuffer();
for (i = 0; i < functionArgs.size(); i++)
{
argColumn = (TsColumn)functionArgs.elementAt(i);
argColumn.updateFunctions();
if (argColumn.isValueSet())
{
valueSet = true;
}
if (argColumn.notNull)
{
concatBuffer.append(argColumn.getString());
notNull = true;
}
}
stringValue = concatBuffer.toString();
}
else if (functionName.equals("UPPER"))
{
argColumn = (TsColumn)functionArgs.elementAt(0);
argColumn.updateFunctions();
if (argColumn.isValueSet())
{
valueSet = true;
}
if (argColumn.notNull)
{
stringValue = argColumn.getString().toUpperCase();
notNull = true;
}
}
else if (functionName.equals("TRIM"))
{
argColumn = (TsColumn)functionArgs.elementAt(0);
argColumn.updateFunctions();
if (argColumn.isValueSet())
{
valueSet = true;
}
if (argColumn.notNull)
{
stringValue = argColumn.getString().trim();
notNull = true;
}
}
else if (functionName.equals("SUBSTR"))
{
if (functionArgs.size() != 3)
{
throw new TinySQLException("Wrong number of arguments for SUBSTR");
}
argColumn = (TsColumn)functionArgs.elementAt(1);
startAt = argColumn.intValue;
argColumn = (TsColumn)functionArgs.elementAt(2);
charCount = argColumn.intValue;
argColumn = (TsColumn)functionArgs.elementAt(0);
argColumn.updateFunctions();
if (argColumn.isValueSet())
{
valueSet = true;
}
if (argColumn.notNull)
{
stringValue = argColumn.stringValue;
if (startAt < stringValue.length() - 1 & charCount > 0)
{
stringValue = stringValue.substring(startAt - 1, startAt + charCount - 1);
notNull = true;
}
else
{
stringValue = (String)null;
}
}
}
else if (functionName.equals("COUNT"))
{
argColumn = (TsColumn)functionArgs.elementAt(0);
argColumn.updateFunctions();
/*
* The COUNT function always returns a not null value
*/
notNull = true;
valueSet = true;
if (intValue == java.lang.Integer.MIN_VALUE)
{
intValue = 0;
}
else
{
intValue = intValue + 1;
}
}
else if (functionName.equals("TO_DATE"))
{
/*
* Validate the TO_DATE argument
*/
argColumn = (TsColumn)functionArgs.elementAt(0);
argColumn.updateFunctions();
if (argColumn.isValueSet())
{
valueSet = true;
}
type = java.sql.Types.DATE;
size = 10;
if (argColumn.notNull)
{
stringValue = argColumn.getString().trim();
ft = new FieldTokenizer(stringValue, '-', false);
ftFields = ft.getFields();
if (ftFields.Length < 3)
{
throw new TinySQLException(stringValue + " is not a date with "
+ "format DD-MON-YY!");
}
else
{
try
{
day = java.lang.Integer.parseInt(ftFields[0]);
if (day < 1 | day > 31)
{
throw new TinySQLException(stringValue + " day not "
+ "between 1 and 31.");
}
monthName = ftFields[1].toUpperCase();
monthAt = months.indexOf("-" + monthName + "-");
if (monthAt == -1)
{
throw new TinySQLException(stringValue + " month not "
+ "recognized.");
}
month = (monthAt + 4) / 4;
year = java.lang.Integer.parseInt(ftFields[2]);
if (year < 0 | year > 2100)
{
throw new TinySQLException(stringValue + " year not "
+ "recognized.");
}
/*
* Assume that years < 50 are in the 21st century, otherwise
* the 20th.
*/
if (year < 50)
{
year = 2000 + year;
}
else if (year < 100)
{
year = 1900 + year;
}
dayField = java.lang.Integer.toString(day);
if (dayField.length() < 2)
{
dayField = "0" + dayField;
}
monthField = java.lang.Integer.toString(month);
if (monthField.length() < 2)
{
monthField = "0" + monthField;
}
yearField = java.lang.Integer.toString(year);
stringValue = yearField + "-" + monthField + "-" + dayField;
}
catch (Exception dayEx)
{
throw new TinySQLException(stringValue + " exception "
+ dayEx.getMessage());
}
}
notNull = true;
}
}
else if (functionName.equals("SUM"))
{
argColumn = (TsColumn)functionArgs.elementAt(0);
argColumn.updateFunctions();
if (argColumn.isValueSet())
{
valueSet = true;
}
if (argColumn.type == java.sql.Types.CHAR | argColumn.type == java.sql.Types.DATE)
{
throw new TinySQLException(argColumn.name + " is not numeric!");
}
if (argColumn.notNull)
{
notNull = true;
if (floatValue == java.lang.Float.MIN_VALUE)
{
floatValue = (float)0.0;
}
else
{
if (argColumn.type == java.sql.Types.INTEGER)
{
floatValue += new java.lang.Integer(argColumn.intValue).floatValue();
}
else
{
floatValue += argColumn.floatValue;
}
}
}
}
else if (functionName.equals("MAX") | functionName.equals("MIN"))
{
argColumn = (TsColumn)functionArgs.elementAt(0);
argColumn.updateFunctions();
if (argColumn.isValueSet())
{
valueSet = true;
}
if (argColumn.notNull)
{
notNull = true;
if (argColumn.type == java.sql.Types.CHAR | argColumn.type == java.sql.Types.DATE)
{
if (stringValue == null)
{
stringValue = argColumn.stringValue;
}
else
{
/*
* Update the max and min based upon string comparisions.
*/
if (functionName.equals("MAX") &
(argColumn.stringValue.compareTo(stringValue) > 0))
{
stringValue = argColumn.stringValue;
}
else if (functionName.equals("MIN") &
(argColumn.stringValue.compareTo(stringValue) < 0))
{
stringValue = argColumn.stringValue;
}
}
}
else if (argColumn.type == java.sql.Types.INTEGER)
{
/*
* Update max and min based upon numeric values.
*/
if (intValue == java.lang.Integer.MIN_VALUE)
{
intValue = argColumn.intValue;
}
else
{
if (functionName.equals("MIN") &
argColumn.intValue < intValue)
{
intValue = argColumn.intValue;
}
else if (functionName.equals("MAX") &
argColumn.intValue > intValue)
{
intValue = argColumn.intValue;
}
}
}
else if (argColumn.type == java.sql.Types.FLOAT)
{
if (floatValue == java.lang.Float.MIN_VALUE)
{
floatValue = argColumn.floatValue;
}
else
{
if (functionName.equals("MIN") &
argColumn.floatValue < floatValue)
{
floatValue = argColumn.floatValue;
}
else if (functionName.equals("MAX") &
argColumn.floatValue > floatValue)
{
floatValue = argColumn.floatValue;
}
}
}
}
}
}
public static void main(String[] args) //throws IOException,SQLException
{
java.sql.DatabaseMetaData dbMeta;
java.sql.ResultSetMetaData meta;
java.sql.ResultSet display_rs, typesRS;
java.io.BufferedReader stdin, loadFileReader;
java.io.BufferedReader startReader = (java.io.BufferedReader)null;
String[] fields;
java.sql.Connection con;
java.sql.Statement stmt;
FieldTokenizer ft;
java.sql.PreparedStatement pstmt = (java.sql.PreparedStatement)null;
int i, rsColCount, endAt, colWidth, colScale, colPrecision, typeCount,
colType, parameterIndex, b1, b2, parameterInt, startAt, columnIndex, valueIndex;
String fName, tableName = null, inputString, cmdString, colTypeName, dbType,
parameterString, loadString, fieldString, readString;
java.lang.StringBuffer lineOut, prepareBuffer, valuesBuffer, inputBuffer;
bool echo = false;
stdin = new java.io.BufferedReader(new java.io.InputStreamReader(java.lang.SystemJ.inJ));
try
{
/*
* Register the JDBC driver for dBase
*/
java.lang.Class.forName("com.sqlmagic.tinysql.dbfFileDriver");
}
catch (java.lang.ClassNotFoundException e)
{
java.lang.SystemJ.err.println(
"JDBC Driver could not be registered!!\n");
if (TinySQLGlobals.DEBUG)
{
e.printStackTrace();
}
}
fName = ".";
if (args.Length > 0)
{
fName = args[0];
}
/*
* Establish a connection to dBase
*/
con = dbConnect(fName);
if (con == (java.sql.Connection)null)
{
fName = ".";
con = dbConnect(fName);
}
dbMeta = con.getMetaData();
dbType = dbMeta.getDatabaseProductName();
dbVersion = dbMeta.getDatabaseProductVersion();
java.lang.SystemJ.outJ.println("===================================================");
java.lang.SystemJ.outJ.println(dbType + " Command line interface version "
+ dbVersion + " Java version released March 15, 2007");
java.lang.SystemJ.outJ.println("Type HELP to get information on available commands.");
cmdString = "NULL";
stmt = con.createStatement();
inputString = (String)null;
if (args.Length > 1)
{
inputString = args[1].trim();
}
while (!cmdString.toUpperCase().equals("EXIT"))
{
try
{
if (startReader != (java.io.BufferedReader)null)
{
/*
* Command START files can contain comments and can have
* commands broken over several lines. However, they
* cannot have partial commands on a line.
*/
inputBuffer = new java.lang.StringBuffer();
inputString = (String)null;
while ((readString = startReader.readLine()) != null)
{
if (readString.startsWith("--") |
readString.startsWith("#"))
{
continue;
}
inputBuffer.append(readString + " ");
/*
* A field tokenizer must be used to avoid problems with
* semi-colons inside quoted strings.
*/
ft = new FieldTokenizer(inputBuffer.toString(), ';', true);
if (ft.countFields() > 1)
{
inputString = inputBuffer.toString();
break;
}
}
if (inputString == (String)null)
{
startReader = (java.io.BufferedReader)null;
continue;
}
}
else if (args.Length == 0)
{
java.lang.SystemJ.outJ.print("tinySQL>");
inputString = stdin.readLine().trim();
}
if (inputString == (String)null)
{
break;
}
if (inputString.toUpperCase().startsWith("EXIT") |
inputString.toUpperCase().startsWith("QUIT"))
{
break;
}
startAt = 0;
while (startAt < inputString.length() - 1)
{
endAt = inputString.indexOf(";", startAt);
if (endAt == -1)
{
endAt = inputString.length();
}
cmdString = inputString.substring(startAt, endAt);
if (echo)
{
java.lang.SystemJ.outJ.println(cmdString);
}
startAt = endAt + 1;
if (cmdString.toUpperCase().startsWith("SELECT"))
{
display_rs = stmt.executeQuery(cmdString);
if (display_rs == (java.sql.ResultSet)null)
{
java.lang.SystemJ.outJ.println("Null ResultSet returned from query");
continue;
}
meta = display_rs.getMetaData();
/*
* The actual number of columns retrieved has to be checked
*/
rsColCount = meta.getColumnCount();
lineOut = new java.lang.StringBuffer(100);
int[] columnWidths = new int[rsColCount];
int[] columnScales = new int[rsColCount];
int[] columnPrecisions = new int[rsColCount];
int[] columnTypes = new int[rsColCount];
String[] columnNames = new String[rsColCount];
for (i = 0; i < rsColCount; i++)
{
columnNames[i] = meta.getColumnName(i + 1);
columnWidths[i] = meta.getColumnDisplaySize(i + 1);
columnTypes[i] = meta.getColumnType(i + 1);
columnScales[i] = meta.getScale(i + 1);
columnPrecisions[i] = meta.getPrecision(i + 1);
if (columnNames[i].length() > columnWidths[i])
{
columnWidths[i] = columnNames[i].length();
}
lineOut.append(padString(columnNames[i], columnWidths[i]) + " ");
}
if (TinySQLGlobals.DEBUG)
{
java.lang.SystemJ.outJ.println(lineOut.toString());
}
displayResults(display_rs);
}
else if (cmdString.toUpperCase().startsWith("CONNECT"))
{
con = dbConnect(cmdString.substring(8, cmdString.length()));
}
else if (cmdString.toUpperCase().startsWith("HELP"))
{
helpMsg(cmdString);
}
else if (cmdString.toUpperCase().startsWith("DESCRIBE"))
{
dbMeta = con.getMetaData();
tableName = cmdString.toUpperCase().substring(9);
display_rs = dbMeta.getColumns(null, null, tableName, null);
java.lang.SystemJ.outJ.println("\nColumns for table " + tableName + "\n"
+ "Name Type");
while (display_rs.next())
{
lineOut = new java.lang.StringBuffer(100);
lineOut.append(padString(display_rs.getString(4), 32));
colTypeName = display_rs.getString(6);
colType = display_rs.getInt(5);
colWidth = display_rs.getInt(7);
colScale = display_rs.getInt(9);
colPrecision = display_rs.getInt(10);
if (colTypeName.equals("CHAR"))
{
colTypeName = colTypeName + "("
+ java.lang.Integer.toString(colWidth) + ")";
}
else if (colTypeName.equals("FLOAT"))
{
colTypeName += "(" + java.lang.Integer.toString(colPrecision)
+ "," + java.lang.Integer.toString(colScale) + ")";
}
lineOut.append(padString(colTypeName, 20) + padString(colType, 12));
java.lang.SystemJ.outJ.println(lineOut.toString());
}
}
else if (cmdString.toUpperCase().equals("SHOW TABLES"))
{
for (i = 0; i < tableList.size(); i++)
{
java.lang.SystemJ.outJ.println((String)tableList.elementAt(i));
}
}
else if (cmdString.toUpperCase().equals("SHOW TYPES"))
{
typesRS = dbMeta.getTypeInfo();
typeCount = displayResults(typesRS);
}
else if (cmdString.toUpperCase().startsWith("SET "))
{
/*
* Support for SET DEBUG ON/OFF and SET ECHO ON/OFF
*/
ft = new FieldTokenizer(cmdString.toUpperCase(), ' ', false);
fields = ft.getFields();
if (fields[1].equals("ECHO"))
{
if (fields[2].equals("ON"))
{
echo = true;
}
else
{
echo = false;
}
}
else if (fields[1].equals("DEBUG"))
{
if (fields[2].equals("ON"))
{
TinySQLGlobals.DEBUG = true;
}
else
{
TinySQLGlobals.DEBUG = false;
}
}
else if (fields[1].equals("PARSER_DEBUG"))
{
if (fields[2].equals("ON"))
{
TinySQLGlobals.PARSER_DEBUG = true;
}
else
{
TinySQLGlobals.PARSER_DEBUG = false;
}
}
else if (fields[1].equals("WHERE_DEBUG"))
{
if (fields[2].equals("ON"))
{
TinySQLGlobals.WHERE_DEBUG = true;
}
else
{
TinySQLGlobals.WHERE_DEBUG = false;
}
}
else if (fields[1].equals("EX_DEBUG"))
{
if (fields[2].equals("ON"))
{
TinySQLGlobals.EX_DEBUG = true;
}
else
{
TinySQLGlobals.EX_DEBUG = false;
}
}
}
else if (cmdString.toUpperCase().startsWith("SPOOL "))
{
/*
* Spool output to a file.
*/
ft = new FieldTokenizer(cmdString, ' ', false);
fName = ft.getField(1);
if (fName.equals("OFF"))
{
try
{
spoolFileWriter.close();
}
catch (Exception spoolEx)
{
java.lang.SystemJ.outJ.println("Unable to close spool file "
+ spoolEx.getMessage() + newLine);
}
}
else
{
try
{
spoolFileWriter = new java.io.FileWriter(fName);
if (spoolFileWriter != (java.io.FileWriter)null)
{
java.lang.SystemJ.outJ.println("Output spooled to " + fName);
}
}
catch (Exception spoolEx)
{
java.lang.SystemJ.outJ.println("Unable to spool to file "
+ spoolEx.getMessage() + newLine);
}
}
}
else if (cmdString.toUpperCase().startsWith("START "))
{
ft = new FieldTokenizer(cmdString, ' ', false);
fName = ft.getField(1);
if (!fName.toUpperCase().endsWith(".SQL"))
{
fName += ".SQL";
}
try
{
startReader = new java.io.BufferedReader(new java.io.FileReader(fName));
}
catch (Exception)
{
startReader = (java.io.BufferedReader)null;
throw new TinySQLException("No such file: " + fName);
}
}
else if (cmdString.toUpperCase().startsWith("LOAD"))
{
ft = new FieldTokenizer(cmdString, ' ', false);
fName = ft.getField(1);
tableName = ft.getField(3);
display_rs = stmt.executeQuery("SELECT * FROM " + tableName);
meta = display_rs.getMetaData();
rsColCount = meta.getColumnCount();
/*
* Set up the PreparedStatement for the inserts
*/
prepareBuffer = new java.lang.StringBuffer("INSERT INTO " + tableName);
valuesBuffer = new java.lang.StringBuffer(" VALUES");
for (i = 0; i < rsColCount; i++)
{
if (i == 0)
{
prepareBuffer.append(" (");
valuesBuffer.append(" (");
}
else
{
prepareBuffer.append(",");
valuesBuffer.append(",");
}
prepareBuffer.append(meta.getColumnName(i + 1));
valuesBuffer.append("?");
}
prepareBuffer.append(")" + valuesBuffer.toString() + ")");
try
{
pstmt = con.prepareStatement(prepareBuffer.toString());
loadFileReader = new java.io.BufferedReader(new java.io.FileReader(fName));
while ((loadString = loadFileReader.readLine()) != null)
{
if (loadString.toUpperCase().equals("ENDOFDATA"))
{
break;
}
columnIndex = 0;
valueIndex = 0;
ft = new FieldTokenizer(loadString, '|', true);
while (ft.hasMoreFields())
{
fieldString = ft.nextField();
if (fieldString.equals("|"))
{
columnIndex++;
if (columnIndex > valueIndex)
{
pstmt.setString(valueIndex + 1, (String)null);
valueIndex++;
}
}
else if (columnIndex < rsColCount)
{
pstmt.setString(valueIndex + 1, fieldString);
valueIndex++;
}
}
pstmt.executeUpdate();
}
pstmt.close();
}
catch (Exception loadEx)
{
java.lang.SystemJ.outJ.println(loadEx.getMessage());
}
}
else if (cmdString.toUpperCase().startsWith("SETSTRING") |
cmdString.toUpperCase().startsWith("SETINT"))
{
b1 = cmdString.indexOf(" ");
b2 = cmdString.lastIndexOf(" ");
if (b2 > b1 & b1 > 0)
{
parameterIndex = java.lang.Integer.parseInt(cmdString.substring(b1 + 1, b2));
parameterString = cmdString.substring(b2 + 1);
if (TinySQLGlobals.DEBUG)
{
java.lang.SystemJ.outJ.println("Set parameter["
+ parameterIndex + "]=" + parameterString);
}
if (cmdString.toUpperCase().startsWith("SETINT"))
{
parameterInt = java.lang.Integer.parseInt(parameterString);
pstmt.setInt(parameterIndex, parameterInt);
}
else
{
pstmt.setString(parameterIndex, parameterString);
}
if (parameterIndex == 2)
{
pstmt.executeUpdate();
}
}
}
else
{
if (cmdString.indexOf("?") > -1)
{
pstmt = con.prepareStatement(cmdString);
}
else
{
try
{
stmt.executeUpdate(cmdString);
java.lang.SystemJ.outJ.println("DONE\n");
}
catch (java.lang.Exception upex)
{
java.lang.SystemJ.outJ.println(upex.getMessage());
if (TinySQLGlobals.DEBUG)
{
upex.printStackTrace();
}
}
}
}
}
if (args.Length > 1)
{
cmdString = "EXIT";
}
}
catch (java.sql.SQLException te)
{
java.lang.SystemJ.outJ.println(te.getMessage());
if (TinySQLGlobals.DEBUG)
{
te.printStackTrace(java.lang.SystemJ.outJ);
}
inputString = (String)null;
}
catch (Exception e)
{
java.lang.SystemJ.outJ.println(e.getMessage());
cmdString = "EXIT";
break;
}
}
try
{
if (spoolFileWriter != (java.io.FileWriter)null)
{
spoolFileWriter.close();
}
}
catch (Exception spoolEx)
{
java.lang.SystemJ.outJ.println("Unable to close spool file "
+ spoolEx.getMessage() + newLine);
}
}
/*
* Convert a date string in the format DD-MON-YY, DD-MON-YYYY, or YYYYMMDD
* to the output YYYYMMDD after checking the validity of all subfields.
* A tinySQLException is thrown if there are problems.
*/
public static String dateValue(String inputString) //throws tinySQLException
{
String months = "-JAN-FEB-MAR-APR-MAY-JUN-JUL-AUG-SEP-OCT-NOV-DEC-";
int[] daysInMonth = { 31, 29, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 };
String dateString, dayField, monthName, monthField, yearField;
String[] ftFields;
FieldTokenizer ft;
int year, month, day, monthAt;
dateString = inputString.toUpperCase().trim();
if (dateString.length() < 8)
{
throw new TinySQLException(dateString + " is less than 8 characters.");
}
/*
* Check for YYYY-MM-DD format - convert to YYYYMMDD if found.
*/
if (dateString.length() == 10 & dateString.charAt(4) == '-' &
dateString.charAt(7) == '-')
{
dateString = dateString.substring(0, 4) + dateString.substring(5, 7)
+ dateString.substring(8, 10);
}
/*
* First check for an 8 character field properly formatted.
*/
if (dateString.length() == 8 & isInteger(dateString))
{
try
{
year = java.lang.Integer.parseInt(dateString.substring(0, 4));
if (year < 0 | year > 2100)
{
throw new TinySQLException(dateString + " year not "
+ "recognized.");
}
month = java.lang.Integer.parseInt(dateString.substring(4, 6));
if (month < 1 | month > 12)
{
throw new TinySQLException(dateString + " month not "
+ "recognized.");
}
day = java.lang.Integer.parseInt(dateString.substring(6, 8));
if (day <1 | day> daysInMonth[month - 1])
{
throw new TinySQLException(dateString + " day not "
+ "recognized.");
}
return(dateString);
}
catch (Exception dateEx)
{
throw new TinySQLException(dateEx.getMessage());
}
}
/*
* Check for dd-MON-YY formats - strip off TO_DATE if it exists.
*/
if (dateString.startsWith("TO_DATE"))
{
dateString = dateString.substring(8, dateString.length() - 1);
dateString = removeQuotes(dateString);
}
ft = new FieldTokenizer(dateString, '-', false);
ftFields = ft.getFields();
if (ftFields.Length < 3)
{
throw new TinySQLException(dateString + " is not a date with "
+ "format DD-MON-YY!");
}
else
{
try
{
day = java.lang.Integer.parseInt(ftFields[0]);
monthName = ftFields[1];
monthAt = months.indexOf("-" + monthName + "-");
if (monthAt == -1)
{
throw new TinySQLException(dateString + " month not "
+ "recognized.");
}
month = (monthAt + 4) / 4;
if (day <1 | day> daysInMonth[month - 1])
{
throw new TinySQLException(dateString + " day not "
+ "between 1 and " + daysInMonth[month - 1]);
}
year = java.lang.Integer.parseInt(ftFields[2]);
if (year < 0 | year > 2100)
{
throw new TinySQLException(dateString + " year not "
+ "recognized.");
}
/*
* Assume that years < 50 are in the 21st century, otherwise
* the 20th.
*/
if (year < 50)
{
year = 2000 + year;
}
else
{
year = 1900 + year;
}
dayField = java.lang.Integer.toString(day);
if (dayField.length() < 2)
{
dayField = "0" + dayField;
}
monthField = java.lang.Integer.toString(month);
if (monthField.length() < 2)
{
monthField = "0" + monthField;
}
yearField = java.lang.Integer.toString(year);
return(yearField + monthField + dayField);
}
catch (Exception dayEx)
{
throw new TinySQLException(dateString + " exception "
+ dayEx.getMessage());
}
}
}
/*
* The constructor builds a Where clause object from the input string.
*/
public TinySQLWhere(String whereString, java.util.Hashtable <Object, Object> tableDefs)
//throws tinySQLException
{
FieldTokenizer ft;
java.util.Vector <Object> whereConditions;
TsColumn leftColumn, rightColumn;
Object whereObj;
java.lang.StringBuffer fieldBuffer;
String nextField, upperField, wherePhrase, comp, left, right, andOr, lastWord;
java.util.Vector <Object> whereCondition;
String[] comparisons = { "<=", "=<", ">=", "=>", "=", "<>", "!=", ">", "<",
"LIKE", "NOT LIKE", "IS" };
String[] fields, keepFields;
bool inBrackets = false, foundFunction = false;
int i, j, foundKeyWord, foundComp, startAt, foundAnd, foundOr, keepCount;
/*
* The whereClauseList is a Vector containing pointers to whereCondition
* Vectors or tinySQLWhere objects.
*/
whereConditions = new java.util.Vector <Object>();
whereClauseList = new java.util.Vector <Object>();
/*
* Identify any phrases that are contained within brackets. Note that
* the FieldTokenizer will catch function definitions as well as
* subPhrases so there has to be additional logic to reconstruct
* the functions.
*/
ft = new FieldTokenizer(whereString, '(', true);
fields = ft.getFields();
keepFields = new String[fields.Length];
lastWord = "NULL";
fieldBuffer = new java.lang.StringBuffer();
foundFunction = false;
keepCount = 0;
for (i = 0; i < fields.Length; i++)
{
keepFields[i] = "";
if (fields[i].equals("("))
{
/*
* If this is a known function reconstruct the function definition
* and save the entire string.
*/
foundFunction = Utils.isFunctionName(lastWord);
if (foundFunction)
{
fieldBuffer.append("(");
}
else
{
if (fieldBuffer.length() > 0)
{
keepFields[keepCount] = fieldBuffer.toString();
keepCount++;
fieldBuffer.delete(0, fieldBuffer.length());
}
keepFields[keepCount] = "(";
keepCount++;
}
}
else if (fields[i].equals(")"))
{
if (foundFunction)
{
fieldBuffer.append(") ");
foundFunction = false;
}
else
{
if (fieldBuffer.length() > 0)
{
keepFields[keepCount] = fieldBuffer.toString();
keepCount++;
fieldBuffer.delete(0, fieldBuffer.length());
}
keepFields[keepCount] = ")";
keepCount++;
}
}
else
{
fieldBuffer.append(fields[i]);
}
lastWord = fields[i].substring(fields[i].lastIndexOf(" ") + 1);
}
/*
* Keep last subPhrase
*/
if (fieldBuffer.length() > 0)
{
keepFields[keepCount] = fieldBuffer.toString();
keepCount++;
}
for (i = 0; i < keepCount; i++)
{
if (TinySQLGlobals.WHERE_DEBUG)
{
java.lang.SystemJ.outJ.println("keepFields[" + i + "]=" + keepFields[i]);
}
nextField = keepFields[i];
upperField = nextField.toUpperCase();
if (nextField.equals("("))
{
whereObj = (Object)null;
inBrackets = true;
}
else if (nextField.equals(")"))
{
inBrackets = false;
whereObj = (Object)null;
}
else if (inBrackets)
{
whereObj = new TinySQLWhere(nextField, tableDefs);
whereConditions.addElement(whereObj);
}
else
{
/*
* Look for AND/OR keywords - if none are found process the
* entire string.
*/
andOr = "AND";
startAt = 0;
while (startAt < upperField.length())
{
if (upperField.startsWith("AND "))
{
foundAnd = 0;
}
else
{
foundAnd = upperField.indexOf(" AND", startAt);
/*
* Make sure this is not just part of a longer string.
*/
if (foundAnd > -1 & foundAnd < upperField.length() - 4)
{
if (upperField.charAt(foundAnd + 4) != ' ')
{
foundAnd = -1;
}
}
}
if (upperField.startsWith("OR "))
{
foundOr = 0;
}
else
{
foundOr = upperField.indexOf(" OR", startAt);
if (foundOr > -1 & foundOr < upperField.length() - 3)
{
if (upperField.charAt(foundOr + 3) != ' ')
{
foundOr = -1;
}
}
}
foundKeyWord = upperField.length();
if (foundAnd > -1)
{
foundKeyWord = foundAnd;
}
if (foundOr > -1 & foundOr < foundKeyWord)
{
foundKeyWord = foundOr;
andOr = "OR";
}
if (foundKeyWord == 0)
{
startAt = andOr.length() + 1;
foundKeyWord = upperField.length();
}
wherePhrase = nextField.substring(startAt, foundKeyWord);
if (TinySQLGlobals.WHERE_DEBUG)
{
java.lang.SystemJ.outJ.println("Where phrase is " + wherePhrase);
}
if (foundKeyWord < upperField.length() - 4)
{
andOr = upperField.substring(foundKeyWord + 1, foundKeyWord + 3);
}
/*
* Build a whereCondition Vector. The elements are
* as follows:
* 0 - left column object
* 1 - comparison
* 2 - right column object
* 3 - status
*
* The status values indicate which parts of the where
* condition have been set.
*/
whereCondition = new java.util.Vector <Object>();
for (j = 0; j < comparisons.Length; j++)
{
comp = comparisons[j];
foundComp = wherePhrase.toUpperCase().indexOf(comp);
if (foundComp > -1)
{
left = wherePhrase.substring(0, foundComp).trim();
leftColumn = new TsColumn(left, tableDefs, "WHERE");
whereCondition.addElement(leftColumn);
whereCondition.addElement(comp);
right = wherePhrase.substring(foundComp + comp.length()).trim();
if (comp.equals("IS"))
{
right = "'" + right.toUpperCase() + "'";
}
rightColumn = new TsColumn(right, tableDefs, "WHERE");
whereCondition.addElement(rightColumn);
if (leftColumn.isConstant & rightColumn.isConstant)
{
whereCondition.addElement("BOTH");
}
else if (leftColumn.isConstant)
{
whereCondition.addElement("LEFT");
}
else if (rightColumn.isConstant)
{
whereCondition.addElement("RIGHT");
}
else
{
whereCondition.addElement("UNKNOWN");
}
break;
}
}
whereConditions.addElement(whereCondition);
/*
* If this condition and the previous one are joined by an
* AND keyword, add the condition to the existing Vector.
* For an OR keyword, create a new entry in the whereClauseList.
*/
if (andOr.equals("OR"))
{
whereClauseList.addElement(whereConditions);
whereConditions = new java.util.Vector <Object>();
}
startAt = foundKeyWord + andOr.length() + 2;
}
}
}
/*
* Add the last where condition to the list.
*/
if (whereConditions.size() > 0)
{
whereClauseList.addElement(whereConditions);
}
if (TinySQLGlobals.WHERE_DEBUG)
{
java.lang.SystemJ.outJ.println("Where clause is \n" + toString());
}
}
