/// <summary>
/// Returns table by use command.
/// </summary>
/// <param name="usecommand">Use command.</param>
public MochaTableResult GetTable(string usecommand, bool from)
{
MochaColumn GetColumn(string cmd, IList <MochaColumn> cols)
{
string decomposeBrackets(string value)
{
int dex;
if ((dex = value.IndexOf('(')) != -1)
{
return(value.Substring(dex + 1, value.Length - dex - 2));
}
return(value);
}
string name = Mhql_AS.GetAS(ref cmd);
if (Mhql_GRAMMAR.UseFunctions.MatchKey(cmd))
{
MochaColumn column = new MochaColumn();
column.MHQLAsText = name;
column.Tag =
Mhql_GRAMMAR.UseFunctions.GetValueByMatchKey(cmd);
if (column.Tag != "COUNT")
{
column.Description =
Mhql_GRAMMAR.GetIndexOfColumn(decomposeBrackets(cmd), cols, from).ToString();
}
return(column);
}
else
{
string colname = cmd.StartsWith("$") ? cmd.Substring(1).Trim() : cmd;
IEnumerable <MochaColumn> result = cols.Where(x => x.Name == colname);
if (!result.Any())
{
throw new Exception($"Could not find a column with the name '{cmd}'!");
}
MochaColumn column = result.First();
column.Tag = colname != cmd ? "$" : null;
column.MHQLAsText = name;
return(column);
}
}
List <MochaColumn> columns = new List <MochaColumn>();
MochaTableResult resulttable = new MochaTableResult();
if (from)
{
int dex = Mhql_FROM.GetIndex(ref usecommand);
string tablename = usecommand.Substring(dex + 5).Trim();
List <string> parts = Mhql_LEXER.SplitUseParameters(usecommand.Substring(0, dex));
List <MochaColumn> _columns = Tdb.GetColumns(tablename);
if (parts.Count == 1 && parts[0].Trim() == "*")
{
columns.AddRange(_columns);
}
else
{
if (parts[0].TrimStart().StartsWith("$") &&
parts[0].TrimStart().Substring(1).TrimStart().StartsWith($"{Mhql_LEXER.LBRACE}"))
{
throw new InvalidOperationException("Cannot be used with subquery FROM keyword!");
}
for (int index = 0; index < parts.Count; ++index)
{
columns.Add(GetColumn(parts[index].Trim(), _columns));
}
}
}
else
{
List <string> parts = Mhql_LEXER.SplitUseParameters(usecommand);
for (int index = 0; index < parts.Count; ++index)
{
string callcmd = parts[index].Trim();
if (callcmd == "*")
{
List <MochaTable> tables = Tdb.GetTables();
for (int tindex = 0; tindex < tables.Count; ++tindex)
{
columns.AddRange(tables[tindex].Columns);
}
continue;
}
int obrace = callcmd.IndexOf(Mhql_LEXER.LBRACE);
if (obrace != -1)
{
IList <MochaColumn> _cols = (new MochaDbCommand(Tdb).ExecuteScalar(Mhql_LEXER.RangeSubqueryBrace(
callcmd.Substring(obrace).Trim()))).Columns;
string mode =
callcmd.Substring(0, obrace).TrimStart().StartsWith("$") ?
"$" : string.Empty;
for (int cindex = 0; cindex < _cols.Count; ++cindex)
{
columns.Add(GetColumn($"{mode}{_cols[cindex].Name}", _cols));
}
continue;
}
if (callcmd.StartsWith("$"))
{
callcmd = callcmd.Substring(1).Trim();
List <MochaColumn> _cols = Tdb.GetColumns(callcmd);
for (int cindex = 0; cindex < _cols.Count; ++cindex)
{
columns.Add(GetColumn($"${_cols[cindex].Name}", _cols));
}
continue;
}
string[] callparts = Mhql_LEXER.SplitSubCalls(callcmd);
if (callparts.Length > 2)
{
throw new InvalidOperationException($"'{callcmd}' command is cannot processed!");
}
for (byte partindex = 0; partindex < callparts.Length; ++partindex)
{
callparts[partindex] = callparts[partindex].Trim();
}
List <MochaColumn> _columns = Tdb.GetColumns(callparts[0]);
if (callparts.Length == 1)
{
columns.AddRange(_columns);
}
else
{
columns.Add(GetColumn(callparts[1], _columns));
}
}
}
resulttable.Columns = columns.ToArray();
resulttable.SetRowsByDatas();
return(resulttable);
}
/// <summary>
/// Returns tables by select command.
/// </summary>
/// <param name="selectcommand">Select command.</param>
public MochaArray <MochaTable> GetTables(string selectcommand)
{
var regex = new Regex(selectcommand);
return(new MochaArray <MochaTable>(Tdb.GetTables(x => regex.IsMatch(x.Name))));
}
/// <summary>
/// Returns table by use command.
/// </summary>
/// <param name="usecommand">Use command.</param>
public MochaTableResult GetTable(string usecommand, bool from)
{
var columns = new List <MochaColumn>();
var resulttable = new MochaTableResult();
if (from)
{
var dex = usecommand.IndexOf("FROM", StringComparison.OrdinalIgnoreCase);
var tablename = usecommand.Substring(dex + 4).TrimStart().TrimEnd();
var parts = usecommand.Substring(0, dex).Split(',');
var table = Tdb.GetTable(tablename);
if (parts.Length == 1 && parts[0].Trim() == "*")
{
columns.AddRange(table.Columns);
}
else
{
for (var index = 0; index < parts.Length; index++)
{
var callcmd = parts[index].Trim();
var name = Mhql_AS.GetAS(ref callcmd);
var column = table.Columns[callcmd];
column.Name = name;
columns.Add(column);
}
}
}
else
{
var parts = usecommand.Split(',');
for (var index = 0; index < parts.Length; index++)
{
var callcmd = parts[index].Trim();
if (callcmd == "*")
{
var tables = Tdb.GetTables();
for (int tindex = 0; tindex < tables.Count; tindex++)
{
columns.AddRange(tables[tindex].Columns);
}
continue;
}
var callparts = callcmd.Split('.');
if (callparts.Length > 2)
{
throw new MochaException($"'{callcmd}' command is cannot processed!");
}
for (byte partindex = 0; partindex < callparts.Length; partindex++)
{
callparts[partindex] = callparts[partindex].Trim();
}
var table = Tdb.GetTable(callparts[0]);
if (callparts.Length == 1)
{
columns.AddRange(table.Columns);
}
else
{
var callp1 = callparts[1];
var name = Mhql_AS.GetAS(ref callp1);
var column = table.Columns[callp1];
column.Name = name;
columns.Add(column);
}
}
}
resulttable.Columns = columns.ToArray();
resulttable.SetRowsByDatas();
return(resulttable);
}
