/// <summary>
/// Crea el contexto de la DB
/// </summary>
public static void CreateDbContext()
{
using (var client = new StarWarsDbContext())
{
client.Database.EnsureCreated();
}
}
static void PrepareContext(DbContextOptions <StarWarsDbContext> options)
{
// get new in memory connection
var dbContext = new StarWarsDbContext(options);
// enforce DB migration
dbContext.Database.Migrate();
dbContext.Seed();
dbContext.SaveChangesAsync();
}
public void Test1()
{
var options = new DbContextOptionsBuilder <StarWarsDbContext>().UseInMemoryDatabase(databaseName: "StarWarsDatabase").Options;
var _mockRepo2 = new Mock <IFilmsManager>();
using (var context = new StarWarsDbContext(options))
{
context.Rating.Add(new EpisodesRating {
Id = 1, EpisodeId = 2, Score = EScoreType.Good
});
context.Rating.Add(new EpisodesRating {
Id = 2, EpisodeId = 5, Score = EScoreType.Excellent
});
context.SaveChanges();
var controller = new FilmController(_mockRepo2.Object, context);
var result = controller.Index();
Assert.IsType <ViewResult>(result);
}
}
public async Task SeedAsync_ShouldPopulateDb_WithoutParameters()
{
// Arrange
var options = new DbContextOptionsBuilder <StarWarsDbContext>()
.UseSqlite(_connection)
.Options;
var dbContext = new StarWarsDbContext(options);
await dbContext.Database.MigrateAsync();
// Act
dbContext.Seed();
// Assert
(await dbContext.Characters.CountAsync()).Should().Be(7);
var luke_skywalker = dbContext.Characters.Where(u => u.Id == 1).Single();
luke_skywalker.EpisodeCharacters.Select(e => e.Episode).Select(e => e.Name)
.Should().BeEquivalentTo(new[] { "NEWHOPE", "EMPIRE", "JEDI" });
luke_skywalker.Friends.Select(e => e.Friend).Select(e => e.Name)
.Should().BeEquivalentTo(new[] { "Han Solo", "Leia Organa", "C-3PO", "R2-D2" });
}
public async Task ProjectTo_shouldGetDomainModelsQueryable_GivenEntityTable()
{
// Arrange
var options = new DbContextOptionsBuilder <StarWarsDbContext>()
.UseSqlite(_connection)
.Options;
var dbContext = new StarWarsDbContext(options);
await dbContext.Database.MigrateAsync();
dbContext.Seed();
await dbContext.SaveChangesAsync();
dbContext = new StarWarsDbContext(options); // get fresh one
var configuration = new MapperConfiguration(cfg => {
cfg.AddProfile <AutoMapping>();
});
IMapper mapper = new Mapper(configuration);
// Act
var result = mapper.ProjectTo <SwCharacter>(dbContext.Characters).ToList();
// Assert
result.Count().Should().Be(7);
}
public RatingRepository(StarWarsDbContext starWarsDbContext)
{
this._starWarsDbContext = starWarsDbContext;
}
public PlanetRepository(StarWarsDbContext context) : base(context)
{
}
public FilmRepository(StarWarsDbContext context) : base(context)
{
}
public CharacterController(StarWarsDbContext context)
{
_context = context;
}
public SpeciesRepository(StarWarsDbContext context) : base(context)
{
}
public DbSeed(StarWarsDbContext starWarsDbContext)
{
_starWarsDbContext = starWarsDbContext;
}
public EpisodeController(StarWarsDbContext context)
{
_context = context;
}
public CharacterRepository(StarWarsDbContext dbContext)
{
_dbContext = dbContext;
}
public BaseRepository(StarWarsDbContext dbContext)
{
this.dbContext = dbContext;
}
public CharacterRepository(StarWarsDbContext dbContext, IMapper mapper)
{
_dbContext = dbContext;
_mapper = mapper;
}
protected BaseRepository(StarWarsDbContext context)
{
this.context = context;
}
public PeopleRepository(StarWarsDbContext dbContext) : base(dbContext)
{
}
public CharacterToEpisodeXrefController(StarWarsDbContext context)
{
_context = context;
}
public StarsShipRepository(StarWarsDbContext dbContext) : base(dbContext)
{
}
public FriendController(StarWarsDbContext context)
{
_context = context;
}
public FilmController(IFilmsManager filmsManager, StarWarsDbContext db)
{
_filmsManager = filmsManager;
_db = db;
}
