public void aaaFakeLicenseDatabaseCleanup(bool deleteLocationProperly, bool useServerSession)
{
if (deleteLocationProperly)
{
using (SessionBase session = useServerSession ? (SessionBase) new ServerClientSession(systemDir) : (SessionBase) new SessionNoServer(systemDir))
{
session.BeginUpdate();
DatabaseLocation defaultLocation = session.DatabaseLocations.Default();
List <Database> dbList = session.OpenLocationDatabases(defaultLocation, true);
foreach (Database db in dbList)
{
if (db.DatabaseNumber > Database.InitialReservedDatabaseNumbers)
{
session.DeleteDatabase(db);
}
}
session.DeleteLocation(defaultLocation);
session.Commit();
}
}
foreach (string s in Directory.GetFiles(systemDir))
{
File.Delete(s);
}
using (SessionBase session = useServerSession ? (SessionBase) new ServerClientSession(systemDir) : (SessionBase) new SessionNoServer(systemDir))
{
session.BeginUpdate();
UInt32 dbNum = session.DatabaseNumberOf(typeof(NotSharingPage));
session.NewDatabase(dbNum);
session.Commit();
}
File.Copy(licenseDbFile, Path.Combine(systemDir, "4.odb"));
}
/// <summary>
/// Restores database files, pages and objects from a .csv file data created with ExportToCSV
/// </summary>
/// <param name="session">the active session</param>
/// <param name="csvDirectory">Path to directory containing CSV files</param>
static public void ImportFromCSV(this SessionBase session, string csvDirectory)
{
const char fieldSeperator = ',';
DirectoryInfo di = new DirectoryInfo(csvDirectory);
#if WINDOWS_PHONE
List <FileInfo> files = di.GetFiles("*.csv").ToList();
#else
List <FileInfo> files = di.GetFiles("*.csv", SearchOption.TopDirectoryOnly).ToList();
#endif
Schema schema = session.OpenSchema(false);
using (StreamReader textReader = new StreamReader(Path.Combine(csvDirectory, "Database.csv")))
{
string header = textReader.ReadLine();
string dbInfoString = textReader.ReadLine();
while (dbInfoString != null)
{
string[] dbInfo = dbInfoString.Split(fieldSeperator);
UInt32 dbNum = UInt32.Parse(dbInfo[0]);
string dbName = dbInfo[1].Trim(new char[] { '"' });
Database db = null;
if (dbNum < 10)
{
db = session.OpenDatabase(dbNum, false, false);
}
if (db == null)
{
db = session.NewDatabase(dbNum, 0, dbName);
}
dbInfoString = textReader.ReadLine();
}
}
using (StreamReader textReader = new StreamReader(Path.Combine(csvDirectory, "Page.csv")))
{
string header = textReader.ReadLine();
string pageInfoString = textReader.ReadLine();
while (pageInfoString != null)
{
int i = 0;
string[] pageInfo = pageInfoString.Split(fieldSeperator);
UInt32 dbNum = UInt32.Parse(pageInfo[i++]);
UInt16 pageNum = UInt16.Parse(pageInfo[i++]);
UInt16 numberOfSlots = UInt16.Parse(pageInfo[i++]);
UInt16 firstFreeSlot = UInt16.Parse(pageInfo[i++]);
UInt64 versionNumber = UInt64.Parse(pageInfo[i++]);
PageInfo.encryptionKind encryptionKind = (PageInfo.encryptionKind)Enum.Parse(typeof(PageInfo.encryptionKind), pageInfo[i++]);
PageInfo.compressionKind compressed = (PageInfo.compressionKind)Enum.Parse(typeof(PageInfo.compressionKind), pageInfo[i++]);
UInt32 typeVersion = UInt32.Parse(pageInfo[i]);
Database db = session.OpenDatabase(dbNum, false, false);
Page page = db.CachedPage(pageNum);
if (page == null)
{
page = new Page(db, pageNum, typeVersion, numberOfSlots);
page.PageInfo.Compressed = compressed;
page.PageInfo.Encryption = encryptionKind;
page.PageInfo.VersionNumber = versionNumber;
page.PageInfo.NumberOfSlots = numberOfSlots;
page.PageInfo.FirstFreeSlot = firstFreeSlot;
session.UpdatePage(ref page);
}
pageInfoString = textReader.ReadLine();
}
}
var schemaInternalTypeFiles = new[] {
"VelocityDb.TypeInfo.Schema65747.csv",
"VelocityDb.TypeInfo.TypeVersion65749.csv",
"VelocityDb.TypeInfo.VelocityDbType65753.csv",
"VelocityDb.TypeInfo.DataMember65745.csv",
"VelocityDb.Collection.BTree.BTreeSetOidShortVelocityDb.TypeInfo.VelocityDbType65623.csv",
"VelocityDb.Collection.Comparer.VelocityDbTypeComparer65655.csv"
};
var schemaInternalTypeFileInfo = new List <FileInfo>();
foreach (var fileName in schemaInternalTypeFiles)
{
schemaInternalTypeFileInfo.Add(di.GetFiles(fileName, SearchOption.TopDirectoryOnly).First());
}
foreach (FileInfo info in schemaInternalTypeFileInfo)
{
string numberString = Regex.Match(info.Name, @"\d+").Value;
if (numberString.Length > 0)
{
UInt32 typeShortId = UInt32.Parse(numberString);
UInt16 slotNumber = (UInt16)typeShortId;
TypeVersion tv = schema.GetTypeVersion(typeShortId, session);
if (tv != null)
{
using (StreamReader textReader = new StreamReader(info.FullName))
{
CsvReader csvReader = new CsvReader(textReader, true);
string[] fileldNames = csvReader.GetFieldHeaders();
foreach (string[] record in csvReader)
{
tv.ObjectBytesFromStrings(record, fileldNames, session, schema);
}
}
}
}
}
Database schemaDb = session.OpenDatabase(Schema.SchemaDB);
Page schemaPage = schemaDb.CachedPage(1);
schemaPage.FinishUpCsvImport();
var schemaTypes = new UInt32[] { 65747, 65749, 65753, 65745, 65623, 65655 };
for (int i = 0; i < 2; i++)
{
foreach (FileInfo info in files)
{
string numberString = Regex.Match(info.Name, @"\d+").Value;
if (numberString.Length > 0)
{
UInt32 typeShortId = UInt32.Parse(numberString);
UInt16 slotNumber = (UInt16)typeShortId;
if (((i == 0 && slotNumber < Schema.s_bootupTypeCountExpanded) || (i == 1 && slotNumber >= Schema.s_bootupTypeCountExpanded)) && !schemaTypes.Contains(typeShortId))
{
TypeVersion tv = schema.GetTypeVersion(typeShortId, session);
if (tv != null)
{
using (StreamReader textReader = new StreamReader(info.FullName))
{
var csvReader = new CsvReader(textReader, true);
string[] fileldNames = csvReader.GetFieldHeaders();
foreach (string[] record in csvReader)
{
tv.ObjectBytesFromStrings(record, fileldNames, session, schema);
}
}
}
}
}
}
}
}
/// <summary>
/// Restores database files, pages and objects from a .csv file data created with ExportToCSV
/// </summary>
/// <param name="session">the active session</param>
/// <param name="csvDirectory">Path to directory containing CSV files</param>
static public void ImportFromCSV(this SessionBase session, string csvDirectory)
{
const char fieldSeperator = ',';
DirectoryInfo di = new DirectoryInfo(csvDirectory);
#if WINDOWS_PHONE
List <FileInfo> files = di.GetFiles("*.csv").ToList();
#else
List <FileInfo> files = di.GetFiles("*.csv", SearchOption.TopDirectoryOnly).ToList();
#endif
Schema schema = session.OpenSchema(false);
using (StreamReader textReader = new StreamReader(Path.Combine(csvDirectory, "Database.csv")))
{
string header = textReader.ReadLine();
string dbInfoString = textReader.ReadLine();
while (dbInfoString != null)
{
string[] dbInfo = dbInfoString.Split(fieldSeperator);
UInt32 dbNum = UInt32.Parse(dbInfo[0]);
string dbName = dbInfo[1].Trim(new char[] { '"' });
Database db = null;
if (dbNum < 10)
{
db = session.OpenDatabase(dbNum, false, false);
}
if (db == null)
{
db = session.NewDatabase(dbNum, 0, dbName);
}
dbInfoString = textReader.ReadLine();
}
}
using (StreamReader textReader = new StreamReader(Path.Combine(csvDirectory, "Page.csv")))
{
string header = textReader.ReadLine();
string pageInfoString = textReader.ReadLine();
while (pageInfoString != null)
{
int i = 0;
string[] pageInfo = pageInfoString.Split(fieldSeperator);
UInt32 dbNum = UInt32.Parse(pageInfo[i++]);
UInt16 pageNum = UInt16.Parse(pageInfo[i++]);
UInt16 numberOfSlots = UInt16.Parse(pageInfo[i++]);
UInt16 firstFreeSlot = UInt16.Parse(pageInfo[i++]);
UInt64 versionNumber = UInt64.Parse(pageInfo[i++]);
PageInfo.encryptionKind encryptionKind = (PageInfo.encryptionKind)Enum.Parse(typeof(PageInfo.encryptionKind), pageInfo[i++]);
PageInfo.compressionKind compressed = (PageInfo.compressionKind)Enum.Parse(typeof(PageInfo.compressionKind), pageInfo[i++]);
UInt32 typeVersion = UInt32.Parse(pageInfo[i]);
Database db = session.OpenDatabase(dbNum, false, false);
Page page = db.CachedPage(pageNum);
if (page == null)
{
page = new Page(db, pageNum, typeVersion, numberOfSlots);
page.PageInfo.Compressed = compressed;
page.PageInfo.Encryption = encryptionKind;
page.PageInfo.VersionNumber = versionNumber;
page.PageInfo.NumberOfSlots = numberOfSlots;
page.PageInfo.FirstFreeSlot = firstFreeSlot;
session.UpdatePage(ref page);
}
pageInfoString = textReader.ReadLine();
}
}
for (int i = 0; i < 2; i++)
{
foreach (FileInfo info in files)
{
string numberString = Regex.Match(info.Name, @"\d+").Value;
if (numberString.Length > 0)
{
UInt32 typeShortId = UInt32.Parse(numberString);
UInt16 slotNumber = (UInt16)typeShortId;
if ((i == 0 && slotNumber < Schema.s_bootupTypeCount) || (i == 1 && slotNumber >= Schema.s_bootupTypeCount))
{
TypeVersion tv = schema.GetTypeVersion(typeShortId, session);
if (tv != null)
{
using (StreamReader textReader = new StreamReader(info.FullName))
{
CsvReader csvReader = new CsvReader(textReader, true);
string[] fileldNames = csvReader.GetFieldHeaders();
foreach (string[] record in csvReader)
{
tv.ObjectBytesFromStrings(record, fileldNames, session, schema);
}
}
}
}
}
}
}
}
static public void SyncWith(this SessionBase sessionToUpdate, SessionBase sessionToRead, Func <SessionBase, UInt64, Change, bool> doUpdate)
{
UInt64 currentVersion;
UInt64 pageToReadVersion;
bool conflictFound = false;
using (var reader = sessionToRead.BeginRead())
{
Changes changes = (Changes)sessionToRead.Open(5, 1, 1, false);
if (changes != null)
{
using (var updater = sessionToUpdate.BeginUpdate())
{
var dbs = sessionToUpdate.OpenAllDatabases();
ReplicaSync matchingReplicaSync = null;
foreach (ReplicaSync sync in sessionToUpdate.AllObjects <ReplicaSync>())
{
if (sync.SyncFromHost == sessionToRead.SystemHostName && sync.SyncFromPath == sessionToRead.SystemDirectory)
{
matchingReplicaSync = sync;
break;
}
}
if (changes.ChangeList.Count > 0)
{
foreach (TransactionChanges transactionChanges in changes.ChangeList)
{
if (matchingReplicaSync == null || matchingReplicaSync.TransactionNumber < transactionChanges.TransactionNumber)
{
foreach (Change change in transactionChanges.ChangeList)
{
Database dbToUpdate = sessionToUpdate.OpenDatabase(change.DatabaseId, false, false);
Database dbToRead = sessionToRead.OpenDatabase(change.DatabaseId, false, false);
string dbName = dbToRead != null ? dbToRead.Name : null;
if (change.Deleted)
{
if (dbToUpdate == null) // does not exist
{
continue;
}
if (change.PageId == 0) // Database delete
{
currentVersion = dbToUpdate.Page.PageInfo.VersionNumber;
if (currentVersion < change.Version)
{
sessionToUpdate.DeleteDatabase(dbToUpdate);
}
else
{
conflictFound = true;
if (doUpdate(sessionToUpdate, currentVersion, change))
{
sessionToUpdate.DeleteDatabase(dbToUpdate);
}
}
}
else
{
Page page = sessionToUpdate.OpenPage(dbToUpdate, change.PageId);
if (page == null) // page does not exist
{
continue;
}
currentVersion = page.PageInfo.VersionNumber;
if (currentVersion < change.Version)
{
sessionToUpdate.DeletePage(dbToUpdate, page);
}
else
{
conflictFound = true;
if (doUpdate(sessionToUpdate, currentVersion, change))
{
sessionToUpdate.DeleteDatabase(dbToUpdate);
}
}
}
}
else
{
if (dbToUpdate == null) // does not exist
{
dbToUpdate = sessionToUpdate.NewDatabase(change.DatabaseId, 0, dbName);
}
if (change.PageId > 0)
{
Page pageToUpdate = sessionToUpdate.OpenPage(dbToUpdate, change.PageId);
Page pageToRead = sessionToRead.OpenPage(dbToRead, change.PageId);
if (pageToRead == null) // upcoming (not yet processed) changes must have deleted this page
{
continue;
}
currentVersion = pageToUpdate == null ? 0 : pageToUpdate.PageInfo.VersionNumber;
pageToReadVersion = pageToRead.PageInfo.VersionNumber;
if (currentVersion < pageToReadVersion || dbToUpdate.IsNew)
{
sessionToUpdate.ReplacePage(dbToUpdate, pageToUpdate, pageToRead);
}
else
{
conflictFound = true;
if (doUpdate(sessionToUpdate, currentVersion, change))
{
sessionToUpdate.ReplacePage(dbToUpdate, pageToUpdate, pageToRead);
}
}
}
}
}
}
}
UInt64 lastTransactionNumber = changes.ChangeList.Last().TransactionNumber;
if (matchingReplicaSync != null)
{
matchingReplicaSync.TransactionNumber = lastTransactionNumber;
}
if (conflictFound)
{
sessionToUpdate.Verify();
}
sessionToUpdate.Commit();
if (matchingReplicaSync == null)
{
sessionToUpdate.BeginUpdate(); // separate transaction or else gets confused with databases added by sync
matchingReplicaSync = new ReplicaSync(sessionToRead, lastTransactionNumber);
sessionToUpdate.Persist(matchingReplicaSync);
sessionToUpdate.Commit();
}
}
}
}
}
}
public void Recover1(SessionBase session)
{
Database db = null;
session.BeginUpdate();
session.RegisterClass(typeof(SortedSetAny <int>));
session.RegisterClass(typeof(SortedSetAny <float>));
db = session.OpenDatabase(88, true, false);
if (db != null)
{
session.DeleteDatabase(db);
}
db = session.OpenDatabase(89, true, false);
if (db != null)
{
session.DeleteDatabase(db);
}
session.Commit();
session.BeginUpdate();
db = session.NewDatabase(88);
session.FlushUpdates();
session.Abort();
session.BeginUpdate();
db = session.NewDatabase(88);
SortedSetAny <float> floatSet;
Oid floatSetOid;
string dbPath = System.IO.Path.Combine(systemDir, "89.odb");
Placement place = new Placement(88);
for (int i = 0; i < 10; i++)
{
floatSet = new SortedSetAny <float>();
floatSet.Persist(place, session);
floatSetOid = floatSet.Oid;
}
db = session.NewDatabase(89);
session.Commit();
File.Delete(dbPath);
session.BeginUpdate();
db = session.NewDatabase(89);
session.Commit();
FileInfo info = new FileInfo(dbPath);
info.CopyTo(dbPath + "X");
session.BeginUpdate();
SortedSetAny <int> intSet;
place = new Placement(89);
for (int i = 0; i < 10; i++)
{
intSet = new SortedSetAny <int>();
intSet.Persist(place, session);
}
db = session.OpenDatabase(88);
var list = db.AllObjects <SortedSetAny <float> >();
foreach (SortedSetAny <float> set in list)
{
set.Unpersist(session);
}
db = session.OpenDatabase(89);
session.Commit();
intSet = null;
db = null; // release refs so that cached data isn't stale
File.Delete(dbPath);
info = new FileInfo(dbPath + "X");
info.MoveTo(dbPath);
session.BeginUpdate();
intSet = (SortedSetAny <int>)session.Open(89, 1, 1, false);
Debug.Assert(intSet == null);
object o = session.Open(88, 1, 1, false);
floatSet = (SortedSetAny <float>)o;
Debug.Assert(floatSet != null);
session.Checkpoint();
db = session.OpenDatabase(88);
session.DeleteDatabase(db);
db = session.OpenDatabase(89);
session.DeleteDatabase(db);
session.Commit();
}
public void Recover1(SessionBase session)
{
Database db = null;
session.BeginUpdate();
db = session.OpenDatabase(88, true, false);
if (db != null)
session.DeleteDatabase(db);
db = session.OpenDatabase(89, true, false);
if (db != null)
session.DeleteDatabase(db);
session.Commit();
session.BeginUpdate();
db = session.NewDatabase(88);
session.FlushUpdates();
session.Abort();
session.BeginUpdate();
db = session.NewDatabase(88);
SortedSetAny<float> floatSet;
Oid floatSetOid;
string dbPath = System.IO.Path.Combine(systemDir, "89.odb");
Placement place = new Placement(88);
for (int i = 0; i < 10; i++)
{
floatSet = new SortedSetAny<float>();
floatSet.Persist(place, session);
floatSetOid = floatSet.Oid;
}
db = session.NewDatabase(89);
session.Commit();
File.Delete(dbPath);
session.BeginUpdate();
db = session.NewDatabase(89);
session.Commit();
FileInfo info = new FileInfo(dbPath);
info.CopyTo(dbPath + "X");
session.BeginUpdate();
SortedSetAny<int> intSet;
place = new Placement(89);
for (int i = 0; i < 10; i++)
{
intSet = new SortedSetAny<int>();
intSet.Persist(place, session);
}
db = session.OpenDatabase(88);
var list = db.AllObjects<SortedSetAny<float>>();
foreach (SortedSetAny<float> set in list)
set.Unpersist(session);
db = session.OpenDatabase(89);
session.Commit();
intSet = null;
db = null; // release refs so that cached data isn't stale
File.Delete(dbPath);
info = new FileInfo(dbPath + "X");
info.MoveTo(dbPath);
session.BeginUpdate();
intSet = (SortedSetAny<int>)session.Open(89, 1, 1, false);
Debug.Assert(intSet == null);
object o = session.Open(88, 1, 1, false);
floatSet = (SortedSetAny<float>)o;
Debug.Assert(floatSet != null);
session.Commit();
session.BeginUpdate();
db = session.OpenDatabase(88);
session.DeleteDatabase(db);
db = session.OpenDatabase(89);
session.DeleteDatabase(db);
session.Commit();
}
