| | | 1 | | using Microsoft.EntityFrameworkCore; |
| | | 2 | | using OzonDomains.Models.BitrixModels; |
| | | 3 | | |
| | | 4 | | namespace OzonRepositories.Context; |
| | | 5 | | |
| | | 6 | | public class BitrixContext : DbContext |
| | | 7 | | { |
| | | 8 | | public BitrixContext(DbContextOptions<BitrixContext> options) |
| | 1 | 9 | | : base(options) |
| | | 10 | | { |
| | 1 | 11 | | } |
| | | 12 | | |
| | 1 | 13 | | public DbSet<BIblockElementProperty> BIblockElementProperties { get; set; } |
| | 1 | 14 | | public DbSet<BCatalogPrice> BCatalogPrices { get; set; } |
| | 1 | 15 | | public DbSet<BCatalogStoreProduct> BCatalogStoreProducts { get; set; } |
| | 1 | 16 | | public DbSet<BCatalogStore> BCatalogStores { get; set; } |
| | 1 | 17 | | public DbSet<BCatalogGroup> BCatalogGroups { get; set; } |
| | 1 | 18 | | public DbSet<RemainingStockBitrix> RemainingStockBitrix { get; set; } |
| | 1 | 19 | | public DbSet<RemainingStockFlat> RemainingStockFlat { get; set; } |
| | | 20 | | |
| | | 21 | | |
| | | 22 | | protected override void OnModelCreating(ModelBuilder modelBuilder) |
| | | 23 | | { |
| | 1 | 24 | | base.OnModelCreating(modelBuilder); |
| | 1 | 25 | | modelBuilder.Entity<RemainingStockBitrix>().HasNoKey(); |
| | 1 | 26 | | modelBuilder.Entity<RemainingStockFlat>().HasNoKey(); |
| | 1 | 27 | | modelBuilder.Entity<MaxTimestampResult>().HasNoKey(); |
| | | 28 | | |
| | 1 | 29 | | modelBuilder.Entity<BCatalogStoreProduct>() |
| | 1 | 30 | | .HasIndex(x => new { x.ProductId, x.StoreId }) |
| | 1 | 31 | | .IsUnique(); |
| | 1 | 32 | | modelBuilder.Entity<BIblockElementProperty>() |
| | 1 | 33 | | .HasIndex(x => new { x.IblockElementId, x.IblockPropertyId }) |
| | 1 | 34 | | .HasDatabaseName("ix_iblock_element_property_1"); |
| | 1 | 35 | | modelBuilder.Entity<BIblockElementProperty>() |
| | 1 | 36 | | .HasIndex(x => x.IblockPropertyId) |
| | 1 | 37 | | .HasDatabaseName("ix_iblock_element_property_2"); |
| | 1 | 38 | | modelBuilder.Entity<BCatalogPrice>() |
| | 1 | 39 | | .HasIndex(x => new { x.ProductId, x.CatalogGroupId }) |
| | 1 | 40 | | .HasDatabaseName("IXS_CAT_PRICE_PID"); |
| | 1 | 41 | | modelBuilder.Entity<BCatalogPrice>() |
| | 1 | 42 | | .HasIndex(x => x.CatalogGroupId) |
| | 1 | 43 | | .HasDatabaseName("IXS_CAT_PRICE_GID"); |
| | 1 | 44 | | modelBuilder.Entity<BCatalogPrice>() |
| | 1 | 45 | | .HasIndex(x => x.PriceScale) |
| | 1 | 46 | | .HasDatabaseName("IXS_CAT_PRICE_SCALE"); |
| | 1 | 47 | | } |
| | | 48 | | } |