| | | 1 | | using System.Text.Json; |
| | | 2 | | using Microsoft.EntityFrameworkCore; |
| | | 3 | | using Microsoft.EntityFrameworkCore.ChangeTracking; |
| | | 4 | | using Microsoft.EntityFrameworkCore.Metadata.Builders; |
| | | 5 | | using TicTacToeApp.API.Data.Converters; |
| | | 6 | | using TicTacToeApp.API.Entity; |
| | | 7 | | |
| | | 8 | | namespace TicTacToeApp.API.Data.Configuration; |
| | | 9 | | |
| | | 10 | | public class GameMapping : IEntityTypeConfiguration<Game> |
| | | 11 | | { |
| | | 12 | | public void Configure(EntityTypeBuilder<Game> builder) |
| | | 13 | | { |
| | 1 | 14 | | builder.ToTable("Games").HasKey(g => g.Id); |
| | 1 | 15 | | builder.Property(g => g.CreatedAt) |
| | 1 | 16 | | .HasColumnType("timestamp with time zone"); |
| | | 17 | | //.HasConversion(new DateTimeToCharConverter()); |
| | | 18 | | |
| | 1 | 19 | | builder.Property(g => g.Status).HasConversion<string>(); |
| | 1 | 20 | | builder.Property(g => g.Result).HasConversion<string>(); |
| | 1 | 21 | | builder.Property(g => g.CurrentMove).HasConversion<string>(); |
| | 1 | 22 | | builder.Property(g => g.Board).HasConversion( |
| | 1 | 23 | | v => JsonSerializer.Serialize(v, (JsonSerializerOptions?)null), |
| | 1 | 24 | | v => JsonSerializer.Deserialize<string?[][]>(v, (JsonSerializerOptions?)null)!); |
| | | 25 | | |
| | 1 | 26 | | builder.Property(g => g.Board) |
| | 1 | 27 | | .HasConversion( |
| | 1 | 28 | | v => JsonSerializer.Serialize(v, (JsonSerializerOptions?)null), |
| | 1 | 29 | | v => JsonSerializer.Deserialize<string?[][]>(v, (JsonSerializerOptions?)null)!) |
| | 1 | 30 | | .Metadata.SetValueComparer( |
| | 1 | 31 | | new ValueComparer<string?[][]>( |
| | 1 | 32 | | (c1, c2) => c1!.SequenceEqual(c2!), // Сравниваем массивы поэлементно |
| | 1 | 33 | | c => c.Aggregate(0, (a, v) => HashCode.Combine(a, v.GetHashCode())), // Вычисляем хеш-код |
| | 1 | 34 | | c => c.Select(x => x.ToArray()).ToArray())); // Создаем глубокую копию для snapshot |
| | | 35 | | |
| | | 36 | | |
| | | 37 | | // builder.HasOne(g => g.User) |
| | | 38 | | // .WithMany(user => user.Games) |
| | | 39 | | // .HasPrincipalKey(g =>g.Id) |
| | | 40 | | // .HasForeignKey(u => u.UserId); |
| | | 41 | | |
| | | 42 | | // Seed |
| | 1 | 43 | | builder.HasData( |
| | 1 | 44 | | new Game |
| | 1 | 45 | | { |
| | 1 | 46 | | Id = new Guid("b8aa36a5-9094-4dbd-80a5-444fcb92d3a4"), // Укажите явный Id (если есть) |
| | 1 | 47 | | Board = new string?[][] |
| | 1 | 48 | | { |
| | 1 | 49 | | new string?[] { "X", "O", null }, |
| | 1 | 50 | | new string?[] { null, "X", "O" }, |
| | 1 | 51 | | new string?[] { "O", null, "X" } |
| | 1 | 52 | | }, |
| | 1 | 53 | | CreatedAt = new DateTime(2023, 1, 1, 0, 0, 0, DateTimeKind.Utc) |
| | 1 | 54 | | |
| | 1 | 55 | | } |
| | 1 | 56 | | ); |
| | 1 | 57 | | } |
| | | 58 | | } |