public void Export(IAssetExportEnvironment env)
        {
            // Determine input and output path
            CsvData input      = env.Input as CsvData;
            string  outputPath = env.AddOutputPath(input.Name + SourceFileExtPrimary);

            BaseAssetImporter.Export(input, outputPath);
        }
示例#2
0
 /// <summary>
 /// Sets the favourite spell.
 /// </summary>
 public void SetFavouriteSpell(SpellData Spell)
 {
     if (Spell != null)
     {
         CsvData CsvData = CsvFiles.Get(Gamefile.Resources).GetData("FavouriteSpell");
         this.CommoditySlots.SetCommodityCount(CommodityType.ProfileResource, CsvData, CsvData.GlobalId);
     }
 }
        public void SetUp()
        {
            theMapping   = new TestCsvMapping();
            theHeaders   = new CsvData(new[] { "Count", "Flag", "Name" });
            theRawValues = new CsvData(new[] { "1", "true", "Test" });

            theValues = theMapping.ValueSource(theRawValues, theHeaders);
        }
        public void SetUp()
        {
            theMapping   = new MappingWithAliases();
            theHeaders   = new CsvData(new[] { "Count", "Flag", "SomethingElse" });
            theRawValues = new CsvData(new[] { "1", "true", "Test" });

            theValues = theMapping.ValueSource(theRawValues, theHeaders);
        }
        public void CsvDataFromObjectShouldConvertableBackToObject()
        {
            var obj     = new CsvDataObject();
            var csvData = CsvData.FromObject(obj);

            var backData = csvData.GetObject <CsvDataObject>();

            Assert.True(PropertiesEqual(obj, backData));
        }
        public override void WriteJson(JsonWriter writer, object value, JsonSerializer serializer)
        {
            var dataPoint = (DataPoint <T>)value;

            if (typeof(T) == typeof(CsvData))
            {
                CsvData csv = (CsvData)(object)dataPoint.Value;
                WriteDataPointArray(writer, serializer, dataPoint.EpochTime, csv.TotalNotional);
            }
        }
        public void CsvDataFromObjectShouldContainAllProperties()
        {
            var obj      = new CsvDataObject();
            var expected = obj.GetType().GetProperties().Length;

            var csvData = CsvData.FromObject(obj);

            Assert.Equal(expected, csvData.Columns.Count);
            Assert.Equal(expected, csvData.Fields.Count);
        }
示例#8
0
        /// <summary>
        ///     Gets if the collection has the specified data.
        /// </summary>
        public bool Exists(int CommodityType, CsvData CsvData)
        {
            if (CommodityType >= 8)
            {
                Logging.Error(this.GetType(), "Exists() - Commodity Type is not valid. (" + CommodityType + ")");
                return(false);
            }

            return(this.Slots[CommodityType].Exists(T => T.Data.Equals(CsvData)));
        }
        public void GivenEmptyResponseData_WhenConvertingToSheet_NoCellsAreCreated()
        {
            var csvData = new CsvData();

            var converter = new CsvToSheetConverter();

            var result = converter.Convert(csvData);

            result.Rows.Should().BeEmpty();
        }
示例#10
0
        static void Main(string[] args)
        {
            var argsParsed = ArgumentsParsed.FromArgs(args);
            var sqlQuery   = SqlQuery.FromProgramParams(argsParsed.ProgramParams);
            var sqlData    = new SqlQueryRunner(sqlQuery.Query, argsParsed.QueryParams).Run();

            CsvData
            .FromSqlData(sqlData)
            .ToFile(argsParsed.GetValue(string.Concat(ArgumentsParsed.PROGRAM_PARAM_PREFIX, "outFilePath")));
        }
示例#11
0
        void RemoveReference()
        {
            bool _success = CsvData.RemoveReference(reference.Value);

            if (!success.IsNone)
            {
                success.Value = _success;
            }

            Fsm.Event(_success?successEvent:failureEvent);
        }
