File: test_blob.rb

package info (click to toggle)
ruby-dbd-mysql 0.4.4%2Bgem2deb-2
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 292 kB
  • ctags: 159
  • sloc: ruby: 1,403; sql: 47; makefile: 2
file content (18 lines) | stat: -rw-r--r-- 578 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
 
class TestMySQLBlob < DBDConfig.testbase(:mysql)
    def test_blob_round_trip
        data =(0..255).collect{|n| n.chr}.join("")
        sql = "INSERT INTO blob_test (name, data) VALUES (?, ?)"

        @dbh.do(sql, 'test1', DBI::Binary.new(data)) 
        @dbh.do(sql, 'test2', data) 

        @dbh.prepare(sql) do |sth|
            sth.execute('test3', DBI::Binary.new(data))
            sth.execute('test4', data)
        end

        @dbh.select_all("SELECT name, data FROM blob_test") do |name, fetch_data|
            assert_equal fetch_data, data
        end
    end
end