/// <summary> /// Process in keyword. /// </summary> /// <param name="tdb">Target database.</param> /// <param name="command">Command.</param> /// <param name="table">Destination table.</param> /// <param name="row">Destination row.</param> /// <param name="from">Use state of FROM keyword.</param> /// <param name="inmode">Set true if command is execute as in mode, set false if ineq mode.</param> /// <returns>True if subquery is success, false if not.</returns> public static bool Process(MochaDatabase tdb, string command, MochaTableResult table, MochaRow row, bool from, bool inmode) { command = command.Substring(inmode ? 2 : 4).TrimStart(); int obrace = command.IndexOf(Mhql_LEXER.LBRACE); if (obrace == -1) { throw new Exception($"{Mhql_LEXER.LBRACE} is not found!"); } MochaColumn column = table.Columns[Mhql_GRAMMAR.GetIndexOfColumn( command.Substring(0, obrace).Trim(), table.Columns, from)]; MochaTableResult result = new MochaDbCommand(tdb).ExecuteScalar(Mhql_LEXER.RangeSubqueryBrace( command.Substring(obrace))); if (result.Columns.Length != 1) { throw new Exception("Subqueries should only return one column!"); } else if (MochaData.IsNumericType(column.DataType) != MochaData.IsNumericType(result.Columns[0].DataType) && column.DataType != result.Columns[0].DataType) { throw new Exception("Column data type is not same of subquery result!"); } if (inmode) { for (int index = 0; index < row.Datas.Count; ++index) { for (int rindex = 0; rindex < result.Columns[0].Datas.Count; ++rindex) { if (row.Datas[index].Data.ToString() == result.Columns[0].Datas[rindex].Data.ToString()) { return(true); } } } return(false); } else { if (result.Rows.Length != 1) { return(false); } return(row.Datas[0].Data.ToString() == result.Columns[0].Datas[0].Data.ToString()); } }
/// <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); }