I hereby claim:
- I am rootcss on github.
- I am rootcss (https://keybase.io/rootcss) on keybase.
- I have a public key whose fingerprint is E39D A481 351E 3C2C FD3D 5EA2 8605 5CD9 0FEB 4148
To claim this, I am signing this object:
I hereby claim:
To claim this, I am signing this object:
| import code | |
| some_var = 100 | |
| code.interact(local=dict(globals(), **locals())) | |
| print some_var |
| import java.io.InputStream | |
| import org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils | |
| import org.apache.spark.sql.{ DataFrame, Row } | |
| import org.postgresql.copy.CopyManager | |
| import org.postgresql.core.BaseConnection | |
| val jdbcUrl = s"jdbc:postgresql://..." // db credentials elided | |
| val connectionProperties = { |
| """ | |
| Fetches key paths and values of a dictionary | |
| """ | |
| def dict_path(path, my_dict): | |
| for k,v in my_dict.iteritems(): | |
| if isinstance(v, dict): | |
| dict_path(path + "_" + k, v) | |
| else: | |
| output.append('key: {}_{}, val: {}'.format(path, k, v)) |
| import subprocess | |
| from threading import Thread | |
| def call_subprocess(cmd): | |
| proc = subprocess.Popen(cmd, shell=True, stdout=subprocess.PIPE, stderr=subprocess.PIPE) | |
| out, err = proc.communicate() | |
| if err: | |
| print(err) | |
| thread = Thread(target=call_subprocess, args=['pip install --upgrade pip && pip install pysftp']) |
| body { background: #222; color: #e6e6e6; } | |
| a { color: #949494; } | |
| a:link, a:visited { color: #949494; } | |
| a:hover, a:active, a:focus { color: #c7c7c7; } | |
| hr { border-bottom: 1px solid #424242; border-top: 1px solid #222; } |
| -- 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%' |
| $("head").append(`<style> | |
| body, | |
| body.notebook_app.command_mode { | |
| font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", "Helvetica Neue", Helvetica, Arial, sans-serif; | |
| } | |
| .CodeMirror pre, | |
| .CodeMirror-dialog, | |
| .CodeMirror-dialog .CodeMirror-search-field, | |
| .terminal-app .terminal { |