emailrhoads

CSV.parse(File.read("irregular_addr.tsv"),
      col_sep: "\t", 
      headers: true, 
    ).map(&:to_h);

emailrhoads

`git rebase -X ours master # Short option`

ours will take the changes from master where conflicts occur

emailrhoads

old_results = Crape::BatchLoanRun.all;

with_attrs = old_results.map do |e|
  e.slice('loan_number') + e.loan_run.attributes
end;

CSV.open("old_cra_results.tsv", "w", write_headers: true, headers: with_attrs.first.keys, col_sep: "\t") do |csv|
  with_attrs.each do |h|
    csv << h.values
  end

emailrhoads

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" |sudo tee  /etc/apt/sources.list.d/pgdg.list
sudo apt update
sudo apt -y install postgresql-client-12
sudo apt -y install postgresql-12 postgresql-client-12
PGDATABASE=$GEMINI_DB PGHOST=$GEMINI_DB_HOST PGUSER=$GEMINI_DB_USER PGPASSWORD=$GEMINI_DB_PASSWORD pg_dump $GEMINI_DB -Ft -f cm_gemini_20210712.tar

emailrhoads

nohup pg_dump -h rds-gemini-dev.pnmac.com -U cmgemini -W -d cm_gemini_dev --no-owner --no-privileges --no-comments --format=custom --file=gemini.sql


pg_dump -h rds-vanna-dev.pnmac.com -U vannadev -W -d vanna_development --no-owner --no-privileges --no-comments --format=custom --file=vanna.sql

nohup pg_dump -h rds-luna-dev.pnmac.com -U lunadev -W -d luna_dev --no-owner --no-privileges --no-comments --format=custom --file=luna.sql

emailrhoads

posting = 'JTR-20220128-1222'

rgen1 = Vanna::RatesheetGenerator.new(
  posting_name: posting,
  posting_datetime: Time.zone.now,
  division_name: 'Broker',
  user: nil
)

rgen2 = Vanna::RatesheetGenerator.new(

emailrhoads

@posting = Marty::Posting.last
client_id = 700106
@bulk_engine = Marty::ScriptSet.new.get_engine('BulkApi')
# from bulk spec
@p = {
      'commitment_days'                       => 15,
      'automated_underwriting_system_type'    => 'DesktopUnderwriter',
      'mortgage_type'                         => 'Conventional',
      'amortization_type'                     => 'Fixed',
      'loan_amortization_period_count'        => 360,

emailrhoads

EXEC cm_inventory_management.dbo.spIMDB_BlotterLoad
 @Debug = 0,
 @EmailList = '[email protected];[email protected]',
 @XMLParam = '
 <poolList>
<pooldetails id="CN4856" agency="GNMA" portid="1" trnno="31334961" compid="1" isoverride="1" iscollapse="0">
	<loans/>
	<investors>

emailrhoads

‎‎​

emailrhoads

data = Netzke::Base.descendants.map do |component|
  next unless component.respond_to?(:marty_permissions)

  # ancestors includes self
  component_permissions = {}
  component.ancestors.each do |ancestor|
    next unless ancestor.respond_to?(:marty_permissions)

    ancestor.marty_permissions.each do |action, roles|