This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/python | |
# $Id: $ | |
# Converts Oracle, SQL-Server, and other DDL to Snowflake DDL | |
def usage(): | |
print """\ | |
# Usage: sql2sf.py input-file [output-file] | |
""" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name: Cypress Tests | |
on: | |
push: | |
branches-ignore: | |
- "renovate/**" | |
jobs: | |
install: | |
runs-on: ubuntu-latest |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Twitter API v2のTweets countsで指定キーワードを含むツイートのリストを取得 | |
# https://developer.twitter.com/en/docs/twitter-api/tweets/search/introduction | |
import json | |
import requests | |
import urllib.parse | |
import settings | |
# 検索条件 | |
query = '一番搾り' | |
url = f'https://api.twitter.com/2/tweets/search/recent?query={urllib.parse.quote(query)}' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
"""DataFrameでdatetime変換する時の速度比較. date formatなし vs date formatあり""" | |
import pandas as pd | |
import timeit | |
def read_csv_with_no_dateformat(): | |
# 2列8760行のCSV | |
df = pd.read_csv('testdata.csv') | |
df['date_time'] = pd.to_datetime(df['date_time']) | |
def read_csv_with_dateformat(): |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
FROM jrottenberg/ffmpeg | |
RUN apt-get update && apt-get install -y \ | |
curl \ | |
unzip \ | |
&& apt-get clean \ | |
&& rm -rf /var/lib/apt/lists/* | |
# aws cli v2 install | |
RUN curl "https://awscli.amazonaws.com/awscli-exe-linux-x86_64.zip" -o "awscliv2.zip" | |
RUN unzip awscliv2.zip | |
RUN ./aws/install |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
FROM jrottenberg/ffmpeg:4.1-ubuntu | |
RUN apt-get update | |
RUN apt-get install python3 python3-pip -y | |
# test | |
RUN pip3 install boto3 | |
ADD getfile_s3.py /opt/getfile_s3.py | |
# transcoding by ffmpeg script | |
ADD transcode_job.sh /usr/local/bin/transcode_job.sh |