Sha256: 68fdeab4551ac0cc20fda82462cda9914377109690d22427f58eb87cb3031cec
Contents?: true
Size: 1.55 KB
Versions: 18
Compression:
Stored size: 1.55 KB
Contents
# encoding : UTF-8
require 'test_helper'
class ValueConversionTest < Test::Unit::TestCase
def setup
@connection = Vertica::Connection.new(TEST_CONNECTION_HASH.merge(:row_style => :array))
@connection.query <<-SQL
CREATE TABLE IF NOT EXISTS conversions_table (
"int_field" int,
"string_field" varchar(100),
"date_field" date,
"timestamp_field" timestamp,
"time_field" time,
"interval_field" interval,
"boolean_field" boolean
)
SQL
end
def teardown
@connection.query("DROP TABLE IF EXISTS conversions_table CASCADE;")
@connection.close
end
def test_value_conversions
@connection.query "INSERT INTO conversions_table VALUES (123, 'hello world', '2010-01-01', '2010-01-01 12:00:00', '12:00:00', INTERVAL '1 DAY', TRUE)"
result = @connection.query "SELECT * FROM conversions_table LIMIT 1"
assert_equal result.rows.length, 1
assert_equal [
123,
'hello world',
Date.parse('2010-01-01'),
DateTime.parse('2010-01-01 12:00:00'),
"12:00:00",
"1",
true], result.rows.first
end
def test_nil_conversions
@connection.query "INSERT INTO conversions_table VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL)"
result = @connection.query "SELECT * FROM conversions_table LIMIT 1"
assert_equal result.rows.length, 1
assert_equal [nil, nil, nil, nil, nil, nil, nil], result.rows.first
end
def test_string_encoding
assert_equal 'åßç∂ë', @connection.query("SELECT 'åßç∂ë'").the_value
end
end
Version data entries
18 entries across 18 versions & 1 rubygems