package com.company.sakila.generated; import com.speedment.common.annotation.GeneratedCode; import com.speedment.runtime.core.internal.AbstractApplicationMetadata; import java.util.Optional; import java.util.stream.Stream; /** * A {@link com.speedment.runtime.core.ApplicationMetadata} class for the {@link * com.speedment.runtime.config.Project} named sakila. This class contains the * meta data present at code generation time. * <p> * This file has been automatically generated by Speedment. Any changes made to * it will be overwritten. * * @author Speedment */ @GeneratedCode("Speedment") public class GeneratedSakilaMetadata extends AbstractApplicationMetadata { private final static String METADATA = init(); private static String init() { final StringBuilder sb = new StringBuilder(); initPart0(sb); initPart1(sb); initPart2(sb); initPart3(sb); initPart4(sb); initPart5(sb); initPart6(sb); initPart7(sb); initPart8(sb); initPart9(sb); initPart10(sb); initPart11(sb); initPart12(sb); initPart13(sb); initPart14(sb); initPart15(sb); initPart16(sb); initPart17(sb); initPart18(sb); initPart19(sb); initPart20(sb); initPart21(sb); return sb.toString(); } @Override protected Optional<String> getMetadata() { return Optional.of(METADATA); } private static void initPart0(StringBuilder sb) { Stream.of( "{", " \"config\" : {", " \"expanded\" : true,", " \"companyName\" : \"company\",", " \"name\" : \"sakila\",", " \"packageLocation\" : \"src/main/java/\",", " \"id\" : \"sakila\",", " \"dbmses\" : [", " {", " \"expanded\" : true,", " \"port\" : 3306,", " \"schemas\" : [", " {", " \"tables\" : [", " {", " \"expanded\" : true,", " \"primaryKeyColumns\" : [", " {", " \"expanded\" : true,", " \"name\" : \"actor_id\",", " \"id\" : \"actor_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"indexes\" : [", " {", " \"expanded\" : false,", " \"unique\" : true,", " \"name\" : \"PRIMARY\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"actor_id\",", " \"id\" : \"actor_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"PRIMARY\",", " \"enabled\" : true", " },", " {", " \"expanded\" : false,", " \"unique\" : false,", " \"name\" : \"idx_actor_last_name\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"last_name\",", " \"id\" : \"last_name\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"idx_actor_last_name\",", " \"enabled\" : true", " }", " ],", " \"columns\" : [", " {", " \"databaseType\" : \"java.lang.Integer\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"autoIncrement\" : true,", " \"name\" : \"actor_id\",", " \"id\" : \"actor_id\",", " \"ordinalPosition\" : 1,", " \"enabled\" : true", " },", " {", " \"databaseType\" : \"java.lang.String\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"first_name\",", " \"id\" : \"first_name\",", " \"ordinalPosition\" : 2,", " \"enabled\" : true", " },", " {", " \"databaseType\" : \"java.lang.String\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"last_name\",", " \"id\" : \"last_name\",", " \"ordinalPosition\" : 3,", " \"enabled\" : true", " },", " {", " \"databaseType\" : \"java.sql.Timestamp\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"last_update\",", " \"id\" : \"last_update\",", " \"ordinalPosition\" : 4,", " \"enabled\" : true", " }", " ],", " \"name\" : \"actor\",", " \"id\" : \"actor\",", " \"enabled\" : true" ).forEachOrdered(sb::append); } private static void initPart1(StringBuilder sb) { Stream.of( " },", " {", " \"foreignKeys\" : [", " {", " \"expanded\" : false,", " \"foreignKeyColumns\" : [", " {", " \"foreignDatabaseName\" : \"db0\",", " \"foreignSchemaName\" : \"sakila\",", " \"expanded\" : true,", " \"name\" : \"city_id\",", " \"foreignColumnName\" : \"city_id\",", " \"id\" : \"city_id\",", " \"foreignTableName\" : \"city\",", " \"ordinalPosition\" : 1", " }", " ],", " \"name\" : \"fk_address_city\",", " \"id\" : \"fk_address_city\",", " \"enabled\" : true", " }", " ],", " \"expanded\" : true,", " \"primaryKeyColumns\" : [", " {", " \"expanded\" : true,", " \"name\" : \"address_id\",", " \"id\" : \"address_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"indexes\" : [", " {", " \"expanded\" : false,", " \"unique\" : true,", " \"name\" : \"PRIMARY\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"address_id\",", " \"id\" : \"address_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"PRIMARY\",", " \"enabled\" : true", " },", " {", " \"expanded\" : false,", " \"unique\" : false,", " \"name\" : \"idx_fk_city_id\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"city_id\",", " \"id\" : \"city_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"idx_fk_city_id\",", " \"enabled\" : true", " },", " {", " \"expanded\" : false,", " \"unique\" : false,", " \"name\" : \"idx_location\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"location\",", " \"id\" : \"location\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"idx_location\",", " \"enabled\" : true", " }", " ],", " \"columns\" : [", " {", " \"databaseType\" : \"java.lang.Integer\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"autoIncrement\" : true,", " \"name\" : \"address_id\",", " \"id\" : \"address_id\",", " \"ordinalPosition\" : 1,", " \"enabled\" : true", " },", " {", " \"databaseType\" : \"java.lang.String\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"address\",", " \"id\" : \"address\",", " \"ordinalPosition\" : 2,", " \"enabled\" : true" ).forEachOrdered(sb::append); } private static void initPart2(StringBuilder sb) { Stream.of( " },", " {", " \"databaseType\" : \"java.lang.String\",", " \"expanded\" : true,", " \"nullable\" : true,", " \"name\" : \"address2\",", " \"id\" : \"address2\",", " \"ordinalPosition\" : 3,", " \"enabled\" : true", " },", " {", " \"databaseType\" : \"java.lang.String\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"district\",", " \"id\" : \"district\",", " \"ordinalPosition\" : 4,", " \"enabled\" : true", " },", " {", " \"databaseType\" : \"java.lang.Integer\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"city_id\",", " \"id\" : \"city_id\",", " \"ordinalPosition\" : 5,", " \"enabled\" : true", " },", " {", " \"databaseType\" : \"java.lang.String\",", " \"expanded\" : true,", " \"nullable\" : true,", " \"name\" : \"postal_code\",", " \"id\" : \"postal_code\",", " \"ordinalPosition\" : 6,", " \"enabled\" : true", " },", " {", " \"databaseType\" : \"java.lang.String\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"phone\",", " \"id\" : \"phone\",", " \"ordinalPosition\" : 7,", " \"enabled\" : true", " },", " {", " \"databaseType\" : \"java.sql.Blob\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"autoIncrement\" : false,", " \"name\" : \"location\",", " \"nullableImplementation\" : \"OPTIONAL\",", " \"id\" : \"location\",", " \"ordinalPosition\" : 8,", " \"enabled\" : true", " },", " {", " \"databaseType\" : \"java.sql.Timestamp\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"last_update\",", " \"id\" : \"last_update\",", " \"ordinalPosition\" : 9,", " \"enabled\" : true", " }", " ],", " \"name\" : \"address\",", " \"id\" : \"address\",", " \"enabled\" : true", " },", " {", " \"expanded\" : true,", " \"primaryKeyColumns\" : [", " {", " \"expanded\" : true,", " \"name\" : \"category_id\",", " \"id\" : \"category_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"indexes\" : [", " {", " \"expanded\" : false,", " \"unique\" : true,", " \"name\" : \"PRIMARY\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"category_id\",", " \"id\" : \"category_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"PRIMARY\",", " \"enabled\" : true", " }", " ],", " \"columns\" : [" ).forEachOrdered(sb::append); } private static void initPart3(StringBuilder sb) { Stream.of( " {", " \"databaseType\" : \"java.lang.Short\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"autoIncrement\" : true,", " \"name\" : \"category_id\",", " \"id\" : \"category_id\",", " \"ordinalPosition\" : 1,", " \"enabled\" : true", " },", " {", " \"databaseType\" : \"java.lang.String\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"name\",", " \"id\" : \"name\",", " \"ordinalPosition\" : 2,", " \"enabled\" : true", " },", " {", " \"databaseType\" : \"java.sql.Timestamp\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"last_update\",", " \"id\" : \"last_update\",", " \"ordinalPosition\" : 3,", " \"enabled\" : true", " }", " ],", " \"name\" : \"category\",", " \"id\" : \"category\",", " \"enabled\" : true", " },", " {", " \"foreignKeys\" : [", " {", " \"expanded\" : false,", " \"foreignKeyColumns\" : [", " {", " \"foreignDatabaseName\" : \"db0\",", " \"foreignSchemaName\" : \"sakila\",", " \"expanded\" : true,", " \"name\" : \"country_id\",", " \"foreignColumnName\" : \"country_id\",", " \"id\" : \"country_id\",", " \"foreignTableName\" : \"country\",", " \"ordinalPosition\" : 1", " }", " ],", " \"name\" : \"fk_city_country\",", " \"id\" : \"fk_city_country\",", " \"enabled\" : true", " }", " ],", " \"expanded\" : true,", " \"primaryKeyColumns\" : [", " {", " \"expanded\" : true,", " \"name\" : \"city_id\",", " \"id\" : \"city_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"indexes\" : [", " {", " \"expanded\" : false,", " \"unique\" : true,", " \"name\" : \"PRIMARY\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"city_id\",", " \"id\" : \"city_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"PRIMARY\",", " \"enabled\" : true", " },", " {", " \"expanded\" : false,", " \"unique\" : false,", " \"name\" : \"idx_fk_country_id\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"country_id\",", " \"id\" : \"country_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"idx_fk_country_id\",", " \"enabled\" : true", " }", " ],", " \"columns\" : [", " {", " \"databaseType\" : \"java.lang.Integer\"," ).forEachOrdered(sb::append); } private static void initPart4(StringBuilder sb) { Stream.of( " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"autoIncrement\" : true,", " \"name\" : \"city_id\",", " \"id\" : \"city_id\",", " \"ordinalPosition\" : 1,", " \"enabled\" : true", " },", " {", " \"databaseType\" : \"java.lang.String\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"city\",", " \"id\" : \"city\",", " \"ordinalPosition\" : 2,", " \"enabled\" : true", " },", " {", " \"databaseType\" : \"java.lang.Integer\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"country_id\",", " \"id\" : \"country_id\",", " \"ordinalPosition\" : 3,", " \"enabled\" : true", " },", " {", " \"databaseType\" : \"java.sql.Timestamp\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"last_update\",", " \"id\" : \"last_update\",", " \"ordinalPosition\" : 4,", " \"enabled\" : true", " }", " ],", " \"name\" : \"city\",", " \"id\" : \"city\",", " \"enabled\" : true", " },", " {", " \"expanded\" : true,", " \"primaryKeyColumns\" : [", " {", " \"expanded\" : true,", " \"name\" : \"country_id\",", " \"id\" : \"country_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"indexes\" : [", " {", " \"expanded\" : false,", " \"unique\" : true,", " \"name\" : \"PRIMARY\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"country_id\",", " \"id\" : \"country_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"PRIMARY\"", " }", " ],", " \"columns\" : [", " {", " \"databaseType\" : \"java.lang.Integer\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"autoIncrement\" : true,", " \"name\" : \"country_id\",", " \"id\" : \"country_id\",", " \"ordinalPosition\" : 1,", " \"enabled\" : true", " },", " {", " \"databaseType\" : \"java.lang.String\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"country\",", " \"id\" : \"country\",", " \"ordinalPosition\" : 2", " },", " {", " \"databaseType\" : \"java.sql.Timestamp\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"last_update\",", " \"id\" : \"last_update\",", " \"ordinalPosition\" : 3", " }", " ],", " \"name\" : \"country\",", " \"id\" : \"country\",", " \"enabled\" : true" ).forEachOrdered(sb::append); } private static void initPart5(StringBuilder sb) { Stream.of( " },", " {", " \"foreignKeys\" : [", " {", " \"expanded\" : false,", " \"foreignKeyColumns\" : [", " {", " \"foreignDatabaseName\" : \"db0\",", " \"foreignSchemaName\" : \"sakila\",", " \"expanded\" : true,", " \"name\" : \"address_id\",", " \"foreignColumnName\" : \"address_id\",", " \"id\" : \"address_id\",", " \"foreignTableName\" : \"address\",", " \"ordinalPosition\" : 1", " }", " ],", " \"name\" : \"fk_customer_address\",", " \"id\" : \"fk_customer_address\"", " },", " {", " \"expanded\" : false,", " \"foreignKeyColumns\" : [", " {", " \"foreignDatabaseName\" : \"db0\",", " \"foreignSchemaName\" : \"sakila\",", " \"expanded\" : true,", " \"name\" : \"store_id\",", " \"foreignColumnName\" : \"store_id\",", " \"id\" : \"store_id\",", " \"foreignTableName\" : \"store\",", " \"ordinalPosition\" : 1", " }", " ],", " \"name\" : \"fk_customer_store\",", " \"id\" : \"fk_customer_store\"", " }", " ],", " \"expanded\" : true,", " \"primaryKeyColumns\" : [", " {", " \"expanded\" : true,", " \"name\" : \"customer_id\",", " \"id\" : \"customer_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"indexes\" : [", " {", " \"expanded\" : false,", " \"unique\" : true,", " \"name\" : \"PRIMARY\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"customer_id\",", " \"id\" : \"customer_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"PRIMARY\"", " },", " {", " \"expanded\" : false,", " \"unique\" : false,", " \"name\" : \"idx_fk_address_id\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"address_id\",", " \"id\" : \"address_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"idx_fk_address_id\"", " },", " {", " \"expanded\" : false,", " \"unique\" : false,", " \"name\" : \"idx_fk_store_id\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"store_id\",", " \"id\" : \"store_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"idx_fk_store_id\"", " },", " {", " \"expanded\" : false,", " \"unique\" : false,", " \"name\" : \"idx_last_name\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true," ).forEachOrdered(sb::append); } private static void initPart6(StringBuilder sb) { Stream.of( " \"name\" : \"last_name\",", " \"id\" : \"last_name\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"idx_last_name\"", " }", " ],", " \"columns\" : [", " {", " \"databaseType\" : \"java.lang.Integer\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"autoIncrement\" : true,", " \"name\" : \"customer_id\",", " \"id\" : \"customer_id\",", " \"ordinalPosition\" : 1", " },", " {", " \"databaseType\" : \"java.lang.Short\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"store_id\",", " \"id\" : \"store_id\",", " \"ordinalPosition\" : 2", " },", " {", " \"databaseType\" : \"java.lang.String\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"first_name\",", " \"id\" : \"first_name\",", " \"ordinalPosition\" : 3", " },", " {", " \"databaseType\" : \"java.lang.String\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"last_name\",", " \"id\" : \"last_name\",", " \"ordinalPosition\" : 4", " },", " {", " \"databaseType\" : \"java.lang.String\",", " \"expanded\" : true,", " \"nullable\" : true,", " \"name\" : \"email\",", " \"id\" : \"email\",", " \"ordinalPosition\" : 5", " },", " {", " \"databaseType\" : \"java.lang.Integer\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"address_id\",", " \"id\" : \"address_id\",", " \"ordinalPosition\" : 6", " },", " {", " \"databaseType\" : \"java.lang.Integer\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"active\",", " \"id\" : \"active\",", " \"ordinalPosition\" : 7", " },", " {", " \"databaseType\" : \"java.sql.Timestamp\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"create_date\",", " \"id\" : \"create_date\",", " \"ordinalPosition\" : 8", " },", " {", " \"databaseType\" : \"java.sql.Timestamp\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"last_update\",", " \"id\" : \"last_update\",", " \"ordinalPosition\" : 9", " }", " ],", " \"name\" : \"customer\",", " \"id\" : \"customer\"", " },", " {", " \"foreignKeys\" : [", " {", " \"expanded\" : false,", " \"foreignKeyColumns\" : [", " {", " \"foreignDatabaseName\" : \"db0\",", " \"foreignSchemaName\" : \"sakila\",", " \"expanded\" : true,", " \"name\" : \"language_id\",", " \"foreignColumnName\" : \"language_id\"," ).forEachOrdered(sb::append); } private static void initPart7(StringBuilder sb) { Stream.of( " \"id\" : \"language_id\",", " \"foreignTableName\" : \"language\",", " \"ordinalPosition\" : 1", " }", " ],", " \"name\" : \"fk_film_language\",", " \"id\" : \"fk_film_language\"", " },", " {", " \"expanded\" : false,", " \"foreignKeyColumns\" : [", " {", " \"foreignDatabaseName\" : \"db0\",", " \"foreignSchemaName\" : \"sakila\",", " \"expanded\" : true,", " \"name\" : \"original_language_id\",", " \"foreignColumnName\" : \"language_id\",", " \"id\" : \"original_language_id\",", " \"foreignTableName\" : \"language\",", " \"ordinalPosition\" : 1", " }", " ],", " \"name\" : \"fk_film_language_original\",", " \"id\" : \"fk_film_language_original\"", " }", " ],", " \"expanded\" : true,", " \"primaryKeyColumns\" : [", " {", " \"expanded\" : true,", " \"name\" : \"film_id\",", " \"id\" : \"film_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"indexes\" : [", " {", " \"expanded\" : false,", " \"unique\" : true,", " \"name\" : \"PRIMARY\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"film_id\",", " \"id\" : \"film_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"PRIMARY\"", " },", " {", " \"expanded\" : false,", " \"unique\" : false,", " \"name\" : \"idx_film_rating\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"rating\",", " \"id\" : \"rating\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"idx_film_rating\"", " },", " {", " \"expanded\" : false,", " \"unique\" : false,", " \"name\" : \"idx_fk_language_id\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"language_id\",", " \"id\" : \"language_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"idx_fk_language_id\"", " },", " {", " \"expanded\" : false,", " \"unique\" : false,", " \"name\" : \"idx_fk_original_language_id\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"original_language_id\",", " \"id\" : \"original_language_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"idx_fk_original_language_id\"", " },", " {", " \"expanded\" : false,", " \"unique\" : false,", " \"name\" : \"idx_title\",", " \"indexColumns\" : [" ).forEachOrdered(sb::append); } private static void initPart8(StringBuilder sb) { Stream.of( " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"title\",", " \"id\" : \"title\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"idx_title\"", " }", " ],", " \"columns\" : [", " {", " \"databaseType\" : \"java.lang.Integer\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"autoIncrement\" : true,", " \"name\" : \"film_id\",", " \"id\" : \"film_id\",", " \"ordinalPosition\" : 1", " },", " {", " \"databaseType\" : \"java.lang.String\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"title\",", " \"id\" : \"title\",", " \"ordinalPosition\" : 2", " },", " {", " \"databaseType\" : \"java.lang.String\",", " \"expanded\" : true,", " \"nullable\" : true,", " \"name\" : \"description\",", " \"id\" : \"description\",", " \"ordinalPosition\" : 3", " },", " {", " \"databaseType\" : \"java.sql.Date\",", " \"expanded\" : true,", " \"nullable\" : true,", " \"name\" : \"release_year\",", " \"id\" : \"release_year\",", " \"ordinalPosition\" : 4", " },", " {", " \"databaseType\" : \"java.lang.Short\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"language_id\",", " \"id\" : \"language_id\",", " \"ordinalPosition\" : 5", " },", " {", " \"databaseType\" : \"java.lang.Short\",", " \"expanded\" : true,", " \"nullable\" : true,", " \"name\" : \"original_language_id\",", " \"id\" : \"original_language_id\",", " \"ordinalPosition\" : 6", " },", " {", " \"databaseType\" : \"java.lang.Short\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"rental_duration\",", " \"id\" : \"rental_duration\",", " \"ordinalPosition\" : 7", " },", " {", " \"databaseType\" : \"java.math.BigDecimal\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"rental_rate\",", " \"id\" : \"rental_rate\",", " \"ordinalPosition\" : 8", " },", " {", " \"databaseType\" : \"java.lang.Integer\",", " \"expanded\" : true,", " \"nullable\" : true,", " \"name\" : \"length\",", " \"id\" : \"length\",", " \"ordinalPosition\" : 9", " },", " {", " \"databaseType\" : \"java.math.BigDecimal\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"replacement_cost\",", " \"id\" : \"replacement_cost\",", " \"ordinalPosition\" : 10", " },", " {", " \"databaseType\" : \"java.lang.String\",", " \"expanded\" : true,", " \"nullable\" : true,", " \"enumConstants\" : \"G,PG,PG-13,R,NC-17\"," ).forEachOrdered(sb::append); } private static void initPart9(StringBuilder sb) { Stream.of( " \"name\" : \"rating\",", " \"id\" : \"rating\",", " \"ordinalPosition\" : 11", " },", " {", " \"databaseType\" : \"java.lang.String\",", " \"expanded\" : true,", " \"nullable\" : true,", " \"name\" : \"special_features\",", " \"id\" : \"special_features\",", " \"ordinalPosition\" : 12", " },", " {", " \"databaseType\" : \"java.sql.Timestamp\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"last_update\",", " \"id\" : \"last_update\",", " \"ordinalPosition\" : 13", " }", " ],", " \"name\" : \"film\",", " \"id\" : \"film\"", " },", " {", " \"foreignKeys\" : [", " {", " \"expanded\" : false,", " \"foreignKeyColumns\" : [", " {", " \"foreignDatabaseName\" : \"db0\",", " \"foreignSchemaName\" : \"sakila\",", " \"expanded\" : true,", " \"name\" : \"actor_id\",", " \"foreignColumnName\" : \"actor_id\",", " \"id\" : \"actor_id\",", " \"foreignTableName\" : \"actor\",", " \"ordinalPosition\" : 1", " }", " ],", " \"name\" : \"fk_film_actor_actor\",", " \"id\" : \"fk_film_actor_actor\"", " },", " {", " \"expanded\" : false,", " \"foreignKeyColumns\" : [", " {", " \"foreignDatabaseName\" : \"db0\",", " \"foreignSchemaName\" : \"sakila\",", " \"expanded\" : true,", " \"name\" : \"film_id\",", " \"foreignColumnName\" : \"film_id\",", " \"id\" : \"film_id\",", " \"foreignTableName\" : \"film\",", " \"ordinalPosition\" : 1", " }", " ],", " \"name\" : \"fk_film_actor_film\",", " \"id\" : \"fk_film_actor_film\"", " }", " ],", " \"expanded\" : true,", " \"primaryKeyColumns\" : [", " {", " \"expanded\" : true,", " \"name\" : \"actor_id\",", " \"id\" : \"actor_id\",", " \"ordinalPosition\" : 1", " },", " {", " \"expanded\" : true,", " \"name\" : \"film_id\",", " \"id\" : \"film_id\",", " \"ordinalPosition\" : 2", " }", " ],", " \"indexes\" : [", " {", " \"expanded\" : false,", " \"unique\" : true,", " \"name\" : \"PRIMARY\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"actor_id\",", " \"id\" : \"actor_id\",", " \"ordinalPosition\" : 1", " },", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"film_id\",", " \"id\" : \"film_id\",", " \"ordinalPosition\" : 2", " }", " ],", " \"id\" : \"PRIMARY\"", " },", " {", " \"expanded\" : false," ).forEachOrdered(sb::append); } private static void initPart10(StringBuilder sb) { Stream.of( " \"unique\" : false,", " \"name\" : \"idx_fk_film_id\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"film_id\",", " \"id\" : \"film_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"idx_fk_film_id\"", " }", " ],", " \"columns\" : [", " {", " \"databaseType\" : \"java.lang.Integer\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"actor_id\",", " \"id\" : \"actor_id\",", " \"ordinalPosition\" : 1", " },", " {", " \"databaseType\" : \"java.lang.Integer\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"film_id\",", " \"id\" : \"film_id\",", " \"ordinalPosition\" : 2", " },", " {", " \"databaseType\" : \"java.sql.Timestamp\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"last_update\",", " \"id\" : \"last_update\",", " \"ordinalPosition\" : 3", " }", " ],", " \"name\" : \"film_actor\",", " \"id\" : \"film_actor\"", " },", " {", " \"foreignKeys\" : [", " {", " \"expanded\" : false,", " \"foreignKeyColumns\" : [", " {", " \"foreignDatabaseName\" : \"db0\",", " \"foreignSchemaName\" : \"sakila\",", " \"expanded\" : true,", " \"name\" : \"category_id\",", " \"foreignColumnName\" : \"category_id\",", " \"id\" : \"category_id\",", " \"foreignTableName\" : \"category\",", " \"ordinalPosition\" : 1", " }", " ],", " \"name\" : \"fk_film_category_category\",", " \"id\" : \"fk_film_category_category\"", " },", " {", " \"expanded\" : false,", " \"foreignKeyColumns\" : [", " {", " \"foreignDatabaseName\" : \"db0\",", " \"foreignSchemaName\" : \"sakila\",", " \"expanded\" : true,", " \"name\" : \"film_id\",", " \"foreignColumnName\" : \"film_id\",", " \"id\" : \"film_id\",", " \"foreignTableName\" : \"film\",", " \"ordinalPosition\" : 1", " }", " ],", " \"name\" : \"fk_film_category_film\",", " \"id\" : \"fk_film_category_film\"", " }", " ],", " \"expanded\" : true,", " \"primaryKeyColumns\" : [", " {", " \"expanded\" : true,", " \"name\" : \"category_id\",", " \"id\" : \"category_id\",", " \"ordinalPosition\" : 2", " },", " {", " \"expanded\" : true,", " \"name\" : \"film_id\",", " \"id\" : \"film_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"indexes\" : [", " {", " \"expanded\" : false,", " \"unique\" : true," ).forEachOrdered(sb::append); } private static void initPart11(StringBuilder sb) { Stream.of( " \"name\" : \"PRIMARY\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"film_id\",", " \"id\" : \"film_id\",", " \"ordinalPosition\" : 1", " },", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"category_id\",", " \"id\" : \"category_id\",", " \"ordinalPosition\" : 2", " }", " ],", " \"id\" : \"PRIMARY\"", " },", " {", " \"expanded\" : false,", " \"unique\" : false,", " \"name\" : \"fk_film_category_category\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"category_id\",", " \"id\" : \"category_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"fk_film_category_category\"", " }", " ],", " \"columns\" : [", " {", " \"databaseType\" : \"java.lang.Integer\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"film_id\",", " \"id\" : \"film_id\",", " \"ordinalPosition\" : 1", " },", " {", " \"databaseType\" : \"java.lang.Short\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"category_id\",", " \"id\" : \"category_id\",", " \"ordinalPosition\" : 2", " },", " {", " \"databaseType\" : \"java.sql.Timestamp\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"last_update\",", " \"id\" : \"last_update\",", " \"ordinalPosition\" : 3", " }", " ],", " \"name\" : \"film_category\",", " \"id\" : \"film_category\"", " },", " {", " \"expanded\" : true,", " \"primaryKeyColumns\" : [", " {", " \"expanded\" : true,", " \"name\" : \"film_id\",", " \"id\" : \"film_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"indexes\" : [", " {", " \"expanded\" : false,", " \"unique\" : true,", " \"name\" : \"PRIMARY\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"film_id\",", " \"id\" : \"film_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"PRIMARY\"", " },", " {", " \"expanded\" : false,", " \"unique\" : false,", " \"name\" : \"idx_title_description\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"NONE\",", " \"expanded\" : true,", " \"name\" : \"title\"," ).forEachOrdered(sb::append); } private static void initPart12(StringBuilder sb) { Stream.of( " \"id\" : \"title\",", " \"ordinalPosition\" : 1", " },", " {", " \"orderType\" : \"NONE\",", " \"expanded\" : true,", " \"name\" : \"description\",", " \"id\" : \"description\",", " \"ordinalPosition\" : 2", " }", " ],", " \"id\" : \"idx_title_description\"", " }", " ],", " \"columns\" : [", " {", " \"databaseType\" : \"java.lang.Short\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"film_id\",", " \"id\" : \"film_id\",", " \"ordinalPosition\" : 1", " },", " {", " \"databaseType\" : \"java.lang.String\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"title\",", " \"id\" : \"title\",", " \"ordinalPosition\" : 2", " },", " {", " \"databaseType\" : \"java.lang.String\",", " \"expanded\" : true,", " \"nullable\" : true,", " \"name\" : \"description\",", " \"id\" : \"description\",", " \"ordinalPosition\" : 3", " }", " ],", " \"name\" : \"film_text\",", " \"id\" : \"film_text\"", " },", " {", " \"foreignKeys\" : [", " {", " \"expanded\" : false,", " \"foreignKeyColumns\" : [", " {", " \"foreignDatabaseName\" : \"db0\",", " \"foreignSchemaName\" : \"sakila\",", " \"expanded\" : true,", " \"name\" : \"film_id\",", " \"foreignColumnName\" : \"film_id\",", " \"id\" : \"film_id\",", " \"foreignTableName\" : \"film\",", " \"ordinalPosition\" : 1", " }", " ],", " \"name\" : \"fk_inventory_film\",", " \"id\" : \"fk_inventory_film\"", " },", " {", " \"expanded\" : false,", " \"foreignKeyColumns\" : [", " {", " \"foreignDatabaseName\" : \"db0\",", " \"foreignSchemaName\" : \"sakila\",", " \"expanded\" : true,", " \"name\" : \"store_id\",", " \"foreignColumnName\" : \"store_id\",", " \"id\" : \"store_id\",", " \"foreignTableName\" : \"store\",", " \"ordinalPosition\" : 1", " }", " ],", " \"name\" : \"fk_inventory_store\",", " \"id\" : \"fk_inventory_store\"", " }", " ],", " \"expanded\" : true,", " \"primaryKeyColumns\" : [", " {", " \"expanded\" : true,", " \"name\" : \"inventory_id\",", " \"id\" : \"inventory_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"indexes\" : [", " {", " \"expanded\" : false,", " \"unique\" : true,", " \"name\" : \"PRIMARY\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"inventory_id\",", " \"id\" : \"inventory_id\"," ).forEachOrdered(sb::append); } private static void initPart13(StringBuilder sb) { Stream.of( " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"PRIMARY\"", " },", " {", " \"expanded\" : false,", " \"unique\" : false,", " \"name\" : \"idx_fk_film_id\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"film_id\",", " \"id\" : \"film_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"idx_fk_film_id\"", " },", " {", " \"expanded\" : false,", " \"unique\" : false,", " \"name\" : \"idx_store_id_film_id\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"store_id\",", " \"id\" : \"store_id\",", " \"ordinalPosition\" : 1", " },", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"film_id\",", " \"id\" : \"film_id\",", " \"ordinalPosition\" : 2", " }", " ],", " \"id\" : \"idx_store_id_film_id\"", " }", " ],", " \"columns\" : [", " {", " \"databaseType\" : \"java.lang.Integer\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"autoIncrement\" : true,", " \"name\" : \"inventory_id\",", " \"id\" : \"inventory_id\",", " \"ordinalPosition\" : 1", " },", " {", " \"databaseType\" : \"java.lang.Integer\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"film_id\",", " \"id\" : \"film_id\",", " \"ordinalPosition\" : 2", " },", " {", " \"databaseType\" : \"java.lang.Short\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"store_id\",", " \"id\" : \"store_id\",", " \"ordinalPosition\" : 3", " },", " {", " \"databaseType\" : \"java.sql.Timestamp\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"last_update\",", " \"id\" : \"last_update\",", " \"ordinalPosition\" : 4", " }", " ],", " \"name\" : \"inventory\",", " \"id\" : \"inventory\"", " },", " {", " \"expanded\" : true,", " \"primaryKeyColumns\" : [", " {", " \"expanded\" : true,", " \"name\" : \"language_id\",", " \"id\" : \"language_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"indexes\" : [", " {", " \"expanded\" : false,", " \"unique\" : true,", " \"name\" : \"PRIMARY\",", " \"indexColumns\" : [", " {" ).forEachOrdered(sb::append); } private static void initPart14(StringBuilder sb) { Stream.of( " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"language_id\",", " \"id\" : \"language_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"PRIMARY\"", " }", " ],", " \"columns\" : [", " {", " \"databaseType\" : \"java.lang.Short\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"autoIncrement\" : true,", " \"name\" : \"language_id\",", " \"id\" : \"language_id\",", " \"ordinalPosition\" : 1", " },", " {", " \"databaseType\" : \"java.lang.String\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"name\",", " \"id\" : \"name\",", " \"ordinalPosition\" : 2", " },", " {", " \"databaseType\" : \"java.sql.Timestamp\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"last_update\",", " \"id\" : \"last_update\",", " \"ordinalPosition\" : 3", " }", " ],", " \"name\" : \"language\",", " \"id\" : \"language\"", " },", " {", " \"foreignKeys\" : [", " {", " \"expanded\" : false,", " \"foreignKeyColumns\" : [", " {", " \"foreignDatabaseName\" : \"db0\",", " \"foreignSchemaName\" : \"sakila\",", " \"expanded\" : true,", " \"name\" : \"customer_id\",", " \"foreignColumnName\" : \"customer_id\",", " \"id\" : \"customer_id\",", " \"foreignTableName\" : \"customer\",", " \"ordinalPosition\" : 1", " }", " ],", " \"name\" : \"fk_payment_customer\",", " \"id\" : \"fk_payment_customer\"", " },", " {", " \"expanded\" : false,", " \"foreignKeyColumns\" : [", " {", " \"foreignDatabaseName\" : \"db0\",", " \"foreignSchemaName\" : \"sakila\",", " \"expanded\" : true,", " \"name\" : \"rental_id\",", " \"foreignColumnName\" : \"rental_id\",", " \"id\" : \"rental_id\",", " \"foreignTableName\" : \"rental\",", " \"ordinalPosition\" : 1", " }", " ],", " \"name\" : \"fk_payment_rental\",", " \"id\" : \"fk_payment_rental\"", " },", " {", " \"expanded\" : false,", " \"foreignKeyColumns\" : [", " {", " \"foreignDatabaseName\" : \"db0\",", " \"foreignSchemaName\" : \"sakila\",", " \"expanded\" : true,", " \"name\" : \"staff_id\",", " \"foreignColumnName\" : \"staff_id\",", " \"id\" : \"staff_id\",", " \"foreignTableName\" : \"staff\",", " \"ordinalPosition\" : 1", " }", " ],", " \"name\" : \"fk_payment_staff\",", " \"id\" : \"fk_payment_staff\"", " }", " ],", " \"expanded\" : true,", " \"primaryKeyColumns\" : [", " {", " \"expanded\" : true,", " \"name\" : \"payment_id\",", " \"id\" : \"payment_id\"," ).forEachOrdered(sb::append); } private static void initPart15(StringBuilder sb) { Stream.of( " \"ordinalPosition\" : 1", " }", " ],", " \"indexes\" : [", " {", " \"expanded\" : false,", " \"unique\" : true,", " \"name\" : \"PRIMARY\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"payment_id\",", " \"id\" : \"payment_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"PRIMARY\"", " },", " {", " \"expanded\" : false,", " \"unique\" : false,", " \"name\" : \"fk_payment_rental\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"rental_id\",", " \"id\" : \"rental_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"fk_payment_rental\"", " },", " {", " \"expanded\" : false,", " \"unique\" : false,", " \"name\" : \"idx_fk_customer_id\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"customer_id\",", " \"id\" : \"customer_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"idx_fk_customer_id\"", " },", " {", " \"expanded\" : false,", " \"unique\" : false,", " \"name\" : \"idx_fk_staff_id\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"staff_id\",", " \"id\" : \"staff_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"idx_fk_staff_id\"", " }", " ],", " \"columns\" : [", " {", " \"databaseType\" : \"java.lang.Integer\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"autoIncrement\" : true,", " \"name\" : \"payment_id\",", " \"id\" : \"payment_id\",", " \"ordinalPosition\" : 1", " },", " {", " \"databaseType\" : \"java.lang.Integer\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"customer_id\",", " \"id\" : \"customer_id\",", " \"ordinalPosition\" : 2", " },", " {", " \"databaseType\" : \"java.lang.Short\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"staff_id\",", " \"id\" : \"staff_id\",", " \"ordinalPosition\" : 3", " },", " {", " \"databaseType\" : \"java.lang.Integer\",", " \"expanded\" : true,", " \"nullable\" : true,", " \"name\" : \"rental_id\",", " \"id\" : \"rental_id\",", " \"ordinalPosition\" : 4" ).forEachOrdered(sb::append); } private static void initPart16(StringBuilder sb) { Stream.of( " },", " {", " \"databaseType\" : \"java.math.BigDecimal\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"amount\",", " \"id\" : \"amount\",", " \"ordinalPosition\" : 5", " },", " {", " \"databaseType\" : \"java.sql.Timestamp\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"payment_date\",", " \"id\" : \"payment_date\",", " \"ordinalPosition\" : 6", " },", " {", " \"databaseType\" : \"java.sql.Timestamp\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"last_update\",", " \"id\" : \"last_update\",", " \"ordinalPosition\" : 7", " }", " ],", " \"name\" : \"payment\",", " \"id\" : \"payment\"", " },", " {", " \"foreignKeys\" : [", " {", " \"expanded\" : false,", " \"foreignKeyColumns\" : [", " {", " \"foreignDatabaseName\" : \"db0\",", " \"foreignSchemaName\" : \"sakila\",", " \"expanded\" : true,", " \"name\" : \"customer_id\",", " \"foreignColumnName\" : \"customer_id\",", " \"id\" : \"customer_id\",", " \"foreignTableName\" : \"customer\",", " \"ordinalPosition\" : 1", " }", " ],", " \"name\" : \"fk_rental_customer\",", " \"id\" : \"fk_rental_customer\"", " },", " {", " \"expanded\" : false,", " \"foreignKeyColumns\" : [", " {", " \"foreignDatabaseName\" : \"db0\",", " \"foreignSchemaName\" : \"sakila\",", " \"expanded\" : true,", " \"name\" : \"inventory_id\",", " \"foreignColumnName\" : \"inventory_id\",", " \"id\" : \"inventory_id\",", " \"foreignTableName\" : \"inventory\",", " \"ordinalPosition\" : 1", " }", " ],", " \"name\" : \"fk_rental_inventory\",", " \"id\" : \"fk_rental_inventory\"", " },", " {", " \"expanded\" : false,", " \"foreignKeyColumns\" : [", " {", " \"foreignDatabaseName\" : \"db0\",", " \"foreignSchemaName\" : \"sakila\",", " \"expanded\" : true,", " \"name\" : \"staff_id\",", " \"foreignColumnName\" : \"staff_id\",", " \"id\" : \"staff_id\",", " \"foreignTableName\" : \"staff\",", " \"ordinalPosition\" : 1", " }", " ],", " \"name\" : \"fk_rental_staff\",", " \"id\" : \"fk_rental_staff\"", " }", " ],", " \"expanded\" : true,", " \"primaryKeyColumns\" : [", " {", " \"expanded\" : true,", " \"name\" : \"rental_id\",", " \"id\" : \"rental_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"indexes\" : [", " {", " \"expanded\" : false,", " \"unique\" : true,", " \"name\" : \"PRIMARY\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true," ).forEachOrdered(sb::append); } private static void initPart17(StringBuilder sb) { Stream.of( " \"name\" : \"rental_id\",", " \"id\" : \"rental_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"PRIMARY\"", " },", " {", " \"expanded\" : false,", " \"unique\" : true,", " \"name\" : \"rental_date\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"rental_date\",", " \"id\" : \"rental_date\",", " \"ordinalPosition\" : 1", " },", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"customer_id\",", " \"id\" : \"customer_id\",", " \"ordinalPosition\" : 3", " },", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"inventory_id\",", " \"id\" : \"inventory_id\",", " \"ordinalPosition\" : 2", " }", " ],", " \"id\" : \"rental_date\"", " },", " {", " \"expanded\" : false,", " \"unique\" : false,", " \"name\" : \"idx_fk_customer_id\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"customer_id\",", " \"id\" : \"customer_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"idx_fk_customer_id\"", " },", " {", " \"expanded\" : false,", " \"unique\" : false,", " \"name\" : \"idx_fk_inventory_id\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"inventory_id\",", " \"id\" : \"inventory_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"idx_fk_inventory_id\"", " },", " {", " \"expanded\" : false,", " \"unique\" : false,", " \"name\" : \"idx_fk_staff_id\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"staff_id\",", " \"id\" : \"staff_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"idx_fk_staff_id\"", " }", " ],", " \"columns\" : [", " {", " \"databaseType\" : \"java.lang.Integer\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"autoIncrement\" : true,", " \"name\" : \"rental_id\",", " \"id\" : \"rental_id\",", " \"ordinalPosition\" : 1", " },", " {", " \"databaseType\" : \"java.sql.Timestamp\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"rental_date\",", " \"id\" : \"rental_date\",", " \"ordinalPosition\" : 2", " }," ).forEachOrdered(sb::append); } private static void initPart18(StringBuilder sb) { Stream.of( " {", " \"databaseType\" : \"java.lang.Integer\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"inventory_id\",", " \"id\" : \"inventory_id\",", " \"ordinalPosition\" : 3", " },", " {", " \"databaseType\" : \"java.lang.Integer\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"customer_id\",", " \"id\" : \"customer_id\",", " \"ordinalPosition\" : 4", " },", " {", " \"databaseType\" : \"java.sql.Timestamp\",", " \"expanded\" : true,", " \"nullable\" : true,", " \"name\" : \"return_date\",", " \"id\" : \"return_date\",", " \"ordinalPosition\" : 5", " },", " {", " \"databaseType\" : \"java.lang.Short\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"staff_id\",", " \"id\" : \"staff_id\",", " \"ordinalPosition\" : 6", " },", " {", " \"databaseType\" : \"java.sql.Timestamp\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"last_update\",", " \"id\" : \"last_update\",", " \"ordinalPosition\" : 7", " }", " ],", " \"name\" : \"rental\",", " \"id\" : \"rental\"", " },", " {", " \"foreignKeys\" : [", " {", " \"expanded\" : false,", " \"foreignKeyColumns\" : [", " {", " \"foreignDatabaseName\" : \"db0\",", " \"foreignSchemaName\" : \"sakila\",", " \"expanded\" : true,", " \"name\" : \"address_id\",", " \"foreignColumnName\" : \"address_id\",", " \"id\" : \"address_id\",", " \"foreignTableName\" : \"address\",", " \"ordinalPosition\" : 1", " }", " ],", " \"name\" : \"fk_staff_address\",", " \"id\" : \"fk_staff_address\"", " },", " {", " \"expanded\" : false,", " \"foreignKeyColumns\" : [", " {", " \"foreignDatabaseName\" : \"db0\",", " \"foreignSchemaName\" : \"sakila\",", " \"expanded\" : true,", " \"name\" : \"store_id\",", " \"foreignColumnName\" : \"store_id\",", " \"id\" : \"store_id\",", " \"foreignTableName\" : \"store\",", " \"ordinalPosition\" : 1", " }", " ],", " \"name\" : \"fk_staff_store\",", " \"id\" : \"fk_staff_store\"", " }", " ],", " \"expanded\" : true,", " \"primaryKeyColumns\" : [", " {", " \"expanded\" : true,", " \"name\" : \"staff_id\",", " \"id\" : \"staff_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"indexes\" : [", " {", " \"expanded\" : false,", " \"unique\" : true,", " \"name\" : \"PRIMARY\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\"," ).forEachOrdered(sb::append); } private static void initPart19(StringBuilder sb) { Stream.of( " \"expanded\" : true,", " \"name\" : \"staff_id\",", " \"id\" : \"staff_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"PRIMARY\"", " },", " {", " \"expanded\" : false,", " \"unique\" : false,", " \"name\" : \"idx_fk_address_id\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"address_id\",", " \"id\" : \"address_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"idx_fk_address_id\"", " },", " {", " \"expanded\" : false,", " \"unique\" : false,", " \"name\" : \"idx_fk_store_id\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"store_id\",", " \"id\" : \"store_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"idx_fk_store_id\"", " }", " ],", " \"columns\" : [", " {", " \"databaseType\" : \"java.lang.Short\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"autoIncrement\" : true,", " \"name\" : \"staff_id\",", " \"id\" : \"staff_id\",", " \"ordinalPosition\" : 1", " },", " {", " \"databaseType\" : \"java.lang.String\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"first_name\",", " \"id\" : \"first_name\",", " \"ordinalPosition\" : 2", " },", " {", " \"databaseType\" : \"java.lang.String\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"last_name\",", " \"id\" : \"last_name\",", " \"ordinalPosition\" : 3", " },", " {", " \"databaseType\" : \"java.lang.Integer\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"address_id\",", " \"id\" : \"address_id\",", " \"ordinalPosition\" : 4", " },", " {", " \"databaseType\" : \"java.sql.Blob\",", " \"expanded\" : true,", " \"nullable\" : true,", " \"name\" : \"picture\",", " \"id\" : \"picture\",", " \"ordinalPosition\" : 5", " },", " {", " \"databaseType\" : \"java.lang.String\",", " \"expanded\" : true,", " \"nullable\" : true,", " \"name\" : \"email\",", " \"id\" : \"email\",", " \"ordinalPosition\" : 6", " },", " {", " \"databaseType\" : \"java.lang.Short\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"store_id\",", " \"id\" : \"store_id\",", " \"ordinalPosition\" : 7", " },", " {" ).forEachOrdered(sb::append); } private static void initPart20(StringBuilder sb) { Stream.of( " \"databaseType\" : \"java.lang.Integer\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"active\",", " \"id\" : \"active\",", " \"ordinalPosition\" : 8", " },", " {", " \"databaseType\" : \"java.lang.String\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"username\",", " \"id\" : \"username\",", " \"ordinalPosition\" : 9", " },", " {", " \"databaseType\" : \"java.lang.String\",", " \"expanded\" : true,", " \"nullable\" : true,", " \"name\" : \"password\",", " \"id\" : \"password\",", " \"ordinalPosition\" : 10", " },", " {", " \"databaseType\" : \"java.sql.Timestamp\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"last_update\",", " \"id\" : \"last_update\",", " \"ordinalPosition\" : 11", " }", " ],", " \"name\" : \"staff\",", " \"id\" : \"staff\"", " },", " {", " \"foreignKeys\" : [", " {", " \"expanded\" : false,", " \"foreignKeyColumns\" : [", " {", " \"foreignDatabaseName\" : \"db0\",", " \"foreignSchemaName\" : \"sakila\",", " \"expanded\" : true,", " \"name\" : \"address_id\",", " \"foreignColumnName\" : \"address_id\",", " \"id\" : \"address_id\",", " \"foreignTableName\" : \"address\",", " \"ordinalPosition\" : 1", " }", " ],", " \"name\" : \"fk_store_address\",", " \"id\" : \"fk_store_address\"", " },", " {", " \"expanded\" : false,", " \"foreignKeyColumns\" : [", " {", " \"foreignDatabaseName\" : \"db0\",", " \"foreignSchemaName\" : \"sakila\",", " \"expanded\" : true,", " \"name\" : \"manager_staff_id\",", " \"foreignColumnName\" : \"staff_id\",", " \"id\" : \"manager_staff_id\",", " \"foreignTableName\" : \"staff\",", " \"ordinalPosition\" : 1", " }", " ],", " \"name\" : \"fk_store_staff\",", " \"id\" : \"fk_store_staff\"", " }", " ],", " \"expanded\" : true,", " \"primaryKeyColumns\" : [", " {", " \"expanded\" : true,", " \"name\" : \"store_id\",", " \"id\" : \"store_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"indexes\" : [", " {", " \"expanded\" : false,", " \"unique\" : true,", " \"name\" : \"idx_unique_manager\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"manager_staff_id\",", " \"id\" : \"manager_staff_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"idx_unique_manager\"", " },", " {", " \"expanded\" : false,", " \"unique\" : true," ).forEachOrdered(sb::append); } private static void initPart21(StringBuilder sb) { Stream.of( " \"name\" : \"PRIMARY\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"store_id\",", " \"id\" : \"store_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"PRIMARY\"", " },", " {", " \"expanded\" : false,", " \"unique\" : false,", " \"name\" : \"idx_fk_address_id\",", " \"indexColumns\" : [", " {", " \"orderType\" : \"ASC\",", " \"expanded\" : true,", " \"name\" : \"address_id\",", " \"id\" : \"address_id\",", " \"ordinalPosition\" : 1", " }", " ],", " \"id\" : \"idx_fk_address_id\"", " }", " ],", " \"columns\" : [", " {", " \"databaseType\" : \"java.lang.Short\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"autoIncrement\" : true,", " \"name\" : \"store_id\",", " \"id\" : \"store_id\",", " \"ordinalPosition\" : 1", " },", " {", " \"databaseType\" : \"java.lang.Short\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"manager_staff_id\",", " \"id\" : \"manager_staff_id\",", " \"ordinalPosition\" : 2", " },", " {", " \"databaseType\" : \"java.lang.Integer\",", " \"typeMapper\" : \"com.speedment.runtime.typemapper.primitive.PrimitiveTypeMapper\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"address_id\",", " \"id\" : \"address_id\",", " \"ordinalPosition\" : 3", " },", " {", " \"databaseType\" : \"java.sql.Timestamp\",", " \"expanded\" : true,", " \"nullable\" : false,", " \"name\" : \"last_update\",", " \"id\" : \"last_update\",", " \"ordinalPosition\" : 4", " }", " ],", " \"name\" : \"store\",", " \"id\" : \"store\"", " }", " ],", " \"expanded\" : true,", " \"name\" : \"sakila\",", " \"id\" : \"sakila\",", " \"enabled\" : true", " }", " ],", " \"typeName\" : \"MySQL\",", " \"ipAddress\" : \"127.0.0.1\",", " \"name\" : \"db0\",", " \"id\" : \"db0\",", " \"enabled\" : true,", " \"username\" : \"sakila-user\"", " }", " ],", " \"enabled\" : true", " }", "}" ).forEachOrdered(sb::append); } }