mirror of
https://github.com/lightninglabs/lightning-terminal.git
synced 2026-08-14 12:43:32 +02:00
5cf25ca624
This commit introduces a comprehensive Starlark scripting system that enables custom automation with access to all subdaemon RPCs (lnd, loop, pool, faraday, taproot-assets). Scripts use native LND macaroons for permission enforcement. Key features: - Starlark execution engine with sandboxed resource limits - Standard builtins: print, log, sleep, now, json_encode/decode - HTTP GET requests with URL allowlisting - Persistent KV store with bucket-based permissions - LND event subscriptions for long-running daemon scripts - Script CRUD operations with macaroon baking - Execution history and running script tracking - Complete CLI commands (litcli scripts ...) Database schema: - scripts: Store script definitions with macaroon permissions - script_executions: Audit trail for script runs - script_kv_store: Persistent key-value storage for scripts - running_scripts: Track currently running scripts Security model: - Each script has an LND macaroon baked with specific permissions - RPC calls from scripts include this macaroon in the header - LND/subdaemons validate permissions natively - URL and bucket allowlists validated at runtime
17 lines
593 B
SQL
17 lines
593 B
SQL
-- Drop all script-related tables and indexes
|
|
|
|
DROP INDEX IF EXISTS running_scripts_script_id_idx;
|
|
DROP TABLE IF EXISTS running_scripts;
|
|
|
|
DROP INDEX IF EXISTS script_kv_store_bucket_key_idx;
|
|
DROP INDEX IF EXISTS script_kv_store_bucket_idx;
|
|
DROP TABLE IF EXISTS script_kv_store;
|
|
|
|
DROP INDEX IF EXISTS script_executions_started_at_idx;
|
|
DROP INDEX IF EXISTS script_executions_state_idx;
|
|
DROP INDEX IF EXISTS script_executions_script_id_idx;
|
|
DROP TABLE IF EXISTS script_executions;
|
|
|
|
DROP INDEX IF EXISTS scripts_created_at_idx;
|
|
DROP INDEX IF EXISTS scripts_name_idx;
|
|
DROP TABLE IF EXISTS scripts;
|