C-JDBC: org.objectweb.cjdbc.common.sql.AlterRequest Class Reference

org.objectweb.cjdbc.common.sql.AlterRequest Class Reference

List of all members.

Public Member Functions

AlterRequest (String sqlQuery, boolean escapeProcessing, int timeout, String lineSeparator)

AlterRequest (String sqlQuery, boolean escapeProcessing, int timeout, String lineSeparator, DatabaseSchema schema, int granularity, boolean isCaseSensitive) throws SQLException

boolean

isReadRequest ()

boolean

isWriteRequest ()

boolean

isUnknownRequest ()

void

parse (DatabaseSchema schema, int granularity, boolean isCaseSensitive) throws SQLException

void

cloneParsing (AbstractRequest request)

boolean

isAlter ()

boolean

isCreate ()

boolean

isDelete ()

boolean

isDrop ()

boolean

isInsert ()

boolean

isUpdate ()

DatabaseTable

getDatabaseTable ()

DatabaseColumn

getColumn ()

boolean

isAdd ()

Constructor & Destructor Documentation

org.objectweb.cjdbc.common.sql.AlterRequest.AlterRequest	(	String	sqlQuery,
		boolean	escapeProcessing,
		int	timeout,
		String	lineSeparator
	)

Creates a new AlterRequest instance. The caller must give an SQL request, without any leading or trailing spaces and beginning with 'alter table '

The request is not parsed but it can be done later by a call to parse(DatabaseSchema, int, boolean).

Parameters:

	sqlQuery	the SQL request
	escapeProcessing	should the driver to escape processing before sending to the database ?
	timeout	an `int` value
	lineSeparator	the line separator used in the query

See also:: parse

Definition at line 68 of file AlterRequest.java.

00070   {
00071     super(sqlQuery, escapeProcessing, timeout, lineSeparator);
00072   }

org.objectweb.cjdbc.common.sql.AlterRequest.AlterRequest	(	String	sqlQuery,
		boolean	escapeProcessing,
		int	timeout,
		String	lineSeparator,
		DatabaseSchema	schema,
		int	granularity,
		boolean	isCaseSensitive
	)	throws SQLException

Creates a new AlterRequest instance. The caller must give an SQL request, without any leading or trailing spaces and beginning with 'alter table '

If the syntax is incorrect an exception is thrown.

Parameters:

	sqlQuery	the SQL request
	escapeProcessing	should the driver to escape processing before sending to the database?
	timeout	an `int` value
	lineSeparator	the line separator used in the query
	schema	a `DatabaseSchema` value
	granularity	parsing granularity as defined in `ParsingGranularities`
	isCaseSensitive	true if parsing is case sensitive

Exceptions:

SQLException

if an error occurs

Definition at line 92 of file AlterRequest.java.

References org.objectweb.cjdbc.common.sql.AlterRequest.parse().

00095   {
00096     this(sqlQuery, escapeProcessing, timeout, lineSeparator);
00097     parse(schema, granularity, isCaseSensitive);
00098   }

00219 { 00220 if (!request.isParsed()) 00221 return; 00222 AlterRequest alterRequest = (AlterRequest) request; 00223 cloneTableNameAndColumns((AbstractWriteRequest) request); 00224 table = alterRequest.getDatabaseTable(); 00225 column = alterRequest.getColumn(); 00226 isParsed = true; 00227 }

00130   {
00131     /*
00132      * Example Alter statement: ALTER TABLE table_name ADD column_name datatype
00133      * ALTER TABLE table_name DROP COLUMN column_name
00134      */
00135 
00136     if (granularity == ParsingGranularities.NO_PARSING)
00137     {
00138       isParsed = true;
00139       return;
00140     }
00141 
00142     String originalSQL = this.trimCarriageReturn();
00143     String sql = originalSQL.toLowerCase();
00144 
00145     // Strip 'alter table '
00146     int tableIdx = sql.indexOf("table");
00147     if (tableIdx == -1)
00148       throw new SQLException(
00149           "Malformed Alter Request. Should start with [ALTER TABLE]");
00150     sql = sql.substring(tableIdx + 5).trim();
00151 
00152     // Does the query contain a add?
00153     int addIdx = sql.indexOf(" add ");
00154 
00155     // Does the query contain a drop?
00156     int dropIdx = sql.indexOf(" drop ");
00157 
00158     if (addIdx != -1)
00159       isAdd = true;
00160     if (dropIdx != -1)
00161       isDrop = true;
00162 
00163     if (!isAdd && !isDrop)
00164       throw new SQLException(
00165           "Malformed Alter Request. No drop or add condition");
00166 
00167     if (isCaseSensitive) // Reverse to the original case
00168       sql = originalSQL.substring(originalSQL.length() - sql.length());
00169 
00170     int index = (isAdd) ? addIdx : dropIdx;
00171 
00172     tableName = sql.substring(0, index).trim();
00173     table = new DatabaseTable(tableName);
00174 
00175 
00176     if (granularity > ParsingGranularities.TABLE)
00177     {
00178       
00179 
00180       int subsIndex = index + 6 + 2; // index +
00181                                                                // column.length()
00182                                                                // + space
00183       if (isAdd)
00184         subsIndex += 3;
00185       else
00186         // Drop
00187         subsIndex += 4;
00188       
00189       columns = new ArrayList();
00190       sql = sql.substring(subsIndex).trim();
00191 
00192       if (isAdd)
00193       {
00194         int colIndex = sql.indexOf(' ');
00195         String colName = sql.substring(0, colIndex);
00196 
00197         int uniqueIndex = sql.toLowerCase().indexOf("unique");
00198         int primary = sql.toLowerCase().indexOf("primary");
00199         if (uniqueIndex != -1 || primary != -1)
00200           column = new DatabaseColumn(colName, true);
00201         else
00202           column = new DatabaseColumn(colName, false);
00203         columns.add(new TableColumn(tableName, colName));
00204       }
00205       else if (isDrop)
00206       {
00207         String colName = sql.trim();
00208         column = schema.getTable(tableName).getColumn(colName);
00209         columns.add(new TableColumn(tableName, colName));
00210       }
00211     }
00212     isParsed  = true;
00213   }

org.objectweb.cjdbc.common.sql.AlterRequest Class Reference

Public Member Functions

Detailed Description

Constructor & Destructor Documentation

Member Function Documentation