public void BaseStationDBInfo_Constructor_Initialises_To_Known_State_And_Properties_Work()
{
var dbInfo = new BaseStationDBInfo();
TestUtilities.TestProperty(dbInfo, "CurrentVersion", 0, 126);
TestUtilities.TestProperty(dbInfo, "OriginalVersion", 0, 28);
}
/// <summary>
/// Generates parameters for a DB info object.
/// </summary>
/// <param name="dbInfo"></param>
/// <returns></returns>
public static DynamicParameters FromDBInfo(BaseStationDBInfo dbInfo)
{
var result = new DynamicParameters();
result.Add(nameof(dbInfo.OriginalVersion), value: dbInfo.OriginalVersion);
result.Add(nameof(dbInfo.CurrentVersion), value: dbInfo.CurrentVersion);
return(result);
}
/// <summary>
/// See interface docs.
/// </summary>
/// <returns></returns>
public BaseStationDBInfo GetDatabaseVersion()
{
BaseStationDBInfo result = null;
lock (_ConnectionLock) {
OpenConnection();
if (_Connection != null)
{
result = _DbInfoTable.GetAllRecords(_Connection, _TransactionHelper.Transaction, _DatabaseLog).Last();
}
}
return(result);
}
/// <summary>
/// Inserts a new record. There is no unique ID column so nothing is returned.
/// </summary>
/// <param name="connection"></param>
/// <param name="transaction"></param>
/// <param name="log"></param>
/// <param name="dbInfo"></param>
public void Insert(IDbConnection connection, IDbTransaction transaction, TextWriter log, BaseStationDBInfo dbInfo)
{
var preparedCommand = PrepareCommand(connection, transaction, "Insert", _InsertCommandText, 2);
Sql.SetParameters(preparedCommand, dbInfo.OriginalVersion, dbInfo.CurrentVersion);
Sql.LogCommand(log, preparedCommand.Command);
preparedCommand.Command.ExecuteNonQuery();
}
