public void GetDdlTest1() { 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), "RDB$1", false, true, ""); table.Colums.Add(new ColumViewMoodel(col1)); var col2 = new ColumInfo("COL2", new FieldType(37, null, 100, null, null, 400), new ColumConstraintsInfo(ConstraintsKind.None), "RDB$2", 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 idx = new IndexInfo(); idx.Name = "RDB$PRIMARYKEY1"; idx.TableName = table.TableName; idx.Kind = ConstraintsKind.Primary; idx.FieldNames.Add(col1.ColumName); var idxVm = new IndexViewModel(idx); dbVm.Indexes.Add(idxVm); table.Indexs.Add(idxVm); table.GetDdl(dbVm).Is( "CREATE TABLE TEST (" + Environment.NewLine + " COL1 INTEGER NOT NULL," + Environment.NewLine + " COL2 VARCHAR(100) NOT NULL," + Environment.NewLine + " COL3 TIMESTAMP NOT NULL," + Environment.NewLine + " COL4 BLOB," + Environment.NewLine + " PRIMARY KEY (COL1)" + Environment.NewLine + ")"); }
public void GetDdlTest2() { 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), "RDB$1", 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), "RDB$2", 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(7, 1, null, 4, 0, 4), new ColumConstraintsInfo(ConstraintsKind.None), "RDB$4", true, true, ""); table.Colums.Add(new ColumViewMoodel(col5)); var col6 = new ColumInfo("COL6", new FieldType(8, 2, null, 4, -2, 4), new ColumConstraintsInfo(ConstraintsKind.None), "RDB$4", true, true, ""); table.Colums.Add(new ColumViewMoodel(col6)); var col7 = new ColumInfo("COL7", new FieldType(16, 2, null, 10, -4, 8), new ColumConstraintsInfo(ConstraintsKind.None), "RDB$4", true, true, ""); table.Colums.Add(new ColumViewMoodel(col7)); var idx = new IndexInfo(); idx.Name = "COMPLEXKEY"; idx.TableName = table.TableName; idx.Kind = 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 TABLE TEST (" + Environment.NewLine + " COL1 INTEGER NOT NULL," + Environment.NewLine + " COL2 VARCHAR(100) NOT NULL," + Environment.NewLine + " COL3 TIMESTAMP NOT NULL," + Environment.NewLine + " COL4 BLOB," + Environment.NewLine + " COL5 NUMERIC(4)," + Environment.NewLine + " COL6 DECIMAL(4,2)," + Environment.NewLine + " COL7 DECIMAL(10,4)," + Environment.NewLine + " CONSTRAINT COMPLEXKEY PRIMARY KEY (COL1, COL2)" + Environment.NewLine + ")"); }
public void GetDdlTest_ForignKey1() { 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), "RDB$1", false, true, ""); table.Colums.Add(new ColumViewMoodel(col1)); var col2 = new ColumInfo("COL2", new FieldType(37, null, 100, null, null, 400), new ColumConstraintsInfo(ConstraintsKind.Foreign), "RDB$2", false, true, ""); table.Colums.Add(new ColumViewMoodel(col2)); var col3 = new ColumInfo("COL3", new FieldType(35, null, null, null, null, 8), new ColumConstraintsInfo(ConstraintsKind.Foreign), "RDB$3", false, true, ""); table.Colums.Add(new ColumViewMoodel(col3)); var idx = new IndexInfo(); idx.Name = "RDB$PRIMARYKEY1"; idx.TableName = table.TableName; idx.Kind = ConstraintsKind.Primary; idx.FieldNames.Add(col1.ColumName); var idxVm = new IndexViewModel(idx); dbVm.Indexes.Add(idxVm); table.Indexs.Add(idxVm); var fpIdx1 = new IndexInfo(); fpIdx1.Name = "RDB$PRIMARYKEY2"; fpIdx1.TableName = "MASTER"; fpIdx1.Kind = ConstraintsKind.Primary; fpIdx1.FieldNames.Add("M_COL1"); var fpIdxVm1 = new IndexViewModel(fpIdx1); dbVm.Indexes.Add(fpIdxVm1); var idx1 = new IndexInfo(); idx1.Name = "RDB$FOREIGNKEY1"; idx1.TableName = table.TableName; idx1.Kind = ConstraintsKind.Foreign; idx1.ForigenKeyName = "RDB$PRIMARYKEY2"; idx1.FieldNames.Add(col2.ColumName); var idxVm1 = new IndexViewModel(idx1); dbVm.Indexes.Add(idxVm1); table.Indexs.Add(idxVm1); var fpIdx2 = new IndexInfo(); fpIdx2.Name = "RDB$PRIMARYKEY3"; fpIdx2.TableName = "MASTER"; fpIdx2.Kind = ConstraintsKind.Primary; fpIdx2.FieldNames.Add("M_COL2"); var fpIdxVm2 = new IndexViewModel(fpIdx2); dbVm.Indexes.Add(fpIdxVm2); var idx2 = new IndexInfo(); idx2.Name = "C_FOREIGNKEY"; idx2.TableName = table.TableName; idx2.Kind = ConstraintsKind.Foreign; idx2.ForigenKeyName = "RDB$PRIMARYKEY3"; idx2.DeleteRule = "SET DEFAULT"; idx2.UpdateRule = "CASCADE"; idx2.FieldNames.Add(col3.ColumName); var idxVm2 = new IndexViewModel(idx2); dbVm.Indexes.Add(idxVm2); table.Indexs.Add(idxVm2); table.GetDdl(dbVm).Is( "CREATE TABLE TEST (" + Environment.NewLine + " COL1 INTEGER NOT NULL," + Environment.NewLine + " COL2 VARCHAR(100) NOT NULL," + Environment.NewLine + " COL3 TIMESTAMP NOT NULL," + Environment.NewLine + " PRIMARY KEY (COL1)," + Environment.NewLine + " FOREIGN KEY (COL2) REFERENCES MASTER (M_COL1)," + Environment.NewLine + " CONSTRAINT C_FOREIGNKEY FOREIGN KEY (COL3) REFERENCES MASTER (M_COL2) ON DELETE SET DEFAULT ON UPDATE CASCADE" + Environment.NewLine + ")"); }
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 + ")"); }