-- テストデータ作成参考: https://goodbyegangster.hatenablog.com/entry/2019/05/06/111009
create table random (code int);
insert into random (code)
    select (random() * 100) from generate_series(1, 10);

CREATE OR REPLACE VIEW view_test as
select * from random
UNION ALL
select * from random
;
 select * from view_test ;
 code
------
   94
   89
   88
    7
   44
    7
   14
   21
   64
   54
   94
   89
   88
    7
   44
    7
   14
   21
   64
   54
(20 rows)

-- 新たにデータを10件投入してみる。
insert into random (code)
    select (random() * 100) from generate_series(1, 10);

 select * from view_test ;
 code
------
   94
   89
   88
    7
   44
    7
   14
   21
   64
   54
   28
   88
   41
   18
   14
   70
   73
   15
    1
   66
   94
   89
   88
    7
   44
    7
   14
   21
   64
   54
   28
   88
   41
   18
   14
   70
   73
   15
    1
   66
(40 rows)

# https://zenn.dev/gakin/scraps/4cc16e7761d1ef　「Dockerfileを修正」まで構築
rm -rf node_modules/
# コンテナ再ビルド
docker-compose up -d --build
docker-compose ps
              Name                             Command               State    Ports
-----------------------------------------------------------------------------------
nodedev_node-dev_1   docker-entrypoint.sh /bin/ ...   Exit 1
# ログ確認→ moduleがなくてコケている。
docker-compose logs
Attaching to nodedev_node-dev_1
node-dev_1  |
node-dev_1  | > app@1.0.0 dev /app
node-dev_1  | > npx ts-node-dev --respawn src/app.ts
node-dev_1  |
npx: installed 52 in 8.128s
node-dev_1  | Cannot find module 'typescript

docker-compose run node-dev npm install
# node_moduleが作成されている。
ls
Dockerfile  docker-compose.yml  node_modules  package-lock.json  package.json  src  tsconfig.json

# コンテナ起動する
docker-compose up -d

# コンテナログを確認→hello worldが表示されていることを確認
docker-compoe logs -f 

Hello, world!

version: '3'
services:
  node-dev:
    build: 
      context: .
      dockerfile: Dockerfile
    tty: true
    volumes:
      - .:/app
    entrypoint: >
      /bin/sh -c "
        npm install && npm run dev
      "

rm -rf node_modules/
# コンテナ起動
docker-compose up -d
# コンテナログ確認→問題なく実行できていることを確認
docker-compose logs -f
 > app@1.0.0 dev /app
 > npx ts-node-dev --respawn src/app.ts

 [INFO] 11:43:18 ts-node-dev ver. 1.1.8 (using ts-node ver. 9.1.1, typescript ver. 4.6.4)
 Hello, world!

version: '3'
services:
  node-dev:
    build: 
      context: .
      dockerfile: Dockerfile
    tty: true
    volumes:
      - .:/app
      - node_modules-volumes:/app/node_modules/
volumes:
    node_modules-volumes:

select 
	count(column_name) 
from 
	information_schema.columns 
where 
	table_name='テーブル名'

gh auth login
# public repo list
gh repo list --visibility public --limit 100
# public→privateに変更する
gh repo edit <repo-name> --visibility private

"[markdown]":  {
    "editor.wordWrap": "on",
    "editor.quickSuggestions": true,
    "editor.snippetSuggestions": "top"
}

"details_tag": {
		"prefix": "ghdetail",
		"body": [
			"<details>",
			"<summary>$1</summary>",
			"",
			"",
			"</details>"
		],
		"description": "gh_details_tag"
}

from typing import Union
def function(test: Union[modelA, modelB]):
    """
    Args:
        test: modelAもしくはmodelBを取る
    """
    pass

KUBECONFIG=~/.kube/config:~/config kubectl config view --flatten

import sqlalchemy as sa
from sqlalchemy.orm import scoped_session
from sqlalchemy.ext.declarative import declarative_base

engine = sa.create_engine(
    sa.engine.url.URL.create(
        drivername="mysql+pymysql", # or postgresql
        username=db_user,  # e.g. "my-database-user"
        password=db_pass,  # e.g. "my-database-password"
        host=db_hostname,  # e.g. "127.0.0.1"
        port=db_port,  # e.g. 3306
        database=db_name,  # e.g. "my-database-name"
    )
)
session = scoped_session(
　　　　sessionmaker(
　　　　　　　　autocommit = False,
　　　　　　　　autoflush = False,
　　　　　　　　bind = engine
　　　　)
)

Base = declarative_base()
class User(Base):
    """
    ユーザモデル
    """
    __tablename__ = 'users'
    id = Column('id', Integer, primary_key = True)
    name = Column('name', String(200))
    age = Column('age', Integer)
    email = Column('email', String(100))


engine = test_session.get_bind()
engine.execute(f'TRUNCATE TABLE {User.__tablename__}')

SELECT 
    pg_terminate_backend(pid) 
FROM 
    pg_stat_activity 
WHERE 
    -- don't kill my own connection!
    pid <> pg_backend_pid()
    -- don't kill the connections to other databases
    AND datname = 'database_name'
;

version: "2"
services:
    containerA:
        image: yauritux/busybox-curl
        tty: true
    containerB:
        image: nginx

command: mysqld --character-set-server=utf8 --collation-server=utf8_general_ci --wait_timeout=10

win2lin () { f="${1/C://c}"; printf '%s\n' "${f//\\//}"; }

$ file='C:\Users\abcd\Downloads\testingFile.log'
$ win2lin "$file"
/c/Users/abcd/Downloads/testingFile.log
$ 
$ file='C:\Users\pqrs\Documents\foobar'
$ win2lin "$file"
/c/Users/pqrs/Documents/foobar

DB_DRIVER=postgresql
DB_USER=postgres
DB_PASS=password
DB_HOST=postgres
# DB_DRIVER=mysql
# DB_USER=mysql+pymysql
# DB_PASS=password
# DB_HOST=mysql
DB_NAME=test

# テーブル全部作る場合
sqlacodegen ${DB_DRIVER}://${DB_USER}:${DB_PASS}@${DB_HOST}/${DB_NAME} --outfile output.py

# 特定table郡から作るばあい
sqlacodegen ${DB_DRIVER}://${DB_USER}:${DB_PASS}@${DB_HOST}/${DB_NAME} --outfile output.py --tables <table名1>,<table名2>

WITH table_list AS
  (SELECT tablename
        , tableowner
   FROM pg_tables -- postgres table

   WHERE schemaname not like 'pg_%'
     AND schemaname != 'information_schema'
   UNION SELECT sequencename AS tablename
              , sequenceowner AS tableowner
   FROM pg_sequences -- postgres sequence

   UNION SELECT pg_views.viewname AS tablename
              , pg_views.viewowner AS tableowner
   FROM pg_views -- postgres view

   LEFT OUTER JOIN pg_class ON pg_views.viewname = pg_class.relname
   WHERE schemaname = current_schema() )
SELECT *
FROM table_list;