示例#12
0
        /// <summary>
        /// Initializes a new instance of the <see cref="Summoner"/> class.
        /// </summary>
        public Summoner(CsvData CsvData) : base(CsvData)
        {
            this.ManaCount   = Globals.StartMana;
            this.ManaReserve = Globals.MaxMana;

            this.Hand = new int[4];

            this.SpellQueue       = new List <int>(4);
            this.SpellQueue2      = new List <int>(4);
            this.LastUsedSpellIdx = -1;
        }
示例#13
0
        public override void UpdateCurrentFrame(int frame)
        {
            var data = CsvData.FirstOrDefault(d => d.FrameNumber == frame);

            if (data == null)
            {
                return;
            }

            Translation = data.Translation;
            Rotation    = data.Rotation;
        }
示例#14
0
            public void ShouldContainStringData()
            {
                // Arrange
                const string expected = "hello world";
                var          sut      = new CsvData(expected, "ext");

                // Act
                var actual = sut.ToString();

                // Assert
                Assert.Equal(expected, actual);
            }
示例#15
0
 /// <summary>
 /// Adds a data data reference.
 /// </summary>
 public static void EncodeData(this ChecksumEncoder Stream, CsvData CsvData)
 {
     if (CsvData != null)
     {
         Stream.WriteVInt(CsvData.Type);
         Stream.WriteVInt(CsvData.Instance);
     }
     else
     {
         Stream.WriteVInt(0);
     }
 }
示例#16
0
    /*
     * 获取文本总长度
     */
    public int GetLength(string filename)
    {
        CsvData data = new CsvData();

        if (m_AllDatas.TryGetValue(filename, out data))
        {
            return(data.GetLength());
        }
        else
        {
            return(0);
        }
    }
示例#17
0
        void DoGetCsvRecordCount()
        {
            CsvData _data = CsvData.GetReference(reference.Value);

            if (_data == null)
            {
                Fsm.Event(errorEvent);
                recordCount.Value = 0;
                return;
            }

            recordCount.Value = _data.RecordCount;
        }
示例#18
0
        void DoGetCsvColumnCount()
        {
            CsvData _data = CsvData.GetReference(reference.Value);

            if (_data == null)
            {
                Fsm.Event(errorEvent);
                columnCount.Value = 0;
                return;
            }

            columnCount.Value = _data.ColumnCount;
        }
示例#19
0
    private CsvData DrawWidget(Rect position, CsvData item)
    {
        float midY             = position.y + position.height / 2 - 5;
        Rect  fieldLableRect   = new Rect(position.x, midY, 50, position.height);
        Rect  headerLableRect  = new Rect(fieldLableRect.xMax + interval, midY, 200, position.height);
        Rect  dataTypeEnumRect = new Rect(headerLableRect.xMax + interval, midY, 200, position.height);
        Rect  isParseRect      = new Rect(dataTypeEnumRect.xMax + interval, midY, 200, position.width);

        EditorGUI.LabelField(fieldLableRect, "字段名:");
        EditorGUI.LabelField(headerLableRect, item.header);
        item.dataType = (DataType)EditorGUI.EnumPopup(dataTypeEnumRect, "数据类型:", item.dataType);
        item.isParse  = EditorGUI.Toggle(isParseRect, "是否解析该字段", item.isParse);
        return(item);
    }
示例#20
0
    public string GetData(string filename, string key, string head)
    {
        CsvData data  = new CsvData();
        string  value = "";

        if (m_AllDatas.TryGetValue(filename, out data))
        {
            value = data.GetData(key, head);
        }
        else
        {
            value = "error";
        }
        return(value);
    }
示例#21
0
        public void SaveFile(string fileName, CsvData csvData)
        {
            using (var streamWriter = new StreamWriter(fileName))
            {
                var header = csvData.FieldNames;

                var headerCsv = string.Join(',', csvData.FieldNames);
                streamWriter.WriteLine(string.Join(',', csvData.FieldNames));

                foreach (var entry in csvData.Entries)
                {
                    streamWriter.WriteLine(entry.GetCsvRow(header));
                }
            }
        }
