/// <summary>
        /// Returns the correct Input Context class for this type of query. It will also sanity check
        /// all relevant config params and throw exceptions where there are violations (required
        /// setting missing, badly formed etc)
        /// </summary>
        /// <returns></returns>
        /// <exception cref="ArgumentException">Thrown if a setting is missing</exception>
        /// <exception cref="FormatException">Thrown if a setting is badly formed</exception>
        protected override object GetInputContext()
        {
            var context = new COMTextLineInputContextClass
            {
                codepage       = myConfig.CodePage ?? 0,
                recurse        = myConfig.Recurse ?? 0,
                splitLongLines = myConfig.SplitLongLines ?? false
            };

            if (!string.IsNullOrEmpty(myConfig.CheckpointFile))
            {
                context.iCheckpoint = myConfig.CheckpointFile;
            }

            return(context);
        }
Exemplo n.º 2
0
        //Call references LogParser. Take sql string query and the Table name and execute into a logparser records set. Then, loop through the records
        //and save them into a dataTable
        private static DataTable parseLog(string query, string TableName)
        {
            LogQueryClass logParser = new LogQueryClass();
            COMTextLineInputContextClass Log = new COMTextLineInputContextClass();

            ILogRecordset rsLP = null;
            ILogRecord rowLP = null;

            rsLP = logParser.Execute(query, Log);

            DataTable tab = new DataTable(TableName);

            // copy schema
            for (int i = 0; i < rsLP.getColumnCount(); i++)
            {
                DataColumn col = new DataColumn();
                col.ColumnName = rsLP.getColumnName(i);
                tab.Columns.Add(col);
            }

            // copy data
            while (!rsLP.atEnd())
            {
                rowLP = rsLP.getRecord();
                DataRow row = tab.NewRow();

                for (int i = 0; i < rsLP.getColumnCount(); i++)
                {
                    row[i] = Convert.ToString(rowLP.getValue(i));
                }

                tab.Rows.Add(row);

                rsLP.moveNext();
            }
            return tab;
        }