$ pip install click requests
$ python query_export.py --redash-url "https://app.redash.io/" --api-key ""
| Retry count | Retry Time | Total Cumulative Time | Total Cumulative Days | |
|---|---|---|---|---|
| 0 | 0:00:00 | 0:00:00 | 0.0 | |
| 1 | 0:00:16 | 0:00:16 | 0.0 | |
| 2 | 0:00:31 | 0:00:47 | 0.0 | |
| 3 | 0:01:36 | 0:02:23 | 0.0 | |
| 4 | 0:04:31 | 0:06:54 | 0.0 | |
| 5 | 0:10:40 | 0:17:34 | 0.0 | |
| 6 | 0:21:51 | 0:39:25 | 0.0 | |
| 7 | 0:40:16 | 1:19:41 | 0.1 | |
| 8 | 1:08:31 | 2:28:12 | 0.1 |
| options = { :body => | |
| { :username => 'my', | |
| :password => 'password' | |
| } | |
| } | |
| results = HTTParty.post("http://api.topcoder.com/v2/auth", options) | |
| ## | |
| ## example for post with papertrail and basic auth | |
| ## |
| (* | |
| @author: Slipp Douglas Thompson | |
| @purpose: Pauses Spotify after the current song finishes playing. | |
| @todo: Optimize so it's more efficient. | |
| @usage: Drop a compiled script (a .scpt file, converted with AppleScript Editor if this is a .applescript file) into ~/Library/Scripts/Applications/Spotify. | |
| Ensure than “Show Script menu in menu bar” is enabled (which can be found in the AppleScript Editor preferences). | |
| When playing a song in Spotify and wishing to stop the music when the track finished, choose “When Song Finishes, Pause” from the script menu, and then walk, walk away. | |
| *) | |
| tell application "Spotify" | |
| log "“When Song Finishes, Pause”: player state is " & (player state) |
| -- show running queries (pre 9.2) | |
| SELECT procpid, age(clock_timestamp(), query_start), usename, current_query | |
| FROM pg_stat_activity | |
| WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
| ORDER BY query_start desc; | |
| -- show running queries (9.2) | |
| SELECT pid, age(clock_timestamp(), query_start), usename, query | |
| FROM pg_stat_activity | |
| WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |