/// <summary>
/// Parse the string and if it is valid build an instance of <see cref="CommandBase" />
/// </summary>
/// <param name="command"></param>
/// <returns></returns>
public CommandBase Parse(string command)
{
CommandBase result = null;
var atoms = new List <string>();
command = command.Trim();
//DUMP target directory
if (Parse(command, "^DUMP\\s*(.*)", atoms))
{
result = new CommandDump {
CmdType = CommandType.Dump
};
if (atoms.Count == 1)
{
var dir = atoms[0];
result.Params.Add(dir);
result.Success = true;
}
else
{
result.Success = false;
result.ErrorMessage = "DUMP comand needs one parameter";
}
}
//RESTORE source_directory
if (Parse(command, "^RESTORE\\s*(.*)", atoms))
{
result = new CommandRestore {
CmdType = CommandType.Restore
};
if (atoms.Count == 1)
{
var dir = atoms[0];
result.Params.Add(dir);
result.Success = true;
}
else
{
result.Success = false;
result.ErrorMessage = "Restore comand needs one parameter";
}
}
//RESTORE source_directory
if (Parse(command, "^IMPORT\\s*(.*)", atoms))
{
result = new CommandImport {
CmdType = CommandType.Import
};
if (atoms.Count == 1)
{
var dir = atoms[0];
result.Params.Add(dir);
result.Success = true;
}
else
{
result.Success = false;
result.ErrorMessage = "Import comand needs one parameter";
}
}
//RECREATE source directory
if (Parse(command, "^RECREATE\\s*(.*)", atoms))
{
result = new CommandRecreate {
CmdType = CommandType.Recreate
};
if (atoms.Count == 1)
{
var dir = atoms[0];
result.Params.Add(dir);
result.Success = true;
}
else
{
result.Success = false;
result.ErrorMessage = "Recreate comand needs 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 {
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
};
result.Success = true;
}
//STOP
else if (Parse(command, "^STOP", atoms))
{
result = new CommandStop
{
CmdType = CommandType.Stop,
Success = true
};
}
//STOP
else if (Parse(command, "^DROP", atoms))
{
result = new CommandDrop
{
CmdType = CommandType.Drop,
Success = true
};
}
else if (Parse(command, "^READONLY", atoms))
{
result = new CommandReadOnly
{
CmdType = CommandType.ReadOnly,
Success = true
};
}
else if (Parse(command, "^READWRITE", atoms))
{
result = new CommandReadWrite
{
CmdType = CommandType.ReadWrite,
Success = true
};
}
else if (Parse(command, "(^SELECT\\s+FROM|SELECT)\\s+(.+)\\s+(WHERE)\\s+(.+)", atoms))
{
result = new CommandSelect {
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].Trim();
// add a parameter for the file name
result.Params.Add(parts[1].Trim());
}
}
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, "(^SEARCH)\\s+([a-zA-Z0-9\\.]+)\\s+(.+)", atoms))
{
result = new CommandSearch {
CmdType = CommandType.Search
};
if (atoms.Count != 3)
{
Logger.WriteEror("Invalid syntax for SEARCH. Type HELP SEARCH for more information");
}
else
{
result.Params.Add(atoms[1]); //table
result.Params.Add(atoms[2]); //query
try
{
var typeDescription = GetTypeDescriptionByName(atoms[1]);
var builder = new QueryBuilder(typeDescription);
var ftQuery = atoms[2];
result.Query = builder.GetMany();
result.Query.FullTextSearch = ftQuery;
result.Query.Take = 10;// limit the number of results when searching in admin console
result.Success = true;
}
catch (Exception ex)
{
Logger.WriteEror("Invalid full-text search request. Type HELP SEARCH for more information",
ex.Message);
}
}
}
else if (Parse(command, "(^DELETE\\s+FROM|DELETE)\\s+(.+)\\s+(WHERE)\\s+(.+)", atoms))
{
result = new CommandDelete {
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 {
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+(\\w+)\\s?(WHERE)?\\s?(.*)", atoms))
{
result = new CommandCount {
CmdType = CommandType.Count
};
if (atoms.Count != 4 && atoms.Count != 2)
{
Logger.WriteEror("Invalid syntax for COUNT. Type HELP COUNT for more information");
}
else
{
result.Params.Add(atoms[1]); //table
if (atoms.Count == 4)
{
result.Params.Add(atoms[3]); //query
}
try
{
var typeDescription = GetTypeDescriptionByName(atoms[1]);
var builder = new QueryBuilder(typeDescription);
if (atoms.Count == 4)
{
result.Query = builder.GetManyWhere(atoms[3]);
}
else
{
result.Query = new OrQuery(typeDescription);
}
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 {
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";
}
}
//CONNECT server port or CONNECT config.xml
else if (Parse(command, "^CONNECT\\s*(.*)", atoms))
{
result = new CommandConnect {
CmdType = CommandType.Connect
};
if (atoms.Count == 1)
{
var parts = atoms[0].Split();
result.Params.Add(parts[0]);
if (parts.Length == 2)
{
result.Params.Add(parts[1]);
}
}
result.Success = true;
}
if (result != null)
{
return(result);
}
return(new CommandBase());
}
/// <summary>
/// Parse the string and if it is valid build an instance of <see cref="CommandBase" />
/// </summary>
/// <param name="command"></param>
/// <returns></returns>
public CommandBase Parse(string command)
{
CommandBase result = null;
var atoms = new List <string>();
command = command.Trim();
//DUMP target directory
if (Parse(command, "^DUMP\\s*(.*)", atoms))
{
result = new CommandDump {
CmdType = CommandType.Dump
};
if (atoms.Count == 1)
{
var dir = atoms[0];
result.Params.Add(dir);
result.Success = true;
}
else
{
result.Success = false;
result.ErrorMessage = "DUMP command needs one parameter";
}
return(result);
}
//RESTORE source_directory
if (Parse(command, "^RESTORE\\s*(.*)", atoms))
{
result = new CommandRestore {
CmdType = CommandType.Restore
};
if (atoms.Count == 1)
{
var dir = atoms[0];
result.Params.Add(dir);
result.Success = true;
}
else
{
result.Success = false;
result.ErrorMessage = "Restore command needs one parameter";
}
return(result);
}
//IMPORT source_directory
if (Parse(command, "^IMPORT\\s*(.*)", atoms))
{
result = new CommandImport {
CmdType = CommandType.Import
};
if (atoms.Count == 1)
{
var dir = atoms[0];
result.Params.Add(dir);
result.Success = true;
}
else
{
result.Success = false;
result.ErrorMessage = "Import command needs one parameter";
}
return(result);
}
//RECREATE source directory
if (Parse(command, "^RECREATE\\s*(.*)", atoms))
{
result = new CommandRecreate {
CmdType = CommandType.Recreate
};
if (atoms.Count == 1)
{
var dir = atoms[0];
result.Params.Add(dir);
result.Success = true;
}
else
{
result.Success = false;
result.ErrorMessage = "Recreate command needs one parameter";
}
return(result);
}
//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>";
}
return(result);
}
//EXIT
if (Parse(command, "^EXIT", atoms))
{
result = new CommandBase {
CmdType = CommandType.Exit, Success = true
};
result.Success = true;
return(result);
}
//STOP
if (Parse(command, "^STOP", atoms))
{
return(new CommandStop
{
CmdType = CommandType.Stop,
Success = true
});
}
//STOP
if (Parse(command, "^DROP", atoms))
{
return(new CommandDrop
{
CmdType = CommandType.Drop,
Success = true
});
}
if (Parse(command, "^READONLY", atoms))
{
return(new CommandReadOnly
{
CmdType = CommandType.ReadOnly,
Success = true
});
}
if (Parse(command, "^READWRITE", atoms))
{
result = new CommandReadWrite
{
CmdType = CommandType.ReadWrite,
Success = true
};
}
if (command.Trim().ToLower().StartsWith("select"))
{
result = new CommandSelect {
CmdType = CommandType.Select
};
try
{
var sqlParser = new Parser();
var selectNode = sqlParser.ParseSql(command);
var table = selectNode.Children.FirstOrDefault(n => n.Token == "from")?.Children.FirstOrDefault()
?.Token;
if (table == null)
{
throw new NotSupportedException("Invalid syntax for SELECT. No table name");
}
var schema = GetTypeDescriptionByName(table);
if (schema == null)
{
throw new NotSupportedException($"Unknown table {table}");
}
var query = selectNode.ToQuery(schema);
result.Query = query;
var intoFile = selectNode.Children.FirstOrDefault(n => n.Token == "into")?.Children.FirstOrDefault()
?.Token;
if (intoFile != null)
{
result.Params.Add(intoFile);
}
result.Success = true;
}
catch (Exception e)
{
Logger.WriteEror($"Error in command {e.Message}");
result.Success = false;
}
return(result);
}
//TODO
if (Parse(command, "(^SEARCH)\\s+([a-zA-Z0-9\\.]+)\\s+(.+)", atoms))
{
result = new CommandSearch {
CmdType = CommandType.Search
};
if (atoms.Count != 3)
{
Logger.WriteEror("Invalid syntax for SEARCH. Type HELP SEARCH for more information");
}
else
{
result.Params.Add(atoms[1]); //table
result.Params.Add(atoms[2]); //query
try
{
var typeDescription = GetTypeDescriptionByName(atoms[1]);
var ftQuery = atoms[2];
result.Query = new OrQuery(typeDescription.CollectionName)
{
FullTextSearch = ftQuery, Take = 10
};
// limit the number of results when searching in admin console
result.Success = true;
}
catch (Exception ex)
{
Logger.WriteEror("Invalid full-text search request. Type HELP SEARCH for more information",
ex.Message);
}
}
}
else if (Parse(command, "(^DELETE\\s+FROM|DELETE)\\s+(.+)\\s+(WHERE)\\s+(.+)", atoms))
{
result = new CommandDelete {
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.FromSql(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 {
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.CollectionName);
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+(\\w+)\\s?(WHERE)?\\s?(.*)", atoms))
{
result = new CommandCount {
CmdType = CommandType.Count
};
if (atoms.Count != 4 && atoms.Count != 2)
{
Logger.WriteEror("Invalid syntax for COUNT. Type HELP COUNT for more information");
}
else
{
result.Params.Add(atoms[1]); //table
if (atoms.Count == 4)
{
result.Params.Add(atoms[3]); //query
}
try
{
var typeDescription = GetTypeDescriptionByName(atoms[1]);
var builder = new QueryBuilder(typeDescription);
if (atoms.Count == 4)
{
result.Query = builder.FromSql(atoms[3]);
}
else
{
result.Query = new OrQuery(typeDescription.CollectionName);
}
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 {
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 command has at most one parameter";
}
}
//CONNECT server port or CONNECT config.xml
else if (Parse(command, "^CONNECT\\s*(.*)", atoms))
{
result = new CommandConnect {
CmdType = CommandType.Connect
};
if (atoms.Count == 1)
{
var parts = atoms[0].Split();
result.Params.Add(parts[0]);
if (parts.Length == 2)
{
result.Params.Add(parts[1]);
}
}
result.Success = true;
}
if (result != null)
{
return(result);
}
return(new CommandBase());
}