miniSql

创建
zgc123@gmail.com authored at 11/19/2023 1:40:15 AM
1.40 KiB
GenerateInsertStatementCommand.cs
#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.IO;
using MiniSqlQuery.Core;
using MiniSqlQuery.Core.DbModel;

namespace MiniSqlQuery.PlugIns.DatabaseInspector.Commands
{
    /// <summary>The generate insert statement command.</summary>
    internal class GenerateInsertStatementCommand : GenerateStatementCommandBase
    {
        /// <summary>Initializes a new instance of the <see cref="GenerateInsertStatementCommand"/> class.</summary>
        public GenerateInsertStatementCommand()
            : base("Generate Insert Statement")
        {
        }

        /// <summary>Execute the command.</summary>
        public override void Execute()
        {
            IQueryEditor editor = ActiveFormAsSqlQueryEditor;
            string tableName = HostWindow.DatabaseInspector.RightClickedTableName;
            DbModelInstance model = HostWindow.DatabaseInspector.DbSchema;

            if (tableName != null && editor != null)
            {
                StringWriter sql = new StringWriter();
                SqlWriter.WriteInsert(sql, GetTableOrViewByName(model, tableName));
                editor.InsertText(sql.ToString());
            }
        }
    }
}