Skip to content

Instantly share code, notes, and snippets.

@ykessler

ykessler/render_insert_smoke.rb

Last active June 1, 2026 00:52
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ykessler/da0e67e75f9a9e62e1cfcced78c1862f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ykessler/da0e67e75f9a9e62e1cfcced78c1862f to your computer and use it in GitHub Desktop.
Download ZIP
temporary render postgres smoke
Raw
render_insert_smoke.rb
require 'pg'
doc = ENV.fetch('DOC_ID')
conn = PG.connect(ENV.fetch('DATABASE_URL').sub(/^postgis/, 'postgres'))
conn.exec_params("INSERT INTO _backfill_acris_legals_unit (document_id,bbl,old_address,new_unit,new_address) VALUES ($1,0,'render marker','X','render marker APT X') ON CONFLICT DO NOTHING", [doc])
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment