コード例 #1
0
ファイル: CsvExtractorTests.cs プロジェクト: ttrider/Osminoq
        public void End2EndMaleNames()
        {
            using (
                var fl =
                    Assembly.GetExecutingAssembly()
                    .GetManifestResourceStream("TTRider.Osminoq.CoreTests.Csv.Data.malenames.txt"))
            {
                var dataPackageModel = new DataPackageModel()
                {
                    HasHeaderRecord = false, Delimeter = ","
                };

                var dataSetModel = new DataSetModel();


                dataSetModel.Properties.Add(new DataItemProperty()
                {
                    Name = "Name", DataType = "string", Source = "0"
                });

                dataPackageModel.DataSetModels.Add(dataSetModel);

                using (var e = new CsvDataItemReader(fl, dataPackageModel))
                {
                    do
                    {
                        foreach (var item in e.ReadDataItems())
                        {
                            Console.WriteLine(item.GetPropertyValue("Name"));
                        }
                    } while (e.NextDataSet());
                }
            }
        }
コード例 #2
0
ファイル: CsvExtractorTests.cs プロジェクト: ttrider/Osminoq
        public void End2EndPoliceStations()
        {
            using (
                var fl =
                    Assembly.GetExecutingAssembly()
                    .GetManifestResourceStream("TTRider.Osminoq.CoreTests.Csv.Data.Police_Stations.csv"))
            {
                var dataPackageModel = new DataPackageModel()
                {
                    HasHeaderRecord = true, Delimeter = ","
                };

                var dataSetModel = new DataSetModel();


                dataSetModel.Properties.Add(new DataItemProperty {
                    Name = "District", DataType = "string", Source = "0"
                });
                dataSetModel.Properties.Add(new DataItemProperty {
                    Name = "Address", DataType = "string", Source = "1"
                });
                dataSetModel.Properties.Add(new DataItemProperty {
                    Name = "City", DataType = "string", Source = "2"
                });
                dataSetModel.Properties.Add(new DataItemProperty {
                    Name = "State", DataType = "string", Source = "3"
                });
                dataSetModel.Properties.Add(new DataItemProperty {
                    Name = "Zip", DataType = "string", Source = "4"
                });
                dataSetModel.Properties.Add(new DataItemProperty {
                    Name = "Website", DataType = "string", Source = "5"
                });
                dataSetModel.Properties.Add(new DataItemProperty {
                    Name = "Phone", DataType = "string", Source = "6"
                });
                dataSetModel.Properties.Add(new DataItemProperty {
                    Name = "Fax", DataType = "string", Source = "7"
                });
                dataSetModel.Properties.Add(new DataItemProperty {
                    Name = "TTY", DataType = "string", Source = "8"
                });
                dataSetModel.Properties.Add(new DataItemProperty {
                    Name = "Location", DataType = "string", Source = "9"
                });

                dataSetModel.Properties.Add(new DataItemProperty {
                    Name = "Latitude", DataType = "double", Source = "9", Template = @"\((?'value'[\-0-9\.]+),"
                });
                dataSetModel.Properties.Add(new DataItemProperty {
                    Name = "Longditude", DataType = "double", Source = "9", Template = @",\s*(?'value'[\-0-9\.]+)\)"
                });



                dataPackageModel.DataSetModels.Add(dataSetModel);

                using (var e = new CsvDataItemReader(fl, dataPackageModel))
                {
                    do
                    {
                        foreach (var item in e.ReadDataItems())
                        {
                            Console.WriteLine(item.GetPropertyValue("Phone"));
                        }
                    } while (e.NextDataSet());
                }
            }
        }
コード例 #3
0
ファイル: CsvExtractorTests.cs プロジェクト: ttrider/Osminoq
 public void CtorNullVal()
 {
     var e = new CsvDataItemReader(null, new DataPackageModel());
 }
コード例 #4
0
ファイル: CsvExtractorTests.cs プロジェクト: ttrider/Osminoq
 public void CtorValNull()
 {
     var e = new CsvDataItemReader(new MemoryStream(), null);
 }
コード例 #5
0
ファイル: CsvExtractorTests.cs プロジェクト: ttrider/Osminoq
 public void CtorNullNull()
 {
     var e = new CsvDataItemReader(null, null);
 }