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 async Task SeedData(UserContext context){using var doc=JsonDocument.Parse(File.ReadAllText(Environment.GetEnvironmentVariable("ORDER_FIXTURE")!));var f=doc.RootElement;var roots=await Q.CommercePlatforms().Limit(2).Comment("Read initialized stock root").Purpose(Seed).ExecuteForListAsync(context);if(roots.Count!=1)throw new Exception("Expected initialized root");int n=0; foreach(var t in f.GetProperty("tenants").EnumerateArray()){string tenant=t.GetProperty("key").GetString()!;var root=n++==0?roots[0]:Q.CommercePlatforms().Comment("Create tenant").Purpose(Seed).NewEntity(context);root.UpdateName("Tenant "+tenant[^1]);root.UpdateTenantKey(tenant);root.UpdateReservationSequence(0);await root.AuditAs(Seed).SaveAsync(context);long rid=E.CommercePlatform(root).Id().Eval()!.Value; for(int k=0;k<2;k++){var stock=Q.Inventory().Comment("Create SKU inventory").Purpose(Seed).NewEntity(context);stock.UpdateCommercePlatformId(rid);stock.UpdateSkuCode(f.GetProperty(k==0?"sku":"controlSku").GetString());stock.UpdateAvailableQuantity(k==0?t.GetProperty("available").GetInt64():f.GetProperty("controlAvailable").GetInt64());stock.UpdateReservedQuantity(0);stock.UpdateWarehouseNote("Initial warehouse stock");await stock.AuditAs(Seed).SaveAsync(context);} foreach(var buyer in f.GetProperty("buyers").EnumerateArray())foreach(var d in f.GetProperty("orders").EnumerateArray()){long qty=d.GetProperty("quantity").GetInt64(),price=f.GetProperty("unitPriceMinor").GetInt64();var o=Q.CustomerOrders().Comment("Create stock Order").Purpose(Seed).NewEntity(context);o.UpdateCommercePlatformId(rid);o.UpdateOrderStatusToDraft();o.UpdateOrderNumber(d.GetProperty("number").GetString());o.UpdateBuyerReference(buyer.GetString());o.UpdateCurrencyCode("USD");o.UpdateTotalMinor(qty*price);o.UpdateOrderNote("Stock reservation fixture order");await o.AuditAs(Seed).SaveAsync(context); var i=Q.OrderItems().Comment("Create complete Order line").Purpose(Seed).NewEntity(context);i.UpdateCustomerOrderId(E.CustomerOrder(o).Id().Eval()!.Value);i.UpdateSkuCode(f.GetProperty("sku").GetString());i.UpdateProductName(f.GetProperty("sku").GetString());i.UpdateQuantity(qty);i.UpdateUnitPriceMinor(price);i.UpdateLineTotalMinor(qty*price);await i.AuditAs(Seed).SaveAsync(context);} }} static async Task> Edit(UserContext context,Gate g,JsonElement r){const string reason="Stress Order and item atomically"; var roots=await Q.CommercePlatforms().WithTenantKeyIs("TENANT-A").Limit(2).Comment("Resolve trusted stress tenant").Purpose(reason).ExecuteForListAsync(context);if(roots.Count!=1)throw new Exception("Invalid root"); var orders=await Q.CustomerOrders().FilterByCommercePlatform(E.CommercePlatform(roots[0]).Id().Eval()!.Value).WithBuyerReferenceIs(r.GetProperty("buyer").GetString()!).WithOrderNumberIs(r.GetProperty("orderNumber").GetString()!).SelectOrderItemListWith(Q.OrderItems().Limit(2)).Limit(2).Comment("Load complete bounded Order and item").Purpose(reason).ExecuteForListAsync(context);if(orders.Count!=1)throw new Exception("Invalid Order");var o=orders[0];if(o.OrderItemList.Count!=1)throw new Exception("Invalid item");var i=o.OrderItemList[0]; var result=new Dictionary{["originalOrderVersion"]=E.CustomerOrder(o).Version().Eval(),["originalItemVersion"]=E.OrderItem(i).Version().Eval()};if(r.TryGetProperty("cohort",out var cohort)&&cohort.GetBoolean()){g.Publish("preloaded",result);await g.Wait("cohort-release");} o.UpdateOrderNote(r.GetProperty("token").GetString()!);i.UpdateProductName(r.GetProperty("token").GetString()!); try{await o.AuditAs(reason).SaveAsync(context);result["outcome"]="COMMITTED";}catch(Exception error){var text=error.ToString();var lower=text.ToLowerInvariant();result["outcome"]=error.GetBaseException() is OperationCanceledException?"CANCELLED":text.Contains("ORDER_STRESS_PROVIDER_ABORT")?"PROVIDER_FAILED":!new[]{"busy","locked","timeout"}.Any(lower.Contains)&&new[]{"version","optimistic","conflict","stale","authoritative persisted state"}.Any(lower.Contains)?"CONFLICT":"ERROR";result["error"]=text;result["type"]=error.GetBaseException().GetType().FullName;}return result; } static async Task Worker(UserContext context,Gate g){g.Publish("ready",new{pid=Environment.ProcessId,providerIdentity=System.Runtime.CompilerServices.RuntimeHelpers.GetHashCode(context.GetResource()!)});for(int n=0;;n++){await g.Wait(n+".command.json");using var doc=JsonDocument.Parse(File.ReadAllText(Path.Combine(g.Folder,n+".command.json")));var r=doc.RootElement;string action=r.GetProperty("action").GetString()!;var result=new Dictionary();if(action=="edit"){g.Mode=r.GetProperty("mode").GetString()!;g.Calibrate=r.TryGetProperty("calibrate",out var cal)&&cal.GetBoolean();g.ActiveTasks++;g.Started++;var task=Task.Run(()=>Edit(context,g,r));try{result=await task;}finally{g.ActiveTasks--;g.Finished++;}if(!task.IsCompleted)throw new Exception("Unjoined task");}bool closed=action=="close";if(closed)await g.Connection.DisposeAsync();result["metrics"]=g.Metrics();result["pid"]=Environment.ProcessId;result["closed"]=closed;g.Publish(n+".result",result);if(closed)break;}} var phase=args.Single();var module=GeneratedRuntimeModule.Module;var context=module.IntoContext();await using var connection=new SqliteConnection("Data Source="+Environment.GetEnvironmentVariable("ORDER_DATABASE")+";Default Timeout=5;Pooling=False");await connection.OpenAsync();var gate=new Gate(connection);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=="stress")await Worker(context,gate);else if(phase!="bootstrap")throw new Exception("Unknown phase");Console.WriteLine("ORDER_OK phase="+phase); sealed class Gate(SqliteConnection connection){ public SqliteConnection Connection=connection;public string Mode="normal";public bool Calibrate;public int Transactions,ActiveTasks,Started,Finished,CreatedTransactions,DisposedTransactions;public string Folder=Environment.GetEnvironmentVariable("ORDER_STRESS_FOLDER")??"."; public object Metrics()=>new{activeTransactions=Transactions,activeTasks=ActiveTasks,startedTasks=Started,finishedTasks=Finished,openConnections=Connection.State==System.Data.ConnectionState.Open?1:0,connectionState=Connection.State.ToString(),createdTransactions=CreatedTransactions,disposedTransactions=DisposedTransactions,fd=Directory.GetFileSystemEntries("/dev/fd").Length,pendingThreadPoolWork=ThreadPool.PendingWorkItemCount}; public void Publish(string name,object value){string tmp=Path.Combine(Folder,name+".tmp");File.WriteAllText(tmp,JsonSerializer.Serialize(value));File.Move(tmp,Path.Combine(Folder,name+".json"));} public async Task Wait(string name){var end=DateTime.UtcNow.AddSeconds(90);while(!File.Exists(Path.Combine(Folder,name))){if(DateTime.UtcNow>end)throw new Exception("Stress protocol timeout "+name);await Task.Delay(2);}} public async Task Checkpoint(){if(Mode=="cancel"){if(Calibrate){Publish("held",Metrics());await Wait("held-release");}using var cancel=new CancellationTokenSource();cancel.Cancel();await Task.Delay(1,cancel.Token);}} } sealed class ObservedTransport(SqliteTransport inner,Gate g):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();g.Transactions++;g.CreatedTransactions++;return new Tx(tx,g);}} sealed class Tx(ISqlTransaction inner,Gate g):ISqlTransaction{ bool disposed;public Task> FetchAllSqlAsync(CompiledQuery q)=>inner.FetchAllSqlAsync(q); public async Task ExecuteSqlAsync(CompiledQuery q){var n=await inner.ExecuteSqlAsync(q);if(Regex.IsMatch(q.Sql,"UPDATE\\s+[\"]?customer_order_data",RegexOptions.IgnoreCase))await g.Checkpoint();return n;} public Task CommitSqlAsync()=>inner.CommitSqlAsync();public Task RollbackSqlAsync()=>inner.RollbackSqlAsync();public void Dispose(){inner.Dispose();if(!disposed){disposed=true;g.Transactions--;g.DisposedTransactions++;}}}