Class: Gzr::Commands::Plan::Failures

Inherits:
Gzr::Command show all
Includes:
Plan
Defined in:
lib/gzr/commands/plan/failures.rb

Instance Method Summary collapse

Methods included from Plan

#create_scheduled_plan, #delete_scheduled_plan, #query_all_scheduled_plans, #query_scheduled_plan, #query_scheduled_plans_for_dashboard, #query_scheduled_plans_for_look, #run_scheduled_plan, #update_scheduled_plan, #upsert_plan_for_dashboard, #upsert_plan_for_look, #upsert_plan_for_obj, #upsert_plans_for_dashboard, #upsert_plans_for_look, #upsert_plans_for_obj

Methods inherited from Gzr::Command

#all_color_collections, #color_collection, #color_palette_lookup!, #create_merge_query, #create_query, #default_color_collection, #field_expressions_eval, #field_names, #find_color_palette_reference, #find_vis_config_reference, #get_auth, #get_user_by_id, #keys_to_keep, #keys_to_keep_internal, #merge_query, #pairs, #query, #render_csv, #rewrite_color_palette!, #run_inline_query, #update_color_palette!

Methods included from Session

#build_connection_hash, #login, #logout_all, #pastel, #read_token_data, #say_error, #say_ok, #say_warning, #sufficient_version?, #token_file, #update_auth, #with_session, #write_token_data

Constructor Details

#initialize(options) ⇒ Failures

Returns a new instance of Failures.



33
34
35
36
 
# File 'lib/gzr/commands/plan/failures.rb', line 33

def initialize(options)
  super()
  @options = options
end

Instance Method Details

#execute(input: $stdin, output: $stdout) ⇒ Object 



38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
 
# File 'lib/gzr/commands/plan/failures.rb', line 38

def execute(input: $stdin, output: $stdout)
  say_warning(@options) if @options[:debug]
  with_session do
    query = {
      :model=>"i__looker",
      :view=>"scheduled_plan",
      :fields=>[
        "scheduled_plan.id",
        "scheduled_plan.name",
        "user.id",
        "user.name",
        "scheduled_job.status",
        "scheduled_job.id",
        "scheduled_job.created_time",
        "scheduled_plan.next_run_time",
        "scheduled_plan.look_id",
        "scheduled_plan.dashboard_id",
        "scheduled_plan.lookml_dashboard_id"
      ],
      :filters=>{
        "scheduled_job_stage.stage": "execute",
        "scheduled_job.created_time": "1 months",
        "scheduled_plan.run_once": "no"
      },
      :sorts=>[
        "scheduled_plan.id",
        "scheduled_job.created_time desc"
      ],
      :limit=>"5000"
    }
    data = run_inline_query(query)
    fields = query[:fields]
    begin
      say_ok "No plans found in history"
      return nil
    end unless data && data.length > 0

    table_hash = Hash.new
    table_hash[:header] = fields unless @options[:plain]
    prior_plan_id = nil
    table_hash[:rows] = data.collect do |row|
      next if row[:'scheduled_plan.id'] == prior_plan_id
      prior_plan_id = row[:'scheduled_plan.id']
      next if row[:'scheduled_job.status'] == 'success'
      fields.collect do |f|
        row.fetch(f.to_sym, nil)
      end
    end.compact
    table = TTY::Table.new(table_hash)
    alignments = fields.collect do |k|
      (k =~ /(id|count)$/) ? :right : :left
    end
    begin
      if @options[:csv] then
        output.puts render_csv(table)
      else
        output.puts table.render(if @options[:plain] then :basic else :ascii end, alignments: alignments, width: @options[:width] || TTY::Screen.width)
      end
    end if table
  end
end