using System;

using System.Collections.Generic;

​

using System.Threading.Tasks;

public class Program

{

    public static void Main()

    {

        var Part1Tasks = new List<Task>();

            Part1Tasks.Add(SpawnFullTableIndexTask(new LuceneIndex(LuceneIndexNames.ProductColumnMappings), null));

            Part1Tasks.Add(SpawnFullTableIndexTask(new LuceneIndex(LuceneIndexNames.SeriesColumnMappings), null));

            Part1Tasks.Add(SpawnFullTableIndexTask(new LuceneIndex(LuceneIndexNames.TypeNameMappings), null));

            Part1Tasks.Add(SpawnFullTableIndexTask(new LuceneIndex(LuceneIndexNames.ProductDocuments), null));

            Part1Tasks.Add(SpawnFullTableIndexTask(new LuceneIndex(LuceneIndexNames.SeriesDocuments), null));

​

            //Wait until all threads are completed to continue.

            Task.WaitAll(Part1Tasks.ToArray());

            if(Part1Tasks.Any(task => task.Exception != null))

                throw new AggregateException(Part1Tasks.Select(task => task.Exception));

​

            //Query index, get Column Names.

​

            //--------------------------

            //Part 2: Get Table Indexes

​

            var Part2Tasks = new List<Task>();

​

            List<string> Indices = new List<string>() { 

                //LuceneIndexNames.AnalogSwitchBase,

                LuceneIndexNames.DetectSwitchBase,

                LuceneIndexNames.DIPSwitchBase,

                //LuceneIndexNames.RAFISwitchBase,

                //LuceneIndexNames.HookSwitchBase,

                //LuceneIndexNames.InterlockSwitchBase,

                LuceneIndexNames.KeySwitchBase,

                LuceneIndexNames.NavigationSwitchBase,

                LuceneIndexNames.PushbuttonSwitchBase,

                LuceneIndexNames.RockerSwitchBase,

                LuceneIndexNames.RotarySwitchBase,

                LuceneIndexNames.SlideSwitchBase,

                LuceneIndexNames.SnapSwitchBase,

                LuceneIndexNames.SwitchlockSwitchBase,

                LuceneIndexNames.TactileSwitchBase,

                LuceneIndexNames.ThumbwheelSwitchBase,

                LuceneIndexNames.ToggleSwitchBase,

                //LuceneIndexNames.TiltSwitchBase,

                LuceneIndexNames.SmartCardBase,

                // LuceneIndexNames.DSubHRCBase,

                // LuceneIndexNames.MicroDHRCBase,

                // LuceneIndexNames.MTB1HRCBase

                 };

​

            var MappedTableWhereClause = "where PDN = 0";

​

            foreach(var indexName in Indices)

            {

                Part2Tasks.Add(SpawnFullTableIndexTask(new LuceneIndex(indexName, LuceneIndexType.Product), MappedTableWhereClause));

            }

​

            foreach(var indexName in Indices)

            {

                Part2Tasks.Add(SpawnFullTableIndexTask(new LuceneIndex(indexName, LuceneIndexType.Series), null));

            }

​

            Part2Tasks.Add(SpawnFullTableIndexTask(new LuceneIndex(LuceneIndexNames.HomePageSeries), null)); 

            Part2Tasks.Add(SpawnFullTableIndexTask(new LuceneIndex(LuceneIndexNames.ProductSeriesDetails), null));

​

            //Wait until all threads are completed to continue.

            Task.WaitAll(Part2Tasks.ToArray());

​

            if(Part2Tasks.Any(task => task.Exception != null))

                throw new AggregateException(Part2Tasks.Select(task => task.Exception));

​

    }

}