示例#22
0
        /// <summary>
        ///     Uses the specified commodity count.
        /// </summary>
        public void UseCommodity(int CommodityType, CsvData CsvData, int Count)
        {
            if (CommodityType >= 8)
            {
                Logging.Error(this.GetType(), "UseCommodity() - Commodity Type is not valid. (" + CommodityType + ")");
                return;
            }

            DataSlot Slot = this.Slots[CommodityType].Find(T => T.Data == CsvData);

            if (Slot != null)
            {
                Slot.Count -= Count;
            }
        }
示例#23
0
 public async Task <HttpResponseMessage> GetDetailsByDateTime(DateTime date)
 {
     /// check for null date
     try
     {
         var csvData = new CsvData();
         // id there is a db this can asychronus call
         var details = csvData.DataConvertor();
         // we can convert the details object to Json here
         return(Request.CreateResponse(System.Net.HttpStatusCode.OK, FilterData(details, date)));
     }
     catch (Exception ex) {
         return(new HttpResponseMessage(System.Net.HttpStatusCode.InternalServerError));
     }
 }
        public void Replace()
        {
            // Arrange
            IEnumerable <ITupleReplace> replaces = new List <ITupleReplace>()
            {
                CreateReplace("A", "Z"),
                CreateReplace("B", "V", "B"),
            };

            var csvDataOk = new CsvData();
            var aListA    = new List <string>()
            {
                "A1", "A2", "A3", "A4"
            };
            var aListB = new List <string>()
            {
                "AB1", "AB2", "AB3", "AB4"
            };

            csvDataOk.Add("A", aListA);
            csvDataOk.Add("B", aListB);
            var lines = csvDataOk.GetLines();

            // Act
            var result = CsvActionCreator.Create(
                replaces);



            // Assert
            foreach (var item in result)
            {
                lines.ToList().ForEach(item);
            }

            lines.ToList().ForEach(
                x =>
            {
                Assert.IsTrue(x["A"].Contains("Z"));
                Assert.IsTrue(!x["A"].Contains("A"));
                Assert.IsTrue(x["B"].Contains("Z"));
                Assert.IsTrue(!x["B"].Contains("A"));

                Assert.IsTrue(x["B"].Contains("V"));
                Assert.IsTrue(!x["B"].Contains("B"));
            }
                );
        }
示例#25
0
            public void ShouldWriteContentToFile()
            {
                // Arrange
                const string baseName = "fileName";
                const string fileName = "fileName.ext";
                const string expected = "hello world";
                var          sut      = new CsvData(expected, "ext");

                // Act
                sut.Save(baseName);

                // Assert
                var actual = File.ReadAllText(fileName);

                Assert.Equal(expected, actual);
            }
        private void CreateDatabaseIfNotExists()
        {
            var database = Store.Database;
            var dbRecord = Store.Admin.Server.Send(new GetDatabaseRecordOperation(database));

            if (dbRecord == null)
            {
                this._logger.LogInformation("RavenDB database does not exist, creating and seeding with initial data");

                // Create database
                dbRecord = new DatabaseRecord(database);

                var createResult = Store.Admin.Server.Send(new CreateDatabaseOperation(dbRecord));

                if (createResult.Name != null)
                {
                    // Seed database
                    var talks    = CsvData.LoadTalks();
                    var speakers = CsvData.LoadSpeakers();

                    // old => new speaker ID map
                    var speakerIdMap = new Dictionary <string, string>();

                    using (var session = Store.OpenSession())
                    {
                        foreach (var speaker in speakers)
                        {
                            var oldId = speaker.Id;
                            speaker.Id = null;
                            session.Store(speaker);
                            speakerIdMap.Add(oldId, speaker.Id);
                        }

                        foreach (var talk in talks)
                        {
                            talk.Id      = null;
                            talk.Speaker = speakerIdMap[talk.Speaker];
                            session.Store(talk);
                        }
                        session.SaveChanges();
                    }

                    this._logger.LogInformation("Seeded database with {0} talks", talks.Count);
                    this._logger.LogInformation("Seeded database with {0} speakers", speakers.Count);
                }
            }
        }
