Esempio n. 1
0
        public static void Run(string[] args, TextWriter log)
        {
            log.WriteLine("{0} {1}", typeof(Program).Assembly.GetCustomAttributes(typeof(AssemblyProductAttribute), false).Cast <AssemblyProductAttribute>().Single().Product, typeof(Program).Assembly.GetCustomAttributes(typeof(AssemblyInformationalVersionAttribute), false).Cast <AssemblyInformationalVersionAttribute>().Single().InformationalVersion);
            log.WriteLine(typeof(Program).Assembly.GetCustomAttributes(typeof(AssemblyDescriptionAttribute), false).Cast <AssemblyDescriptionAttribute>().Single().Description);
            log.WriteLine(typeof(Program).Assembly.GetCustomAttributes(typeof(AssemblyCopyrightAttribute), false).Cast <AssemblyCopyrightAttribute>().Single().Copyright);

            var commandLineParser = new CommandLineParser <Options>();

            if (args.Length == 0)
            {
                log.WriteLine("Command line parameters:");
                commandLineParser.PrintHelp(log);
                return;
            }
            Options opts            = commandLineParser.Parse(args);
            var     db              = new MssqlDatabase(opts.ConnStr, opts.DbName, opts.Timeout, opts.MigrationsTableName);
            var     scriptBuilder   = new ScriptBuilder(db, log);
            var     migrationFilter = new MigrationFilter(new MigrationRepository(opts.MigrationsDir, opts.TextEncoding, db), db);

            string script;

            if (opts.Count >= 0)
            {
                log.WriteLine("Building Up script");
                script = scriptBuilder.BuildUp(migrationFilter.GetPendingMigrations(), opts.Count);
            }
            else
            {
                log.WriteLine("Building Down script");
                script = scriptBuilder.BuildDown(migrationFilter.GetApplyedMigrations(), -opts.Count);
            }

            if (string.IsNullOrWhiteSpace(opts.OutputFile))
            {
                log.WriteLine("Executing script to {0}", opts.ConnStr);
                db.Execute(script);
            }
            else
            {
                log.WriteLine("Saving script to {0}", opts.OutputFile);
                File.WriteAllText(opts.OutputFile, script, opts.TextEncoding);
            }
        }
Esempio n. 2
0
        public static void Run(string[] args, TextWriter log)
        {
            log.WriteLine("{0} {1}", typeof(Program).Assembly.GetCustomAttributes(typeof(AssemblyProductAttribute), false).Cast<AssemblyProductAttribute>().Single().Product, typeof(Program).Assembly.GetCustomAttributes(typeof(AssemblyInformationalVersionAttribute), false).Cast<AssemblyInformationalVersionAttribute>().Single().InformationalVersion);
            log.WriteLine(typeof(Program).Assembly.GetCustomAttributes(typeof(AssemblyDescriptionAttribute), false).Cast<AssemblyDescriptionAttribute>().Single().Description);
            log.WriteLine(typeof(Program).Assembly.GetCustomAttributes(typeof(AssemblyCopyrightAttribute), false).Cast<AssemblyCopyrightAttribute>().Single().Copyright);

            var commandLineParser = new CommandLineParser<Options>();
            if(args.Length == 0)
            {
                log.WriteLine("Command line parameters:");
                commandLineParser.PrintHelp(log);
                return;
            }
            Options opts = commandLineParser.Parse(args);
            var db = new MssqlDatabase(opts.ConnStr, opts.Timeout);
            var scriptBuilder = new ScriptBuilder(db, log);
            var migrationFilter = new MigrationFilter(new MigrationRepository(opts.MigrationsDir, opts.TextEncoding, db), db);

            string script;
            if(opts.Count >= 0)
            {
                log.WriteLine("Building Up script");
                script = scriptBuilder.BuildUp(migrationFilter.GetPendingMigrations(), opts.Count);
            }
            else
            {
                log.WriteLine("Building Down script");
                script = scriptBuilder.BuildDown(migrationFilter.GetApplyedMigrations(), -opts.Count);
            }

            if(string.IsNullOrWhiteSpace(opts.OutputFile))
            {
                log.WriteLine("Executing script to {0}", opts.ConnStr);
                db.Execute(script);
            }
            else
            {
                log.WriteLine("Saving script to {0}", opts.OutputFile);
                File.WriteAllText(opts.OutputFile, script, opts.TextEncoding);
            }
        }