"""Independent SQLite oracle. Only mode=ro connections; no generated imports."""
import json,sqlite3,sys
from pathlib import Path
if not __debug__:raise RuntimeError('Assertions required')
database=Path(sys.argv[1]);phase=sys.argv[2]
with sqlite3.connect(database.resolve().as_uri()+'?mode=ro',uri=True) as db:
 db.row_factory=sqlite3.Row
 state={name:[dict(r) for r in db.execute('SELECT * FROM '+table+' ORDER BY id')] for name,table in [('roots','commerce_platform_data'),('statuses','order_status_data'),('orders','customer_order_data'),('items','order_item_data')]}
 if phase=='bootstrap':
  assert not state['orders'] and not state['items'];assert len(state['roots'])==1
 elif phase=='seed':
  assert len(state['roots'])==2 and {r['tenant_key'] for r in state['roots']}=={'TENANT-A','TENANT-B'}
  assert len(state['orders'])==8 and len(state['items'])==16 and len(state['statuses'])==3
  for root in state['roots']:
   for buyer in ['BUYER-A','BUYER-B']:
    orders=[o for o in state['orders'] if o['commerce_platform']==root['id'] and o['buyer_reference']==buyer]
    assert {o['order_number'] for o in orders}=={'ORD-SHARED-001','ORD-SHARED-002'}
    for o in orders:
     assert o['version']==1 and o['total_minor']==3850 and o['currency_code']=='USD' and o['order_status']==1001
     assert o['order_note']=='Original '+root['tenant_key']+' '+buyer
     items=[i for i in state['items'] if i['customer_order']==o['id']]
     assert len(items)==2 and {i['sku_code'] for i in items}=={'SKU-NOTEBOOK','SKU-PEN'}
     assert sum(i['line_total_minor'] for i in items)==3850
     for i in items:assert i['version']==1 and i['product_name']==i['sku_code'] and i['line_total_minor']==i['quantity']*i['unit_price_minor']
 else:
  baseline=json.load(open(sys.argv[3]));spec=json.load(open(sys.argv[4]));result=json.load(open(sys.argv[5]));fixture=json.load(open(Path(__file__).with_name('fixture.json')))
  expected=json.loads(json.dumps(baseline));mutation=spec.get('mutation')
  if mutation:
   row=next(r for r in expected[mutation['table']] if r['id']==mutation['id']);actual=next(r for r in state[mutation['table']] if r['id']==mutation['id'])
   row.update({mutation['field']:mutation['value'],'version':row['version']+1,'update_time':actual['update_time']});assert actual['update_time'] is not None
  assert state==expected,'Unexpected persisted field, relation, amount, version or timestamp changed'
  def expected_result(token,r):
   session=fixture['sessions'][token];root=db.execute('SELECT id FROM commerce_platform_data WHERE tenant_key=?',(session['tenant'],)).fetchone()[0]
   where='version>0 AND commerce_platform=? AND buyer_reference=?';params=[root,session['buyer']]
   if 'orderId' in r:where+=' AND id=?';params.append(r['orderId'])
   if 'orderNumber' in r:where+=' AND order_number=?';params.append(r['orderNumber'])
   count,amount=db.execute('SELECT COUNT(*),SUM(total_minor) FROM customer_order_data WHERE '+where,params).fetchone()
   if r['op']=='summary':return dict(code='OK',**session,count=count,amount=amount)
   rows=[]
   for o in db.execute('SELECT * FROM customer_order_data WHERE '+where+' ORDER BY id LIMIT ?',params+[r.get('limit',2)]):
    items=[]
    for i in db.execute('SELECT * FROM order_item_data WHERE version>0 AND customer_order=? ORDER BY id LIMIT 3',(o['id'],)):
     if r['op']=='items' and i['id']!=r['itemId']:continue
     items.append(dict(id=i['id'],sku=i['sku_code'],productName=i['product_name'],version=i['version']))
    value=dict(id=o['id'],buyer=o['buyer_reference'],orderNumber=o['order_number'],note=o['order_note'],totalMinor=o['total_minor'],version=o['version'])
    if r['op']!='retained':value['items']=items
    rows.append(value)
   return dict(code='OK',**session,rows=rows,total=count)
  if spec['id']=='cache-switch':
   assert len(result['pages'])==4
   for token,plan,page in zip(['a','b','c','a'],['ID_SET_BUILD','ID_SET_BUILD','ID_SET_BUILD','ID_SET_HIT'],result['pages']):assert page==dict(**expected_result(token,{'op':'retained','limit':1}),plan=plan)
  elif spec['code']!='OK':assert result=={'code':spec['code']}
  elif mutation and not spec.get('readback'):assert result=={'code':'OK','changed':True}
  else:assert result==expected_result(spec['session'],spec['request']),(result,expected_result(spec['session'],spec['request']))
print(json.dumps(state,sort_keys=True))
