Class: AppCommand::Fix

Inherits:
Convoy::ActionCommand::Base
  • Object
show all
Defined in:
lib/routes/fix.rb

Instance Method Summary collapse

Instance Method Details

#clear_sessions ⇒ Object

Fixes problem with Login (when sessions get screwed up)

Returns:

  • void



37
38
39
40
41
42
43
44
45
46
47
48
 
# File 'lib/routes/fix.rb', line 37

def clear_sessions

    App::Terminal::info('Attempting to clear all sessions from DB..')
    App::Terminal::output('DELETE FROM _session.session;')
    @mysql_ses.query('DELETE FROM session;')
    App::Terminal::output('DELETE FROM app.session_to_licence_type;')
    @mysql_app.query('DELETE FROM session_to_licence_type;')
    App::Terminal::output('DELETE FROM app.sessions;')
    @mysql_app.query('DELETE FROM sessions;')
    puts

end

#execute ⇒ Object 



5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 
# File 'lib/routes/fix.rb', line 5

def execute

    @opts = command_options
    @args = arguments

    @mysql_app = App::MySQL::vm
    @mysql_ses = App::MySQL::vm('_session')

    @sql_index_start = nil
    @sql_index_end = nil

    opts_validate
    opts_routing

end

#opts_routing ⇒ Object 



25
26
27
28
29
30
31
32
 
# File 'lib/routes/fix.rb', line 25

def opts_routing

    clear_sessions if @opts[:login_sessions]
    sql_mode if @opts[:sql_mode]

    system('bp f -h') if App::UtilsRoutes::flags_set(@opts) == 0

end

#opts_validate ⇒ Object 



21
22
23
 
# File 'lib/routes/fix.rb', line 21

def opts_validate

end

#sql_mode ⇒ Object

Fix SQL error – STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION

Returns:

  • void



52
53
54
55
56
 
# File 'lib/routes/fix.rb', line 52

def sql_mode

    App::SSH::run_script_on_remote('vm', 'fix-sql-mode.sh')

end