Sha256: a1b18b6bf1115f9d913e820d7cda922d14f77eaf9882522927c8e58b49ef95f5
Contents?: true
Size: 792 Bytes
Versions: 79
Compression:
Stored size: 792 Bytes
Contents
require("cipherstash-pg")
db = CipherStashPG.connect(:dbname => "test")
db.exec("DROP TABLE IF EXISTS test")
db.exec("CREATE TABLE test (a INTEGER, b BYTEA)")
a = 42
b = [1, 2, 3]
db.exec("INSERT INTO test(a, b) VALUES($1::int, $2::bytea)", [a, { :value => b.pack("N*"), :format => 1 }])
db.exec("SELECT a::int, b::bytea FROM test LIMIT 1", [], 1) do |res|
res.nfields.times do |i|
puts(("Field %d is: %s, a %s (%s) column from table %p" % [i, res.fname(i), db.exec("SELECT format_type($1,$2)", [res.ftype(i), res.fmod(1)]).getvalue(0, 0), res.fformat(i).zero? ? ("string") : ("binary"), res.ftable(i)]))
end
res.each do |row|
puts("a = #{row["a"].inspect}")
puts("a (unpacked) = #{row["a"].unpack("N*").inspect}")
puts("b = #{row["b"].unpack("N*").inspect}")
end
end
Version data entries
79 entries across 79 versions & 1 rubygems