示例#27
0
        /// <summary>
        ///     Gets the commodity count.
        /// </summary>
        public int GetCommodityCount(int CommodityType, CsvData CsvData)
        {
            if (CommodityType >= 8)
            {
                Logging.Error(this.GetType(), "GetCommodityCount() - Commodity Type is not valid. (" + CommodityType + ")");
                return(0);
            }

            DataSlot Slot = this.Slots[CommodityType].Find(T => T.Data == CsvData);

            if (Slot != null)
            {
                return(Slot.Count);
            }

            return(0);
        }
        public CsvData CreateCsvData(AggregatedData data)
        {
            CsvData report = new CsvData(new[] { "Local Time", "Volume" });

            DateTime utcSessionStart = data.TradingDate.AddDays(-1).Add(data.SessionStart);

            for (int i = 0; i < data.Volumes.Length; i++)
            {
                DateTime localTime = utcSessionStart.Add(TimeSpan.FromHours(i)).ToLocalTime();

                string time   = localTime.TimeOfDay.ToString(@"hh\:mm");
                string volume = data.Volumes[i].ToString(CultureInfo.InvariantCulture);

                report.AddRow(new[] { time, volume });
            }
            return(report);
        }
示例#29
0
        public static IEnumerable <ICsvLine> AddStringLine(this IEnumerable <ICsvLine> lines, string repeatValue = null)
        {
            var csvData = new CsvData();
            var aListA  = repeatValue == null ? new List <string>()
            {
                "S1", "S2", "S3", "S4"
            } : new List <string>()
            {
                repeatValue, repeatValue, repeatValue, repeatValue
            };

            csvData.Add("string", aListA);


            lines = lines.Append(csvData.GetLines().First());
            return(lines);
        }
示例#30
0
        public static IEnumerable <ICsvLine> AddIntLine(this IEnumerable <ICsvLine> lines, int?repeatValue = null)
        {
            var csvData = new CsvData();
            var aListA  = repeatValue == null ? new List <string>()
            {
                "1", "2", "3", "4"
            } : new List <string>()
            {
                repeatValue.ToString(), repeatValue.ToString(), repeatValue.ToString(), repeatValue.ToString()
            };

            csvData.Add("int", aListA);


            lines = lines.Append(csvData.GetLines().First());
            return(lines);
        }
示例#31
0
        public HttpResponseMessage GetUrl(CsvData data)
        {
            var src = String.Format(urlFormat,
                Request.RequestUri.Host + (Request.RequestUri.Port != 80 ? ":" + Request.RequestUri.Port : ""),
                data.DisplayType,
                HttpUtility.UrlEncode(data.CsvDocument),
                data.HasColumnNames ? "1" : "0",
                data.DisplayType != "RSS" ? data.GroupBy : null,
                data.Width,
                data.FilterBy,
                data.FilterValue,
                data.ExactFilterMatch ? "1" : "0");

            if (data.DisplayType == "Timeline")
                src += "&startDateColumn=" + data.Timeline.startDateColumn +
                   "&endDateColumn=" + data.Timeline.endDateColumn +
                   "&textColumn=" + data.Timeline.TextColumn +
                   "&numOfDaysToShow=" + data.Timeline.NumberOfDaysToShowFromNow +
                   "&onlyWithContent=" + (data.Timeline.OnlyShowLinesWithContent ? "1" : "0");

            if (data.DisplayType == "List")
                src += "&include=" + String.Join("|", data.Columns.Where(x => x.Include).Select(x => x.Name).ToArray());

            if (data.DisplayType == "RSS")
                src += "&Title=" + data.RSS.Title +
                   "&Description=" + data.RSS.Description +
                   "&DateColumn=" + data.RSS.DateColumn +
                   "&TitleColumn=" + data.RSS.TitleColumn +
                   "&DescriptionColumn=" + data.RSS.DescriptionColumn +
                   "&LinkColumn=" + data.RSS.LinkColumn +
                   "&numOfDaysToShow=" + data.RSS.NumberOfDaysToShowFromNow;

            var ret = new HttpResponseMessage();
            ret.Content = new StringContent(src);
            return ret;
        }
