/**
* Returns an object with the following fields:
*
* <p>name: The name of the column orgname: The original name if an alias was specified table: The
* name of the table orgtable: The original name if an alias was specified def: default value for
* this field, represented as a string max_length: The maximum width of the field for the result
* set flags: An integer representing the bit-flags for the field type: An integer respresenting
* the data type used for this field decimals: The number of decimals used (for integer fields)
*
* @param env the PHP executing environment
* @param fieldLength the field length as defined in the table declaration.
* @param name the field name
* @param originalName the field original name
* @param table the field table name
* @param type the field type
* @param scale the field scale
* @return an object containing field metadata
*/
protected Value fetchFieldImproved(
Env env,
int fieldLength,
String name,
String originalName,
String table,
int jdbcType,
String mysqlType,
int scale) {
Value result = env.createObject();
try {
ResultSetMetaData md = getMetaData();
if (!_rs.next()) return BooleanValue.FALSE;
result.putField(env, "name", env.createString(name));
result.putField(env, "orgname", env.createString(originalName));
result.putField(env, "table", env.createString(table));
// XXX: orgtable same as table
result.putField(env, "orgtable", env.createString(table));
result.putField(env, "def", env.createString(_rs.getString(6)));
// "max_length" is the maximum width of this field in this
// result set.
result.putField(env, "max_length", LongValue.ZERO);
// "length" is the width of the field defined in the table
// declaration.
result.putField(env, "length", LongValue.create(fieldLength));
// generate flags
long flags = 0;
if (!isInResultString(4, "YES")) flags += MysqliModule.NOT_NULL_FLAG;
if (isInResultString(5, "PRI")) {
flags += MysqliModule.PRI_KEY_FLAG;
flags += MysqliModule.PART_KEY_FLAG;
}
if (isInResultString(5, "MUL")) {
flags += MysqliModule.MULTIPLE_KEY_FLAG;
flags += MysqliModule.PART_KEY_FLAG;
}
if (isInResultString(2, "blob")
|| (jdbcType == Types.LONGVARCHAR)
|| (jdbcType == Types.LONGVARBINARY)) flags += MysqliModule.BLOB_FLAG;
if (isInResultString(2, "unsigned")) flags += MysqliModule.UNSIGNED_FLAG;
if (isInResultString(2, "zerofill")) flags += MysqliModule.ZEROFILL_FLAG;
// php/1f73 - null check
if (isInResultString(3, "bin")
|| (jdbcType == Types.LONGVARBINARY)
|| (jdbcType == Types.DATE)
|| (jdbcType == Types.TIMESTAMP)) flags += MysqliModule.BINARY_FLAG;
if (isInResultString(2, "enum")) flags += MysqliModule.ENUM_FLAG;
if (isInResultString(7, "auto")) flags += MysqliModule.AUTO_INCREMENT_FLAG;
if (isInResultString(2, "set")) flags += MysqliModule.SET_FLAG;
if ((jdbcType == Types.BIGINT)
|| (jdbcType == Types.BIT)
|| (jdbcType == Types.BOOLEAN)
|| (jdbcType == Types.DECIMAL)
|| (jdbcType == Types.DOUBLE)
|| (jdbcType == Types.REAL)
|| (jdbcType == Types.INTEGER)
|| (jdbcType == Types.SMALLINT)) flags += MysqliModule.NUM_FLAG;
result.putField(env, "flags", LongValue.create(flags));
// generate PHP type
int quercusType = 0;
switch (jdbcType) {
case Types.DECIMAL:
quercusType = MysqliModule.MYSQLI_TYPE_DECIMAL;
break;
case Types.BIT:
// Connector-J enables the tinyInt1isBit property
// by default and converts TINYINT to BIT. Use
// the mysql type name to tell the two apart.
if (mysqlType.equals("BIT")) {
quercusType = MysqliModule.MYSQLI_TYPE_BIT;
} else {
quercusType = MysqliModule.MYSQLI_TYPE_TINY;
}
break;
case Types.SMALLINT:
quercusType = MysqliModule.MYSQLI_TYPE_SHORT;
break;
case Types.INTEGER:
{
if (!isInResultString(2, "medium")) quercusType = MysqliModule.MYSQLI_TYPE_LONG;
else quercusType = MysqliModule.MYSQLI_TYPE_INT24;
break;
}
case Types.REAL:
quercusType = MysqliModule.MYSQLI_TYPE_FLOAT;
break;
case Types.DOUBLE:
quercusType = MysqliModule.MYSQLI_TYPE_DOUBLE;
break;
case Types.BIGINT:
quercusType = MysqliModule.MYSQLI_TYPE_LONGLONG;
break;
case Types.DATE:
if (mysqlType.equals("YEAR")) {
quercusType = MysqliModule.MYSQLI_TYPE_YEAR;
} else {
quercusType = MysqliModule.MYSQLI_TYPE_DATE;
}
break;
case Types.TINYINT:
quercusType = MysqliModule.MYSQLI_TYPE_TINY;
break;
case Types.TIME:
quercusType = MysqliModule.MYSQLI_TYPE_TIME;
break;
case Types.TIMESTAMP:
if (mysqlType.equals("TIMESTAMP")) {
quercusType = MysqliModule.MYSQLI_TYPE_TIMESTAMP;
} else {
quercusType = MysqliModule.MYSQLI_TYPE_DATETIME;
}
break;
case Types.LONGVARBINARY:
case Types.LONGVARCHAR:
quercusType = MysqliModule.MYSQLI_TYPE_BLOB;
break;
case Types.BINARY:
case Types.CHAR:
quercusType = MysqliModule.MYSQLI_TYPE_STRING;
break;
case Types.VARBINARY:
case Types.VARCHAR:
quercusType = MysqliModule.MYSQLI_TYPE_VAR_STRING;
break;
// XXX: may need to revisit default
default:
quercusType = MysqliModule.MYSQLI_TYPE_NULL;
break;
}
result.putField(env, "type", LongValue.create(quercusType));
result.putField(env, "decimals", LongValue.create(scale));
// The "charsetnr" field is an integer identifier
// for the character set used to encode the field.
// This integer is sent by the server to the JDBC client
// and is stored as com.mysql.jdbc.Field.charsetIndex,
// but this field is private and the class does not provide
// any means to access the field. There is also no way
// to lookup the mysql index given a Java or Mysql encoding
// name.
result.putField(env, "charsetnr", LongValue.ZERO);
} catch (SQLException e) {
log.log(Level.FINE, e.toString(), e);
return BooleanValue.FALSE;
}
return result;
}
protected Value fetchFieldImproved(Env env, ResultSetMetaData md, int offset) {
Value result = env.createObject();
try {
int jdbcType = md.getColumnType(offset);
String catalogName = md.getCatalogName(offset);
String fieldTable = md.getTableName(offset);
String fieldSchema = md.getSchemaName(offset);
String fieldName = md.getColumnName(offset);
String fieldAlias = md.getColumnLabel(offset);
String mysqlType = md.getColumnTypeName(offset);
int fieldLength = md.getPrecision(offset);
int scale = md.getScale(offset);
if ((fieldTable == null || "".equals(fieldTable))
&& ((Mysqli) getConnection()).isLastSqlDescribe()) fieldTable = "COLUMNS";
result.putField(env, "name", env.createString(fieldAlias));
result.putField(env, "orgname", env.createString(fieldName));
result.putField(env, "table", env.createString(fieldTable));
// XXX: orgtable same as table
result.putField(env, "orgtable", env.createString(fieldTable));
result.putField(env, "def", env.createString(""));
// "max_length" is the maximum width of this field in this
// result set.
result.putField(env, "max_length", LongValue.ZERO);
// "length" is the width of the field defined in the table
// declaration.
result.putField(env, "length", LongValue.create(fieldLength));
// generate flags
long flags = 0;
result.putField(env, "flags", LongValue.create(flags));
// generate PHP type
int quercusType = 0;
switch (jdbcType) {
case Types.DECIMAL:
quercusType = MysqliModule.MYSQLI_TYPE_DECIMAL;
break;
case Types.BIT:
// Connector-J enables the tinyInt1isBit property
// by default and converts TINYINT to BIT. Use
// the mysql type name to tell the two apart.
if (mysqlType.equals("BIT")) {
quercusType = MysqliModule.MYSQLI_TYPE_BIT;
} else {
quercusType = MysqliModule.MYSQLI_TYPE_TINY;
}
break;
case Types.SMALLINT:
quercusType = MysqliModule.MYSQLI_TYPE_SHORT;
break;
case Types.INTEGER:
{
if (!isInResultString(2, "medium")) quercusType = MysqliModule.MYSQLI_TYPE_LONG;
else quercusType = MysqliModule.MYSQLI_TYPE_INT24;
break;
}
case Types.REAL:
quercusType = MysqliModule.MYSQLI_TYPE_FLOAT;
break;
case Types.DOUBLE:
quercusType = MysqliModule.MYSQLI_TYPE_DOUBLE;
break;
case Types.BIGINT:
quercusType = MysqliModule.MYSQLI_TYPE_LONGLONG;
break;
case Types.DATE:
if (mysqlType.equals("YEAR")) {
quercusType = MysqliModule.MYSQLI_TYPE_YEAR;
} else {
quercusType = MysqliModule.MYSQLI_TYPE_DATE;
}
break;
case Types.TINYINT:
quercusType = MysqliModule.MYSQLI_TYPE_TINY;
break;
case Types.TIME:
quercusType = MysqliModule.MYSQLI_TYPE_TIME;
break;
case Types.TIMESTAMP:
if (mysqlType.equals("TIMESTAMP")) {
quercusType = MysqliModule.MYSQLI_TYPE_TIMESTAMP;
} else {
quercusType = MysqliModule.MYSQLI_TYPE_DATETIME;
}
break;
case Types.LONGVARBINARY:
case Types.LONGVARCHAR:
quercusType = MysqliModule.MYSQLI_TYPE_BLOB;
break;
case Types.BINARY:
case Types.CHAR:
quercusType = MysqliModule.MYSQLI_TYPE_STRING;
break;
case Types.VARBINARY:
case Types.VARCHAR:
quercusType = MysqliModule.MYSQLI_TYPE_VAR_STRING;
break;
// XXX: may need to revisit default
default:
quercusType = MysqliModule.MYSQLI_TYPE_NULL;
break;
}
result.putField(env, "type", LongValue.create(quercusType));
result.putField(env, "decimals", LongValue.create(scale));
// The "charsetnr" field is an integer identifier
// for the character set used to encode the field.
// This integer is sent by the server to the JDBC client
// and is stored as com.mysql.jdbc.Field.charsetIndex,
// but this field is private and the class does not provide
// any means to access the field. There is also no way
// to lookup the mysql index given a Java or Mysql encoding
// name.
result.putField(env, "charsetnr", LongValue.ZERO);
} catch (SQLException e) {
log.log(Level.FINE, e.toString(), e);
return BooleanValue.FALSE;
}
return result;
}
