mirror of
https://github.com/narkoz/hacker-scripts
synced 2025-08-22 10:27:11 +00:00
40 lines
1.0 KiB
Ruby
Executable File
40 lines
1.0 KiB
Ruby
Executable File
#!/usr/bin/env ruby
|
|
|
|
require 'dotenv'
|
|
require 'gmail'
|
|
|
|
Dotenv.load
|
|
|
|
GMAIL_USERNAME = ENV['GMAIL_USERNAME']
|
|
GMAIL_PASSWORD = ENV['GMAIL_PASSWORD']
|
|
|
|
GMAIL = Gmail.connect(GMAIL_USERNAME, GMAIL_PASSWORD)
|
|
KUMARS_EMAIL = 'kumar.a@example.com'
|
|
|
|
DB_NAME_REGEX = /\S+_staging/
|
|
KEYWORDS_REGEX = /sorry|help|wrong/i
|
|
|
|
def create_reply(subject)
|
|
GMAIL.compose do
|
|
to KUMARS_EMAIL
|
|
subject "RE: #{subject}"
|
|
body "No problem. I've fixed it. \n\n Please be careful next time."
|
|
end
|
|
end
|
|
|
|
GMAIL.inbox.find(:unread, from: KUMARS_EMAIL).each do |email|
|
|
if email.body.raw_source[KEYWORDS_REGEX] && (db_name = email.body.raw_source[DB_NAME_REGEX])
|
|
backup_file = "/home/backups/databases/#{db_name}-" + (Date.today - 1).strftime('%Y%m%d') + '.gz'
|
|
abort 'ERROR: Backup file not found' unless File.exist?(backup_file)
|
|
|
|
# Restore DB
|
|
`gunzip -c #{backup_file} | psql #{db_name}`
|
|
|
|
# Mark as read, add label and reply
|
|
email.read!
|
|
email.label('Database fixes')
|
|
reply = create_reply(email.subject)
|
|
GMAIL.deliver(reply)
|
|
end
|
|
end
|