public static bool HandleSelection(string input)
{
switch (input)
{
case "1":
NewQueryHandler();
break;
case "2":
Database.PrintCatalog();
break;
case "3":
SurlyFileReader.LoadFile();
break;
case "4":
Database.PrintDatabase();
break;
case "5":
PrintHelp();
break;
case "6":
MakeEpic("\n\tCome again soon!");
return(false);
default:
Console.WriteLine($"\n{input} is not an option. Please enter a valid selection.");
return(true);
}
return(true);
}
public static void ExecuteQuery(this SurlyDatabase database, string line)
{
Set(Cyan);
if (line.ToUpper().Contains("PROJECT"))
{
database.Project(line);
return;
}
if (line.ToUpper().Contains("VIEW"))
{
database.CreateView(line);
return;
}
if (line.ToUpper().Contains("SELECT"))
{
database.Select(line);
return;
}
if (line.ToUpper().Contains("JOIN"))
{
database.Join(line);
return;
}
if (line.ToUpper().Contains("PRINT CATALOG"))
{
database.PrintCatalog();
return;
}
var steps = line.Split(' ').ToList();
switch (steps[0].ToUpper())
{
case "RELATION":
database.CreateTable(steps[1].ToUpper(), line);
break;
case "INSERT":
database.AddTuples(steps[1].ToUpper(), line);
break;
case "PRINT":
database.Print(line);
break;
case "DELETE":
database.Delete(steps[1], line);
break;
case "DESTROY":
database.DestroyTable(steps[1].Replace(";", "").ToUpper(), line);
break;
default:
WriteLine($"\n\tUnknown command: {steps[0].ToUpper()}, please see help for recognized commands", Red);
break;
}
}