public void BaseStationDBHistory_Constructor_Initialises_To_Known_State_And_Properties_Work()
{
var record = new BaseStationDBHistory();
TestUtilities.TestProperty(record, "DBHistoryID", 0, 1202);
TestUtilities.TestProperty(record, "Description", null, "ANV");
TestUtilities.TestProperty(record, "TimeStamp", DateTime.MinValue, DateTime.Now);
}
/// <summary>
/// Generates parameters for a DB history object.
/// </summary>
/// <param name="dbHistory"></param>
/// <param name="includeHistoryID"></param>
/// <returns></returns>
public static DynamicParameters FromDBHistory(BaseStationDBHistory dbHistory, bool includeHistoryID = true)
{
var result = new DynamicParameters();
if (includeHistoryID)
{
result.Add(nameof(dbHistory.DBHistoryID), value: dbHistory.DBHistoryID);
}
result.Add(nameof(dbHistory.TimeStamp), value: dbHistory.TimeStamp);
result.Add(nameof(dbHistory.Description), value: dbHistory.Description);
return(result);
}
public void BaseStationDBHistory_IsCreationOfDatabaseByVirtualRadarServer_Returns_True_When_Matching_Description_Seen()
{
var record = new BaseStationDBHistory();
Assert.IsFalse(record.IsCreationOfDatabaseByVirtualRadarServer);
record.Description = "Database autocreated by Virtual Radar Server";
Assert.IsTrue(record.IsCreationOfDatabaseByVirtualRadarServer);
record.Description = "DATABASE AUTOCREATED BY VIRTUAL RADAR SERVER";
Assert.IsTrue(record.IsCreationOfDatabaseByVirtualRadarServer);
record.Description = "Database created by Snoopy";
Assert.IsFalse(record.IsCreationOfDatabaseByVirtualRadarServer);
}
/// <summary>
/// Inserts a new record and returns its identifier.
/// </summary>
/// <param name="connection"></param>
/// <param name="transaction"></param>
/// <param name="log"></param>
/// <param name="dbHistory"></param>
/// <returns></returns>
public int Insert(IDbConnection connection, IDbTransaction transaction, TextWriter log, BaseStationDBHistory dbHistory)
{
var preparedCommand = PrepareInsert(connection, transaction, "Insert", "DBHistoryID", "TimeStamp", "Description");
return (int)Sql.ExecuteInsert(preparedCommand, log, dbHistory.TimeStamp, dbHistory.Description);
}
