Class: MrMurano::Postgresql

Inherits:
PlatformService show all
Defined in:
lib/MrMurano/commands/postgresql.rb

Constant Summary

Constants included from Verbose

Verbose::TABULARIZE_DATA_FORMAT_ERROR

Constants included from SolutionId

SolutionId::INVALID_API_ID, SolutionId::UNEXPECTED_TYPE_OR_ERROR_MSG

Constants included from AccountBase

AccountBase::LOGIN_ADVICE, AccountBase::LOGIN_NOTICE

Instance Attribute Summary

Attributes included from SolutionId

#api_id, #sid, #valid_api_id

Instance Method Summary collapse

Methods inherited from PlatformService

#call_platform, must_return_nonnil_nonerror!

Methods inherited from ServiceConfig

#call, #create, #fetch, #info, #list, #logs, #must_id!, #remove, #scid, #scid_for_name, #search

Methods inherited from SolutionBase

#==, #endpoint, #search

Methods included from SyncUpDown

#config_vars_decode, #config_vars_encode, #debug_print_localitems, #diff_download, #diff_item_write, #docmp, #download, #ignore?, #ignoring, #list, #localitems, #locallist, #locallist_add_item, #locallist_complain_missing, #locallist_mark_seen, #location, #match, #remove, #remove_or_clear, #removelocal, #resolve_config_var_usage!, #resurrect_undeletables, #searchFor, #syncdown_after, #syncdown_before, #synckey, #syncup_after, #syncup_before, #to_remote_items, #tolocalname, #tolocalpath, #update_mtime, #upload

Methods included from Verbose

ask_yes_no, #ask_yes_no, #assert, assert, cmd_confirm_delete!, #cmd_confirm_delete!, debug, #debug, dump_file_json, dump_file_plain, dump_file_yaml, #dump_output_file, #error, error, #error_file_format!, fancy_ticks, #fancy_ticks, #load_file_json, #load_file_plain, #load_file_yaml, #load_input_file, outf, #outf, #outformat_engine, #pluralize?, pluralize?, #prepare_hash_csv, #read_hashf!, #tabularize, tabularize, verbose, #verbose, warning, #warning, #whirly_interject, whirly_interject, #whirly_linger, whirly_linger, #whirly_msg, whirly_msg, #whirly_pause, whirly_pause, #whirly_start, whirly_start, #whirly_stop, whirly_stop, #whirly_unpause, whirly_unpause

Methods included from SyncCore

#debug_selected, #dodiff, #dodiff_build_cmd, #dodiff_cull_tempfile_paths, #dodiff_do_diff, #dodiff_download_remote, #dodiff_flexible, #dodiff_header_aware, #dodiff_local_to_tempfile, #dodiff_prepare_local_and_diff, #dodiff_resolve_localname, #dodiff_tempfile_paths, #filter_solution, #init_mods_and_chgs_arrs, #item_dirty_set_status, #item_local_there_merged, #item_merged_diff_status, #item_merged_set_status, #item_select_selected!, #items_classify_and_find_duplicates, #items_cull_clashes!, #items_lists, #items_log_duplicates, #items_log_duplicates_there_local, #items_mods_and_chgs!, #items_new_and_old!, #select_selected!, #sort_by_name, #status, #sync_update_progress, #syncable_validate_api_id, #syncdown, #syncdown_item, #syncup, #syncup_item

Methods included from SyncAllowed

#download_item_allowed, #remove_item_allowed, #removelocal_item_allowed, #sync_item_allowed, #upload_item_allowed

Methods included from SolutionId

#affirm_valid, #api_id?, #endpoint, #init_api_id!, #valid_api_id?

Methods included from AccountBase

#add_headers, #ask_for_password!, #ask_for_user!, #cfg_clear_user_and_business, #credentials_reset, #get, #invalidate_token, #login_info, #logout, #must_prompt_if_logged_off!, #token, #token_reset, #verify_cfg_auth!, #verify_cfg_auth_persist, #verify_cfg_auth_scheme!, #verify_cfg_auth_ttl, #verify_set, warn_configfile_env_maybe

Methods included from Http

#add_headers, #curldebug, curldebug_after, curldebug_elapsed, curldebug_log, #delete, #endpoint, #get, #host, #http, #http_reset, #isJSON, #json_opts, #patch, #post, #postf, #put, #showHttpError, #user, #workit, #workit_response

Constructor Details

#initialize(api_id = nil) ⇒ Postgresql

Returns a new instance of Postgresql.



30
31
32
33
34
35
 
# File 'lib/MrMurano/commands/postgresql.rb', line 30

def initialize(api_id=nil)
  # FIXME/2017-07-03: What soln types have PSQLs?
  @solntype = 'application.id'
  super
  @service_name = 'postgresql'
end

Instance Method Details

#must_determine_current_version! ⇒ Object 



49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
 
# File 'lib/MrMurano/commands/postgresql.rb', line 49

def must_determine_current_version!
  ret = queries %(
    CREATE SCHEMA IF NOT EXISTS __murano_cli__;
    CREATE TABLE IF NOT EXISTS __murano_cli__.migrate_version (version integer);
    SELECT version FROM __murano_cli__.migrate_version ORDER BY version DESC;
  ).gsub(/^\s+/, '')
  if ret.nil?
    MrMurano::Verbose.error 'Unknown Postgresql failure determining version'
    exit 1
  elsif !ret[:error].nil?
    pp ret
    exit 1
  end
  MrMurano::Verbose.debug("CREATE/SELECT: #{ret}")
  current_version = (
    ((((ret[:result] || []).last || {})[:rows] || []).first || []).first || 0
  ).to_i
  current_version
end

#queries(query, params = nil) ⇒ Object 



43
44
45
46
47
 
# File 'lib/MrMurano/commands/postgresql.rb', line 43

def queries(query, params=nil)
  aqr = { sql: query }
  aqr[:parameters] = params unless params.nil?
  call_platform(:queries, aqr)
end

#query(query, params = nil) ⇒ Object 



37
38
39
40
41
 
# File 'lib/MrMurano/commands/postgresql.rb', line 37

def query(query, params=nil)
  aqr = { sql: query }
  aqr[:parameters] = params unless params.nil?
  call_platform(:query, aqr)
end