SELECT
*,
CONCAT(CONCAT('KILL ', id), ';') AS KILL_SQL,
CONCAT(CONCAT('CALL mysql.rds_kill(', id), ');') AS KILL_SQL_FOR_RDS
FROM
INFORMATION_SCHEMA.PROCESSLIST
WHERE
db = 'your_db'
AND info LIKE '%probrem_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
linters: | |
LineLength: | |
enabled: false | |
SpaceInsideHashAttributes: | |
enabled: false | |
ViewLength: | |
enabled: false | |
InlineStyles: | |
enabled: false | |
ClassesBeforeIds: |
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
require "octokit" | |
require "json" | |
class GithubPullRequest | |
def initialize(access_token: ENV["GITHUB_TOKEN"], repository:) | |
@client = Octokit::Client.new(access_token: access_token) | |
@repository = repository | |
end | |
def update_description!(rspec_examples:, pull_request_number:, ci_build_url:) |
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
# gem install rspec | |
# rspec calculator.rb | |
require "rspec" | |
class Calculator | |
def sum(value1, value2) | |
value1 + value2 | |
end | |
end |
git checkout -b topic_branch
git commit --allow-empty -m 'Make a pull request'
git push --set-upstream origin topic_branch
hub pull-request -b develop
hub browse -- pull/{pull_request_id}
# urlが変更されるまで待つ
# 登録ボタンをクリックして登録処理が完了すると画面遷移する場合などで画面遷移するまで待つようにできる
# 例) wait_for_url_change { click_on '登録' }
# 登録して画面遷移が終わるまでwait_for_url_changeでsleepされる
def wait_for_url_change(timeout_sec = 3)
current_path = page.current_path
yield
%cat /usr/local/bin/rubymine
#!/bin/sh
open -na /Applications/RubyMine.app --args "$@"
chmod +x/usr/local/bin/rubymine
NewerOlder