static String getTableName(JdbcTable table) { // tableName is: [catalog,] [schema,] table SqlIdentifier identifier = table.tableName(); return identifier.names.get(identifier.names.size() - 1); }
static RelNode toRel(RelOptCluster cluster, RelOptSchema relOptSchema, JdbcTable table, List<String> qualifiedName) { RelOptTable.ToRelContext toRelContext = new RelOptTable.ToRelContext() { @Override public RelOptCluster getCluster() { return cluster; } @Override public RelRoot expandView(RelDataType rowType, String queryString, List<String> schemaPath, List<String> viewPath) { throw new UnsupportedOperationException(); } }; return table.toRel( toRelContext, relOptSchema.getTableForMember(qualifiedName) ); }
public Enumerable<Object[]> scan(DataContext root) { final JavaTypeFactory typeFactory = root.getTypeFactory(); final SqlString sql = generateSql(); return ResultSetEnumerable.of(jdbcSchema.getDataSource(), sql.getSql(), JdbcUtils.ObjectArrayRowBuilder.factory(fieldClasses(typeFactory))); }
public Enumerator<T> enumerator() { final JavaTypeFactory typeFactory = ((CalciteConnection) queryProvider).getTypeFactory(); final SqlString sql = generateSql(); //noinspection unchecked final Enumerable<T> enumerable = (Enumerable<T>) ResultSetEnumerable.of( jdbcSchema.getDataSource(), sql.getSql(), JdbcUtils.ObjectArrayRowBuilder.factory(fieldClasses(typeFactory))); return enumerable.enumerator(); } }
new JdbcTable(this, catalogName, schemaName, tableName, tableType); builder.put(tableName, table);
JournalledJdbcTable( String tableName, JournalledJdbcSchema journalledJdbcSchema, JdbcTable journalTable, String[] keyColumnNames ) { super( journalledJdbcSchema, JdbcTableUtils.getCatalogName(journalTable), JdbcTableUtils.getSchemaName(journalTable), tableName, journalTable.getJdbcTableType() ); this.journalTable = journalTable; this.journalledJdbcSchema = journalledJdbcSchema; this.keyColumnNames = ImmutableList.copyOf(keyColumnNames); }
public Enumerable<Object[]> scan(DataContext root) { final JavaTypeFactory typeFactory = root.getTypeFactory(); final SqlString sql = generateSql(); return ResultSetEnumerable.of(jdbcSchema.getDataSource(), sql.getSql(), JdbcUtils.ObjectArrayRowBuilder.factory(fieldClasses(typeFactory))); }
public Enumerator<T> enumerator() { final JavaTypeFactory typeFactory = ((CalciteConnection) queryProvider).getTypeFactory(); final SqlString sql = generateSql(); //noinspection unchecked final Enumerable<T> enumerable = (Enumerable<T>) ResultSetEnumerable.of( jdbcSchema.getDataSource(), sql.getSql(), JdbcUtils.ObjectArrayRowBuilder.factory(fieldClasses(typeFactory))); return enumerable.enumerator(); } }
new JdbcTable(this, catalogName, schemaName, tableName, tableType); builder.put(tableName, table);
/** @see #dispatch */ public Result visit(JdbcTableScan scan) { return result(scan.jdbcTable.tableName(), ImmutableList.of(Clause.FROM), scan, null); }
public JdbcImplementor.Result implement(JdbcImplementor implementor) { return implementor.result(jdbcTable.tableName(), ImmutableList.of(JdbcImplementor.Clause.FROM), this, null); } }
/** @see #dispatch */ public Result visit(JdbcTableScan scan) { return result(scan.jdbcTable.tableName(), ImmutableList.of(Clause.FROM), scan, null); }
public JdbcImplementor.Result implement(JdbcImplementor implementor) { return implementor.result(jdbcTable.tableName(), ImmutableList.of(JdbcImplementor.Clause.FROM), this, null); } }
SqlString generateSql() { final SqlNodeList selectList = new SqlNodeList( Collections.singletonList(SqlIdentifier.star(SqlParserPos.ZERO)), SqlParserPos.ZERO); SqlSelect node = new SqlSelect(SqlParserPos.ZERO, SqlNodeList.EMPTY, selectList, tableName(), null, null, null, null, null, null, null); final SqlPrettyWriter writer = new SqlPrettyWriter(jdbcSchema.dialect); node.unparse(writer, 0, 0); return writer.toSqlString(); }
SqlString generateSql() { final SqlNodeList selectList = new SqlNodeList( Collections.singletonList(SqlIdentifier.star(SqlParserPos.ZERO)), SqlParserPos.ZERO); SqlSelect node = new SqlSelect(SqlParserPos.ZERO, SqlNodeList.EMPTY, selectList, tableName(), null, null, null, null, null, null, null); final SqlPrettyWriter writer = new SqlPrettyWriter(jdbcSchema.dialect); node.unparse(writer, 0, 0); return writer.toSqlString(); }