Exemplo n.º 1
0
        public static async Task ExecuteCommand(string command, List <string> parameters, List <string> words)
        {
            switch (command)
            {
            case "crtdb":
            {
                if (parameters[0] == "dbname")
                {
                    await RequestSender.CreateDatabaseAsync(words[2]);
                }
                break;
            }

            case "loaddb":
            {
                if (parameters[0] == "dbname")
                {
                    await RequestSender.LoadDatabase(words[2]);
                }
                break;
            }

            case "crtabl":
            {
                if (parameters[0] == "dbname" && parameters[1] == "tablname")
                {
                    await RequestSender.CreateTable(words[2], words[4]);
                }
                break;
            }

            case "addcol":
            {
                if (parameters[0] == "dbname" && parameters[1] == "tablname" &&
                    parameters[2] == "colname" && parameters[3] == "coltype")
                {
                    await RequestSender.AddColumn(words[2], words[4], words[6], words[8]);
                }
                break;
            }

            case "addrow":
            {
                if (parameters[0] == "dbname" && parameters[1] == "tablname")
                {
                    string row = "";
                    for (int i = 5; i < words.Count; i++)
                    {
                        row += words[i];
                        row += '&';
                    }
                    await RequestSender.AddRow(words[2], words[4], row);
                }
                break;
            }

            case "showrows":
            {
                if (parameters[0] == "dbname" && parameters[1] == "tablname")
                {
                    await RequestSender.ShowRows(words[2], words[4]);
                }
                break;
            }

            case "editrow":
            {
                if (parameters[0] == "dbname" && parameters[1] == "tablname" && parameters[2] == "id")
                {
                    string row = "";
                    for (int i = 7; i < words.Count; i++)
                    {
                        row += words[i];
                        row += '&';
                    }
                    await RequestSender.EditRow(words[2], words[4], Convert.ToInt32(words[6]), row);
                }
                break;
            }

            case "intabl":
            {
                if (parameters[0] == "dbname" && parameters[1] == "tablname" && parameters[2] == "tablname" && parameters[3] == "tablname")
                {
                    await RequestSender.IntersectTables(words[2], words[4], words[6], words[8]);
                }
                break;
            }

            case "deltabl":
            {
                if (parameters[0] == "dbname" && parameters[1] == "tablname")
                {
                    await RequestSender.DeleteTable(words[2], words[4]);
                }
                break;
            }

            default:
            {
                Console.WriteLine("Error in command: " + command);
                break;
            }
            }
        }