ConsoleForm.cs

using System;
using Eto.Drawing;
using Eto.Forms;

namespace devtime
{
    public class ConsoleForm : Dialog
    {
        private readonly TextArea _outputArea;
        private readonly TextBox _inputBox;
        private readonly Button _executeButton;

        public ConsoleForm()
        {
            Title = "SQLite3 Console - devtime";
            Icon = IconLoader.LoadIcon("terminal.png");

            MinimumSize = new Size(531, 270);
            Resizable = true;

            var consoleFont = Fonts.Monospace(9);
            var consoleBg = Colors.Black;
            var consoleFg = Color.Parse("#E0E0E0");

            _outputArea = new TextArea
            {
                ReadOnly = true,
                Font = consoleFont,
                BackgroundColor = consoleBg,
                TextColor = consoleFg,
                Text = "SQLite 3 Console\n\nEnter a valid SQLite 3 query to execute it.\nType 'tables' to list all tables."
            };

            _inputBox = new TextBox
            {
                Font = consoleFont,
                BackgroundColor = consoleBg,
                TextColor = consoleFg
            };

            _executeButton = new Button
            {
                Text = ">>",
                Font = consoleFont
            };

            _inputBox.KeyDown += (s, e) =>
            {
                if (e.Key == Keys.Enter)
                {
                    Execute();
                    e.Handled = true;
                }
            };

            _executeButton.Click += (s, e) => Execute();

            var inputLayout = new TableLayout
            {


                Rows =
                {
                    new TableRow(new TableCell(_inputBox, true), new TableCell(_executeButton, false))
                }
            };

            Content = new TableLayout
            {
                Rows =
                {
                    new TableRow(_outputArea) { ScaleHeight = true },
                    new TableRow(inputLayout)
                }
            };

            _inputBox.Focus();
        }

        private void WriteLine(string text = "")
        {
            _outputArea.Append(text + Environment.NewLine, true);
        }

        private void Execute()
        {
            string input = _inputBox.Text.Trim();
            if (string.IsNullOrEmpty(input)) return;

            _inputBox.Text = "";
            _inputBox.Enabled = false;
            _executeButton.Enabled = false;

            WriteLine($"> {input}{Environment.NewLine}");

            HandleQuery(input);

            _inputBox.Enabled = true;
            _executeButton.Enabled = true;
            _inputBox.Focus();
        }

        private void HandleQuery(string query)
        {
            string cmd = query.ToLowerInvariant().Trim();

            if (cmd == "tables")
            {
                var tables = DB.ListTables();
                if (tables.Count == 0)
                {
                    WriteLine($"No tables found{Environment.NewLine}");
                }
                else
                {
                    foreach (var table in tables)
                    {
                        WriteLine(table);
                    }
                    WriteLine();
                }
            }
            else if (cmd == "clear" || cmd == "cls")
            {
                _outputArea.Text = "";
            }
            else
            {
                try
                {
                    string result = DB.ExecuteRaw(query);
                    WriteLine(result + Environment.NewLine);
                }
                catch (Exception ex)
                {
                    WriteLine(ex.Message + Environment.NewLine);
                }
            }
        }
    }
}