public void GetDdlTest3()
{
var dbVm = new DbViewModel();
var table = new TableViewModel("TEST");
dbVm.Tables.Add(table);
var col1 = new ColumInfo("COL1", new FieldType(8, null, null, null, null, 4), new ColumConstraintsInfo(ConstraintsKind.Primary), "SARARY", false, true, "");
table.Colums.Add(new ColumViewMoodel(col1));
var col2 = new ColumInfo("COL2", new FieldType(37, null, 100, null, null, 400), new ColumConstraintsInfo(ConstraintsKind.Primary), "NAME", false, true, "");
table.Colums.Add(new ColumViewMoodel(col2));
var col3 = new ColumInfo("COL3", new FieldType(35, null, null, null, null, 8), new ColumConstraintsInfo(ConstraintsKind.None), "RDB$3", false, true, "");
table.Colums.Add(new ColumViewMoodel(col3));
var col4 = new ColumInfo("COL4", new FieldType(261, null, null, null, null, 8), new ColumConstraintsInfo(ConstraintsKind.None), "RDB$4", true, true, "");
table.Colums.Add(new ColumViewMoodel(col4));
var col5 = new ColumInfo("COL5", new FieldType(37, null, 100, null, null, 400), new ColumConstraintsInfo(ConstraintsKind.None), "NAME", true, true, "");
table.Colums.Add(new ColumViewMoodel(col5));
var col6 = new ColumInfo("COL6", new FieldType(37, null, 100, null, null, 400), new ColumConstraintsInfo(ConstraintsKind.None), "MEMO", true, true, "DEFAULT 'HOGE'");
table.Colums.Add(new ColumViewMoodel(col6));
var col7 = new ColumInfo("COL7", new FieldType(37, null, 100, null, null, 400), new ColumConstraintsInfo(ConstraintsKind.None), "MEMO2", true, false, "DEFAULT 'HOGE2'");
table.Colums.Add(new ColumViewMoodel(col7));
var idx = new IndexInfo();
idx.Name = "COMPLEXKEY";
idx.TableName = table.TableName;
idx.Kind = FAManagementStudio.Common.ConstraintsKind.Primary;
idx.FieldNames.Add(col1.ColumName);
idx.FieldNames.Add(col2.ColumName);
var idxVm = new IndexViewModel(idx);
dbVm.Indexes.Add(idxVm);
table.Indexs.Add(idxVm);
table.GetDdl(dbVm).Is(
"CREATE DOMAIN SARARY AS INTEGER;" + Environment.NewLine +
"CREATE DOMAIN NAME AS VARCHAR(100);" + Environment.NewLine +
"CREATE DOMAIN MEMO AS VARCHAR(100) DEFAULT 'HOGE';" + Environment.NewLine +
"CREATE DOMAIN MEMO2 AS VARCHAR(100) NOT NULL DEFAULT 'HOGE2';" + Environment.NewLine +
"CREATE TABLE TEST (" + Environment.NewLine +
" COL1 SARARY NOT NULL," + Environment.NewLine +
" COL2 NAME NOT NULL," + Environment.NewLine +
" COL3 TIMESTAMP NOT NULL," + Environment.NewLine +
" COL4 BLOB," + Environment.NewLine +
" COL5 NAME," + Environment.NewLine +
" COL6 MEMO," + Environment.NewLine +
" COL7 MEMO2," + Environment.NewLine +
" CONSTRAINT COMPLEXKEY PRIMARY KEY (COL1, COL2)" + Environment.NewLine +
")");
}
