/// <summary>
/// Initializes a new PodcastRepository.
/// </summary>
/// <param name="context">Vocalia database reference.</param>
/// <param name="gpodderFacade">GPodder API service.</param>
/// <param name="iTunesFacade">iTunes API service.</param>
/// <param name="cache">Cache object for storing pre-fetched data.</param>
public PodcastRepository(PodcastContext context, IGPodderFacade gpodderFacade,
IITunesFacade iTunesFacade, IMemoryCache cache,
IObjectBus <Vocalia.ServiceBus.Types.Podcast.Podcast> podcastBus)
{
DbContext = context;
GPodderService = gpodderFacade;
ITunesService = iTunesFacade;
Cache = cache;
_ = podcastBus;
}
public void CanReadHostFromDatabase()
{
var builder = new DbContextOptionsBuilder <PodcastContext>();
builder.UseInMemoryDatabase("CanInsertHost");
using (var context = new PodcastContext(builder.Options))
{
var host = context.Hosts.FirstOrDefault();
Debug.WriteLine($"Selected ID: {host.Id}");
Assert.AreNotEqual(0, host.Id);
}
}
public void CanReadMoviesFromDatabase()
{
var builder = new DbContextOptionsBuilder <PodcastContext>();
builder.UseInMemoryDatabase("CanInsertMovie");
using (var context = new PodcastContext(builder.Options))
{
var movie = context.Movies.FirstOrDefault();
Debug.WriteLine($"Selected ID: {movie.Id}");
Assert.AreNotEqual(0, movie.Id);
}
}
public IEnumerable <Episode> GetEpisodes()
{
var list = new List <Episode>();
var pods = PodcastContext.GetPodcasts();
for (int i = 0; i < 30; i++)
{
list.Add(new Episode(pods[i % 5].Thumbnail)
{
});
}
return(list);
}
public void CanInsertHostIntoDatabase()
{
var builder = new DbContextOptionsBuilder <PodcastContext>();
builder.UseInMemoryDatabase("PodcastTestingDatabase");
using (var context = new PodcastContext(builder.Options))
{
var host = new Host();
context.Hosts.Add(host);
context.SaveChanges();
Debug.WriteLine($"Inserted ID: {host.Id}");
Assert.AreNotEqual(0, host.Id);
}
}
public void CanReadPodcastFromDatabase()
{
CanInsertPodcastIntoDatabase();
var builder = new DbContextOptionsBuilder <PodcastContext>();
builder.UseInMemoryDatabase("PodcastTestingDatabase");
using (var context = new PodcastContext(builder.Options))
{
var podcast = context.Podcasts.FirstOrDefault(x => x.Title == "Test");
var podcasts = context.Podcasts.ToList();
Debug.WriteLine($"Selected ID: {podcast.Id}");
Assert.AreNotEqual(0, podcast.Id);
}
}
public void CanInsertMovieIntoDatabase()
{
var builder = new DbContextOptionsBuilder <PodcastContext>();
builder.UseInMemoryDatabase("CanInsertMovie");
using (var context = new PodcastContext(builder.Options))
{
var movie = new Movie();
context.Movies.Add(movie);
context.SaveChanges();
Debug.WriteLine($"Inserted ID: {movie.Id}");
Assert.AreNotEqual(0, movie.Id);
}
}
public static void Initialize(PodcastContext context)
{
if (!context.Authors.Any())
{
context.Authors.AddRange(
new Author
{
Name = "Disgusting men",
Description = "Это еженедельный подкаст с disgustingmen.com. Мы говорим о кинематографе, музыке, светской жизни, путешествиях и видеоиграх.",
Image = "http://drive.google.com/uc?export=view&id=1ya_nPmBefspSlzxTGf1pQ-3Viyby75tw"
}
);
context.SaveChanges();
}
}
static void Main(string[] args)
{
var optionsBuilder = new DbContextOptionsBuilder <PodcastContext>();
_context = new PodcastContext(optionsBuilder.UseSqlite("Data Source = /Users/rafa/Projects/PodcastDB.db").Options);
_context.Database.EnsureCreated();
/*GetPodcasts("Before Add:");
* InsertMultiplePodcasts();
* GetPodcasts("After Add:");
* InsertBattle();
* QueryAndUpdateBattle_Disconnected();
* InsertNewPodcastWithAQuote();
* AddQuoteToExistingPodcastWhileTracked();*/
// GetRawSQL();
Console.Write("Press any key...");
Console.ReadKey();
}
public MovieLogic(PodcastContext context)
{
_context = context;
}
public HomeController(PodcastContext context, IWebHostEnvironment hostingEnvironment)
{
db = context;
this.hostingEnvironment = hostingEnvironment;
}
public PodcastsController(PodcastContext context)
{
PodcastLogic.SetContext(context);
}
public PodcastLogic(PodcastContext context)
{
_context = context;
}
public PodcastsController(PodcastContext context)
{
_context = context;
}
public MoviesController(PodcastContext context)
{
MovieLogic.SetContext(context);
PodcastLogic.SetContext(context);
}
public Podcast Get(string id)
{
return(PodcastContext.GetPodcast(new Guid(id)));
}
public IEnumerable <Podcast> Get()
{
return(PodcastContext.GetPodcasts());
}
public static void SetContext(PodcastContext context)
{
_context = context;
}
public FeedController(PodcastContext context)
{
_context = context;
}
