/// <summary>
/// Export all persistent objects to .csv files, one file for each Type and version of Type.
/// This is preview release, format may change. ImportFromCSV can be used to recreate your data.
/// Note that Microsoft Excel can't handle many of these CSV files due to a field value limitation (at about 33000 chars)
/// Notepad++ is one application that can read these files.
/// Some fields like array data are encoded http://msdn.microsoft.com/en-us/library/dhx0d524(v=vs.110).aspx
/// </summary>
/// <param name="session">the active session</param>
/// <param name="directory">Where to store the CSV files</param>
static public void ExportToCSV(this SessionBase session, string directory)
{
const char fieldSeperator = ',';
if (!Directory.Exists(directory))
{
Directory.CreateDirectory(directory);
}
StreamWriter writer;
StreamWriter dbWriter = null;
StreamWriter pageWriter = null;
Dictionary <UInt32, StreamWriter> files = new Dictionary <uint, StreamWriter>();
byte[] newLineBytes = Page.StringToByteArray(Environment.NewLine);
try
{
List <Database> dbs = session.OpenAllDatabases();
string filePath = "Database.csv";
FileStream dbStream = new FileStream(Path.Combine(directory, filePath), FileMode.Create);
dbWriter = new StreamWriter(dbStream);
dbWriter.WriteLine($"Number{fieldSeperator}Name");
filePath = "Page.csv";
FileStream pageStream = new FileStream(Path.Combine(directory, filePath), FileMode.Create);
pageWriter = new StreamWriter(pageStream);
pageWriter.WriteLine($"DatabaseNumber{fieldSeperator}PageNumber{fieldSeperator}NumberOfSlots{fieldSeperator}FirstFreeSlot{fieldSeperator}Version{fieldSeperator}Encryption{fieldSeperator}Compression{fieldSeperator}TypeVersion");
foreach (Database db in dbs)
{
if (db != null && db.DatabaseNumber != 4 && db.DatabaseNumber != 0) // we skip the license database because we can't restore it without encryption key
{
dbWriter.WriteLine(db.DatabaseNumber.ToString() + fieldSeperator + "\"" + db.Name + "\"");
foreach (Page page in db)
{
if (page.PageNumber > 0)
{
pageWriter.WriteLine(page.Database.DatabaseNumber.ToString() + fieldSeperator +
page.PageNumber + fieldSeperator +
page.PageInfo.NumberOfSlots + fieldSeperator +
page.PageInfo.FirstFreeSlot + fieldSeperator +
page.PageInfo.VersionNumber + fieldSeperator +
page.PageInfo.Encryption + fieldSeperator +
page.PageInfo.Compressed + fieldSeperator +
page.PageInfo.ShapeNumber);
foreach (IOptimizedPersistable pObj in page)
{
TypeVersion tv = pObj.GetTypeVersion();
if (!files.TryGetValue(tv.ShortId, out writer))
{
Type type = tv.VelocityDbType.Type;
string typeName = type == null ? "Unknown (not loaded)" : type.ToGenericTypeString();
string[] illegal = new string[] { "<", ">" };
foreach (var c in illegal)
{
typeName = typeName.Replace(c, string.Empty);
}
filePath = typeName + pObj.GetTypeVersion().ShortId + ".csv";
FileStream fStream = new FileStream(Path.Combine(directory, filePath), FileMode.Create);
writer = new StreamWriter(fStream);
files[pObj.GetTypeVersion().ShortId] = writer;
List <DataMember> members = tv.GetDataMemberList();
byte[] bytes = Page.StringToByteArray($"IOptimizedPersistable.id{fieldSeperator}"); // special transient member
fStream.Write(bytes, 0, bytes.Length);
if (tv.IsString)
{
bytes = Page.StringToByteArray($"String");
fStream.Write(bytes, 0, bytes.Length);
}
else if (tv.IsISerializable)
{
bytes = Page.StringToByteArray($"IsISerializable");
fStream.Write(bytes, 0, bytes.Length);
}
else
{
int l = members.Count;
for (int i = 0; i < l; i++)
{
if (i + 1 < l)
{
bytes = Page.StringToByteArray(members[i].FieldName + fieldSeperator);
}
else
{
bytes = Page.StringToByteArray(members[i].FieldName);
}
fStream.Write(bytes, 0, bytes.Length);
}
}
//writer.Write("\"" + pObj.Shape.velocityDbType.type.AssemblyQualifiedName + "\"");
writer.WriteLine();
}
string aRow = tv.EncodeForCsv(pObj, page.PageInfo, session);
writer.WriteLine(aRow);
}
}
}
}
}
}
finally
{
foreach (StreamWriter s in files.Values)
{
#if WINDOWS_UWP
s.Flush();
s.Dispose();
#else
s.Close();
#endif
}
#if WINDOWS_UWP
pageWriter?.Dispose();
dbWriter?.Dispose();
#else
pageWriter?.Close();
dbWriter?.Close();
#endif
}
}
