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(); }