Esempio n. 1
0
        private void DoRowData(ISheet sheet, XivRow row, List <string> data, StringBuilder sb)
        {
            for (int i = 0; i < sheet.Header.ColumnCount; i++)
            {
                var o = row.GetRaw(i);

                if (o is Quad)
                {
                    var q = (Quad)o;
                    data.Add(q.ToInt64().ToString());
                    continue;
                }

                if (IsUnescaped(o))
                {
                    data.Add(o.ToString());
                    continue;
                }

                string d = o.ToString();
                if (string.IsNullOrEmpty(d))
                {
                    d = "NULL";
                }
                else
                {
                    d = $"'{d.Replace("'", "\\'")}'";
                }
                data.Add(d);
            }

            sb.AppendLine($"  ( {string.Join(", ", data)} ),");
        }