{"id":89,"date":"2020-09-28T14:23:19","date_gmt":"2020-09-28T12:23:19","guid":{"rendered":"https:\/\/mtymejczyk.wordpress.com\/?p=89"},"modified":"2020-09-28T14:23:19","modified_gmt":"2020-09-28T12:23:19","slug":"coffeshop-cz-2-ef-core","status":"publish","type":"post","link":"https:\/\/tymejczyk.net\/index.php\/2020\/09\/28\/coffeshop-cz-2-ef-core\/","title":{"rendered":"CoffeShop cz. 2 – Migracje i Seedowanie"},"content":{"rendered":"\n

K<\/strong>ontynuuje prace nad projektem, \u017ceby tyle nie musie\u0107 mockowa\u0107 podepn\u0119 pod wszystko baze przy u\u017cyciu EF Core \ud83d\ude42<\/p>\n\n\n\n

Stworzy\u0142em 3 encje kt\u00f3re ca\u0142kowicie b\u0119d\u0105 wystarczy\u0142y do naszego projektu.
S\u0105 to: Order, OrderDetail oraz Product.<\/em><\/p>\n\n\n\n

namespace Domain.Entities\n{\n    public class Order\n    {\n        public Order()\n        {\n            OrderDetails = new HashSet<OrderDetail>();\n        }\n\n        public int Id { get; set; }\n        public ICollection<OrderDetail> OrderDetails { get; set; }\n        public DateTime OrderPlaced { get; set; }\n        public DateTime? OrderCompleted { get; set; }\n        public OrderStatus Status { get; set; }\n    }\n\n    public class OrderDetail\n    {\n        public int Id { get; set; }\n        public int Quantity { get; set; }\n        public decimal UnitPrice { get; set; }\n        public int UnitTimeToPrepare { get; set; }\n        public string AdditionalInfo { get; set; }\n\n        public int ProductId { get; set; }\n        public int OrderId { get; set; }\n        public Product Product { get; set; }\n        public Order Order { get; set; }\n    }\n\n    public class Product\n    {\n        public Product()\n        {\n            OrderDetails = new HashSet<OrderDetail>();\n        }\n\n        public int Id { get; set; }\n        public string Name { get; set; }\n        public decimal Price { get; set; }\n        public int TimeToPrepare { get; set; }\n        public ICollection<OrderDetail> OrderDetails { get; set; }\n    }\n}\n\n<\/pre>\n\n\n\n
Encja Order posiada pole OrderStatus kt\u00f3rej jest enumem posiadaj\u0105cy 3 stany: 
NotStarted, InProgress, Completed<\/em>.

Dodane zosta\u0142y tak\u017ce pola wskazuj\u0105ce na czas oczekiwania na zam\u00f3wienie oraz napiwek przy zam\u00f3wieniu powy\u017cej 5 kaw wynosz\u0105cy +10% do ceny zam\u00f3wienia. 

Dzi\u0119ki zastosowaniu ICollection<OrderDetail><\/em> w klasach Order <\/em>i Product <\/em>oraz dodaniu p\u00f3l Product product<\/em> i Order order<\/em> wraz z ich kluczami otrzymali\u015bmy relacje One-To-Many. \ud83d\ude42<\/p>\n\n\n\n
Teraz tworzymy Interfejs IContext i implementujemy go. Pos\u0142u\u017cy on do Dependency Injection<\/em> poprzez konstruktor.<\/p>\n\n\n\n
namespace Domain.Interfaces\n{\n    public interface IContext\n    {\n        DbSet<Product> Products { get; set; }\n        DbSet<Order> Orders { get; set; }\n        DbSet<OrderDetail> OrderDetails { get; set; }\n\n        Task<int> SaveChangesAsync();\n    }\n}<\/pre>\n\n\n\n
namespace Infrastructure\n{\n    public class Context : DbContext, IContext\n    {\n        public DbSet<Product> Products { get; set; }\n        public DbSet<Order> Orders { get; set; }\n        public DbSet<OrderDetail> OrderDetails { get; set; }\n\n        public Context(DbContextOptions<Context> options)\n            : base(options)\n        { }\n\n        protected override void OnModelCreating(ModelBuilder builder)\n        {\n            \/\/ builder.ApplyConfigurationsFromAssembly(typeof(Context).Assembly);\n            builder.Entity<OrderDetail>()\n             .HasOne(o => o.Product)\n             .WithMany(p => p.OrderDetails)\n             .OnDelete(DeleteBehavior.Cascade);\n        }\n\n        public async Task<int> SaveChangesAsync()\n        {\n            return this.SaveChanges();\n        }\n    }\n}<\/pre>\n\n\n\n
Nast\u0119pnie dodajemy DI<\/em> dla IContext <\/em>oraz ConnectionString <\/em>kt\u00f3ry zczytywany jest z appsettings.json<\/em> w warstwie Prezentacji.<\/p>\n\n\n\n
namespace Infrastructure\n{\n    public static class DependencyInjection\n    {\n        public static void AddInfrastructure(this IServiceCollection services, IConfiguration configuration)\n        {\n            services.AddDbContext<Context>(opt =>\n                opt.UseSqlServer(configuration.GetConnectionString(\"Context\")));\n\n            services.AddScoped<IContext, Context>();\n        }\n    }\n}<\/pre>\n\n\n\n
  \"ConnectionStrings\": {\n    \"Context\": \"Server=(localdb)\\\\mssqllocaldb;Database=CoffeShop;Trusted_Connection=True;MultipleActiveResultSets=true\",\n  },<\/pre>\n\n\n\n
Tworzymy migracje wpisuj\u0105c w okno PMC:  Add-Migration Initial<\/em>

Je\u015bli wyskakuje b\u0142\u0105d trzeba zrestartowa\u0107 Visual Studio, \u017ceby widzia\u0142o komend\u0119. Dodatkowo w warstwie aplikacji trzeba doinstalowa\u0107 Microsoft.EntityFrameworkCore.Design<\/strong><\/em> o co „prosi” sam PMC.<\/p>\n\n\n\n
Je\u015bli stworzenie Migracji si\u0119 powiod\u0142o wpisujemy w PMC: Update-Database<\/em><\/p>\n\n\n\n
Dodam teraz opcje seedowania bazy. 
Mo\u017cna by to zrobi\u0107 za pomoc\u0105 ModelBuildera ale zrobie poprostu endpoint kt\u00f3ry b\u0119dziemy mogli seedowa\u0107 baz\u0119 danych je\u015bli nie posiada ona jeszcze element\u00f3w. 
<\/p>\n\n\n\n
Najpierw dodajemy klase do seedowania:<\/p>\n\n\n\n
namespace Application.System.Command\n{\n    public class SampleDataSeeder : IRequest\n    {\n        public class SampleDataSeederHandler : IRequestHandler<SampleDataSeeder>\n        {\n            private readonly IContext _context;\n\n            public SampleDataSeederHandler(IContext context)\n            {\n                _context = context;\n            }\n\n            private readonly Dictionary<int, Product> Products = new Dictionary<int, Product>();\n\n            public async Task<Unit> Handle(SampleDataSeeder request, CancellationToken cancellationToken)\n            {\n                if (_context.Orders.Any())\n                {\n                    return Unit.Value;\n                }\n\n                await SeedProducts();\n                await SeedOrders();\n\n                return Unit.Value;\n            }\n\n            private async Task SeedProducts()\n            {\n                if (_context.Products.Any() || Products.Any())\n                {\n                    return;\n                }\n\n                Products.Add(1, new Product { Name = \"Cappuccino S\", Price = 5.99m, TimeToPrepare = 3 });\n                Products.Add(2, new Product { Name = \"Cappuccino M\", Price = 8.99m, TimeToPrepare = 4 });\n                Products.Add(3, new Product { Name = \"Cappuccino L\", Price = 9.99m, TimeToPrepare = 4 });\n                Products.Add(4, new Product { Name = \"Espresso\", Price = 4.99m, TimeToPrepare = 2 });\n                Products.Add(5, new Product { Name = \"Espresso Doppio\", Price = 5.99m, TimeToPrepare = 4 });\n                Products.Add(6, new Product { Name = \"Americano S\", Price = 4.99m, TimeToPrepare = 2 });\n                Products.Add(7, new Product { Name = \"Americano M\", Price = 6.99m, TimeToPrepare = 3 });\n                Products.Add(8, new Product { Name = \"Americano L\", Price = 8.99m, TimeToPrepare = 4 });\n                Products.Add(9, new Product { Name = \"Latte S\", Price = 6.99m, TimeToPrepare = 4 });\n                Products.Add(10, new Product { Name = \"Latte M\", Price = 8.59m, TimeToPrepare = 4 });\n                Products.Add(11, new Product { Name = \"Latte L\", Price = 9.99m, TimeToPrepare = 5 });\n\n                foreach (var product in Products.Values)\n                {\n                    _context.Products.Add(product);\n                }\n\n                await _context.SaveChangesAsync();\n            }\n\n            private async Task SeedOrders()\n            {\n                var orders = new List<Order>()\n                {\n                    new Order\n                    {\n                        OrderPlaced = DateTime.UtcNow,\n                        OrderCompleted = DateTime.UtcNow.AddMinutes(7),\n                        Status = OrderStatus.Completed\n                    }.AddOrderDetails(\n                        new OrderDetail { Product = Products[1], Quantity = 2, },\n                        new OrderDetail { Product = Products[2], Quantity = 1, }),\n\n                    new Order\n                    {\n                        OrderPlaced = DateTime.UtcNow,\n                        OrderCompleted = DateTime.UtcNow.AddMinutes(2),\n                        Status = OrderStatus.Completed\n                    }.AddOrderDetails(\n                        new OrderDetail { Product = Products[3], Quantity = 1, }),\n\n                    new Order\n                    {\n                        OrderPlaced = DateTime.UtcNow,\n                        OrderCompleted = DateTime.UtcNow.AddMinutes(9),\n                        Status = OrderStatus.Completed,\n                    }.AddOrderDetails(\n                        new OrderDetail { Product = Products[4], Quantity = 1, },\n                        new OrderDetail { Product = Products[5], Quantity = 3, }),\n\n                    new Order\n                    {\n                        OrderPlaced = DateTime.UtcNow,\n                        OrderCompleted = DateTime.UtcNow.AddMinutes(6),\n                        Status = OrderStatus.Completed,\n                    }.AddOrderDetails(\n                        new OrderDetail { Product = Products[6], Quantity = 2, }),\n\n                    new Order\n                    {\n                        OrderPlaced = DateTime.UtcNow,\n                        OrderCompleted = DateTime.UtcNow.AddMinutes(5),\n                        Status = OrderStatus.Completed,\n                    }.AddOrderDetails(\n                        new OrderDetail { Product = Products[7], Quantity = 3, }),\n                };\n\n                foreach (var order in orders)\n                {\n                    foreach (var detail in order.OrderDetails)\n                    {\n                        detail.UnitPrice = detail.Product.Price * detail.Quantity;\n                        detail.UnitTimeToPrepare = detail.Product.TimeToPrepare * detail.Quantity;\n                    }\n                }\n\n                _context.Orders.AddRange(orders);\n\n                await _context.SaveChangesAsync();\n            }\n        }\n    }\n}<\/pre>\n\n\n\n
Oraz endpoint:<\/p>\n\n\n\n
namespace Presentation.Controllers\n{\n    public class SystemController : BaseController\n    {\n        [HttpGet]\n        public async Task<Unit> SeedDatabase()\n        {\n            return await Mediator.Send(new SampleDataSeeder()); \n        }\n    }\n}<\/pre>\n\n\n\n
W\u0142\u0105czamy nasz projekt, przechodzimy do Swaggera i strzelamy w \/api\/system<\/em>.

Teraz je\u015bli u\u017cywamy Visual Studio 2019 mo\u017cemy w \u0142atwy spos\u00f3b podejrze\u0107 zawarto\u015b\u0107 naszej bazy.  <\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Mo\u017cna wpisa\u0107 lub u\u017cy\u0107 skr\u00f3tu klawiszowego. 
Otwieramy nasz\u0105 baze i sprawdzamy czy wszystko si\u0119 zasia\u0142o jak mia\u0142o \ud83e\udd14<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Wszystko si\u0119 uda\u0142o \ud83d\ude00 <\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Ca\u0142y kod zamieszczam na github: https:\/\/github.com\/MichaelStett\/CoffeShop<\/a><\/p>\n\n\n\n
Dzi\u0119kuje za Twoj\u0105 uwag\u0119 i do nast\u0119pnego \ud83d\ude00<\/p>\n","protected":false},"excerpt":{"rendered":"
Kontynuuje prace nad projektem, \u017ceby tyle nie musie\u0107 mockowa\u0107 podepn\u0119 pod wszystko baze przy u\u017cyciu EF Core \ud83d\ude42 Stworzy\u0142em 3 encje kt\u00f3re ca\u0142kowicie b\u0119d\u0105 wystarczy\u0142y do naszego projektu.S\u0105 to: Order, OrderDetail oraz Product. Encja Order posiada pole OrderStatus kt\u00f3rej jest enumem posiadaj\u0105cy 3 stany: NotStarted, InProgress, Completed. Dodane zosta\u0142y tak\u017ce pola wskazuj\u0105ce na czas oczekiwania […]<\/p>\n","protected":false},"author":1,"featured_media":133,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-89","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-project-coffeshop"],"_links":{"self":[{"href":"https:\/\/tymejczyk.net\/index.php\/wp-json\/wp\/v2\/posts\/89","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tymejczyk.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tymejczyk.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tymejczyk.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tymejczyk.net\/index.php\/wp-json\/wp\/v2\/comments?post=89"}],"version-history":[{"count":0,"href":"https:\/\/tymejczyk.net\/index.php\/wp-json\/wp\/v2\/posts\/89\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tymejczyk.net\/index.php\/wp-json\/wp\/v2\/media\/133"}],"wp:attachment":[{"href":"https:\/\/tymejczyk.net\/index.php\/wp-json\/wp\/v2\/media?parent=89"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tymejczyk.net\/index.php\/wp-json\/wp\/v2\/categories?post=89"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tymejczyk.net\/index.php\/wp-json\/wp\/v2\/tags?post=89"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}