Adding a minimal "connection-test function" example

ged · ged · commit ae9bb3b55fc0 · 2012-06-17T09:18:00.000-07:00
diff --git a/Manifest.txt b/Manifest.txt
@@ -28,6 +28,7 @@ lib/pg/result.rb
 sample/async_api.rb
 sample/async_copyto.rb
 sample/async_mixed.rb
+sample/check_conn.rb
 sample/copyfrom.rb
 sample/copyto.rb
 sample/cursor.rb
diff --git a/sample/check_conn.rb b/sample/check_conn.rb
@@ -0,0 +1,21 @@
+#!/usr/bin/env ruby
+# vim: set nosta noet ts=4 sw=4:
+# encoding: utf-8
+
+require 'pg'
+
+# This is a minimal example of a function that can test an existing PG::Connection and
+# reset it if necessary.
+
+def check_connection( conn )
+	begin
+		conn.exec( "SELECT 1" )
+	rescue PG::Error => err
+		$stderr.puts "%p while testing connection: %s" % [ err.class, err.message ]
+		conn.reset
+	end
+end
+
+conn = PG.connect( dbname: 'test' )
+check_connection( conn )
+
