public void GetCursur(string dbFileName, bool ifConfig)
{
HeapDatabaseConfig dbConfig = new HeapDatabaseConfig();
dbConfig.Creation = CreatePolicy.IF_NEEDED;
HeapDatabase db = HeapDatabase.Open(dbFileName, dbConfig);
HeapRecordId rid = db.Append(
new DatabaseEntry(BitConverter.GetBytes((int)1)));
Cursor cursor;
CursorConfig cursorConfig = new CursorConfig();
cursorConfig.Priority = CachePriority.HIGH;
if (ifConfig == false)
{
cursor = db.Cursor();
}
else
{
cursor = db.Cursor(cursorConfig);
}
cursor.Add(new KeyValuePair <DatabaseEntry, DatabaseEntry>(
new DatabaseEntry(rid.toArray()),
new DatabaseEntry(BitConverter.GetBytes((int)2))));
Cursor dupCursor = cursor.Duplicate(false);
Assert.IsNull(dupCursor.Current.Key);
if (ifConfig)
{
Assert.AreEqual(CachePriority.HIGH, dupCursor.Priority);
}
dupCursor.Close();
cursor.Close();
db.Close();
}
public void PutRecordCase1(HeapDatabase db, Transaction txn)
{
byte[] bigArray = new byte[4000];
HeapRecordId rid = new HeapRecordId(2, 0);
for (int i = 1; i <= 100; i++)
{
if (txn == null)
{
rid = db.Append(
new DatabaseEntry(BitConverter.GetBytes(i)));
}
else
{
rid = db.Append(
new DatabaseEntry(BitConverter.GetBytes(i)), txn);
}
}
DatabaseEntry key = new DatabaseEntry(rid.toArray());
for (int i = 100; i <= 500; i++)
{
if (txn == null)
{
db.Put(key, new DatabaseEntry(bigArray));
}
else
{
db.Put(key, new DatabaseEntry(bigArray), txn);
}
}
}
public void TestAppendWithoutTxn()
{
testName = "TestAppendWithoutTxn";
SetUpTest(true);
string heapDBFileName = testHome + "/" + testName + ".db";
HeapDatabaseConfig heapConfig = new HeapDatabaseConfig();
heapConfig.Creation = CreatePolicy.ALWAYS;
HeapDatabase heapDB = HeapDatabase.Open(
heapDBFileName, heapConfig);
byte[] byteArr = new byte[4];
byteArr = BitConverter.GetBytes((int)1);
DatabaseEntry data = new DatabaseEntry(byteArr);
HeapRecordId rid = heapDB.Append(data);
// Confirm that the record lives on a page larger than 0.
Assert.AreNotEqual(0, rid.PageNumber);
// Confirm that the record exists in the database.
DatabaseEntry key = new DatabaseEntry(rid.toArray());
Assert.IsTrue(heapDB.Exists(key));
heapDB.Close();
}
public void TestStats()
{
testName = "TestStats";
SetUpTest(true);
string dbFileName = testHome + "/" +
testName + ".db";
HeapDatabaseConfig dbConfig =
new HeapDatabaseConfig();
ConfigCase1(dbConfig);
HeapDatabase db = HeapDatabase.Open(dbFileName, dbConfig);
HeapStats stats = db.Stats();
ConfirmStatsPart1Case1(stats);
db.PrintFastStats(true);
// Put 500 records into the database.
PutRecordCase1(db, null);
stats = db.Stats();
ConfirmStatsPart2Case1(stats);
db.PrintFastStats();
db.Close();
}
public void TestMessageFile()
{
testName = "TestMessageFile";
SetUpTest(true);
// Configure and open an environment.
DatabaseEnvironmentConfig envConfig =
new DatabaseEnvironmentConfig();
envConfig.Create = true;
envConfig.UseMPool = true;
DatabaseEnvironment env = DatabaseEnvironment.Open(
testHome, envConfig);
// Configure and open a database.
HeapDatabaseConfig DBConfig =
new HeapDatabaseConfig();
DBConfig.Env = env;
DBConfig.Creation = CreatePolicy.IF_NEEDED;
string DBFileName = testName + ".db";
HeapDatabase db = HeapDatabase.Open(DBFileName, DBConfig);
// Confirm message file does not exist.
string messageFile = testHome + "/" + "msgfile";
Assert.AreEqual(false, File.Exists(messageFile));
// Call set_msgfile() of db.
db.Msgfile = messageFile;
// Print db statistic to message file.
db.PrintStats(true);
// Confirm message file exists now.
Assert.AreEqual(true, File.Exists(messageFile));
db.Msgfile = "";
string line = null;
// Read the third line of message file.
System.IO.StreamReader file = new System.IO.StreamReader(@"" + messageFile);
line = file.ReadLine();
line = file.ReadLine();
line = file.ReadLine();
// Confirm the message file is not empty.
Assert.AreEqual(line, "DB handle information:");
file.Close();
// Close database and environment.
db.Close();
env.Close();
}
public void StatsInTxn(string home, string name, bool ifIsolation)
{
DatabaseEnvironmentConfig envConfig =
new DatabaseEnvironmentConfig();
EnvConfigCase1(envConfig);
DatabaseEnvironment env = DatabaseEnvironment.Open(
home, envConfig);
Transaction openTxn = env.BeginTransaction();
HeapDatabaseConfig dbConfig =
new HeapDatabaseConfig();
ConfigCase1(dbConfig);
dbConfig.Env = env;
HeapDatabase db = HeapDatabase.Open(name + ".db",
dbConfig, openTxn);
openTxn.Commit();
Transaction statsTxn = env.BeginTransaction();
HeapStats stats;
if (ifIsolation == false)
{
stats = db.Stats(statsTxn);
}
else
{
stats = db.Stats(statsTxn, Isolation.DEGREE_ONE);
}
ConfirmStatsPart1Case1(stats);
db.Msgfile = home + "/" + name + ".log";
db.PrintStats(true);
// Put 500 records into the database.
PutRecordCase1(db, statsTxn);
if (ifIsolation == false)
{
stats = db.Stats(statsTxn);
}
else
{
stats = db.Stats(statsTxn, Isolation.DEGREE_TWO);
}
ConfirmStatsPart2Case1(stats);
db.PrintStats();
statsTxn.Commit();
db.Close();
env.Close();
}
public static void Confirm(XmlElement xmlElem,
HeapDatabase heapDB, bool compulsory)
{
DatabaseTest.Confirm(xmlElem, heapDB, compulsory);
// Confirm heap database specific field/property
Assert.AreEqual(DatabaseType.HEAP, heapDB.Type);
string type = heapDB.Type.ToString();
Assert.IsNotNull(type);
}
public HeapTransactionState(HeapDatabase db, int id)
{
allocated = new Dictionary<long, Stream>();
this.db = db;
this.id = id;
tables = new Dictionary<TableName, ITable>();
indexes = new Dictionary<IndexName, ITableIndex>();
schemata = new List<string>();
foreach (KeyValuePair<TableName, ITable> table in db.tables) {
tables[table.Key] = table.Value;
}
}
public void TestAppendWithTxn()
{
testName = "TestAppendWithTxn";
SetUpTest(true);
string heapDBFileName = testHome + "/" + testName + ".db";
string heapDBName =
Path.GetFileNameWithoutExtension(heapDBFileName);
DatabaseEnvironmentConfig envConfig =
new DatabaseEnvironmentConfig();
envConfig.Create = true;
envConfig.UseTxns = true;
envConfig.UseMPool = true;
DatabaseEnvironment env = DatabaseEnvironment.Open(
testHome, envConfig);
Transaction txn = env.BeginTransaction();
HeapDatabaseConfig heapConfig = new HeapDatabaseConfig();
heapConfig.Creation = CreatePolicy.ALWAYS;
heapConfig.Env = env;
/* If environmnet home is set, the file name in
* Open() is the relative path.
*/
HeapDatabase heapDB = HeapDatabase.Open(
heapDBName, heapConfig, txn);
DatabaseEntry data;
int i = 1000;
try {
while (i > 0)
{
data = new DatabaseEntry(
BitConverter.GetBytes(i));
heapDB.Append(data, txn);
i--;
}
txn.Commit();
} catch {
txn.Abort();
} finally {
heapDB.Close();
env.Close();
}
}
public void TestOpenExistingHeapDB()
{
testName = "TestOpenExistingHeapDB";
SetUpTest(true);
string heapDBFileName = testHome + "/" + testName + ".db";
HeapDatabaseConfig heapConfig = new HeapDatabaseConfig();
heapConfig.Creation = CreatePolicy.ALWAYS;
HeapDatabase heapDB = HeapDatabase.Open(
heapDBFileName, heapConfig);
heapDB.Close();
DatabaseConfig dbConfig = new DatabaseConfig();
Database db = Database.Open(heapDBFileName, dbConfig);
Assert.AreEqual(db.Type, DatabaseType.HEAP);
db.Close();
}
public void TestHeapRegionsize()
{
/*
* Check that with a very small region size, the number of regions
* grows quickly.
*/
testName = "TestHeapRegionsize";
SetUpTest(true);
Random r = new Random();
byte[] buf = new byte[1024];
r.NextBytes(buf);
HeapDatabaseConfig cfg = new HeapDatabaseConfig();
cfg.Creation = CreatePolicy.ALWAYS;
cfg.PageSize = 512;
cfg.RegionSize = 4;
HeapDatabase db = HeapDatabase.Open(
testHome + "/" + testName + ".db", cfg);
DatabaseEntry dbt = new DatabaseEntry(buf);
for (int i = 0; i < 10; i++)
{
db.Append(dbt);
}
Assert.AreEqual(db.RegionSize, 4);
HeapStats stats = db.Stats();
db.Close();
Assert.AreEqual(stats.RegionSize, 4);
Assert.Greater(stats.nRegions, 1);
}
public void TestOpenNewHeapDB()
{
testName = "TestOpenNewHeapDB";
SetUpTest(true);
string heapDBFileName = testHome + "/" + testName + ".db";
// Configure all fields/properties in heap database.
XmlElement xmlElem = Configuration.TestSetUp(
testFixtureName, testName);
HeapDatabaseConfig heapConfig = new HeapDatabaseConfig();
HeapDatabaseConfigTest.Config(xmlElem, ref heapConfig, true);
heapConfig.Feedback = new DatabaseFeedbackDelegate(DbFeedback);
// Open the heap database with above configuration.
HeapDatabase heapDB = HeapDatabase.Open(
heapDBFileName, heapConfig);
// Check the fields/properties in opened heap database.
Confirm(xmlElem, heapDB, true);
heapDB.Close();
}
protected Repository(string databaseName, ILoggerFactory loggerService)
{
path = Environment.GetEnvironmentVariable("DATA_DIR");
logger = loggerService.CreateLogger(databaseName);
var cfg = new HeapDatabaseConfig()
{
Creation = CreatePolicy.IF_NEEDED,
CacheSize = new CacheInfo(1, 0, 1),
ErrorFeedback = (prefix, message) =>
{
var fg = Console.ForegroundColor;
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"{prefix}: {message}");
Console.ForegroundColor = fg;
},
ErrorPrefix = databaseName,
//Duplicates = DuplicatesPolicy.SORTED,
//TableSize = tableSize
};
db = HeapDatabase.Open(Path.Combine(path, databaseName + ".db"), cfg);
}
public void TestPutHeap()
{
KeyValuePair <DatabaseEntry, DatabaseEntry> pair;
testName = "TestPutHeap";
SetUpTest(true);
string heapDBFileName = testHome + "/" +
testName + ".db";
HeapDatabaseConfig heapConfig =
new HeapDatabaseConfig();
heapConfig.Creation = CreatePolicy.ALWAYS;
using (HeapDatabase heapDB = HeapDatabase.Open(
heapDBFileName, heapConfig)) {
DatabaseEntry data = new DatabaseEntry(
BitConverter.GetBytes((int)1));
HeapRecordId rid = heapDB.Append(data);
DatabaseEntry key = new DatabaseEntry(rid.toArray());
data = new DatabaseEntry(BitConverter.GetBytes((int)2));
heapDB.Put(key, data);
pair = heapDB.GetBoth(key, data);
}
}
public void TestExists()
{
testName = "TestExists";
SetUpTest(true);
DatabaseEnvironmentConfig envConfig =
new DatabaseEnvironmentConfig();
envConfig.Create = true;
envConfig.UseLocking = true;
envConfig.UseLogging = true;
envConfig.UseMPool = true;
envConfig.UseTxns = true;
DatabaseEnvironment env = DatabaseEnvironment.Open(
testHome, envConfig);
HeapDatabase db;
try {
Transaction openTxn = env.BeginTransaction();
try {
HeapDatabaseConfig heapConfig =
new HeapDatabaseConfig();
heapConfig.Creation = CreatePolicy.IF_NEEDED;
heapConfig.Env = env;
db = HeapDatabase.Open(testName + ".db",
heapConfig, openTxn);
openTxn.Commit();
} catch (DatabaseException e) {
openTxn.Abort();
throw e;
}
Transaction cursorTxn = env.BeginTransaction();
Cursor cursor;
HeapRecordId rid;
try {
/*
* Put a record into heap database with
* cursor and abort the operation.
*/
rid = db.Append(new DatabaseEntry(
ASCIIEncoding.ASCII.GetBytes("foo")), cursorTxn);
cursor = db.Cursor(cursorTxn);
KeyValuePair <DatabaseEntry, DatabaseEntry> pair;
pair = new KeyValuePair <DatabaseEntry, DatabaseEntry>(
new DatabaseEntry(rid.toArray()),
new DatabaseEntry(ASCIIEncoding.ASCII.GetBytes("bar")));
cursor.Add(pair);
cursor.Close();
Assert.IsTrue(db.Exists(
new DatabaseEntry(rid.toArray()), cursorTxn));
cursorTxn.Abort();
} catch (DatabaseException e) {
cursorTxn.Abort();
db.Close();
throw e;
}
Transaction delTxn = env.BeginTransaction();
try {
/*
* The put operation is aborted in the heap
* database so querying if the record still exists
* throws KeyEmptyException.
*/
Assert.IsFalse(db.Exists(
new DatabaseEntry(rid.toArray()), delTxn));
delTxn.Commit();
} catch (DatabaseException e) {
delTxn.Abort();
throw e;
} finally {
db.Close();
}
} finally {
env.Close();
}
}
public void TestSetUp()
{
HeapDatabase testdb = new HeapDatabase(null, "testdb");
ITransactionState transaction = testdb.CreateTransaction();
transaction.CreateSchema("test");
IMutableTable table = (IMutableTable) transaction.CreateTable(new TableName("test", "names"));
table.Columns.Add("id", SqlType.Numeric, true);
table.Columns.Add("first_name", SqlType.String, true);
table.Columns.Add("last_name", SqlType.String, true);
TableRow row = table.NewRow();
row.SetValue("id", 1);
row.SetValue("first_name", "Antonello");
row.SetValue("last_name", "Provenzano");
row.Insert();
table.Commit();
table = (IMutableTable) transaction.CreateTable(new TableName("test", "books"));
table.Columns.Add("id", SqlType.Numeric, true);
table.Columns.Add("title", SqlType.String, true);
table.Columns.Add("author", SqlType.String, false);
row = table.NewRow();
row["id"] = 1;
row["title"] = "The Lord Of The Rings";
row["author"] = "J. R. R. Tolkien";
row.Insert();
row = table.NewRow();
row["id"] = 2;
row["title"] = "Buddenbrooks";
row["author"] = "Thomas Mann";
row.Insert();
table.Commit();
table = (IMutableTable) transaction.CreateTable(new TableName("test", "book_read"));
table.Columns.Add("id", SqlType.Numeric, true);
table.Columns.Add("book_id", SqlType.Numeric, true);
table.Columns.Add("name_id", SqlType.Numeric, true);
table.Columns.Add("read_date", SqlType.DateTime, true);
row = table.NewRow();
row["id"] = 1;
row["book_id"] = 1;
row["name_id"] = 1;
row["read_date"] = "2001-12-22";
row.Insert();
row = table.NewRow();
row["id"] = 2;
row["book_id"] = 2;
row["name_id"] = 1;
row["read_date"] = "2009-05-10";
row.Insert();
table.Commit();
testdb.CommitTransaction(transaction);
sessionContext = new EmbeddedSessionContext(testdb, true, "antonello");
connection = sessionContext.CreateConnection();
connection.Open();
try {
IDbCommand command = connection.CreateCommand();
command.CommandText = "SET SCHEMA test;";
command.ExecuteNonQuery();
} catch (Exception e) {
Console.Error.WriteLine("Error: {0}", e.Message);
Console.Error.WriteLine(e.StackTrace);
}
}
/*
* Test the blob database with or without environment.
* 1. Config and open the environment;
* 2. Verify the environment blob configs;
* 3. Config and open the database;
* 4. Verify the database blob configs;
* 5. Insert and verify some blob data by database methods;
* 6. Verify the stats;
* 7. Close all handles.
* If "blobdbt" is true, set the data DatabaseEntry.Blob as
* true, otherwise make the data DatabaseEntry reach the blob
* threshold in size.
*/
void TestBlobHeapDatabase(uint env_threshold, string env_blobdir,
uint db_threshold, string db_blobdir, bool blobdbt)
{
if (env_threshold == 0 && db_threshold == 0)
{
return;
}
string heapDBName =
testHome + "/" + testName + ".db";
Configuration.ClearDir(testHome);
HeapDatabaseConfig cfg = new HeapDatabaseConfig();
cfg.Creation = CreatePolicy.ALWAYS;
string blrootdir = "__db_bl";
// Open the environment and verify the blob configs.
if (env_threshold > 0)
{
DatabaseEnvironmentConfig envConfig =
new DatabaseEnvironmentConfig();
envConfig.AutoCommit = true;
envConfig.Create = true;
envConfig.UseMPool = true;
envConfig.UseLogging = true;
envConfig.UseTxns = true;
envConfig.UseLocking = true;
envConfig.BlobThreshold = env_threshold;
if (env_blobdir != null)
{
envConfig.BlobDir = env_blobdir;
blrootdir = env_blobdir;
}
DatabaseEnvironment env = DatabaseEnvironment.Open(
testHome, envConfig);
if (env_blobdir == null)
{
Assert.IsNull(env.BlobDir);
}
else
{
Assert.AreEqual(0,
env.BlobDir.CompareTo(env_blobdir));
}
Assert.AreEqual(env_threshold, env.BlobThreshold);
cfg.Env = env;
heapDBName = testName + ".db";
}
// Open the database and verify the blob configs.
if (db_threshold > 0)
{
cfg.BlobThreshold = db_threshold;
}
if (db_blobdir != null)
{
cfg.BlobDir = db_blobdir;
/*
* The blob directory setting in the database
* is effective only when it is opened without
* an environment.
*/
if (cfg.Env == null)
{
blrootdir = db_blobdir;
}
}
HeapDatabase db = HeapDatabase.Open(heapDBName, cfg);
Assert.AreEqual(
db_threshold > 0 ? db_threshold : env_threshold,
db.BlobThreshold);
if (db_blobdir == null && cfg.Env == null)
{
Assert.IsNull(db.BlobDir);
}
else
{
Assert.AreEqual(0, db.BlobDir.CompareTo(blrootdir));
}
// Insert and verify some blob data by database methods.
string[] records = { "a", "b", "c", "d", "e", "f", "g", "h",
"i", "j", "k", "l", "m", "n", "o", "p","q","r", "s",
"t", "u", "v", "w", "x", "y", "z" };
DatabaseEntry kdbt = new DatabaseEntry();
DatabaseEntry ddbt = new DatabaseEntry();
byte[] ddata;
string str;
KeyValuePair <DatabaseEntry, DatabaseEntry> pair;
ddbt.Blob = blobdbt;
Assert.AreEqual(blobdbt, ddbt.Blob);
for (int i = 0; i < records.Length; i++)
{
str = records[i];
if (!blobdbt)
{
for (int j = 0; j < db_threshold; j++)
{
str = str + records[i];
}
}
ddata = Encoding.ASCII.GetBytes(str);
ddbt.Data = ddata;
kdbt = new DatabaseEntry((db.Append(ddbt)).toArray());
try
{
pair = db.Get(kdbt);
}
catch (DatabaseException)
{
db.Close();
if (cfg.Env != null)
{
cfg.Env.Close();
}
throw new TestException();
}
Assert.AreEqual(ddata, pair.Value.Data);
}
/*
* Verify the blob files are created in the expected location.
* This part of test is disabled since BTreeDatabase.BlobSubDir
* is not exposed to users.
*/
//if (cfg.Env != null)
// blrootdir = testHome + "/" + blrootdir;
//string blobdir = blrootdir + "/" + db.BlobSubDir;
//Assert.AreEqual(records.Length,
// Directory.GetFiles(blobdir, "__db.bl*").Length);
//Assert.AreEqual(1,
// Directory.GetFiles(blobdir, "__db_blob_meta.db").Length);
// Verify the stats.
HeapStats st = db.Stats();
Assert.AreEqual(records.Length, st.nBlobRecords);
// Close all handles.
db.Close();
if (cfg.Env != null)
{
cfg.Env.Close();
}
/*
* Remove the default blob directory
* when it is not under the test home.
*/
if (db_blobdir == null && cfg.Env == null)
{
Directory.Delete("__db_bl", true);
}
}