com.mongodb.jdbc.MongoResultSetMetaData Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of mongodb-jdbc Show documentation
Show all versions of mongodb-jdbc Show documentation
JDBC Driver for MongoDB Atlas SQL interface
package com.mongodb.jdbc;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Types;
import org.bson.BsonValue;
public class MongoResultSetMetaData implements ResultSetMetaData {
private MongoResultDoc mongoResultDoc;
private final int unknownLength = 0;
public MongoResultSetMetaData(MongoResultDoc mongoResultDoc) {
this.mongoResultDoc = mongoResultDoc;
}
private void checkBounds(int i) throws SQLException {
if (i > mongoResultDoc.columnCount()) {
throw new SQLException("Index out of bounds: '" + i + "'.");
}
}
@Override
public int getColumnCount() throws SQLException {
return mongoResultDoc.columnCount();
}
@Override
public boolean isAutoIncrement(int column) throws SQLException {
checkBounds(column);
return false;
}
@Override
public boolean isCaseSensitive(int column) throws SQLException {
BsonValue o = getObject(column);
if (o == null) {
return false;
}
switch (o.getBsonType()) {
case ARRAY:
case BINARY:
case BOOLEAN:
case DATE_TIME:
case DB_POINTER:
case DECIMAL128:
case DOCUMENT:
case DOUBLE:
case END_OF_DOCUMENT:
case INT32:
case INT64:
case MAX_KEY:
case MIN_KEY:
case NULL:
case OBJECT_ID:
case TIMESTAMP:
case UNDEFINED:
return false;
case JAVASCRIPT:
case JAVASCRIPT_WITH_SCOPE:
case REGULAR_EXPRESSION:
case STRING:
case SYMBOL:
return true;
}
return false;
}
@Override
public boolean isSearchable(int column) throws SQLException {
checkBounds(column);
return true;
}
@Override
public boolean isCurrency(int column) throws SQLException {
checkBounds(column);
return false;
}
@Override
public int isNullable(int column) throws SQLException {
checkBounds(column);
return columnNullableUnknown;
}
@Override
public boolean isSigned(int column) throws SQLException {
BsonValue o = getObject(column);
if (o == null) {
return false;
}
switch (o.getBsonType()) {
case DOUBLE:
case DECIMAL128:
case INT32:
case INT64:
return true;
case ARRAY:
case BINARY:
case BOOLEAN:
case DATE_TIME:
case DB_POINTER:
case DOCUMENT:
case END_OF_DOCUMENT:
case MAX_KEY:
case MIN_KEY:
case NULL:
case OBJECT_ID:
case TIMESTAMP:
case UNDEFINED:
case JAVASCRIPT:
case JAVASCRIPT_WITH_SCOPE:
case REGULAR_EXPRESSION:
case STRING:
case SYMBOL:
return false;
}
return false;
}
@Override
public int getColumnDisplaySize(int column) throws SQLException {
BsonValue o = getObject(column);
if (o == null) {
return 0;
}
switch (o.getBsonType()) {
case ARRAY:
return unknownLength;
case BINARY:
return unknownLength;
case BOOLEAN:
return 1;
case DATE_TIME:
//24 characters to display.
return 24;
case DB_POINTER:
return 0;
case DECIMAL128:
return 34;
case DOCUMENT:
return unknownLength;
case DOUBLE:
return 15;
case END_OF_DOCUMENT:
return 0;
case INT32:
return 10;
case INT64:
return 19;
case JAVASCRIPT:
return unknownLength;
case JAVASCRIPT_WITH_SCOPE:
return unknownLength;
case MAX_KEY:
return 0;
case MIN_KEY:
return 0;
case NULL:
return 0;
case OBJECT_ID:
return 24;
case REGULAR_EXPRESSION:
return unknownLength;
case STRING:
return unknownLength;
case SYMBOL:
return unknownLength;
case TIMESTAMP:
return unknownLength;
case UNDEFINED:
return 0;
}
throw new SQLException("unknown bson type with value: " + o);
}
@Override
public String getColumnLabel(int column) throws SQLException {
checkBounds(column);
return mongoResultDoc.values.get(column - 1).columnAlias;
}
@Override
public String getColumnName(int column) throws SQLException {
checkBounds(column);
return mongoResultDoc.values.get(column - 1).column;
}
@Override
public String getSchemaName(int column) throws SQLException {
checkBounds(column);
return "";
}
@Override
public int getPrecision(int column) throws SQLException {
BsonValue o = getObject(column);
if (o == null) {
return 0;
}
switch (o.getBsonType()) {
case ARRAY:
return unknownLength;
case BINARY:
return unknownLength;
case BOOLEAN:
return 1;
case DATE_TIME:
return 24;
case DB_POINTER:
return 0;
case DECIMAL128:
return 34;
case DOCUMENT:
return unknownLength;
case DOUBLE:
return 15;
case END_OF_DOCUMENT:
return 0;
case INT32:
return 10;
case INT64:
return 19;
case JAVASCRIPT:
return unknownLength;
case JAVASCRIPT_WITH_SCOPE:
return unknownLength;
case MAX_KEY:
return 0;
case MIN_KEY:
return 0;
case NULL:
return 0;
case OBJECT_ID:
return 24;
case REGULAR_EXPRESSION:
return unknownLength;
case STRING:
return unknownLength;
case SYMBOL:
return unknownLength;
case TIMESTAMP:
return 0;
case UNDEFINED:
return 0;
}
throw new SQLException("unknown bson type with value: " + o);
}
@Override
public int getScale(int column) throws SQLException {
BsonValue o = getObject(column);
if (o == null) {
return 0;
}
switch (o.getBsonType()) {
case ARRAY:
case BINARY:
case BOOLEAN:
case DATE_TIME:
case DB_POINTER:
case DOCUMENT:
case END_OF_DOCUMENT:
case INT32:
case INT64:
case JAVASCRIPT:
case JAVASCRIPT_WITH_SCOPE:
case MAX_KEY:
case MIN_KEY:
case NULL:
case OBJECT_ID:
case REGULAR_EXPRESSION:
case STRING:
case SYMBOL:
case TIMESTAMP:
case UNDEFINED:
return 0;
case DECIMAL128:
return 34;
case DOUBLE:
return 15;
}
throw new SQLException("unknown bson type with value: " + o);
}
@Override
public String getTableName(int column) throws SQLException {
checkBounds(column);
return mongoResultDoc.values.get(column).tableAlias;
}
@Override
public String getCatalogName(int column) throws SQLException {
checkBounds(column);
return mongoResultDoc.values.get(column - 1).database;
}
private BsonValue getObject(int column) throws SQLException {
checkBounds(column);
return mongoResultDoc.values.get(column - 1).value;
}
@Override
public int getColumnType(int column) throws SQLException {
BsonValue o = getObject(column);
if (o == null) {
return Types.NULL;
}
switch (o.getBsonType()) {
case ARRAY:
return Types.ARRAY;
case BINARY:
return Types.BLOB;
case BOOLEAN:
return Types.BIT;
case DATE_TIME:
return Types.TIMESTAMP;
case DB_POINTER:
return Types.NULL;
case DECIMAL128:
return Types.DECIMAL;
case DOCUMENT:
return Types.NULL;
case DOUBLE:
return Types.DOUBLE;
case END_OF_DOCUMENT:
return Types.NULL;
case INT32:
return Types.INTEGER;
case INT64:
return Types.INTEGER;
case JAVASCRIPT:
return Types.NULL;
case JAVASCRIPT_WITH_SCOPE:
return Types.NULL;
case MAX_KEY:
return Types.NULL;
case MIN_KEY:
return Types.NULL;
case NULL:
return Types.NULL;
case OBJECT_ID:
return Types.LONGVARCHAR;
case REGULAR_EXPRESSION:
return Types.NULL;
case STRING:
return Types.LONGVARCHAR;
case SYMBOL:
return Types.NULL;
case TIMESTAMP:
return Types.NULL;
case UNDEFINED:
return Types.NULL;
}
throw new SQLException("unknown bson type with value: " + o);
}
@Override
public String getColumnTypeName(int column) throws SQLException {
BsonValue o = getObject(column);
if (o == null) {
return "null";
}
switch (o.getBsonType()) {
// we will return the same names as the mongodb $type function:
case ARRAY:
return "array";
case BINARY:
return "binData";
case BOOLEAN:
return "bool";
case DATE_TIME:
return "date";
case DB_POINTER:
return "null";
case DECIMAL128:
return "decimal";
case DOCUMENT:
return "null";
case DOUBLE:
return "double";
case END_OF_DOCUMENT:
return "null";
case INT32:
return "int";
case INT64:
return "long";
case JAVASCRIPT:
return "null";
case JAVASCRIPT_WITH_SCOPE:
return "null";
case MAX_KEY:
return "null";
case MIN_KEY:
return "null";
case NULL:
return "null";
case OBJECT_ID:
return "string";
case REGULAR_EXPRESSION:
return "null";
case STRING:
return "string";
case SYMBOL:
return "null";
case TIMESTAMP:
return "null";
case UNDEFINED:
return "null";
}
throw new SQLException("unknown bson type with value: " + o);
}
@Override
public boolean isReadOnly(int column) throws SQLException {
checkBounds(column);
return true;
}
@Override
public boolean isWritable(int column) throws SQLException {
checkBounds(column);
return false;
}
@Override
public boolean isDefinitelyWritable(int column) throws SQLException {
checkBounds(column);
return false;
}
// --------------------------JDBC 2.0-----------------------------------
@Override
public String getColumnClassName(int column) throws SQLException {
Object o = getObject(column);
return o.getClass().getName();
}
// java.sql.Wrapper impl
@Override
public boolean isWrapperFor(Class iface) throws SQLException {
return iface.isInstance(this);
}
@SuppressWarnings("unchecked")
@Override
public T unwrap(Class iface) throws SQLException {
return (T) this;
}
}
© 2015 - 2024 Weber Informatics LLC | Privacy Policy