public static MyRM.MyRM_Accessor MockRM(string dbname="test")
{
var db = new SimpleDatabase(dbname, true);
db.CreateTable(Constants.ReservationTableName, 96, 36);
db.CreateTable(Constants.ResourcesTableName, 96, 36);
var tm = new MyTM.MyTM();
var rm = new MyRM_Accessor
{
_transactionStorage = new TransactionStorage(db),
TransactionManager = tm,
_name = dbname
};
tm.Register(rm);
return rm;
}
static void Main(string[] args)
{
var db = new SimpleDatabase(args[0], true, true);
var pageTable = db.DiskReadPageTable(args[1]);
System.Console.WriteLine("Database is {0}, index item size is {1}", args[0], pageTable.RecordIndexEntrySizeInBytes);
foreach (var r in pageTable.RecordIndices)
{
bool isNotFound = false;
Row row = null;
try
{
row = db.ReadRecord(null, args[1], Trim(r.Key));
}
catch (RecordNotFoundException)
{
isNotFound = true;
}
System.Console.WriteLine("Key={0}, P={1}, R={2}, F={3}, Data={4}", r.Key, r.PageIndex, r.RowIndex, r.ActiveFileId, isNotFound ? "not found" : row.DataString);
}
System.Console.WriteLine("Total rows {0}", pageTable.RecordIndices.Length);
}
private SimpleDatabase CreateDatabase()
{
var db = new SimpleDatabase("TEST_" + Guid.NewGuid(), useTwoPhaseCommit: true);
db.CreateTable(Constants.ReservationTableName, 96, 36);
db.CreateTable(Constants.ResourcesTableName, 96, 36);
return db;
}
protected void InitStorage()
{
var database = new SimpleDatabase("MYRM_" + _name, true);
//TODO: BUGBUG: add validation to check the data and key length
database.CreateTable(Constants.ReservationTableName, 96, 36);
database.CreateTable(Constants.ResourcesTableName, 96, 36);
_transactionStorage = new TransactionStorage(database);
}
