Cannot capture the output of external command (:sh displays it)?

[ostrolucky]

Cannot capture the output of external command (:sh displays it)?

[tstack]

The shell_exec() SQL function was recently added and can be used to execute a command. So, you can extract the user ID using one of the SQL JSON functions, like so:

;SELECT jget(context, '/upstream_session/user_id') AS userId FROM monologjson WHERE log_line = log_msg_line()

then do ;SELECT ... WHERE id=$userId to retrieve corresponding entry from database

Is this an external database that you would be talking to? For example, with PostgreSQL, I think something like the following might work... but, I haven't tried it out for real:

;SELECT shell_exec(
    'psql -v "userId=$userId"',
    'SELECT ... WHERE id=:userId',
    json_object('env', json_object('userId', $userId)))

[tstack]

Another new feature you might be interested in for this is the :annotate command, which will run a script and then insert the output into the log view. The following annotation configuration will convert an encoded backtrace in a log file and insert something human-readable:

lnav/src/root-config.json

Lines 17 to 23 in c0e3931

	"annotations": {
	"com.vmware.vmacore.backtrace": {
	"description": "Convert a vmacore backtrace into human-readable text",
	"condition": ":log_body LIKE '%[context]%[/context]%'",
	"handler": "com.vmware.btresolver.py"
	}
	}

[tstack]

The :sh command is intended to be used to asynchronously run a command where you want the output to be displayed in the log or text view. For example, using a command to get logs from a service would be a good use for :sh. The --name is used to name the output in the log/text view.

[ostrolucky]

Hmm is there a synchronous command I can use to preprocess things for following steps in a script? My intention here is to use jq with $log_raw_text to extract ID from a message and then do ;SELECT ... WHERE id=$userId to retrieve corresponding entry from database

[ostrolucky]

Oh yeah this is all I need for my use case. Works great for my use case. Makes things fly unlike :sh as well, because of #1222