Created
May 21, 2018 16:10
-
-
Save Pyknic/cb7b3741b4f10750c02495cda68b8e23 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
package com.speedment.enterprise.benchmark.joins; | |
import com.speedment.common.tuple.Tuple2; | |
import com.speedment.common.tuple.Tuples; | |
import com.speedment.enterprise.aggregator.Aggregator; | |
import com.speedment.enterprise.benchmark.joins.db.EmployeesApplication; | |
import com.speedment.enterprise.benchmark.joins.db.EmployeesApplicationBuilder; | |
import com.speedment.enterprise.benchmark.joins.db.employees.Employee; | |
import com.speedment.enterprise.benchmark.joins.db.salaries.Salary; | |
import com.speedment.enterprise.benchmark.joins.db.salaries.SalaryManager; | |
import com.speedment.enterprise.datastore.runtime.DataStoreBundle; | |
import com.speedment.enterprise.datastore.runtime.DataStoreComponent; | |
import com.speedment.enterprise.join.DataStoreJoinBundle; | |
import com.speedment.runtime.join.JoinComponent; | |
import java.time.LocalDate; | |
import static java.util.stream.Collectors.toList; | |
/** | |
* @author Emil Forslund | |
* @since 1.0.0 | |
*/ | |
public class Main { | |
private final static long TODAY = LocalDate.now().toEpochDay(); | |
private final static Aggregator<Tuple2<Salary, Employee>, ?, Result> AGGREGATOR = | |
Aggregator.<Tuple2<Salary, Employee>, Result>builderOfType(Result::new) | |
.firstOn(Tuple2.getter1()) | |
.andThen(Employee.GENDER) | |
.key(Result::setGender) | |
.firstOn(Tuple2.getter1()) | |
.andThen(Employee.HIRE_DATE.mapToLongIfPresent(LocalDate::toEpochDay) | |
.orElse(TODAY) | |
.minus(TODAY) | |
.negate() | |
) | |
.average(Result::setEmployedDays) | |
.firstOn(Tuple2.getter0()) | |
.andThen(Salary.SALARY) | |
.average(Result::setSalary) | |
.build(); | |
public static void main(String... args) { | |
System.out.println("Starting Speedment"); | |
final EmployeesApplication app = new EmployeesApplicationBuilder() | |
.withUsername("root") | |
.withPassword("password") | |
.withBundle(DataStoreBundle.class) | |
.withBundle(DataStoreJoinBundle.class) | |
.build(); | |
System.out.println("Loading data."); | |
final DataStoreComponent dataStore = app.getOrThrow(DataStoreComponent.class); | |
dataStore.load(); | |
System.out.println("Fully loaded."); | |
final JoinComponent joins = app.getOrThrow(JoinComponent.class); | |
System.out.println( | |
joins.from(SalaryManager.IDENTIFIER) | |
.innerJoinOn(Employee.EMP_NO).equal(Salary.EMP_NO) | |
.build(Tuples::of) | |
.stream() | |
.collect(AGGREGATOR.createCollector()) | |
.streamAndClose() | |
.collect(toList()) | |
); | |
app.close(); | |
} | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"config" : { | |
"speedmentVersion" : "Speedment:1.2.1-SNAPSHOT", | |
"nameProtected" : false, | |
"expanded" : true, | |
"appId" : "54cdb0a4-83e9-46a9-b33f-9138f9155406", | |
"companyName" : "speedment", | |
"name" : "employees", | |
"packageLocation" : "target/generated-sources/src/main/java/", | |
"id" : "employees", | |
"packageName" : "com.speedment.enterprise.benchmark.joins.db", | |
"dbmses" : [ | |
{ | |
"expanded" : true, | |
"port" : 3306, | |
"schemas" : [ | |
{ | |
"nameProtected" : true, | |
"tables" : [ | |
{ | |
"nameProtected" : true, | |
"expanded" : false, | |
"primaryKeyColumns" : [ | |
{ | |
"expanded" : false, | |
"name" : "dept_no", | |
"id" : "dept_no", | |
"ordinalPosition" : 1, | |
"enabled" : true | |
} | |
], | |
"indexes" : [ | |
{ | |
"expanded" : false, | |
"unique" : true, | |
"name" : "dept_name", | |
"indexColumns" : [ | |
{ | |
"orderType" : "ASC", | |
"expanded" : false, | |
"name" : "dept_name", | |
"id" : "dept_name", | |
"ordinalPosition" : 1 | |
} | |
], | |
"id" : "dept_name", | |
"enabled" : true | |
}, | |
{ | |
"expanded" : false, | |
"unique" : true, | |
"name" : "PRIMARY", | |
"indexColumns" : [ | |
{ | |
"orderType" : "ASC", | |
"expanded" : false, | |
"name" : "dept_no", | |
"id" : "dept_no", | |
"ordinalPosition" : 1 | |
} | |
], | |
"id" : "PRIMARY", | |
"enabled" : true | |
} | |
], | |
"isView" : false, | |
"columns" : [ | |
{ | |
"databaseType" : "java.lang.String", | |
"expanded" : false, | |
"nullable" : false, | |
"name" : "dept_no", | |
"id" : "dept_no", | |
"ordinalPosition" : 1, | |
"enabled" : true | |
}, | |
{ | |
"databaseType" : "java.lang.String", | |
"expanded" : false, | |
"nullable" : false, | |
"name" : "dept_name", | |
"id" : "dept_name", | |
"ordinalPosition" : 2, | |
"enabled" : true | |
} | |
], | |
"name" : "departments", | |
"alias" : "department", | |
"id" : "departments", | |
"packageName" : "com.speedment.enterprise.benchmark.joins.db.departments", | |
"enabled" : true | |
}, | |
{ | |
"nameProtected" : true, | |
"foreignKeys" : [ | |
{ | |
"expanded" : false, | |
"foreignKeyColumns" : [ | |
{ | |
"foreignDatabaseName" : "employees", | |
"foreignSchemaName" : "employees", | |
"expanded" : false, | |
"name" : "emp_no", | |
"foreignColumnName" : "emp_no", | |
"id" : "emp_no", | |
"foreignTableName" : "employees", | |
"ordinalPosition" : 1 | |
} | |
], | |
"name" : "dept_emp_ibfk_1", | |
"id" : "dept_emp_ibfk_1", | |
"enabled" : true | |
}, | |
{ | |
"expanded" : false, | |
"foreignKeyColumns" : [ | |
{ | |
"foreignDatabaseName" : "employees", | |
"foreignSchemaName" : "employees", | |
"expanded" : false, | |
"name" : "dept_no", | |
"foreignColumnName" : "dept_no", | |
"id" : "dept_no", | |
"foreignTableName" : "departments", | |
"ordinalPosition" : 1 | |
} | |
], | |
"name" : "dept_emp_ibfk_2", | |
"id" : "dept_emp_ibfk_2", | |
"enabled" : true | |
} | |
], | |
"expanded" : false, | |
"primaryKeyColumns" : [ | |
{ | |
"expanded" : false, | |
"name" : "dept_no", | |
"id" : "dept_no", | |
"ordinalPosition" : 2, | |
"enabled" : true | |
}, | |
{ | |
"expanded" : false, | |
"name" : "emp_no", | |
"id" : "emp_no", | |
"ordinalPosition" : 1, | |
"enabled" : true | |
} | |
], | |
"indexes" : [ | |
{ | |
"expanded" : false, | |
"unique" : true, | |
"name" : "PRIMARY", | |
"indexColumns" : [ | |
{ | |
"orderType" : "ASC", | |
"expanded" : false, | |
"name" : "emp_no", | |
"id" : "emp_no", | |
"ordinalPosition" : 1 | |
}, | |
{ | |
"orderType" : "ASC", | |
"expanded" : false, | |
"name" : "dept_no", | |
"id" : "dept_no", | |
"ordinalPosition" : 2 | |
} | |
], | |
"id" : "PRIMARY", | |
"enabled" : true | |
}, | |
{ | |
"expanded" : false, | |
"unique" : false, | |
"name" : "dept_no", | |
"indexColumns" : [ | |
{ | |
"orderType" : "ASC", | |
"expanded" : false, | |
"name" : "dept_no", | |
"id" : "dept_no", | |
"ordinalPosition" : 1 | |
} | |
], | |
"id" : "dept_no", | |
"enabled" : true | |
} | |
], | |
"isView" : false, | |
"columns" : [ | |
{ | |
"databaseType" : "java.lang.Integer", | |
"typeMapper" : "com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper", | |
"expanded" : false, | |
"nullable" : false, | |
"name" : "emp_no", | |
"id" : "emp_no", | |
"ordinalPosition" : 1, | |
"enabled" : true | |
}, | |
{ | |
"databaseType" : "java.lang.String", | |
"expanded" : false, | |
"nullable" : false, | |
"name" : "dept_no", | |
"id" : "dept_no", | |
"ordinalPosition" : 2, | |
"enabled" : true | |
}, | |
{ | |
"nameProtected" : true, | |
"nullable" : false, | |
"unindexed" : false, | |
"lowCardinality" : false, | |
"autoIncrement" : false, | |
"biDirectional" : false, | |
"ordinalPosition" : 3, | |
"enabled" : true, | |
"databaseType" : "java.sql.Date", | |
"expanded" : false, | |
"typeMapper" : "com.speedment.runtime.typemapper.time.DateToLocalDateMapper", | |
"name" : "from_date", | |
"nullableImplementation" : "OPTIONAL", | |
"id" : "from_date", | |
"hashIndex" : false | |
}, | |
{ | |
"nameProtected" : true, | |
"nullable" : false, | |
"unindexed" : false, | |
"lowCardinality" : false, | |
"autoIncrement" : false, | |
"biDirectional" : false, | |
"ordinalPosition" : 4, | |
"enabled" : true, | |
"databaseType" : "java.sql.Date", | |
"expanded" : false, | |
"typeMapper" : "com.speedment.runtime.typemapper.time.DateToLocalDateMapper", | |
"name" : "to_date", | |
"nullableImplementation" : "OPTIONAL", | |
"id" : "to_date", | |
"hashIndex" : false | |
} | |
], | |
"name" : "dept_emp", | |
"id" : "dept_emp", | |
"packageName" : "com.speedment.enterprise.benchmark.joins.db.dept_emp", | |
"enabled" : true | |
}, | |
{ | |
"nameProtected" : true, | |
"foreignKeys" : [ | |
{ | |
"expanded" : false, | |
"foreignKeyColumns" : [ | |
{ | |
"foreignDatabaseName" : "employees", | |
"foreignSchemaName" : "employees", | |
"expanded" : false, | |
"name" : "emp_no", | |
"foreignColumnName" : "emp_no", | |
"id" : "emp_no", | |
"foreignTableName" : "employees", | |
"ordinalPosition" : 1 | |
} | |
], | |
"name" : "dept_manager_ibfk_1", | |
"id" : "dept_manager_ibfk_1", | |
"enabled" : true | |
}, | |
{ | |
"expanded" : false, | |
"foreignKeyColumns" : [ | |
{ | |
"foreignDatabaseName" : "employees", | |
"foreignSchemaName" : "employees", | |
"expanded" : false, | |
"name" : "dept_no", | |
"foreignColumnName" : "dept_no", | |
"id" : "dept_no", | |
"foreignTableName" : "departments", | |
"ordinalPosition" : 1 | |
} | |
], | |
"name" : "dept_manager_ibfk_2", | |
"id" : "dept_manager_ibfk_2", | |
"enabled" : true | |
} | |
], | |
"expanded" : false, | |
"primaryKeyColumns" : [ | |
{ | |
"expanded" : false, | |
"name" : "dept_no", | |
"id" : "dept_no", | |
"ordinalPosition" : 2 | |
}, | |
{ | |
"expanded" : false, | |
"name" : "emp_no", | |
"id" : "emp_no", | |
"ordinalPosition" : 1 | |
} | |
], | |
"indexes" : [ | |
{ | |
"expanded" : false, | |
"unique" : true, | |
"name" : "PRIMARY", | |
"indexColumns" : [ | |
{ | |
"orderType" : "ASC", | |
"expanded" : false, | |
"name" : "emp_no", | |
"id" : "emp_no", | |
"ordinalPosition" : 1 | |
}, | |
{ | |
"orderType" : "ASC", | |
"expanded" : false, | |
"name" : "dept_no", | |
"id" : "dept_no", | |
"ordinalPosition" : 2 | |
} | |
], | |
"id" : "PRIMARY", | |
"enabled" : true | |
}, | |
{ | |
"expanded" : false, | |
"unique" : false, | |
"name" : "dept_no", | |
"indexColumns" : [ | |
{ | |
"orderType" : "ASC", | |
"expanded" : false, | |
"name" : "dept_no", | |
"id" : "dept_no", | |
"ordinalPosition" : 1 | |
} | |
], | |
"id" : "dept_no", | |
"enabled" : true | |
} | |
], | |
"isView" : false, | |
"columns" : [ | |
{ | |
"databaseType" : "java.lang.Integer", | |
"typeMapper" : "com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper", | |
"expanded" : false, | |
"nullable" : false, | |
"name" : "emp_no", | |
"id" : "emp_no", | |
"ordinalPosition" : 1, | |
"enabled" : true | |
}, | |
{ | |
"databaseType" : "java.lang.String", | |
"expanded" : false, | |
"nullable" : false, | |
"name" : "dept_no", | |
"id" : "dept_no", | |
"ordinalPosition" : 2, | |
"enabled" : true | |
}, | |
{ | |
"nameProtected" : true, | |
"nullable" : false, | |
"unindexed" : false, | |
"lowCardinality" : false, | |
"autoIncrement" : false, | |
"biDirectional" : false, | |
"ordinalPosition" : 3, | |
"enabled" : true, | |
"databaseType" : "java.sql.Date", | |
"expanded" : false, | |
"typeMapper" : "com.speedment.runtime.typemapper.time.DateToLocalDateMapper", | |
"name" : "from_date", | |
"nullableImplementation" : "OPTIONAL", | |
"id" : "from_date", | |
"hashIndex" : false | |
}, | |
{ | |
"nameProtected" : true, | |
"nullable" : false, | |
"unindexed" : false, | |
"lowCardinality" : false, | |
"autoIncrement" : false, | |
"biDirectional" : false, | |
"ordinalPosition" : 4, | |
"enabled" : true, | |
"databaseType" : "java.sql.Date", | |
"expanded" : false, | |
"typeMapper" : "com.speedment.runtime.typemapper.time.DateToLocalDateMapper", | |
"name" : "to_date", | |
"nullableImplementation" : "OPTIONAL", | |
"id" : "to_date", | |
"hashIndex" : false | |
} | |
], | |
"name" : "dept_manager", | |
"id" : "dept_manager", | |
"packageName" : "com.speedment.enterprise.benchmark.joins.db.dept_manager", | |
"enabled" : true | |
}, | |
{ | |
"nameProtected" : true, | |
"expanded" : true, | |
"primaryKeyColumns" : [ | |
{ | |
"expanded" : false, | |
"name" : "emp_no", | |
"id" : "emp_no", | |
"ordinalPosition" : 1, | |
"enabled" : true | |
} | |
], | |
"indexes" : [ | |
{ | |
"expanded" : false, | |
"unique" : true, | |
"name" : "PRIMARY", | |
"indexColumns" : [ | |
{ | |
"orderType" : "ASC", | |
"expanded" : false, | |
"name" : "emp_no", | |
"id" : "emp_no", | |
"ordinalPosition" : 1 | |
} | |
], | |
"id" : "PRIMARY", | |
"enabled" : true | |
} | |
], | |
"isView" : false, | |
"columns" : [ | |
{ | |
"databaseType" : "java.lang.Integer", | |
"typeMapper" : "com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper", | |
"expanded" : false, | |
"nullable" : false, | |
"name" : "emp_no", | |
"id" : "emp_no", | |
"ordinalPosition" : 1, | |
"enabled" : true | |
}, | |
{ | |
"nameProtected" : true, | |
"nullable" : false, | |
"unindexed" : false, | |
"lowCardinality" : false, | |
"autoIncrement" : false, | |
"biDirectional" : false, | |
"ordinalPosition" : 2, | |
"enabled" : true, | |
"databaseType" : "java.sql.Date", | |
"expanded" : false, | |
"typeMapper" : "com.speedment.runtime.typemapper.time.DateToLocalDateMapper", | |
"name" : "birth_date", | |
"nullableImplementation" : "OPTIONAL", | |
"id" : "birth_date", | |
"hashIndex" : false | |
}, | |
{ | |
"databaseType" : "java.lang.String", | |
"expanded" : false, | |
"nullable" : false, | |
"name" : "first_name", | |
"id" : "first_name", | |
"ordinalPosition" : 3, | |
"enabled" : true | |
}, | |
{ | |
"databaseType" : "java.lang.String", | |
"expanded" : false, | |
"nullable" : false, | |
"name" : "last_name", | |
"id" : "last_name", | |
"ordinalPosition" : 4, | |
"enabled" : true | |
}, | |
{ | |
"nameProtected" : true, | |
"nullable" : false, | |
"unindexed" : false, | |
"lowCardinality" : false, | |
"autoIncrement" : false, | |
"biDirectional" : false, | |
"ordinalPosition" : 5, | |
"enabled" : true, | |
"databaseType" : "java.lang.String", | |
"expanded" : false, | |
"typeMapper" : "com.speedment.plugins.enums.StringToEnumTypeMapper", | |
"enumConstants" : "M,F", | |
"name" : "gender", | |
"nullableImplementation" : "OPTIONAL", | |
"id" : "gender", | |
"hashIndex" : false | |
}, | |
{ | |
"nameProtected" : true, | |
"nullable" : false, | |
"unindexed" : false, | |
"lowCardinality" : false, | |
"autoIncrement" : false, | |
"biDirectional" : false, | |
"ordinalPosition" : 6, | |
"enabled" : true, | |
"databaseType" : "java.sql.Date", | |
"expanded" : false, | |
"typeMapper" : "com.speedment.runtime.typemapper.time.DateToLocalDateMapper", | |
"name" : "hire_date", | |
"nullableImplementation" : "OPTIONAL", | |
"id" : "hire_date", | |
"hashIndex" : false | |
} | |
], | |
"name" : "employees", | |
"alias" : "employee", | |
"id" : "employees", | |
"packageName" : "com.speedment.enterprise.benchmark.joins.db.employees", | |
"enabled" : true | |
}, | |
{ | |
"nameProtected" : true, | |
"foreignKeys" : [ | |
{ | |
"expanded" : false, | |
"foreignKeyColumns" : [ | |
{ | |
"foreignDatabaseName" : "employees", | |
"foreignSchemaName" : "employees", | |
"expanded" : false, | |
"name" : "emp_no", | |
"foreignColumnName" : "emp_no", | |
"id" : "emp_no", | |
"foreignTableName" : "employees", | |
"ordinalPosition" : 1 | |
} | |
], | |
"name" : "salaries_ibfk_1", | |
"id" : "salaries_ibfk_1", | |
"enabled" : true | |
} | |
], | |
"isView" : false, | |
"columns" : [ | |
{ | |
"databaseType" : "java.lang.Integer", | |
"typeMapper" : "com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper", | |
"expanded" : false, | |
"nullable" : false, | |
"name" : "emp_no", | |
"id" : "emp_no", | |
"ordinalPosition" : 1, | |
"enabled" : true | |
}, | |
{ | |
"databaseType" : "java.lang.Integer", | |
"typeMapper" : "com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper", | |
"expanded" : false, | |
"nullable" : false, | |
"name" : "salary", | |
"id" : "salary", | |
"ordinalPosition" : 2, | |
"enabled" : true | |
}, | |
{ | |
"nameProtected" : true, | |
"nullable" : false, | |
"unindexed" : false, | |
"lowCardinality" : false, | |
"autoIncrement" : false, | |
"biDirectional" : false, | |
"ordinalPosition" : 3, | |
"enabled" : true, | |
"databaseType" : "java.sql.Date", | |
"expanded" : false, | |
"typeMapper" : "com.speedment.runtime.typemapper.time.DateToLocalDateMapper", | |
"name" : "from_date", | |
"nullableImplementation" : "OPTIONAL", | |
"id" : "from_date", | |
"hashIndex" : false | |
}, | |
{ | |
"nameProtected" : true, | |
"nullable" : false, | |
"unindexed" : false, | |
"lowCardinality" : false, | |
"autoIncrement" : false, | |
"biDirectional" : false, | |
"ordinalPosition" : 4, | |
"enabled" : true, | |
"databaseType" : "java.sql.Date", | |
"expanded" : false, | |
"typeMapper" : "com.speedment.runtime.typemapper.time.DateToLocalDateMapper", | |
"name" : "to_date", | |
"nullableImplementation" : "OPTIONAL", | |
"id" : "to_date", | |
"hashIndex" : false | |
} | |
], | |
"enabled" : true, | |
"expanded" : true, | |
"primaryKeyColumns" : [ | |
{ | |
"expanded" : false, | |
"name" : "emp_no", | |
"id" : "emp_no", | |
"ordinalPosition" : 1, | |
"enabled" : true | |
}, | |
{ | |
"expanded" : false, | |
"name" : "from_date", | |
"id" : "from_date", | |
"ordinalPosition" : 2, | |
"enabled" : true | |
} | |
], | |
"indexes" : [ | |
{ | |
"expanded" : false, | |
"unique" : true, | |
"name" : "PRIMARY", | |
"indexColumns" : [ | |
{ | |
"orderType" : "ASC", | |
"expanded" : false, | |
"name" : "emp_no", | |
"id" : "emp_no", | |
"ordinalPosition" : 1 | |
}, | |
{ | |
"orderType" : "ASC", | |
"expanded" : false, | |
"name" : "from_date", | |
"id" : "from_date", | |
"ordinalPosition" : 2 | |
} | |
], | |
"id" : "PRIMARY", | |
"enabled" : true | |
} | |
], | |
"name" : "salaries", | |
"alias" : "salary", | |
"id" : "salaries", | |
"packageName" : "com.speedment.enterprise.benchmark.joins.db.salaries" | |
}, | |
{ | |
"nameProtected" : true, | |
"foreignKeys" : [ | |
{ | |
"expanded" : false, | |
"foreignKeyColumns" : [ | |
{ | |
"foreignDatabaseName" : "employees", | |
"foreignSchemaName" : "employees", | |
"expanded" : false, | |
"name" : "emp_no", | |
"foreignColumnName" : "emp_no", | |
"id" : "emp_no", | |
"foreignTableName" : "employees", | |
"ordinalPosition" : 1 | |
} | |
], | |
"name" : "titles_ibfk_1", | |
"id" : "titles_ibfk_1", | |
"enabled" : true | |
} | |
], | |
"isView" : false, | |
"columns" : [ | |
{ | |
"databaseType" : "java.lang.Integer", | |
"typeMapper" : "com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper", | |
"expanded" : false, | |
"nullable" : false, | |
"name" : "emp_no", | |
"id" : "emp_no", | |
"ordinalPosition" : 1, | |
"enabled" : true | |
}, | |
{ | |
"databaseType" : "java.lang.String", | |
"expanded" : false, | |
"nullable" : false, | |
"name" : "title", | |
"id" : "title", | |
"ordinalPosition" : 2, | |
"enabled" : true | |
}, | |
{ | |
"nameProtected" : true, | |
"nullable" : false, | |
"unindexed" : false, | |
"lowCardinality" : false, | |
"autoIncrement" : false, | |
"biDirectional" : false, | |
"ordinalPosition" : 3, | |
"enabled" : true, | |
"databaseType" : "java.sql.Date", | |
"expanded" : false, | |
"typeMapper" : "com.speedment.runtime.typemapper.time.DateToLocalDateMapper", | |
"name" : "from_date", | |
"nullableImplementation" : "OPTIONAL", | |
"id" : "from_date", | |
"hashIndex" : false | |
}, | |
{ | |
"nameProtected" : true, | |
"nullable" : true, | |
"unindexed" : false, | |
"lowCardinality" : false, | |
"autoIncrement" : false, | |
"biDirectional" : false, | |
"ordinalPosition" : 4, | |
"enabled" : true, | |
"databaseType" : "java.sql.Date", | |
"expanded" : false, | |
"typeMapper" : "com.speedment.runtime.typemapper.time.DateToLocalDateMapper", | |
"name" : "to_date", | |
"nullableImplementation" : "OPTIONAL", | |
"id" : "to_date", | |
"hashIndex" : false | |
} | |
], | |
"enabled" : true, | |
"expanded" : true, | |
"primaryKeyColumns" : [ | |
{ | |
"expanded" : false, | |
"name" : "emp_no", | |
"id" : "emp_no", | |
"ordinalPosition" : 1, | |
"enabled" : true | |
}, | |
{ | |
"expanded" : false, | |
"name" : "from_date", | |
"id" : "from_date", | |
"ordinalPosition" : 3, | |
"enabled" : true | |
}, | |
{ | |
"expanded" : false, | |
"name" : "title", | |
"id" : "title", | |
"ordinalPosition" : 2, | |
"enabled" : true | |
} | |
], | |
"indexes" : [ | |
{ | |
"expanded" : false, | |
"unique" : true, | |
"name" : "PRIMARY", | |
"indexColumns" : [ | |
{ | |
"orderType" : "ASC", | |
"expanded" : false, | |
"name" : "emp_no", | |
"id" : "emp_no", | |
"ordinalPosition" : 1 | |
}, | |
{ | |
"orderType" : "ASC", | |
"expanded" : false, | |
"name" : "from_date", | |
"id" : "from_date", | |
"ordinalPosition" : 3 | |
}, | |
{ | |
"orderType" : "ASC", | |
"expanded" : false, | |
"name" : "title", | |
"id" : "title", | |
"ordinalPosition" : 2 | |
} | |
], | |
"id" : "PRIMARY", | |
"enabled" : true | |
} | |
], | |
"name" : "titles", | |
"alias" : "title", | |
"id" : "titles", | |
"packageName" : "com.speedment.enterprise.benchmark.joins.db.titles" | |
}, | |
{ | |
"nameProtected" : true, | |
"expanded" : true, | |
"isView" : true, | |
"columns" : [ | |
{ | |
"databaseType" : "java.lang.Integer", | |
"typeMapper" : "com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper", | |
"expanded" : false, | |
"nullable" : false, | |
"name" : "emp_no", | |
"id" : "emp_no", | |
"ordinalPosition" : 1, | |
"enabled" : true | |
}, | |
{ | |
"databaseType" : "java.lang.String", | |
"expanded" : false, | |
"nullable" : false, | |
"name" : "dept_no", | |
"id" : "dept_no", | |
"ordinalPosition" : 2, | |
"enabled" : true | |
}, | |
{ | |
"nameProtected" : true, | |
"nullable" : true, | |
"unindexed" : false, | |
"lowCardinality" : false, | |
"autoIncrement" : false, | |
"biDirectional" : false, | |
"ordinalPosition" : 3, | |
"enabled" : true, | |
"databaseType" : "java.sql.Date", | |
"expanded" : false, | |
"typeMapper" : "com.speedment.runtime.typemapper.time.DateToLocalDateMapper", | |
"name" : "from_date", | |
"nullableImplementation" : "OPTIONAL", | |
"id" : "from_date", | |
"hashIndex" : false | |
}, | |
{ | |
"nameProtected" : true, | |
"nullable" : true, | |
"unindexed" : false, | |
"lowCardinality" : false, | |
"autoIncrement" : false, | |
"biDirectional" : false, | |
"ordinalPosition" : 4, | |
"enabled" : true, | |
"databaseType" : "java.sql.Date", | |
"expanded" : false, | |
"typeMapper" : "com.speedment.runtime.typemapper.time.DateToLocalDateMapper", | |
"name" : "to_date", | |
"nullableImplementation" : "OPTIONAL", | |
"id" : "to_date", | |
"hashIndex" : false | |
} | |
], | |
"name" : "current_dept_emp", | |
"id" : "current_dept_emp", | |
"packageName" : "com.speedment.enterprise.benchmark.joins.db.current_dept_emp", | |
"enabled" : true | |
}, | |
{ | |
"nameProtected" : true, | |
"expanded" : true, | |
"isView" : true, | |
"columns" : [ | |
{ | |
"databaseType" : "java.lang.Integer", | |
"typeMapper" : "com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper", | |
"expanded" : false, | |
"nullable" : false, | |
"name" : "emp_no", | |
"id" : "emp_no", | |
"ordinalPosition" : 1, | |
"enabled" : true | |
}, | |
{ | |
"nameProtected" : true, | |
"nullable" : true, | |
"unindexed" : false, | |
"lowCardinality" : false, | |
"autoIncrement" : false, | |
"biDirectional" : false, | |
"ordinalPosition" : 2, | |
"enabled" : true, | |
"databaseType" : "java.sql.Date", | |
"expanded" : false, | |
"typeMapper" : "com.speedment.runtime.typemapper.time.DateToLocalDateMapper", | |
"name" : "from_date", | |
"nullableImplementation" : "OPTIONAL", | |
"id" : "from_date", | |
"hashIndex" : false | |
}, | |
{ | |
"nameProtected" : true, | |
"nullable" : true, | |
"unindexed" : false, | |
"lowCardinality" : false, | |
"autoIncrement" : false, | |
"biDirectional" : false, | |
"ordinalPosition" : 3, | |
"enabled" : true, | |
"databaseType" : "java.sql.Date", | |
"expanded" : false, | |
"typeMapper" : "com.speedment.runtime.typemapper.time.DateToLocalDateMapper", | |
"name" : "to_date", | |
"nullableImplementation" : "OPTIONAL", | |
"id" : "to_date", | |
"hashIndex" : false | |
} | |
], | |
"name" : "dept_emp_latest_date", | |
"id" : "dept_emp_latest_date", | |
"packageName" : "com.speedment.enterprise.benchmark.joins.db.dept_emp_latest_date", | |
"enabled" : true | |
} | |
], | |
"expanded" : true, | |
"name" : "employees", | |
"id" : "employees", | |
"enabled" : true | |
} | |
], | |
"typeName" : "MySQL", | |
"ipAddress" : "127.0.0.1", | |
"name" : "employees", | |
"id" : "employees", | |
"enabled" : true, | |
"username" : "root" | |
} | |
], | |
"enabled" : true | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment