Skip to content

Instantly share code, notes, and snippets.

View u110's full-sized avatar
๐Ÿ’ญ
๐Ÿ‘

Yuu Ito u110

๐Ÿ’ญ
๐Ÿ‘
View GitHub Profile
FROM postgres:14
ENV POSTGRES_PASSWORD=postgres
ENV POSTGRES_USER=postgres
# Fixed ownership and mode
RUN chown root:ssl-cert /etc/ssl/private/ssl-cert-snakeoil.key
RUN chmod 740 /etc/ssl/private/ssl-cert-snakeoil.key
CMD ["-c", "ssl=on", "-c", "ssl_cert_file=/etc/ssl/certs/ssl-cert-snakeoil.pem", "-c", "ssl_key_file=/etc/ssl/private/ssl-cert-snakeoil.key"]
# https://twitter.com/hiroysato/status/1339925551167893504
FROM openjdk:8-slim
ENV LANG=C.UTF-8 \
PATH_TO_EMBULK=/opt/embulk \
PATH=${PATH}:/opt/embulk
# Change timezone
RUN ln -sf /usr/share/zoneinfo/Asia/Tokyo /etc/localtime
with subset as (
select '๏ผ‘๏ผ’๏ผ“โˆ’๏ผ”๏ผ•๏ผ–๏ผ—' as x union all -- 123โˆ’4567
select 'ใŒถ' as x union all -- ใƒ˜ใ‚ฏใ‚ฟใƒผใƒซ
select 'ใˆฑใˆฒ' as x union all -- (ๆ ช)(ๆœ‰)
select '๏ฝฑ๏ฝฒ๏ฝณ๏ฝด๏ฝต๏ผก๏ผข๏ผฃ๏ฝ๏ฝ‚๏ฝƒโ‘ ' as x union all -- ใ‚ขใ‚คใ‚ฆใ‚จใ‚ชabcabc1
select 'ใ€’ใ€ ใ€ถ' as x union all -- ใ€’ใ€ ใ€’
select '()๏ผˆ๏ผ‰' as x union all -- ()()
select 'ABCabc'
)
select x,
package main
import (
"context"
"fmt"
"cloud.google.com/go/bigquery"
)
// Item represents a row item.
package transformer
import (
"bufio"
"encoding/csv"
"encoding/json"
"fmt"
"io"
"os"
)
@u110
u110 / bq_with_context.go
Last active February 23, 2020 04:42
gcloud sdk go ใจ context(cancel, timeout)ใฎๅ‹•ไฝœ
package main
import (
"cloud.google.com/go/bigquery"
"context"
"fmt"
"google.golang.org/api/iterator"
"log"
"os"
"time"
package main
import (
"encoding/csv"
"encoding/json"
"fmt"
"io"
"log"
"strings"
)
package main
import (
"encoding/json"
"errors"
"io/ioutil"
"log"
)
type Runner interface {
package main
import (
"cloud.google.com/go/bigquery"
"context"
"fmt"
"google.golang.org/api/option"
)
func showBqDatasets() {
package main
import (
"fmt"
"math/rand"
"time"
)
func Swap(arr *[]int, i int, j int) {
(*arr)[i], (*arr)[j] = (*arr)[j], (*arr)[i]