Examples of net.hydromatic.optiq.impl.java.ReflectiveSchema

net.hydromatic.optiq.impl.java.ReflectiveSchema
Implementation of {@link net.hydromatic.optiq.Schema} that exposes the publicfields and methods in a Java object.

    SchemaPlus rootSchema = optiqConnection.getRootSchema();
    rootSchema.add("DB",
        JdbcSchema.create(rootSchema, "DB",
            JdbcSchema.dataSource(db, "org.hsqldb.jdbcDriver", "", ""),
            null, null));
    rootSchema.add("hr", new ReflectiveSchema(new JdbcTest.HrSchema()));
    return optiqConn;
  }

View Full Code Here

    }
  }


  private SchemaPlus createHrSchema() {
    return Frameworks.createRootSchema(true).add("hr",
        new ReflectiveSchema(new JdbcTest.HrSchema()));
  }

View Full Code Here

  }


  public String checkTpchQuery(String tpchTestQuery) throws Exception {
    final SchemaPlus schema =
        Frameworks.createRootSchema(true).add("tpch",
            new ReflectiveSchema(new TpchSchema()));


    Planner p = Frameworks.getPlanner(Lex.MYSQL, schema,
        SqlStdOperatorTable.instance(), RuleSets.ofList(RULE_SET));
    SqlNode n = p.parse(tpchTestQuery);
    n = p.validate(n);

View Full Code Here

                  DriverManager.getConnection("jdbc:optiq:");
              OptiqConnection optiqConnection =
                  connection.unwrap(OptiqConnection.class);
              SchemaPlus rootSchema =
                  optiqConnection.getRootSchema();
              rootSchema.add(name, new ReflectiveSchema(schema));
              optiqConnection.setSchema(name);
              return optiqConnection;
            }
          });
    }

View Full Code Here

        Frameworks.withPlanner(
            new Frameworks.PlannerAction<String>() {
              public String apply(RelOptCluster cluster,
                  RelOptSchema relOptSchema, SchemaPlus rootSchema) {
                rootSchema.add("hr",
                    new ReflectiveSchema(new JdbcTest.HrSchema()));
                TableAccessRel table =
                    new TableAccessRel(cluster,
                        relOptSchema.getTableForMember(
                            Arrays.asList("hr", "emps")));
                final RexBuilder rexBuilder = cluster.getRexBuilder();

View Full Code Here

            new Frameworks.PlannerAction<String>() {
              public String apply(RelOptCluster cluster,
                  RelOptSchema relOptSchema, SchemaPlus rootSchema) {
                SchemaPlus schema =
                    rootSchema.add("hr",
                        new ReflectiveSchema(new JdbcTest.HrSchema()));
                final RelJsonReader reader =
                    new RelJsonReader(cluster, relOptSchema, schema);
                RelNode node;
                try {
                  node = reader.read(XX);

View Full Code Here

  }


  public String checkTpchQuery(String tpchTestQuery) throws Exception {
    final SchemaPlus schema =
        Frameworks.createRootSchema(true).add("tpch",
            new ReflectiveSchema(new TpchSchema()));


    final FrameworkConfig config = Frameworks.newConfigBuilder()
        .lex(Lex.MYSQL)
        .defaultSchema(schema)
        .programs(Programs.ofRules(Programs.RULE_SET))

View Full Code Here

    Connection connection =
        DriverManager.getConnection("jdbc:optiq:", info);
    OptiqConnection optiqConnection =
        connection.unwrap(OptiqConnection.class);
    SchemaPlus rootSchema = optiqConnection.getRootSchema();
    rootSchema.add("hr", new ReflectiveSchema(new HrSchema()));
    SchemaPlus schema = rootSchema.add("s", new AbstractSchema());
    optiqConnection.setSchema("hr");
    final TableFunction table =
        new SqlAdvisorGetHintsFunction();
    schema.add("get_hints", table);

View Full Code Here

    final HandlerDriver driver =
        new HandlerDriver();
    OptiqConnection connection = (OptiqConnection)
        driver.connect("jdbc:optiq:", new Properties());
    SchemaPlus rootSchema = connection.getRootSchema();
    rootSchema.add("hr", new ReflectiveSchema(new HrSchema()));
    connection.setSchema("hr");
    final Statement statement = connection.createStatement();
    final ResultSet resultSet =
        statement.executeQuery("select * from \"emps\"");
    assertEquals(0, closeCount[0]);

View Full Code Here

    }
    final Driver driver = new Driver();
    OptiqConnection connection = (OptiqConnection)
        driver.connect("jdbc:optiq:", new Properties());
    SchemaPlus rootSchema = connection.getRootSchema();
    rootSchema.add("hr", new ReflectiveSchema(new HrSchema()));
    connection.setSchema("hr");
    final Statement statement = connection.createStatement();
    assertFalse((Boolean) OptiqAssert.call(statement, "isCloseOnCompletion"));
    OptiqAssert.call(statement, "closeOnCompletion");
    assertTrue((Boolean) OptiqAssert.call(statement, "isCloseOnCompletion"));

View Full Code Here

0 1 2 3

TOP

Related Classes of net.hydromatic.optiq.impl.java.ReflectiveSchema

net.hydromatic.optiq.examples.foodmart.java.JdbcExample

net.hydromatic.optiq.Table

net.hydromatic.optiq.test.ExceptionMessageTest

net.hydromatic.optiq.test.JdbcTest

net.hydromatic.optiq.test.JdbcTest$MySchemaFactory

net.hydromatic.optiq.test.MultiJdbcSchemaJoinTest

net.hydromatic.optiq.test.OptiqAssert

net.hydromatic.optiq.test.OptiqAssert$AssertThat

net.hydromatic.optiq.tools.PlannerTest

org.eigenbase.relopt.RelWriterTest

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.