示例#32
0
        public CsvData AnalyzeCsvData(CsvData data)
        {
            try
            {
                if (String.IsNullOrEmpty(data.CsvDocument))
                    throw new Exception("Du skal indtaste et link til dokumentet");

                try
                {
                    SmtpClient client = new SmtpClient();
                    MailMessage mm = new MailMessage();
                    mm.From = new MailAddress("*****@*****.**");
                    mm.To.Add(new MailAddress("*****@*****.**"));
                    mm.Subject = "AnalyzeCsvData called";
                    mm.Body = data.CsvDocument;
                    client.Send(mm);

                }
                catch
                {
                    //throw;
                }

                data.CsvDocumentValid = true;
                data.Width = 900;
                data.Columns = new List<Column>();
                data.HasColumnNames = true;
                data.GroupBy = "";
                data.FilterBy = "";
                data.FilterValue = "";
                data.NotSupportedDisplayTypes = new List<string>();

                data.Timeline = new Timeline();
                data.Timeline.OnlyShowLinesWithContent = true;
                data.Timeline.NumberOfDaysToShowFromNow = 28;
                data.Timeline.endDateColumn = "";

                data.RSS = new RSS();
                data.RSS.Title = "Indtast overskrift her";
                data.RSS.Description = "Indtast beskrivelse her";
                data.RSS.NumberOfDaysToShowFromNow = 28;

                data.DisplayType = "Timeline";

                var list = Csv.CsvListRepository.GetList(data.CsvDocument, true, "", "", "", false, null);

                foreach (var col in list.ColumnNames)
                {
                    data.Columns.Add(new Column { Name = col.Name, Type = col.Type });

                    if (col.Type == "DateTime" && String.IsNullOrEmpty(data.Timeline.startDateColumn))
                    {
                        data.Timeline.startDateColumn = col.Name;
                        data.RSS.DateColumn = col.Name;
                    }
                    else if (col.Type == "DateTime" && String.IsNullOrEmpty(data.Timeline.endDateColumn))
                        data.Timeline.endDateColumn = col.Name;

                    if (col.Type == "String" || col.Type == "Uri")
                    {
                        if (String.IsNullOrEmpty(data.GroupBy))
                            data.GroupBy = col.Name;

                        if (String.IsNullOrEmpty(data.Timeline.TextColumn))
                            data.Timeline.TextColumn = col.Name;

                        if (col.Type == "String")
                            if (String.IsNullOrEmpty(data.RSS.TitleColumn))
                                data.RSS.TitleColumn = col.Name;
                            else if (String.IsNullOrEmpty(data.RSS.DescriptionColumn))
                                data.RSS.DescriptionColumn = col.Name;

                    }

                    if (col.Type == "Uri" && String.IsNullOrEmpty(data.RSS.LinkColumn))
                        data.RSS.LinkColumn = col.Name;

                }
                data.CsvDocument = list.CsvLink;

                if (String.IsNullOrEmpty(data.Timeline.startDateColumn))
                {
                    data.NotSupportedDisplayTypes.Add("Timeline");
                    data.DisplayType = "List";
                }

            }
            catch (Exception ex)
            {
                data.CsvDocumentValid = false;
                data.isError = true;
                data.ErrorMessage = ex.Message;
            }

            return data;
        }