/// <summary>
/// Pet context constructor, creates view for expiring vaccinations
/// </summary>
public PetContext()
{
string viewQuery = "CREATE VIEW IF NOT EXISTS View_ExpiringVaccination AS " +
"SELECT Name AS \"Imię\", vaccination.Date AS \"Data szczepienia\", DATE_ADD(vaccination.Date, INTERVAL 1 YEAR) AS \"Data ważności\" FROM animals " +
"LEFT JOIN vaccination ON animals.ID = vaccination.AnimalID " +
"LEFT JOIN death ON animals.ID = death.AnimalID " +
"LEFT JOIN lost ON animals.ID = lost.AnimalID " +
"WHERE CURRENT_DATE() > DATE_ADD(DATE_ADD(vaccination.Date, INTERVAL 1 YEAR), INTERVAL - 1 WEEK) " +
"AND CURRENT_DATE() < DATE_ADD(vaccination.Date, INTERVAL 1 YEAR)";
Database.ExecuteSqlRaw(viewQuery);
}
