bskim45

import java.awt.*;
import java.awt.event.ComponentAdapter;
import java.awt.event.ComponentEvent;
import java.awt.image.BufferedImage;
import java.io.File;
import java.io.IOException;
import java.util.concurrent.*;

import javax.imageio.ImageIO;
import javax.swing.JComponent;

bskim45

from pynamodb.models import Model
from pynamodb.attributes import UnicodeAttribute, NumberAttribute


class MyModel(Model):
    class Meta:
        table_name = 'mytable'

    group = UnicodeAttribute(hash_key=True)
    id = NumberAttribute(range_key=True)

bskim45

Req id:

parse @message '(*) *' as reqId, message
| filter reqId like "c19dd3fc-5f27-11e9-a823-930d231e2ab8"
| sort @timestamp asc
| limit 50

Status code:

bskim45

#!/bin/bash

if test -n "$GIT_PUSH_OPTION_COUNT"
then
  i=0
  while test "$i" -lt "$GIT_PUSH_OPTION_COUNT"
  do
    eval "value=\$GIT_PUSH_OPTION_$i"
    case "$value" in
    force)

bskim45

-- Identify how many S3 objects each COPY command loads
SELECT
    query, COUNT(*) num_files,
    ROUND(MAX(wq.total_exec_time/1000000.0),2) execution_secs,
    ROUND(SUM(transfer_size)/(1024.0*1024.0),2) total_mb,
    SUBSTRING(querytxt,1,60) copy_sql
FROM stl_s3client s
JOIN stl_query q USING (query)
JOIN stl_wlm_query wq USING (query)
WHERE s.userid>1 AND http_method = 'GET'

bskim45

/** Parallel Collection with parallelism level
*
* Changes the task support of a parallel collection to use a fork-join pool
* with desired parallelism level
*
* Usage:
* {{{
* Seq(1, 2, 3, 4).par.withCores(Runtime.getRuntime.availableProcessors * 2).map(_ * 2).sum
* }}}
*

bskim45

Markdown      +123/    -64 ████████████▎░░░░░░░░ 58.9%
Ruby          +674/   -250 ██▏░░░░░░░░░░░░░░░░░░ 10.3%
Python        +962/   -321 ██░░░░░░░░░░░░░░░░░░░  9.6%
TypeScript   +1.0k/   -184 █▋░░░░░░░░░░░░░░░░░░░  7.9%
JSON          +321/   -320 █▌░░░░░░░░░░░░░░░░░░░  7.2%
YAML          +596/   -162 █▏░░░░░░░░░░░░░░░░░░░  5.5%
TOML           +57/     -3 ░░░░░░░░░░░░░░░░░░░░░  0.5%
JavaScript      +6/     -6 ░░░░░░░░░░░░░░░░░░░░░  0.1%

bskim45

🌞 Morning     1 commits  ▎░░░░░░░░░░░░░░░░░░░░   1.4%
🌆 Daytime    14 commits  ████░░░░░░░░░░░░░░░░░  19.4%
🌃 Evening    34 commits  █████████▉░░░░░░░░░░░  47.2%
🌙 Night      23 commits  ██████▋░░░░░░░░░░░░░░  31.9%

bskim45

atlantis cheatsheet

Plan/apply only for a target resource

atlantis plan -d path/to/workspace -- -target target_resource

Destroy a workspace

bskim45

BigQuery Audit Log Cheatsheet (Cloud Logging)

Audit log format reference: https://cloud.google.com/bigquery/docs/reference/auditlogs

More sample queries: https://cloud.google.com/logging/docs/view/query-library#bigquery-filters

Get logs for dataset delete operations:

resource.type="bigquery_resource"