public void AddScriptShouldAddScript() { Pilot p = new Pilot { ProducerID = 4 }; Script s = new Script { ScriptWriterID = 5 }; using (var ctx = new AviDBContext(options)) { ctx.Pilots.Add(p); ctx.SaveChanges(); s.PilotID = p.ID; IAviRepo repo = new AviRepoDB(ctx); repo.AddScript(s); } using (var assertCtx = new AviDBContext(options)) { var result = assertCtx.Scripts.FirstOrDefault(_s => _s.ID == s.ID); Assert.NotNull(result); Assert.Equal(5, result.ScriptWriterID); Assert.Equal(p.ID, result.PilotID); } }
public void GetScenesByPilotIDShouldGetScenes() { using (var ctx = new AviDBContext(options)) { IAviRepo repo = new AviRepoDB(ctx); List <Scene> scenes = repo.GetScenesByPilotID(1); Assert.NotNull(scenes); Assert.NotEmpty(scenes); } }
public async Task GetContributorsByUserIDShouldGetContributors() { using (var ctx = new AviDBContext(options)) { IAviRepo repo = new AviRepoDB(ctx); List <Contributor> contributors = repo.GetContributorsByUserID(2); Assert.NotNull(contributors); Assert.NotEmpty(contributors); } }
public void GetScriptsByPilotIDShouldGetScripts() { using (var ctx = new AviDBContext(options)) { IAviRepo repo = new AviRepoDB(ctx); Script script = repo.GetScriptByPilotID(1); Assert.NotNull(script); Assert.Equal(1, script.PilotID); } }
public void GetPilotsShouldGetPilots() { using (var ctx = new AviDBContext(options)) { IAviRepo repo = new AviRepoDB(ctx); List <Pilot> pilots = repo.GetPilots(); Assert.NotNull(pilots); Assert.NotEmpty(pilots); } }
public void GetPilotByIDShouldGetPilot() { using (var ctx = new AviDBContext(options)) { IAviRepo repo = new AviRepoDB(ctx); Pilot p = repo.GetPilotByID(1); Assert.NotNull(p); Assert.Equal(1, p.ID); } }
public async Task GetFilesByPilotIDShouldGetFiles() { using (var ctx = new AviDBContext(options)) { IAviRepo repo = new AviRepoDB(ctx); List <File> files = repo.GetFilesByPilotID(1); Assert.NotNull(files); Assert.NotEmpty(files); } }
public void GetFilesBySceneIdShouldGetFiles() { using (var ctx = new AviDBContext(options)) { IAviRepo repo = new AviRepoDB(ctx); List <File> files = repo.GetFilesBySceneId(1); Assert.NotNull(files); Assert.NotEmpty(files); } }
public void GetContributorsByPilotIDShouldGetContributors() { using (var ctx = new AviDBContext(options)) { IAviRepo repo = new AviRepoDB(ctx); List <Contributor> contributors = repo.GetContributorsByPilotID(1); Assert.NotNull(contributors); Assert.NotEmpty(contributors); } }
public void DeleteScriptIfExistsShouldDeleteScript() { using (var ctx = new AviDBContext(options)) { IAviRepo repo = new AviRepoDB(ctx); Script s = ctx.Scripts.AsNoTracking().FirstOrDefault(); Assert.NotNull(s); repo.DeleteScriptIfExists(s.PilotID); Assert.Null(ctx.Scripts.FirstOrDefault(s2 => s2.PilotID == s.PilotID)); } }
public void DeleteFileShouldDeleteFile() { using (var ctx = new AviDBContext(options)) { File file = ctx.Files.FirstOrDefault(f => true); Assert.NotNull(file); int fID = file.ID; IAviRepo repo = new AviRepoDB(ctx); repo.DeleteFile(file); file = ctx.Files.FirstOrDefault(f => f.ID == fID); Assert.Null(file); } }
public void DeleteScenesIfExistsShouldDeleteScenes() { using (var ctx = new AviDBContext(options)) { IAviRepo repo = new AviRepoDB(ctx); List <Scene> scenes = ctx.Pilots.Where(p => p.ID == 1).Include(p => p.Scenes).AsNoTracking().FirstOrDefault().Scenes; Assert.NotNull(scenes); Assert.NotEmpty(scenes); repo.DeleteScenesIfExists(1); scenes = ctx.Pilots.Where(p => p.ID == 1).Include(p => p.Scenes).AsNoTracking().FirstOrDefault().Scenes; Assert.NotNull(scenes); Assert.Empty(scenes); } }
public void AddPilotShouldAddPilot() { Pilot p = new Pilot { ProducerID = 4 }; using (var ctx = new AviDBContext(options)) { IAviRepo repo = new AviRepoDB(ctx); repo.AddPilot(p); } using (var assertCtx = new AviDBContext(options)) { var result = assertCtx.Pilots.FirstOrDefault(_p => _p.ID == p.ID); Assert.NotNull(result); Assert.Equal(4, p.ProducerID); } }
public void AddSceneShouldAddScene() { Scene s = new Scene { SceneIndex = 1, PilotID = 1 }; using (var ctx = new AviDBContext(options)) { IAviRepo repo = new AviRepoDB(ctx); repo.AddScene(s); } using (var assertCtx = new AviDBContext(options)) { var result = assertCtx.Scenes.FirstOrDefault(_s => _s.ID == s.ID); Assert.NotNull(result); Assert.Equal(1, result.SceneIndex); Assert.Equal(1, result.PilotID); } }
public void AddSceneFileShouldAddSceneFile() { SceneFile sf = new SceneFile { SceneID = 1, FileID = 1 }; using (var ctx = new AviDBContext(options)) { IAviRepo repo = new AviRepoDB(ctx); repo.AddSceneFile(sf); } using (var assertCtx = new AviDBContext(options)) { var result = assertCtx.SceneFiles.FirstOrDefault(_sf => _sf.ID == sf.ID); Assert.NotNull(result); Assert.Equal(1, result.SceneID); Assert.Equal(1, result.FileID); } }
public void AddFileShouldAddFile() { File f = new File { PilotID = 1, UploaderID = 1, FileURL = "https://www.google.com/" }; using (var ctx = new AviDBContext(options)) { IAviRepo repo = new AviRepoDB(ctx); repo.AddFile(f); } using (var assertCtx = new AviDBContext(options)) { var result = assertCtx.Files.FirstOrDefault(_f => _f.ID == f.ID); Assert.NotNull(result); Assert.Equal(1, result.PilotID); Assert.Equal(1, result.UploaderID); Assert.Equal("https://www.google.com/", result.FileURL); } }
public void AddContributorShouldAddContributor() { Contributor c = new Contributor { PilotID = 1, UserID = 1 }; using (var ctx = new AviDBContext(options)) { List <User> users = ctx.Users.ToList(); List <Pilot> pilots = ctx.Pilots.ToList(); IAviRepo repo = new AviRepoDB(ctx); repo.AddContributor(c); } using (var assertCtx = new AviDBContext(options)) { var result = assertCtx.Contributors.FirstOrDefault(_c => _c.ID == c.ID); Assert.NotNull(result); Assert.Equal(1, result.PilotID); Assert.Equal(1, result.UserID); } }
private void Seed() { using (var ctx = new AviDBContext(options)) { ctx.Database.EnsureDeleted(); ctx.Database.EnsureCreated(); for (int i = 1; i <= 5; i++) { ctx.Users.Add(new User { Email = $"user{i}@gmail.com", FirstName = $"FN{i}", LastName = $"LN{i}", PhoneNumb = i * 1111111111, UserName = $"User{i}" }); } ctx.SaveChanges(); List <Scene> scenes = new List <Scene>(); scenes.Add(new Scene { SceneIndex = 0 }); ctx.Pilots.Add(new Pilot { ProducerID = 1, Script = new Script { ScriptURL = "https://www.script.com/", ScriptWriterID = 2 }, Scenes = scenes }); ctx.SaveChanges(); ctx.Contributors.Add(new Contributor { PilotID = 1, UserID = 2 }); ctx.Contributors.Add(new Contributor { PilotID = 1, UserID = 3 }); ctx.Files.Add(new File { FileURL = "https://www.file.com", PilotID = 1, UploaderID = 3 }); ctx.SceneFiles.Add(new SceneFile { SceneID = 1, FileID = 1 }); ctx.SaveChanges(); } }