Masashi mmasashi

Prepare for OS update (事前準備)

	import contextlib
	import pytest
	from unittest.mock import patch


	class A(object):
	def say(self, msg):
	return f'A say {msg!r}.'

	@contextlib.contextmanager

	import contextlib
	import cProfile
	import datetime
	import io
	import pstats
	import time


	def log(msg):
	cur_datetime_str = datetime.datetime.now().strftime('%Y-%m-%dT%H:%M:%S')

	def setup_logging():
	import logging
	import os
	from logging.handlers import RotatingFileHandler
	from logging import Formatter
	handler = RotatingFileHandler('log/flask.log', maxBytes=10000, backupCount=1)
	process_id = os.getpid()
	handler.setFormatter(Formatter(
	#'[%(asctime)s] [%(levelname)s]: %(message)s [in %(pathname)s:%(lineno)d]' # for debug
	'[%(asctime)s #' + str(process_id) + '] [%(levelname)s]: %(message)s'

	require 'msgpack'
	require 'json'

	def usage
	puts <<EOT
	usage: ruby msgpack_util.rb <option> <input-file-path> [<output-file-path>]
	option:
	-d, --decode: Decode msgpack formatted data into JSON formatted data
	-e, --encode: Encode JSON formatted data into msgpack formatted data
	EOT

	CREATE USER r_only_user identified by 'password';
	GRANT SELECT, SHOW VIEW, PROCESS, REPLICATION CLIENT ON . TO 'r_only_user'@'%' IDENTIFIED BY 'password';
	GRANT SELECT, SHOW VIEW, PROCESS, REPLICATION CLIENT ON . TO 'r_only_user'@'localhost' IDENTIFIED BY 'password';
	FLUSH PRIVILEGES;

	require 'pg'
	require 'socket'
	require 'pp'

	TIMEOUT = 5
	IDLE_CONN_TIMEOUT_MINUTES = 30 # 30 minutes
	#IDLE_CONN_TIMEOUT_MINUTES = 1 # 1 minute for testing
	CURRENT_SESSIONS_QUERY = "select * from stv_sessions where user_name = '%{user}' and starttime < CURRENT_TIMESTAMP - INTERVAL '%{timeout} minutes' order by starttime;"
	KILL_CONNECTION_QUERY = "select pg_terminate_backend(%{pid})"

	#!/bin/bash
	docker rmi $(docker images -q)

	import os
	os.urandom(24)