CJDBCversion1.0.4: クラス org.objectweb.cjdbc.common.sql.AlterRequest

説明

AlterRequest

バージョン:

1.0

AlterRequest.java の 41 行で定義されています。


Public メソッド
	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 ()
Private 変数
transient DatabaseTable	table = null
transient DatabaseColumn	column = null
transient boolean	isDrop = false
transient boolean	isAdd = false

コンストラクタとデストラクタ

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).

引数:

	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

参照:: parse

AlterRequest.java の 68 行で定義されています。

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.

引数:

	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

例外:

SQLException

if an error occurs

AlterRequest.java の 92 行で定義されています。

参照先 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

説明

Public メソッド

Private 変数

コンストラクタとデストラクタ

メソッド

変数