"""Separate test setup and lock probe; never the business oracle."""
import sqlite3,sys,json
c=sqlite3.connect(sys.argv[1],timeout=0)
try:
 if sys.argv[2]=='install':
  c.execute('PRAGMA journal_mode=DELETE')
  c.execute("CREATE TRIGGER stress_item_abort BEFORE UPDATE ON order_item_data WHEN NEW.product_name LIKE 'STRESS-PROVIDER-%' BEGIN SELECT RAISE(ABORT,'ORDER_STRESS_PROVIDER_ABORT'); END")
  c.commit();print(json.dumps({'installed':True}))
 elif sys.argv[2]=='probe':
  try:c.execute('BEGIN IMMEDIATE');c.rollback();print(json.dumps({'writeLock':'available'}))
  except sqlite3.OperationalError as e:
   if 'locked' not in str(e).lower():raise
   print(json.dumps({'writeLock':'held','error':str(e)}))
 else:raise ValueError('Unknown setup action')
finally:c.close()
