require 'ibm_db2'
require 'stringio'
require 'test/unit'
class TestIbmDb2 < Test::Unit::TestCase
def test_046
assert_equal expected, capture {
conn = DB2::connect(db,username,password)
//_GET['EMPNO'] = '000130'
if isset(_GET['EMPNO']) && isset(_GET['FORMAT'])
result = DB2::exec(conn, "select photo_format, picture, length(picture) from emp_photo where photo_format='" . _GET['FORMAT'] . "' and empno='"._GET['EMPNO']."'")
row = DB2::fetch_{result};
if row
// We'll be outputting a
header('Content-type: image/'. row[0])
header('Content-Length: '. row[2])
putsrow[1];
else
putsDB2::error();
end
exit()
else
result = DB2::exec(conn, "select EMPNO, PHOTO_FORMAT, length(PICTURE) from emp_photo");
while (row = DB2::fetch_{result})
printf("%s - %s - %s bytes
",row['0'], row[1], row['0'], row[1], row[2])
puts "\n"
end
end
}
end
end
__END__
000130 - bitmap - 43690 bytes
000130 - gif - 29540 bytes
000130 - xwd - 45800 bytes
000140 - bitmap - 71798 bytes
000140 - gif - 29143 bytes
000140 - xwd - 73908 bytes
000150 - bitmap - 73438 bytes
000150 - gif - 39795 bytes
000150 - xwd - 75547 bytes
000190 - bitmap - 63542 bytes
000190 - gif - 36088 bytes
000190 - xwd - 65650 bytes