Skip to content

Instantly share code, notes, and snippets.

@savfischer
Last active June 5, 2019 21:26
Show Gist options
  • Save savfischer/d5be560c26d51dbb97d3e2c8ab9048c0 to your computer and use it in GitHub Desktop.
Save savfischer/d5be560c26d51dbb97d3e2c8ab9048c0 to your computer and use it in GitHub Desktop.
Getting all CMBS data from a single Depositor
# run "redis-server" in one terminal window
# run "bundle exec sidekiq" in one terminal window
# run the following commands in rails console
depositor = Depositor.create(name: 'UBS Commercial Mortgage Securitization Corp.', cik: '0001532799')
CmbsData::IssuingEntitiesFromDepositorsWorker.new.perform(depositor.id)
entities = IssuingEntity.includes(:prospectuses).where(prospectuses: { id: nil })
entities.each do |issuing_entity|
CmbsData::ProspectusHuntWorker.perform_async(issuing_entity.id)
end
CmbsData::PopulateAnnexAOneTablesWorker.perform_async(true)
PDocStat.where(loan_tables: nil).each do |p_doc_stat|
table_count = p_doc_stat.prospectus.annex_a_one_tables.count
p_doc_stat.update(loan_tables: table_count)
end
issuing_entities = IssuingEntity.includes(:loans).where(loans: { id: nil })
if issuing_entities.present?
ie = issuing_entities.first
prospectus = ie.latest_full_prospectus
if prospectus.present?
CmbsData::BaseUnitsWorker.perform_async(prospectus.id, true)
end
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment