chmarr

2020-05-01 07:37:28,554 - octoprint.server.heartbeat - INFO - Server heartbeat <3
2020-05-01 07:37:28,675 - octoprint.server - INFO - --- Log roll over detected ---------------------------------------------------
2020-05-01 07:37:28,738 - octoprint.server - INFO - OctoPrint 1.3.12
2020-05-01 07:37:29,278 - octoprint.plugin.core - INFO - 15 plugin(s) registered with the system:
|  Action Command Prompt Support (bundled) = /home/pi/oprint/lib/python2.7/site-packages/octoprint/plugins/action_command_prompt
|  Announcement Plugin (bundled) = /home/pi/oprint/lib/python2.7/site-packages/octoprint/plugins/announcements
|  Anonymous Usage Tracking (bundled) = /home/pi/oprint/lib/python2.7/site-packages/octoprint/plugins/tracking
|  Application Keys Plugin (bundled) = /home/pi/oprint/lib/python2.7/site-packages/octoprint/plugins/appkeys
|  Backup & Restore (bundled) = /home/pi/oprint/lib/python2.7/site-packages/octoprint/plugins/backup
|  Core Wizard (bundled) = /home/pi/oprint/lib/python2.7/site-packages/octoprint/pl

chmarr

SELECT blocked_locks.pid         AS blocked_pid,
       blocked_activity.usename  AS blocked_user,
	   now() - blocked_activity.query_start
		                         AS blocked_duration,
       blocking_locks.pid        AS blocking_pid,
       blocking_activity.usename AS blocking_user,
	   now() - blocking_activity.query_start
                                 AS blocking_duration,
       blocked_activity.query    AS blocked_statement,
       blocking_activity.query   AS blocking_statement

chmarr

import yaml
import json
import sys

with open(sys.argv[2], "w") as outf, open(sys.argv[1]) as inf:
    o = yaml.safe_load(inf)
    json.dump(o, outf)Dtex-Mac23:tmp ccogdon$