コード例 #1
0
ファイル: BaseSync.cs プロジェクト: NATKazakhstan/AspWebGen
        public bool Execute(XDocument dbml, ScriptList scripts)
        {
            Doc     = dbml;
            Scripts = scripts;
            bool valid = false;

            try
            {
                try
                {
                    _isValidation = true;
                    valid         = Validate();
                    _isValidation = false;
                    Success       = valid && Execute() || !MustHave;
                }
                catch (CustomException)
                {
                    Success = !MustHave;
                }
            }
            catch (Exception e)
            {
                Error(e);
                Success = false;
            }
            finally
            {
                IsExecuted = true;
            }
            if (_sb != null)
            {
                Console.Write(_sb.ToString());
                Console.WriteLine("End");
            }
            return(Success);
        }
コード例 #2
0
        static void Main(string[] args)
        {
//            Thread.Sleep(10000);
            if (AutoUpdater.SuggestAndUpdate(false))
            {
                return;
            }
            //Thread.Sleep(3000);
            if (args == null || args.Length == 0 || args[0].ToUpper() == "HELP" || args[0] == "?")
            {
                Console.Write(Resources.Help);
                return;
            }

            string     scriptFile = args[0];
            string     dbmlFile   = args.Length > 1 ? args[1] : "";
            ScriptList scripts;

            var ser = new XmlSerializer(typeof(ScriptList));

            if (dbmlFile.ToUpper() == "CSS")
            {
                using (var stream = new FileStream(scriptFile, FileMode.Create, FileAccess.Write))
                {
                    var obj = new ScriptList(new BaseSync[]
                    {
                        new SyncAssociation {
                            AssociationName = "AssociationName"
                        },
                        new SyncColumn {
                            TableName = "TableName"
                        },
                        new SyncTable {
                            TableName = "TableName"
                        },
                    });
                    obj.Version = Version;
                    ser.Serialize(stream, obj);
                }
                return;
            }
            var isSdbml = Path.GetExtension(scriptFile).Equals(".sdbml", StringComparison.OrdinalIgnoreCase);

            if (isSdbml && dbmlFile == "")
            {
                dbmlFile = Path.GetFullPath(Path.Combine(Path.GetDirectoryName(scriptFile), "DB.dbml"));
                if (!File.Exists(dbmlFile))
                {
                    dbmlFile = Path.GetFullPath(Path.Combine(Path.GetDirectoryName(scriptFile), "../DB.dbml"));
                    if (!File.Exists(dbmlFile))
                    {
                        dbmlFile = Path.GetFullPath(Path.Combine(Path.GetDirectoryName(scriptFile), "../../DB.dbml"));
                    }
                }
            }

            if (string.IsNullOrEmpty(dbmlFile))
            {
                dbmlFile = "<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n"
                           + "<Database Class=\"DBDataContext\" xmlns=\"http://schemas.microsoft.com/linqtosql/dbml/2007\"></Database>";
            }

            var doc = XDocument.Load(dbmlFile);

            using (var stream = new FileStream(scriptFile, FileMode.Open, FileAccess.Read))
                scripts = (ScriptList)ser.Deserialize(stream);
            if (scripts.Version != Version)
            {
                Console.WriteLine("Version of file '{0}' not equals version of program '{1}'", scripts.Version, Version);
                return;
            }

            var syncManager = new ScriptManager();

            foreach (var publicSyncFile in Settings.Default.PublicSyncFiles)
            {
                var files = Directory.GetFiles(publicSyncFile, "*.sdbml", SearchOption.AllDirectories);
                syncManager.AddScripts <ScriptList, BaseSync>(files);
            }

            syncManager.MergeScripts <ScriptList, BaseSync>(scripts);

            var ignoreTables     = Settings.Default.IgnoreTables.Cast <string>().ToDictionary(s => s);
            var modifyOnlyTables = Settings.Default.ModifyOnlyTables.Cast <string>().ToDictionary(s => s);

            scripts.IgnoreTables     = ignoreTables;
            scripts.ModifyOnlyTables = modifyOnlyTables;
            foreach (var script in scripts.Scripts.Where(r => !r.SkipExecution))
            {
//                Console.WriteLine("Execute " + script.Command + " from " + script.GetType().FullName);
                if (script.IsChangeTables(ignoreTables))
                {
                    Console.WriteLine("Skip " + script.GetName());
                    continue;
                }
                if (modifyOnlyTables.Count > 0 && !script.IsChangeTables(modifyOnlyTables))
                {
                    Console.WriteLine("Skip " + script.GetName());
                    continue;
                }
                if ((!script.IsExecuted && !script.Execute(doc, scripts)) || (script.IsExecuted && !script.Success && script.MustHave))
                {
                    Console.WriteLine();
                    Console.WriteLine("Failed sync");
                    if (isSdbml)
                    {
                        Console.WriteLine("Do you want to ignore error? Y/N");
                        if (Console.ReadKey().Key == ConsoleKey.Y)
                        {
                            continue;
                        }
                        Console.WriteLine("Execution canceled. Press any key.");
                        Console.ReadKey();
                    }
                    return;
                }
            }
            doc.Save(dbmlFile + ".new");
            File.Replace(dbmlFile + ".new", dbmlFile, dbmlFile + ".bak");
            Console.WriteLine();
            Console.WriteLine("Successful sync");

            var codeFile  = Path.Combine(Path.GetDirectoryName(dbmlFile), "DB.designer.cs");
            var ns        = Path.GetFileName(Path.GetDirectoryName(dbmlFile));
            var arguments = "/namespace:" + ns + " \"/code:" + codeFile + "\" \"" + dbmlFile + "\"";
            var startInfo = new ProcessStartInfo(Settings.Default.SqlMetal, arguments);

            startInfo.RedirectStandardOutput = true;
            startInfo.UseShellExecute        = false;
            var process = Process.Start(startInfo);

            Console.WriteLine(process.StandardOutput.ReadToEnd());
            process.WaitForExit();

            if (isSdbml)
            {
                Console.WriteLine("Press any key");
                Console.Read();
            }
        }