"""Controlled test setup and independent lock probe; never part of the oracle."""
import sqlite3,sys,json
p,op=sys.argv[1:3]
with sqlite3.connect(p,timeout=0) as db:
 if op=='install':db.execute("CREATE TRIGGER order_provider_test_abort BEFORE INSERT ON stock_reservation_data BEGIN SELECT RAISE(ABORT,'ORDER_PROVIDER_TEST_ABORT'); END")
 elif op=='remove':db.execute('DROP TRIGGER order_provider_test_abort')
 elif op=='journal':assert db.execute('PRAGMA journal_mode=DELETE').fetchone()[0]=='delete'
 elif op=='probe':
  try:db.execute('BEGIN IMMEDIATE');db.rollback();print(json.dumps({'writeLock':'available'}))
  except sqlite3.OperationalError as e:
   assert 'locked' in str(e).lower();print(json.dumps({'writeLock':'held','error':str(e),'sqliteCode':e.sqlite_errorcode}))
 else:raise ValueError('Unknown operation')
