/// <summary>
/// Instantiate a command attached to a cache client
/// </summary>
/// <param name="client"></param>
public CommandDelete(Core.CacheClient client)
{
_client = client;
}
/// <summary>
/// Instantiate a command attached to a cache client
/// </summary>
/// <param name="client"></param>
public CommandSelect(Core.CacheClient client)
{
_client = client;
}
/// <summary>
/// Parse the string and if it is valid build an instance of <see cref="CommandBase" />
/// </summary>
/// <param name="command"></param>
/// <param name="client"></param>
/// <returns></returns>
public CommandBase Parse(string command, Core.CacheClient client)
{
CommandBase result = null;
var atoms = new List <string>();
command = command.Trim();
//DUMP filename/DUMP
if (Parse(command, "^DUMP\\s*(.*)", atoms))
{
result = new CommandDump {
CmdType = CommandType.Dump
};
if (atoms.Count <= 1)
{
if (atoms.Count == 1)
{
var fileName = atoms[0];
result.Params.Add(fileName);
}
result.Success = true;
}
else
{
result.Success = false;
result.ErrorMessage = "DUMP comand has at most one parameter";
}
}
//HELP command/HELP
if (Parse(command, "^HELP\\s*(.*)", atoms))
{
result = new CommandHelp {
CmdType = CommandType.Help
};
if (atoms.Count <= 1)
{
if (atoms.Count == 1)
{
var cmd = atoms[0];
result.Params.Add(cmd);
}
result.Success = true;
}
else
{
result.Success = false;
result.ErrorMessage = "usage HELP or HELP <command>";
}
}
//LAST lines
else if (Parse(command, "^LAST\\s*(.*)", atoms))
{
result = new CommandLast(client)
{
CmdType = CommandType.Log
};
if (atoms.Count == 1)
{
var lines = atoms[0];
if (int.TryParse(lines, out _))
{
result.Params.Add(lines);
result.Success = true;
}
}
else if (atoms.Count == 0)
{
result.Params.Add("1");
result.Success = true;
}
else
{
result.Success = false;
result.ErrorMessage = "LAST comand has at most one parameter";
}
}
//EXIT
else if (Parse(command, "^EXIT", atoms))
{
result = new CommandBase {
CmdType = CommandType.Exit, Success = true
};
}
else if (Parse(command, "(^SELECT\\s+FROM|SELECT)\\s+(.+)\\s+(WHERE)\\s+(.+)", atoms))
{
result = new CommandSelect(client)
{
CmdType = CommandType.Select
};
if (atoms.Count != 4)
{
Logger.WriteEror("Invalid syntax for SELECT. Type HELP SELECT for more information");
}
else
{
result.Params.Add(atoms[1]); //table
result.Params.Add(atoms[3]); //query
try
{
var typeDescription = GetTypeDescriptionByName(atoms[1]);
var builder = new QueryBuilder(typeDescription);
var query = atoms[3];
if (query.ToLower().Contains("into"))
{
var parts = query.Split(new[] { "into", "INTO" }, StringSplitOptions.RemoveEmptyEntries);
if (parts.Length == 2)
{
query = parts[0];
// add a parameter for the file name
result.Params.Add(parts[1]);
}
}
result.Query = builder.GetManyWhere(query);
result.Success = true;
}
catch (Exception ex)
{
Logger.WriteEror("Invalid WHERE clause: {0}. Type HELP SELECT for more information",
ex.Message);
}
}
}
else if (Parse(command, "(^DELETE\\s+FROM|DELETE)\\s+(.+)\\s+(WHERE)\\s+(.+)", atoms))
{
result = new CommandDelete(client)
{
CmdType = CommandType.Delete
};
if (atoms.Count != 4)
{
Logger.WriteEror("Invalid syntax for DELETE. Type HELP DELETE for more information");
}
else
{
result.Params.Add(atoms[1]); //table
result.Params.Add(atoms[3]); //query
try
{
var typeDescription = GetTypeDescriptionByName(atoms[1]);
var builder = new QueryBuilder(typeDescription);
result.Query = builder.GetManyWhere(atoms[3]);
result.Success = true;
}
catch (Exception ex)
{
Logger.WriteEror("Invalid WHERE clause: {0}. Type HELP DELETE for more information",
ex.Message);
}
}
}
else if (Parse(command, "^TRUNCATE\\s+(.+)", atoms))
{
result = new CommandDelete(client)
{
CmdType = CommandType.Delete
};
if (atoms.Count != 1)
{
Logger.WriteEror("Invalid syntax for TRUNCATE. Type HELP TRUNCATE for more information");
}
else
{
result.Params.Add(atoms[0]); //table
try
{
var typeDescription = GetTypeDescriptionByName(atoms[0]);
result.Query = new OrQuery(typeDescription.FullTypeName);
result.Success = true;
}
catch (Exception ex)
{
Logger.WriteEror("Invalid command: {0}", ex.Message);
}
}
}
//COUNT [FROM] table where column1=value1, column2=value2 ...("," means AND)
else if (Parse(command, "(^COUNT\\s+FROM|COUNT)\\s+(.+)\\s+(WHERE)\\s+(.+)", atoms))
{
result = new CommandCount(client)
{
CmdType = CommandType.Count
};
if (atoms.Count != 4)
{
Logger.WriteEror("Invalid syntax for COUNT. Type HELP COUNT for more information");
}
else
{
result.Params.Add(atoms[1]); //table
result.Params.Add(atoms[3]); //query
try
{
var typeDescription = GetTypeDescriptionByName(atoms[1]);
var builder = new QueryBuilder(typeDescription);
result.Query = builder.GetManyWhere(atoms[3]);
result.Success = true;
}
catch (Exception ex)
{
Logger.WriteEror("Invalid WHERE clause: {0}. Type HELP COUNT for more information", ex.Message);
}
}
}
//DESC table / DESC (the second form displays information on the server)
else if (Parse(command, "^DESC\\s*(.*)", atoms))
{
result = new CommandDesc(client)
{
CmdType = CommandType.Desc
};
if (atoms.Count <= 1)
{
if (atoms.Count == 1)
{
var fileName = atoms[0];
result.Params.Add(fileName);
}
result.Success = true;
}
else
{
result.Success = false;
result.ErrorMessage = "DESC comand has at most one parameter";
}
}
if (result != null)
{
return(result);
}
return(new CommandBase());
}
/// <summary>
/// Instantiate a command attached to a cache client
/// </summary>
/// <param name="client"></param>
public CommandCount(Core.CacheClient client)
{
_client = client;
}
/// <summary>
/// </summary>
/// <param name="client"></param>
public CommandLast(Core.CacheClient client)
{
_client = client;
}
