Class: DbAgent::DbHandler::MySQL
Instance Attribute Summary
#backup_folder, #config, #data_folder, #migrations_folder, #schema_folder, #superconfig, #viewpoints_folder
Instance Method Summary
collapse
factor, #initialize, #migrate, #ping, #require_viewpoints!, #sequel_db, #sequel_superdb, #system, #wait, #wait_server
Instance Method Details
#backup ⇒ Object
14
15
16
17
|
# File 'lib/db_agent/db_handler/mysql.rb', line 14
def backup
datetime = Time.now.strftime('%Y%m%dT%H%M%S')
shell mysqldump(config[:database], "> #{backup_folder}/backup-#{datetime}.sql")
end
|
#create ⇒ Object
6
7
8
|
# File 'lib/db_agent/db_handler/mysql.rb', line 6
def create
raise
end
|
#drop ⇒ Object
10
11
12
|
# File 'lib/db_agent/db_handler/mysql.rb', line 10
def drop
raise
end
|
#repl ⇒ Object
19
20
21
|
# File 'lib/db_agent/db_handler/mysql.rb', line 19
def repl
shell mysql(config[:database])
end
|
#restore(_t, args) ⇒ Object
41
42
43
44
45
46
47
48
|
# File 'lib/db_agent/db_handler/mysql.rb', line 41
def restore(_t, args)
candidates = backup_folder.glob('*.sql').sort
if args[:pattern] && rx = Regexp.new(args[:pattern])
candidates = candidates.select { |f| f.basename.to_s =~ rx }
end
file = candidates.last
shell mysql(config[:database], '<', file.to_s)
end
|
#spy ⇒ Object
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
|
# File 'lib/db_agent/db_handler/mysql.rb', line 23
def spy
spy_jar = DbAgent._!('vendor').glob('schema*.jar').first
jdbc_jar = DbAgent._!('vendor').glob('mysql*.jar').first
cmd = ""
cmd << %Q{java -jar #{spy_jar}}
cmd << %Q{ -dp #{jdbc_jar} -t mysql}
cmd << %Q{ -host #{config[:host]}}
cmd << %Q{ -u #{config[:user]}}
cmd << %Q{ -p #{config[:password]}}
cmd << %Q{ -db #{config[:database]}}
cmd << %Q{ -port #{config[:port]}}
cmd << %Q{ -s public}
cmd << %Q{ -o #{schema_folder}/spy}
cmd << %Q{ #{ENV['SCHEMA_SPY_ARGS']}} if ENV['SCHEMA_SPY_ARGS']
system(cmd)
system %Q{open #{schema_folder}/spy/index.html}
end
|