public void AddDailySettingsShouldInsert()
{
// arrage
DailySettings daily = new DailySettings();
daily.DayOfYear = 3;
daily.TimePeriod = 0;
daily.Rotors = "I V II";
daily.Reflector = "B";
daily.BetaOrGamma = "Beta";
daily.Offsets = "0 9 21";
daily.Plugs = "I H L P Y S R D M W O Z B N U F Q K C A";
daily.StartingPositions = "W O L F";
DailySettingsDAO dao = new DailySettingsDAO(databaseConnectionString);
int starting = dao.GetDailySettings().Count;
// act
dao.AddDailySettings(daily);
// assert
int ending = dao.GetDailySettings().Count;
Assert.AreNotEqual(starting, ending);
}
public void PopulateDailySettings()
{
int count = 1;
List <int> period = new List <int>()
{
0, 8, 16
};
Program program = new Program();
DailySettingsDAO dao = new DailySettingsDAO(program.ReturnConnectionString());
Console.WriteLine($"Total rows before inserts: {dao.GetDailySettings().Count}");
while (count < 1098)
{
DailySettings daily = new DailySettings();
daily.DayOfYear = 1 + count / 3;
daily.TimePeriod = period[count % 3];
daily.Rotors = string.Join(" ", lister.Randomizer(lister.GetRotors(), 3));
daily.Reflector = string.Join(" ", lister.Randomizer(lister.GetReflector(), 1));
daily.BetaOrGamma = string.Join(" ", lister.Randomizer(lister.GetFourth(), 1));
daily.Offsets = string.Join(" ", lister.OffsetMaker());
daily.Plugs = string.Join(" ", lister.Randomizer(lister.GetAlphabet(), 20));
daily.StartingPositions = string.Join(" ", lister.KeyMaker());
dao.AddDailySettings(daily);
count++;
}
Console.WriteLine($"Total rows after inserts: {dao.GetDailySettings().Count}");
}
public void SelectDailySettingsShouldReturnOne(int id)
{
// arrage
DailySettingsDAO dao = new DailySettingsDAO(databaseConnectionString);
IList <DailySettings> settings = dao.SelectDailySettings(id);
// act
int result = settings.Count;
// assert
Assert.AreEqual(1, result);
}
public void GetDailySettingsShouldReturnListCountSix()
{
// arrage
DailySettingsDAO dao = new DailySettingsDAO(databaseConnectionString);
IList <DailySettings> settings = dao.GetDailySettings();
// act
int result = settings.Count;
// assert
Assert.AreEqual(6, result);
}
static void Main(string[] args)
{
var services = ServiceProviderBuilder.GetServiceProvider(args);
var options = services.GetRequiredService <IOptions <MyOptions> >();
string connectionString = options.Value.SecretOption;
databaseConnectionString = connectionString;
IDailySettingsDAO dailyDAO = new DailySettingsDAO(connectionString);
// options.Value.SecretOption will be SQL Connection String and editable via secrets.json
// options.Value.OpenOption is in appsettings.json
UserInterface userInterface = new UserInterface();
userInterface.Menus();
}
