public void TestInitialize()
{
FlightRecorderDbContext context = new FlightRecorderDbContextFactory().CreateInMemoryDbContext();
_factory = new FlightRecorderFactory(context);
_factory.Flights.Add(FlightNumber, Embarkation, Destination, AirlineName);
}
public void TestInitialize()
{
FlightRecorderDbContext context = new FlightRecorderDbContextFactory().CreateInMemoryDbContext();
_factory = new FlightRecorderFactory(context);
User user = _factory.Users.AddUser(UserName, Password);
_factory.Context.SaveChanges();
_userId = user.Id;
}
public void TestInitialize()
{
FlightRecorderDbContext context = new FlightRecorderDbContextFactory().CreateInMemoryDbContext();
_factory = new FlightRecorderFactory(context);
_locationId = _factory.Locations.Add(LocationName).Id;
_flightId = _factory.Flights.Add(FlightNumber, Embarkation, Destination, AirlineName).Id;
_aircraftId = _factory.Aircraft.Add(Registration, SerialNumber, YearOfManufacture, ModelName, ManufacturerName).Id;
_sightingId = _factory.Sightings.Add(Altitude, SightingDate, _locationId, _flightId, _aircraftId).Id;
}
public void TestInitialize()
{
FlightRecorderDbContext context = new FlightRecorderDbContextFactory().CreateInMemoryDbContext();
_factory = new FlightRecorderFactory(context);
_sightingId = _factory.Sightings.Add(new FlattenedSighting
{
FlightNumber = FlightNumber,
Airline = AirlineName,
Registration = Registration,
SerialNumber = SerialNumber,
Manufacturer = ManufacturerName,
Model = ModelName,
Age = Age,
Embarkation = Embarkation,
Destination = Destination,
Altitude = Altitude,
Date = SightingDate,
Location = LocationName
}).Id;
}
static void Main(string[] args)
{
string version = typeof(Program).Assembly.GetName().Version.ToString();
Console.WriteLine($"Flight Recorder Database Management {version}");
Operation op = new CommandParser().ParseCommandLine(args);
if (op.Valid)
{
FlightRecorderDbContext context = new FlightRecorderDbContextFactory().CreateDbContext(null);
FlightRecorderFactory factory = new FlightRecorderFactory(context);
try
{
switch (op.Type)
{
case OperationType.add:
factory.Users.AddUser(op.UserName, op.Password);
Console.WriteLine($"Added user {op.UserName}");
break;
case OperationType.setpassword:
factory.Users.SetPassword(op.UserName, op.Password);
Console.WriteLine($"Set password for user {op.UserName}");
break;
case OperationType.delete:
factory.Users.DeleteUser(op.UserName);
Console.WriteLine($"Deleted user {op.UserName}");
break;
case OperationType.import:
CsvImporter importer = new CsvImporter();
importer.Import(op.FileName, factory);
Console.WriteLine($"Imported data from {op.FileName}");
break;
case OperationType.export:
// The third parameter is an arbitrary large number intended to capture all
// sightings
IEnumerable <Sighting> sightings = factory.Sightings.List(null, 1, 99999999);
CsvExporter exporter = new CsvExporter();
exporter.Export(sightings, op.FileName);
Console.WriteLine($"Exported the database to {op.FileName}");
break;
case OperationType.update:
context.Database.Migrate();
Console.WriteLine($"Applied the latest database migrations");
break;
default:
break;
}
}
catch (Exception ex)
{
Console.WriteLine($"Error : {ex.Message}");
}
}
else
{
string executable = AppDomain.CurrentDomain.FriendlyName;
Console.WriteLine("Usage:");
Console.WriteLine($"[1] {executable} add username password");
Console.WriteLine($"[2] {executable} setpassword username password");
Console.WriteLine($"[3] {executable} delete username");
Console.WriteLine($"[4] {executable} import csv_file_path");
Console.WriteLine($"[5] {executable} export csv_file_path");
Console.WriteLine($"[6] {executable} update");
}
}
