C# (CSharp) MsSql.ReCreate示例

示例#1

        public void ReCreateTest()
        {
            var server = Utility.LoadServers("TestData/servers.yml")["mssql"];
            var db     = Utility.LoadDataBase("TestData/mssql.yml");

            var sql = new MsSql(server, false);

            sql.Connect();
            var result = sql.ReCreate(db, false);

            _output.WriteLine(result.Query);
            Assert.True(result.Success);
        }

示例#2

        public void DiffTest()
        {
            var server = Utility.LoadServers("TestData/servers.yml")["mssql"];
            var db     = Utility.LoadDataBase("TestData/mssql.yml");

            var sql = new MsSql(server, false);
            var res = sql.Connect();

            sql.ReCreate(db, false);
            Utility.TrimDataBaseProperties(db);
            var diff = sql.Diff(db);

            Assert.False(diff.HasDiff);
        }

示例#3

        public void ExtractTest()
        {
            var server = Utility.LoadServers("TestData/servers.yml")["mssql"];
            var db     = Utility.LoadDataBase("TestData/mssql.yml");

            var sql = new MsSql(server, false);
            var res = sql.Connect();

            sql.ReCreate(db, false);
            Utility.TrimDataBaseProperties(db);

            var extract = sql.Extract();
            var yaml    = Utility.DataBaseToYaml(extract);

            _output.WriteLine(yaml);
            Assert.NotEmpty(extract.Tables);
        }