Contents

# frozen_string_literal: true

require 'bundler/setup'
require 'polyphony/postgres'

DB = PG.connect(
  host:     '/tmp',
  user:     'reality',
  password: nil,
  dbname:   'reality',
  sslmode:  'require'
)

def perform(error)
  puts '*' * 40
  DB.transaction do
    res = DB.query('select 1 as test')
    puts "result: #{res.to_a}"
    raise 'hello' if error

    DB.transaction do
      res = DB.query('select 2 as test')
      puts "result: #{res.to_a}"
    end
  end
rescue StandardError => e
  puts "error: #{e.inspect}"
end

perform(true)
perform(false)

Version data entries

11 entries across 11 versions & 1 rubygems

Version	Path
polyphony-0.30	examples/interfaces/pg_transaction.rb
polyphony-0.29	examples/interfaces/pg_transaction.rb
polyphony-0.28	examples/interfaces/pg_transaction.rb
polyphony-0.27	examples/interfaces/pg_transaction.rb
polyphony-0.26	examples/interfaces/pg_transaction.rb
polyphony-0.25	examples/interfaces/pg_transaction.rb
polyphony-0.24	examples/interfaces/pg_transaction.rb
polyphony-0.23	examples/interfaces/pg_transaction.rb
polyphony-0.22	examples/interfaces/pg_transaction.rb
polyphony-0.21	examples/interfaces/pg_transaction.rb
polyphony-0.20	examples/interfaces/pg_transaction.rb