#region License

// Copyright 2005-2019 Paul Kohler (https://github.com/paulkohler/minisqlquery). All rights reserved.
// This source code is made available under the terms of the GNU Lesser General Public License v3.0
// https://github.com/paulkohler/minisqlquery/blob/master/LICENSE
#endregion

using System.Text;
using MiniSqlQuery.Core.DbModel;
using WeifenLuo.WinFormsUI.Docking;

namespace MiniSqlQuery.Core.Commands
{
    /// <summary>
    /// 	The display db model dependencies command.
    /// </summary>
    public class DisplayDbModelDependenciesCommand
        : CommandBase
    {
        /// <summary>
        /// 	Initializes a new instance of the <see cref = "DisplayDbModelDependenciesCommand" /> class.
        /// </summary>
        public DisplayDbModelDependenciesCommand()
            : base("Order Tables by FK Dependencies")
        {
            SmallImage = ImageResource.table_link;
        }

        /// <summary>
        /// 	Execute the command.
        /// </summary>
        public override void Execute()
        {
            var editor = Services.Resolve<IEditor>("txt-editor");
            editor.FileName = null;
            HostWindow.DisplayDockedForm(editor as DockContent);

            if (HostWindow.DatabaseInspector.DbSchema == null)
            {
                HostWindow.DatabaseInspector.LoadDatabaseDetails();
            }

            var dependencyWalker = new DbModelDependencyWalker(HostWindow.DatabaseInspector.DbSchema);
            var tables = dependencyWalker.SortTablesByForeignKeyReferences();

            var sb = new StringBuilder();
            foreach (DbModelTable table in tables)
            {
                sb.AppendLine(table.FullName);
            }

            editor.AllText = sb.ToString();
        }

        /// <summary>
        /// Gets a value indicating that the command can be executed (requires a connection).
        /// </summary>
        public override bool Enabled
        {
            get
            {
                return Services.Settings.ConnectionDefinition != null;
            }
        }
    }
}