public class org.finos.legend.engine.persistence.components.logicalplan.operations.CreateTableTest extends java.lang.Object
{
public void <init>()
{
org.finos.legend.engine.persistence.components.logicalplan.operations.CreateTableTest v;
v := @this: org.finos.legend.engine.persistence.components.logicalplan.operations.CreateTableTest;
specialinvoke v.<java.lang.Object: void <init>()>();
return;
}
public void testCreateTable()
{
org.finos.legend.engine.persistence.components.logicalplan.operations.CreateTableTest v;
org.finos.legend.engine.persistence.components.relational.SqlPlan v;
org.finos.legend.engine.persistence.components.logicalplan.datasets.SchemaDefinition v;
org.finos.legend.engine.persistence.components.logicalplan.LogicalPlan$Builder v, v;
org.finos.legend.engine.persistence.components.relational.RelationalSink v;
org.finos.legend.engine.persistence.components.relational.transformer.RelationalTransformer v;
org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder v, v, v, v, v, v;
org.finos.legend.engine.persistence.components.logicalplan.LogicalPlan v;
org.finos.legend.engine.persistence.components.logicalplan.operations.Create v;
java.util.List v;
java.lang.Object v;
org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition v;
v := @this: org.finos.legend.engine.persistence.components.logicalplan.operations.CreateTableTest;
v = staticinvoke <org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition: org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder builder()>();
v = virtualinvoke v.<org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder: org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder database(java.lang.String)>("my_db");
v = virtualinvoke v.<org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder: org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder group(java.lang.String)>("my_schema");
v = virtualinvoke v.<org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder: org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder name(java.lang.String)>("my_table");
v = virtualinvoke v.<org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder: org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder alias(java.lang.String)>("my_alias");
v = <org.finos.legend.engine.persistence.components.logicalplan.operations.BaseTestUtils: org.finos.legend.engine.persistence.components.logicalplan.datasets.SchemaDefinition schemaWithAllColumns>;
v = virtualinvoke v.<org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder: org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder schema(org.finos.legend.engine.persistence.components.logicalplan.datasets.SchemaDefinition)>(v);
v = virtualinvoke v.<org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder: org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition build()>();
v = staticinvoke <org.finos.legend.engine.persistence.components.logicalplan.operations.Create: org.finos.legend.engine.persistence.components.logicalplan.operations.Create of(boolean,org.finos.legend.engine.persistence.components.logicalplan.datasets.Dataset)>(1, v);
v = new org.finos.legend.engine.persistence.components.relational.transformer.RelationalTransformer;
v = staticinvoke <org.finos.legend.engine.persistence.components.relational.ansi.AnsiSqlSink: org.finos.legend.engine.persistence.components.relational.RelationalSink get()>();
specialinvoke v.<org.finos.legend.engine.persistence.components.relational.transformer.RelationalTransformer: void <init>(org.finos.legend.engine.persistence.components.relational.RelationalSink)>(v);
v = staticinvoke <org.finos.legend.engine.persistence.components.logicalplan.LogicalPlan: org.finos.legend.engine.persistence.components.logicalplan.LogicalPlan$Builder builder()>();
v = virtualinvoke v.<org.finos.legend.engine.persistence.components.logicalplan.LogicalPlan$Builder: org.finos.legend.engine.persistence.components.logicalplan.LogicalPlan$Builder addOps(org.finos.legend.engine.persistence.components.logicalplan.operations.Operation)>(v);
v = virtualinvoke v.<org.finos.legend.engine.persistence.components.logicalplan.LogicalPlan$Builder: org.finos.legend.engine.persistence.components.logicalplan.LogicalPlan build()>();
v = virtualinvoke v.<org.finos.legend.engine.persistence.components.relational.transformer.RelationalTransformer: org.finos.legend.engine.persistence.components.relational.SqlPlan generatePhysicalPlan(org.finos.legend.engine.persistence.components.logicalplan.LogicalPlan)>(v);
v = virtualinvoke v.<org.finos.legend.engine.persistence.components.relational.SqlPlan: java.util.List getSqlList()>();
v = interfaceinvoke v.<java.util.List: java.lang.Object get(int)>(0);
staticinvoke <org.junit.jupiter.api.Assertions: void assertEquals(java.lang.Object,java.lang.Object)>("CREATE TABLE IF NOT EXISTS \"my_db\".\"my_schema\".\"my_table\"(\"col_int\" INTEGER NOT NULL PRIMARY KEY,\"col_integer\" INTEGER NOT NULL UNIQUE,\"col_bigint\" BIGINT,\"col_tinyint\" TINYINT,\"col_smallint\" SMALLINT,\"col_char\" CHAR,\"col_varchar\" VARCHAR,\"col_string\" VARCHAR,\"col_timestamp\" TIMESTAMP,\"col_datetime\" DATETIME,\"col_date\" DATE,\"col_real\" REAL,\"col_float\" REAL,\"col_decimal\" DECIMAL(10,4),\"col_double\" DOUBLE,\"col_binary\" BINARY,\"col_time\" TIME,\"col_numeric\" NUMERIC,\"col_longtext\" LONGTEXT,\"col_boolean\" BOOLEAN,\"col_varbinary\" VARBINARY(10),\"col_bit\" BIT,INDEX \"my_idx\" (\"col_int\", \"col_varchar\"))", v);
return;
}
public void testCreateTableWithUpperCase()
{
org.finos.legend.engine.persistence.components.logicalplan.operations.CreateTableTest v;
org.finos.legend.engine.persistence.components.relational.SqlPlan v;
org.finos.legend.engine.persistence.components.logicalplan.datasets.TableType v;
org.finos.legend.engine.persistence.components.logicalplan.datasets.SchemaDefinition v;
org.finos.legend.engine.persistence.components.transformer.TransformOptions v;
org.finos.legend.engine.persistence.components.logicalplan.LogicalPlan$Builder v, v;
org.finos.legend.engine.persistence.components.relational.RelationalSink v;
org.finos.legend.engine.persistence.components.relational.ansi.optimizer.UpperCaseOptimizer v;
org.finos.legend.engine.persistence.components.relational.transformer.RelationalTransformer v;
org.finos.legend.engine.persistence.components.transformer.TransformOptions$Builder v, v;
org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetAdditionalProperties v;
org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder v, v, v, v, v, v, v;
org.finos.legend.engine.persistence.components.logicalplan.LogicalPlan v;
org.finos.legend.engine.persistence.components.logicalplan.operations.Create v;
java.util.List v;
java.lang.Object v;
org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetAdditionalProperties$Builder v, v;
org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition v;
v := @this: org.finos.legend.engine.persistence.components.logicalplan.operations.CreateTableTest;
v = staticinvoke <org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition: org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder builder()>();
v = virtualinvoke v.<org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder: org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder database(java.lang.String)>("my_db");
v = virtualinvoke v.<org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder: org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder group(java.lang.String)>("my_schema");
v = virtualinvoke v.<org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder: org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder name(java.lang.String)>("my_table");
v = virtualinvoke v.<org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder: org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder alias(java.lang.String)>("my_alias");
v = <org.finos.legend.engine.persistence.components.logicalplan.operations.BaseTestUtils: org.finos.legend.engine.persistence.components.logicalplan.datasets.SchemaDefinition schemaWithAllColumns>;
v = virtualinvoke v.<org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder: org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder schema(org.finos.legend.engine.persistence.components.logicalplan.datasets.SchemaDefinition)>(v);
v = staticinvoke <org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetAdditionalProperties: org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetAdditionalProperties$Builder builder()>();
v = <org.finos.legend.engine.persistence.components.logicalplan.datasets.TableType: org.finos.legend.engine.persistence.components.logicalplan.datasets.TableType TEMPORARY>;
v = virtualinvoke v.<org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetAdditionalProperties$Builder: org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetAdditionalProperties$Builder tableType(org.finos.legend.engine.persistence.components.logicalplan.datasets.TableType)>(v);
v = virtualinvoke v.<org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetAdditionalProperties$Builder: org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetAdditionalProperties build()>();
v = virtualinvoke v.<org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder: org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder datasetAdditionalProperties(org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetAdditionalProperties)>(v);
v = virtualinvoke v.<org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition$Builder: org.finos.legend.engine.persistence.components.logicalplan.datasets.DatasetDefinition build()>();
v = staticinvoke <org.finos.legend.engine.persistence.components.logicalplan.operations.Create: org.finos.legend.engine.persistence.components.logicalplan.operations.Create of(boolean,org.finos.legend.engine.persistence.components.logicalplan.datasets.Dataset)>(1, v);
v = staticinvoke <org.finos.legend.engine.persistence.components.logicalplan.LogicalPlan: org.finos.legend.engine.persistence.components.logicalplan.LogicalPlan$Builder builder()>();
v = virtualinvoke v.<org.finos.legend.engine.persistence.components.logicalplan.LogicalPlan$Builder: org.finos.legend.engine.persistence.components.logicalplan.LogicalPlan$Builder addOps(org.finos.legend.engine.persistence.components.logicalplan.operations.Operation)>(v);
v = virtualinvoke v.<org.finos.legend.engine.persistence.components.logicalplan.LogicalPlan$Builder: org.finos.legend.engine.persistence.components.logicalplan.LogicalPlan build()>();
v = new org.finos.legend.engine.persistence.components.relational.transformer.RelationalTransformer;
v = staticinvoke <org.finos.legend.engine.persistence.components.relational.ansi.AnsiSqlSink: org.finos.legend.engine.persistence.components.relational.RelationalSink get()>();
v = staticinvoke <org.finos.legend.engine.persistence.components.transformer.TransformOptions: org.finos.legend.engine.persistence.components.transformer.TransformOptions$Builder builder()>();
v = new org.finos.legend.engine.persistence.components.relational.ansi.optimizer.UpperCaseOptimizer;
specialinvoke v.<org.finos.legend.engine.persistence.components.relational.ansi.optimizer.UpperCaseOptimizer: void <init>()>();
v = virtualinvoke v.<org.finos.legend.engine.persistence.components.transformer.TransformOptions$Builder: org.finos.legend.engine.persistence.components.transformer.TransformOptions$Builder addOptimizers(org.finos.legend.engine.persistence.components.optimizer.Optimizer)>(v);
v = virtualinvoke v.<org.finos.legend.engine.persistence.components.transformer.TransformOptions$Builder: org.finos.legend.engine.persistence.components.transformer.TransformOptions build()>();
specialinvoke v.<org.finos.legend.engine.persistence.components.relational.transformer.RelationalTransformer: void <init>(org.finos.legend.engine.persistence.components.relational.RelationalSink,org.finos.legend.engine.persistence.components.transformer.TransformOptions)>(v, v);
v = virtualinvoke v.<org.finos.legend.engine.persistence.components.relational.transformer.RelationalTransformer: org.finos.legend.engine.persistence.components.relational.SqlPlan generatePhysicalPlan(org.finos.legend.engine.persistence.components.logicalplan.LogicalPlan)>(v);
v = virtualinvoke v.<org.finos.legend.engine.persistence.components.relational.SqlPlan: java.util.List getSqlList()>();
v = interfaceinvoke v.<java.util.List: java.lang.Object get(int)>(0);
staticinvoke <org.junit.jupiter.api.Assertions: void assertEquals(java.lang.Object,java.lang.Object)>("CREATE TEMPORARY TABLE IF NOT EXISTS \"MY_DB\".\"MY_SCHEMA\".\"MY_TABLE\"(\"COL_INT\" INTEGER NOT NULL PRIMARY KEY,\"COL_INTEGER\" INTEGER NOT NULL UNIQUE,\"COL_BIGINT\" BIGINT,\"COL_TINYINT\" TINYINT,\"COL_SMALLINT\" SMALLINT,\"COL_CHAR\" CHAR,\"COL_VARCHAR\" VARCHAR,\"COL_STRING\" VARCHAR,\"COL_TIMESTAMP\" TIMESTAMP,\"COL_DATETIME\" DATETIME,\"COL_DATE\" DATE,\"COL_REAL\" REAL,\"COL_FLOAT\" REAL,\"COL_DECIMAL\" DECIMAL(10,4),\"COL_DOUBLE\" DOUBLE,\"COL_BINARY\" BINARY,\"COL_TIME\" TIME,\"COL_NUMERIC\" NUMERIC,\"COL_LONGTEXT\" LONGTEXT,\"COL_BOOLEAN\" BOOLEAN,\"COL_VARBINARY\" VARBINARY(10),\"COL_BIT\" BIT,INDEX \"MY_IDX\" (\"COL_INT\", \"COL_VARCHAR\"))", v);
return;
}
}