public bool openDbTest(
string sDbName,
DbSystem dbSystem)
{
Db db = null;
beginTest( "Open Database Test (" + sDbName + ")");
try
{
db = dbSystem.dbOpen( sDbName, null, null, null, false);
}
catch (XFlaimException ex)
{
endTest( false, ex, "opening database");
return( false);
}
if (db != null)
{
db.close();
db = null;
}
endTest( false, true);
return( true);
}
public bool backupDbTest(
string sDbName,
string sBackupPath,
DbSystem dbSystem)
{
Db db = null;
Backup backup = null;
MyBackupStatus backupStatus = null;
// Try backing up the database
beginTest( "Backup Database Test (" + sDbName + " to directory \"" + sBackupPath + "\")");
try
{
db = dbSystem.dbOpen( sDbName, null, null, null, false);
}
catch (XFlaimException ex)
{
endTest( false, ex, "opening database");
return( false);
}
// Backup the database
try
{
backup = db.backupBegin( true, false, 0);
}
catch (XFlaimException ex)
{
endTest( false, ex, "calling backupBegin");
return( false);
}
// Perform the backup
backupStatus = new MyBackupStatus();
try
{
backup.backup( sBackupPath, null, null, backupStatus);
}
catch (XFlaimException ex)
{
endTest( backupStatus.outputLines(), ex, "calling backup");
return( false);
}
// End the backup
try
{
backup.endBackup();
}
catch (XFlaimException ex)
{
endTest( backupStatus.outputLines(), ex, "calling endBackup");
return( false);
}
db.close();
db = null;
endTest( backupStatus.outputLines(), true);
return( true);
}
public bool statsTests(
string sDbName,
DbSystem dbSystem)
{
Db db = null;
DbSystemStats stats = null;
uint uiNumDatabases;
uint uiStartTime;
uint uiStopTime;
CS_XFLM_DB_STATS dbStats = null;
CS_XFLM_LFILE_STATS lFileStats = null;
beginTest( "Start statistics");
try
{
dbSystem.startStats();
}
catch (XFlaimException ex)
{
endTest( false, ex, "starting statistics");
return( false);
}
endTest( false, true);
// Open a database to make some statistics happen
beginTest( "Open Database Test (" + sDbName + ")");
try
{
db = dbSystem.dbOpen( sDbName, null, null, null, false);
}
catch (XFlaimException ex)
{
endTest( false, ex, "opening database");
return( false);
}
if (db != null)
{
db.close();
db = null;
}
endTest( false, true);
// Stop collecting statistics
beginTest( "Stop statistics");
try
{
dbSystem.stopStats();
}
catch (XFlaimException ex)
{
endTest( false, ex, "stopping statistics");
return( false);
}
endTest( false, true);
// Get statistics
beginTest( "Get statistics");
try
{
stats = dbSystem.getStats();
}
catch (XFlaimException ex)
{
endTest( false, ex, "getting statistics");
return( false);
}
endTest( false, true);
// Get general statistics
beginTest( "Get general statistics");
try
{
stats.getGeneralStats( out uiNumDatabases, out uiStartTime,
out uiStopTime);
}
catch (XFlaimException ex)
{
endTest( false, ex, "getting statistics");
return( false);
}
endTest( false, true);
printUIntStat( 0, "Databases", uiNumDatabases);
printUIntStat( 0, "Start Time", uiStartTime);
printUIntStat( 0, "Stop Time", uiStopTime);
// Get Database statistics
for (uint uiLoop = 0; uiLoop < uiNumDatabases; uiLoop++)
{
beginTest( "Get database statistics for DB#" + uiLoop);
try
{
dbStats = stats.getDbStats( uiLoop, dbStats);
}
catch (XFlaimException ex)
{
endTest( false, ex, "getting database statistics");
return( false);
}
endTest( false, true);
printStrStat( 0, "Database Name", dbStats.sDbName);
printUIntStat( 0, "Logical File Count", dbStats.uiNumLFiles);
System.Console.WriteLine( "Read Transactions");
printCountTimeStat( 1, "Committed Transactions", dbStats.ReadTransStats.CommittedTrans);
printCountTimeStat( 1, "Aborted Transactions", dbStats.ReadTransStats.AbortedTrans);
System.Console.WriteLine( "Update Transactions");
printCountTimeStat( 1, "Committed Transactions", dbStats.UpdateTransStats.CommittedTrans);
printCountTimeStat( 1, "Aborted Transactions", dbStats.UpdateTransStats.AbortedTrans);
printCountTimeStat( 1, "Group Completes", dbStats.UpdateTransStats.GroupCompletes);
printULongStat( 1, "Group Finished", dbStats.UpdateTransStats.ulGroupFinished);
printBlockIOStats( 0, "LFH Block Stats", dbStats.LFHBlockStats);
printBlockIOStats( 0, "Avail Block Stats", dbStats.AvailBlockStats);
printDiskIOStats( 0, "Database Header Writes", dbStats.DbHdrWrites);
printDiskIOStats( 0, "Log Block Writes", dbStats.LogBlockWrites);
printDiskIOStats( 0, "Log Block Restores", dbStats.LogBlockRestores);
printDiskIOStats( 0, "Log Block Reads", dbStats.LogBlockReads);
printUIntStat( 0, "Log Block Checksum Errors", dbStats.uiLogBlockChkErrs);
printUIntStat( 0, "Read Errors", dbStats.uiReadErrors);
printCountTimeStat( 0, "No Locks", dbStats.LockStats.NoLocks);
printCountTimeStat( 0, "Waiting For Lock", dbStats.LockStats.WaitingForLock);
printCountTimeStat( 0, "Held Lock", dbStats.LockStats.HeldLock);
for (uint uiLoop2 = 0; uiLoop2 < dbStats.uiNumLFiles; uiLoop2++)
{
beginTest( " Get database statistics for DB#" + uiLoop + ", LFile#" + uiLoop2);
try
{
lFileStats = stats.getLFileStats( uiLoop, uiLoop2, lFileStats);
}
catch (XFlaimException ex)
{
endTest( false, ex, "getting logical file statistics");
return( false);
}
endTest( false, true);
System.Console.WriteLine( " LOGICAL FILE {0} ({1})",
lFileStats.uiLFileNum, lFileStats.eLfType);
printBlockIOStats( 2, "Root Block Stats", lFileStats.RootBlockStats);
printBlockIOStats( 2, "Middle Block Stats", lFileStats.MiddleBlockStats);
printBlockIOStats( 2, "Leaf Block Stats", lFileStats.LeafBlockStats);
printULongStat( 2, "Block Splits", lFileStats.ulBlockSplits);
printULongStat( 2, "Block Combines", lFileStats.ulBlockCombines);
}
}
return( true);
}
//-----------------------------------------------------------------------
// This method opens or creates the sample database.
//-----------------------------------------------------------------------
static Db createOrOpenDatabase( DbSystem dbSystem, out bool bCreatedDatabase)
{
Db db;
string sDbName = "sample.db";
// Try to open a database. If that fails, create it. The following
// example creates the database in the current directory. However,
// a full or partial file name may be specified.
// NOTE: Multiple threads should each do their own open of the
// database and get back their own Db object.
try
{
db = dbSystem.dbOpen( sDbName, null, null, null, false);
}
catch (XFlaimException ex)
{
if (ex.getRCode() != RCODE.NE_XFLM_IO_PATH_NOT_FOUND)
{
throw ex;
}
db = dbSystem.dbCreate( sDbName, null, null, null, null, null);
bCreatedDatabase = true;
}
return( db);
}
