| | | 1 | | namespace ZhEaIsNsAaBn.APPSettings; |
| | | 2 | | |
| | | 3 | | /// <summary>Default writer: updates the row with the key (among rows matching the query) or adds one.</summary> |
| | | 4 | | internal sealed class EFConfigurationWriter< TSettingsTable, TDbContext > : IEFConfigurationWriter<TSettingsTable, TDbCo |
| | | 5 | | where TSettingsTable : class, IEFConfigurationValue, new() |
| | | 6 | | where TDbContext : DbContext |
| | | 7 | | { |
| | | 8 | | private readonly EFConfigurationProviderSettings<TSettingsTable, TDbContext> _settings; |
| | | 9 | | |
| | | 10 | | |
| | 48 | 11 | | public EFConfigurationWriter( EFConfigurationProviderSettings<TSettingsTable, TDbContext> settings ) => _settings = |
| | | 12 | | |
| | | 13 | | |
| | | 14 | | /// <inheritdoc /> |
| | | 15 | | public async Task InsertAsync( string key, string value, CancellationToken cancellationToken = default ) |
| | | 16 | | { |
| | 8 | 17 | | ArgumentException.ThrowIfNullOrWhiteSpace( key ); |
| | 8 | 18 | | ArgumentNullException.ThrowIfNull( value ); |
| | | 19 | | |
| | | 20 | | |
| | 8 | 21 | | var context = await _settings.GetRequiredDbContextFactory().CreateDbContextAsync( cancellationToken ).ConfigureA |
| | | 22 | | |
| | 8 | 23 | | await using ( context.ConfigureAwait( false ) ) |
| | | 24 | | { |
| | 8 | 25 | | var set = context.Set<TSettingsTable>(); |
| | 8 | 26 | | var existing = await set.Where( _settings.Query ).FirstOrDefaultAsync( e => e.Key == key, cancellationToken |
| | | 27 | | |
| | | 28 | | |
| | 12 | 29 | | if ( existing is null ) { set.Add( new TSettingsTable { Key = key, Value = value } ); } |
| | 4 | 30 | | else { existing.Value = value; } |
| | | 31 | | |
| | | 32 | | |
| | 8 | 33 | | await context.SaveChangesAsync( cancellationToken ).ConfigureAwait( false ); |
| | 8 | 34 | | } |
| | 8 | 35 | | } |
| | | 36 | | |
| | | 37 | | /// <inheritdoc /> |
| | | 38 | | public async Task InsertFromJsonAsync( string json, CancellationToken cancellationToken = default ) |
| | | 39 | | { |
| | 12 | 40 | | ArgumentNullException.ThrowIfNull( json ); |
| | | 41 | | |
| | | 42 | | |
| | 12 | 43 | | var values = FlattenJson( json ); |
| | | 44 | | |
| | 4 | 45 | | if ( values.Count == 0 ) { return; } |
| | | 46 | | |
| | | 47 | | |
| | 4 | 48 | | var context = await _settings.GetRequiredDbContextFactory().CreateDbContextAsync( cancellationToken ).ConfigureA |
| | | 49 | | |
| | 4 | 50 | | await using ( context.ConfigureAwait( false ) ) |
| | | 51 | | { |
| | 4 | 52 | | var set = context.Set<TSettingsTable>(); |
| | 4 | 53 | | var keys = values.Keys.ToList(); |
| | 4 | 54 | | var existing = new Dictionary<string, TSettingsTable>( StringComparer.OrdinalIgnoreCase ); |
| | | 55 | | |
| | 4 | 56 | | var rows = await set.Where( _settings.Query ) |
| | 4 | 57 | | .Where( e => keys.Contains( e.Key ) ) |
| | 4 | 58 | | .ToListAsync( cancellationToken ) |
| | 4 | 59 | | .ConfigureAwait( false ); |
| | | 60 | | |
| | | 61 | | |
| | 20 | 62 | | foreach ( var row in rows ) { existing.TryAdd( row.Key, row ); } |
| | | 63 | | |
| | | 64 | | |
| | 40 | 65 | | foreach ( var (key, value) in values ) |
| | | 66 | | { |
| | 20 | 67 | | if ( existing.TryGetValue( key, out var row ) ) { row.Value = value; } |
| | 12 | 68 | | else { set.Add( new TSettingsTable { Key = key, Value = value } ); } |
| | | 69 | | } |
| | | 70 | | |
| | | 71 | | |
| | 4 | 72 | | await context.SaveChangesAsync( cancellationToken ).ConfigureAwait( false ); |
| | 4 | 73 | | } |
| | 4 | 74 | | } |
| | | 75 | | |
| | | 76 | | |
| | | 77 | | private static Dictionary<string, string> FlattenJson( string json ) |
| | | 78 | | { |
| | 12 | 79 | | using var document = JsonDocument.Parse( json ); |
| | | 80 | | |
| | 12 | 81 | | if ( document.RootElement.ValueKind != JsonValueKind.Object ) { throw new ArgumentException( "The JSON root must |
| | | 82 | | |
| | | 83 | | |
| | 4 | 84 | | var values = new Dictionary<string, string>( StringComparer.OrdinalIgnoreCase ); |
| | | 85 | | |
| | 4 | 86 | | FlattenElement( document.RootElement, string.Empty, values ); |
| | | 87 | | |
| | 4 | 88 | | return values; |
| | 4 | 89 | | } |
| | | 90 | | |
| | | 91 | | private static void FlattenElement( JsonElement element, string prefix, Dictionary<string, string> values ) |
| | | 92 | | { |
| | 24 | 93 | | switch ( element.ValueKind ) |
| | | 94 | | { |
| | | 95 | | case JsonValueKind.Object: |
| | 56 | 96 | | foreach ( var property in element.EnumerateObject() ) |
| | | 97 | | { |
| | 20 | 98 | | FlattenElement( property.Value, prefix.Length == 0 ? property.Name : $"{prefix}:{property.Name}", va |
| | | 99 | | } |
| | | 100 | | |
| | | 101 | | break; |
| | | 102 | | |
| | | 103 | | case JsonValueKind.Array: |
| | 4 | 104 | | values[ prefix ] = element.GetRawText(); |
| | | 105 | | |
| | 4 | 106 | | break; |
| | | 107 | | |
| | | 108 | | default: |
| | 12 | 109 | | values[ prefix ] = element.ToString(); |
| | | 110 | | |
| | | 111 | | break; |
| | | 112 | | } |
| | 20 | 113 | | } |
| | | 114 | | } |