org.apache.calcite.test.schemata.hr

类 HrSchema

java.lang.Object

org.apache.calcite.test.schemata.hr.HrSchema

public class HrSchema
extends Object

A schema that contains two tables by reflection.

Here is the SQL to create equivalent tables in Oracle:

 CREATE TABLE "emps" (
   "empid" INTEGER NOT NULL,
   "deptno" INTEGER NOT NULL,
   "name" VARCHAR(10) NOT NULL,
   "salary" NUMBER(6, 2) NOT NULL,
   "commission" INTEGER);
 INSERT INTO "emps" VALUES (100, 10, 'Bill', 10000, 1000);
 INSERT INTO "emps" VALUES (200, 20, 'Eric', 8000, 500);
 INSERT INTO "emps" VALUES (150, 10, 'Sebastian', 7000, null);
 INSERT INTO "emps" VALUES (110, 10, 'Theodore', 11500, 250);

 CREATE TABLE "depts" (
   "deptno" INTEGER NOT NULL,
   "name" VARCHAR(10) NOT NULL,
   "employees" ARRAY OF "Employee",
   "location" "Location");
 INSERT INTO "depts" VALUES (10, 'Sales', null, (-122, 38));
 INSERT INTO "depts" VALUES (30, 'Marketing', null, (0, 52));
 INSERT INTO "depts" VALUES (40, 'HR', null, null);
 

字段概要

字段

限定符和类型	字段和说明
Dependent[]	dependents
Department[]	depts
Employee[]	emps
Dependent[]	locations

构造器概要

构造器

构造器和说明
HrSchema()

方法概要

限定符和类型	方法和说明
org.apache.calcite.schema.QueryableTable	foo(int count)
String	toString()
org.apache.calcite.schema.TranslatableTable	view(String s)

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

字段详细资料

emps

public final Employee[] emps

depts

public final Department[] depts

dependents

public final Dependent[] dependents

locations

public final Dependent[] locations

构造器详细资料

HrSchema

public HrSchema()

方法详细资料

toString

public String toString()

覆盖:

toString 在类中 Object

foo

public org.apache.calcite.schema.QueryableTable foo(int count)

view

public org.apache.calcite.schema.TranslatableTable view(String s)