using System.Text.Json;using System.Text.RegularExpressions;using Generated;using Generated.Models;using TeaQL.Core;using TeaQL.Sql;using TeaQL.Provider.Sqlite;using Microsoft.Data.Sqlite; const string Seed="Seed stock reservation fixture",Reserve="Reserve Order inventory atomically"; static string[]? Session(string token)=>token switch{"a"=>["ACTOR-A","TENANT-A","BUYER-A"],"b"=>["ACTOR-B","TENANT-A","BUYER-B"],"c"=>["ACTOR-C","TENANT-B","BUYER-A"],_=>null}; static bool Has(JsonElement r,string k)=>r.TryGetProperty(k,out _); static void Validate(string token,JsonElement r){if(Session(token)==null)throw new Denied("UNAUTHENTICATED");if(new[]{"tenant","buyer","actor","permissions","policy","userContext"}.Any(k=>Has(r,k)))throw new Denied("FORGED_SCOPE");if(r.EnumerateObject().Select(p=>p.Name).Order().SequenceEqual(new[]{"orderNumber","quantity","requestKey","sku"})==false||r.GetProperty("quantity").ValueKind!=JsonValueKind.Number||!r.GetProperty("quantity").TryGetInt64(out long q)||q<1||q>10||r.GetProperty("requestKey").ValueKind!=JsonValueKind.String||!Regex.IsMatch(r.GetProperty("requestKey").GetString()!,"\\A[A-Z0-9-]{1,64}\\z"))throw new Denied("INVALID_REQUEST");foreach(string key in new[]{"orderNumber","sku"})if(r.GetProperty(key).ValueKind!=JsonValueKind.String||r.GetProperty(key).GetString()!.Length is <1 or >64)throw new Denied("INVALID_REQUEST");} static bool Conflict(Exception error){string t=error.ToString().ToLowerInvariant();return !new[]{"busy","locked","timeout"}.Any(t.Contains)&&new[]{"version","optimistic","conflict","stale","authoritative persisted state"}.Any(t.Contains);} static Dictionary Result(string code,long? receipt,int attempts,List reasons)=>new(){["code"]=code,["receiptId"]=receipt,["attempts"]=attempts,["conflicts"]=reasons.Count,["conflictReasons"]=reasons.ToArray()}; static async Task Barrier(object ready){string? folder=Environment.GetEnvironmentVariable("ORDER_BARRIER");if(folder==null)return;string worker=Environment.GetEnvironmentVariable("ORDER_WORKER")!,temp=Path.Combine(folder,worker+".tmp");File.WriteAllText(temp,JsonSerializer.Serialize(ready));File.Move(temp,Path.Combine(folder,worker+".ready"));var end=DateTime.UtcNow.AddSeconds(45);while(!File.Exists(Path.Combine(folder,"release"))){if(DateTime.UtcNow>end)throw new Exception("Barrier timeout");await Task.Delay(10);}} static async Task Handle(UserContext context,string token,JsonElement r){int attempts=0;var reasons=new List();try{ Validate(token,r);var session=Session(token)!;string tenant=session[1],buyer=session[2],key=r.GetProperty("requestKey").GetString()!,number=r.GetProperty("orderNumber").GetString()!,sku=r.GetProperty("sku").GetString()!;long qty=r.GetProperty("quantity").GetInt64(); for(int attempt=0;attempt<3;attempt++){ attempts++;var roots=await Q.CommercePlatforms().WithTenantKeyIs(tenant) .SelectCustomerOrderListWith(Q.CustomerOrders().WithBuyerReferenceIs(buyer).WithOrderNumberIs(number).Limit(2)) .SelectInventoryListWith(Q.Inventory().WithSkuCodeIs(sku).Limit(2)) .SelectStockReservationListWith(Q.StockReservations().WithBuyerReferenceIs(buyer).WithRequestKeyIs(key).Limit(2)) .Limit(2).Comment("Load trusted tenant reservation aggregate").Purpose("Bind Order inventory and receipt to server session").ExecuteForListAsync(context); if(roots.Count!=1)throw new Exception("Invalid trusted root");var root=roots[0];var receipts=root.StockReservationList;if(receipts.Count>1)throw new Exception("Duplicate persisted request key"); if(receipts.Count==1){var e=E.StockReservation(receipts[0]);bool same=e.OrderNumber().Eval()==number&&e.SkuCode().Eval()==sku&&e.Quantity().Eval()==qty;return Result(same?"REPLAY":"IDEMPOTENCY_CONFLICT",same?e.Id().Eval():null,attempts,reasons);} var orders=root.CustomerOrderList;var stocks=root.InventoryList;if(orders.Count!=1||stocks.Count!=1)throw new Denied("NOT_FOUND");var order=orders[0];var stock=stocks[0];var oe=E.CustomerOrder(order);var se=E.Inventory(stock); if(oe.OrderStatusId().Eval()!=1001)throw new Denied("ORDER_NOT_DRAFT");var items=await Q.OrderItems().FilterByCustomerOrder(oe.Id().Eval()!.Value).Limit(2).Comment("Validate complete bounded Order items").Purpose("Reject mismatched reservation quantity or SKU").ExecuteForListAsync(context); if(items.Count!=1||E.OrderItem(items[0]).SkuCode().Eval()!=sku||E.OrderItem(items[0]).Quantity().Eval()!=qty)throw new Denied("INVALID_ORDER_ITEMS");long available=se.AvailableQuantity().Eval()!.Value,reserved=se.ReservedQuantity().Eval()!.Value;if(available<0||reserved<0)throw new Exception("Invalid inventory");if(available();var originalContext=context;using var request=JsonDocument.Parse("{\"requestKey\":\"REQ-FAULT\",\"orderNumber\":\"ORD-STOCK-001\",\"sku\":\"SKU-WIDGET\",\"quantity\":4}");gate.Active=true;Console.WriteLine("ORDER_FAULT_BEGIN");Dictionary first; try{if(gate.Mode=="pre-cancel"){gate.Cancellation.Cancel();gate.Cancellation.Token.ThrowIfCancellationRequested();}var result=await Handle(context,"a",request.RootElement);var value=JsonSerializer.SerializeToElement(result);first=new(){["code"]=value.GetProperty("code").GetString(),["result"]=result};} catch(Exception error){bool cancelled=error.GetBaseException() is OperationCanceledException;first=new(){["code"]=cancelled?"CANCELLED":gate.Mode=="commit"?"COMMIT_FAILED":"UNEXPECTED_ERROR",["type"]=error.GetBaseException().GetType().FullName,["error"]=error.ToString()};} first["pid"]=Environment.ProcessId;first["providerIdentity"]=System.Runtime.CompilerServices.RuntimeHelpers.GetHashCode(originalProvider!);first["contextIdentity"]=System.Runtime.CompilerServices.RuntimeHelpers.GetHashCode(context);first["events"]=gate.Events.ToArray();gate.Publish("failed",first);gate.Active=false;await gate.Wait("recovery");Console.WriteLine("ORDER_FAULT_RECOVERY");var recovery=await Handle(context,"a",request.RootElement);Console.WriteLine("ORDER_FAULT_RESULT "+JsonSerializer.Serialize(new{mode=gate.Mode,first,recovery,sameProvider=ReferenceEquals(originalProvider,context.GetResource()),sameContext=ReferenceEquals(originalContext,context),tasksJoined=true})); } var phase=args.Single();var module=GeneratedRuntimeModule.Module;var context=module.IntoContext();var gate=new FaultGate();await using var connection=new SqliteConnection("Data Source="+Environment.GetEnvironmentVariable("ORDER_DATABASE")+";Default Timeout=2");await connection.OpenAsync();var transport=new ObservedTransport(new SqliteTransport(connection),gate);var provider=new SqlDataServiceExecutor(new SqliteDialect(),transport,new MetadataSchemaProvider(module.Metadata.GetEntity));context.WithDataService(provider); if(phase is "bootstrap" or "seed")await context.EnsureSchemaAsync();if(phase=="seed")await SeedData(context);else if(phase=="fault")await FaultRun(context,gate);else if(phase!="bootstrap")throw new Exception("Unknown phase");Console.WriteLine("ORDER_OK phase="+phase); sealed class Denied(string code):Exception(code); sealed class FaultGate{ public bool Active;public string Mode=Environment.GetEnvironmentVariable("ORDER_FAULT_MODE")??"";readonly string Folder=Environment.GetEnvironmentVariable("ORDER_FAULT_BARRIER")??".";public List Events=new();public CancellationTokenSource Cancellation=new(); public void Event(string kind,object? detail=null){if(Active){var row=new{ @event=kind,detail};Events.Add(row);Console.WriteLine("ORDER_FAULT_EVENT "+JsonSerializer.Serialize(row));}} public void Publish(string name,object value){string temp=Path.Combine(Folder,name+".tmp");File.WriteAllText(temp,JsonSerializer.Serialize(value));File.Move(temp,Path.Combine(Folder,name+".json"));} public async Task Wait(string name){var end=DateTime.UtcNow.AddSeconds(45);while(!File.Exists(Path.Combine(Folder,name))){if(DateTime.UtcNow>end)throw new Exception("Fault barrier timeout");await Task.Delay(10);}} public async Task Gate(string point){if(!Active||point=="after-inventory"&&Mode!="cancel"&&Mode!="provider"||point=="before-commit"&&Mode!="commit"&&Mode!="control")return;Event("WAIT",point);Publish("ready",new{pid=Environment.ProcessId,mode=Mode,point});if(Mode=="cancel"){await Wait("cancel");Cancellation.Cancel();await Task.Delay(1,Cancellation.Token);}else await Wait("release");} } sealed class ObservedTransport(SqliteTransport inner,FaultGate gate):IAutomaticMutationTransactionTransport,ISchemaConnectionInitializer{ public Task EnsureSchemaFunctionsAsync()=>inner.EnsureSchemaFunctionsAsync(); public Task> FetchAllSqlAsync(CompiledQuery q)=>inner.FetchAllSqlAsync(q); public Task ExecuteSqlAsync(CompiledQuery q)=>inner.ExecuteSqlAsync(q); public async Task BeginSqlAsync(){var tx=await inner.BeginSqlAsync();gate.Event("BEGIN_OK");return new ObservedTransaction(tx,gate);} } sealed class ObservedTransaction(ISqlTransaction inner,FaultGate gate):ISqlTransaction{ public Task> FetchAllSqlAsync(CompiledQuery q)=>inner.FetchAllSqlAsync(q); public async Task ExecuteSqlAsync(CompiledQuery q){var rows=await inner.ExecuteSqlAsync(q);if(gate.Active&&Regex.IsMatch(q.Sql,"UPDATE\\s+[\"]?inventory_data",RegexOptions.IgnoreCase))await gate.Gate("after-inventory");return rows;} public async Task CommitSqlAsync(){await gate.Gate("before-commit");gate.Event("COMMIT_START");try{await inner.CommitSqlAsync();gate.Event("COMMIT_OK");}catch(Exception e){gate.Event("COMMIT_ERROR",e.ToString());throw;}} public async Task RollbackSqlAsync(){gate.Event("ROLLBACK_START");try{await inner.RollbackSqlAsync();gate.Event("ROLLBACK_OK");}catch(Exception e){gate.Event("ROLLBACK_ERROR",e.ToString());throw;}} public void Dispose(){inner.Dispose();gate.Event("DISPOSE_OK");} }