示例#1
0
        private static void PrintColumnNames(ParseTreeNode rootNode, ExecutionPlanOptions executionPlanOptions)
        {
            if(string.Equals(ID3SQLGrammar.SelectStatementNonTermName, rootNode.Term.Name))
            {
                ParseTreeNode selectListNode = rootNode.ChildNodes[1];
                ParseTreeNode topNode = selectListNode.ChildNodes[0];
                if (topNode.Token != null && string.Equals(topNode.Token.Text, "*"))
                {
                    string[] allGetFunctionPropertyNames = TagFunctionManager.AllGetFunctionPropertyNames().ToArray();
                    string columnNameLine = string.Join(executionPlanOptions.ColumnSeparator, allGetFunctionPropertyNames);

                    Console.WriteLine(columnNameLine);
                }
                else if (topNode.ChildNodes.Count > 0)
                {
                    IEnumerable<string> allGetFunctionPropertyNames = TagFunctionManager.AllGetFunctionPropertyNames();
                    ICollection<string> propertyNames = new List<string>();
                    foreach (ParseTreeNode idNode in topNode.ChildNodes)
                    {
                        string propertyName = idNode.Token.Text;
                        if (allGetFunctionPropertyNames.Contains(propertyName))
                        {
                            propertyNames.Add(propertyName);
                        }
                        else
                        {
                            throw new ID3SQLException("Unknown property name in select list");
                        }
                    }

                    string columnNameLine = string.Join(executionPlanOptions.ColumnSeparator, propertyNames);

                    Console.WriteLine(columnNameLine);
                }
                else
                {
                    throw new Exception("Unknown select non-term");
                }
            }
        }
示例#2
0
 private static string[] ValueToStringArray(object value, ExecutionPlanOptions executionPlanOptions)
 {
     if (value is IEnumerable<string>)
     {
         return (value as IEnumerable<string>).ToArray();
     }
     else if (value is string)
     {
         return (value as string).Split(executionPlanOptions.StringArraySeparator);
     }
     else
     {
         throw new ID3SQLException(string.Format("Invalid Assignment: {0}", value));
     }
 }
示例#3
0
        public static void Main(string[] args)
        {
            CommandLineOptions options = new CommandLineOptions();

            try
            {
                if (CommandLine.Parser.Default.ParseArguments(args, options))
                {
                    Regex fileRegex;
                    try
                    {
                        fileRegex = new Regex(options.FileRegex ?? DefaultFileRegex());
                    }
                    catch(Exception ex)
                    {
                        throw new ID3SQLException("Error parsing fileRegex", ex);
                    }

                    string startDirectory = options.Directory ?? DefaultDirectoryPath();

                    string statement = options.Statement;

                    if(statement == null)
                    {
                        throw new ID3SQLException("No SQL statement supplied");
                    }

                    Action<IEnumerable<string>, ExecutionPlanOptions> executionPlan = ExecutionPlan.GenerateExecutionPlan(statement);

                    ICollection<string> tagFilePaths = new List<string>();
                    try
                    {
                        BuildFileList(startDirectory, tagFilePaths, fileRegex);
                    }
                    catch(Exception ex)
                    {
                        throw new ID3SQLException(string.Format("Error building file list from start directory '{0}'", startDirectory), ex);
                    }

                    ExecutionPlanOptions executionPlanOptions = new ExecutionPlanOptions()
                    {
                        Recycle = options.Recycle,
                        DryRun = options.DryRun,
                        Verbose = options.Verbose,
                        StringArraySeparator = options.StringLiteralSeparator,
                        RegexIgnoreCase = options.RegexIgnoreCase,
                        ColumnNames = options.ColumnNames,
                        ColumnSeparator = options.ColumnSeparator
                    };

                    executionPlan(tagFilePaths, executionPlanOptions);
                }
            }
            catch(ID3SQLException ex)
            {
                Console.Error.WriteLine(ex.Message);
                if(options.Verbose)
                {
                    Console.Error.Write(ex);
                }
            }
            catch(Exception ex)
            {
                Console.Error.WriteLine("Unknown error has occured");
                if(options.Verbose)
                {
                    Console.Error.WriteLine(ex);
                }
            }
        }