Sha256: 4267b42404cb640fe1437bbd76394f881e5cfe546282325fc2b5f943deff468f
Contents?: true
Size: 1.62 KB
Versions: 16
Compression:
Stored size: 1.62 KB
Contents
RSpec.describe 'ROM::SQL::Schema::MysqlInferrer', :mysql do
include_context 'database setup'
before do
inferrable_relations.concat %i(test_inferrence)
end
before do
conn.create_table :test_inferrence do
tinyint :tiny
mediumint :medium
bigint :big
datetime :created_at
column :date_and_time, 'datetime(0)'
column :time_with_ms, 'datetime(3)'
timestamp :unix_time_usec
column :unix_time_sec, 'timestamp(0) null'
boolean :flag, null: false
end
end
before do
conf.relation(:test_inferrence) do
schema(infer: true)
end
end
let(:schema) { container.relations[:test_inferrence].schema }
let(:source) { container.relations[:test_inferrence].name }
it 'can infer attributes for dataset' do
expect(schema.to_h).
to eql(
tiny: ROM::SQL::Types::Int.optional.meta(name: :tiny, source: source),
medium: ROM::SQL::Types::Int.optional.meta(name: :medium, source: source),
big: ROM::SQL::Types::Int.optional.meta(name: :big, source: source),
created_at: ROM::SQL::Types::Time.optional.meta(name: :created_at, source: source),
date_and_time: ROM::SQL::Types::Time.optional.meta(name: :date_and_time, source: source),
time_with_ms: ROM::SQL::Types::Time.optional.meta(name: :time_with_ms, source: source),
unix_time_usec: ROM::SQL::Types::Time.meta(name: :unix_time_usec, source: source),
unix_time_sec: ROM::SQL::Types::Time.optional.meta(name: :unix_time_sec, source: source),
flag: ROM::SQL::Types::Bool.meta(name: :flag, source: source)
)
end
end
Version data entries
16 entries across 16 versions & 1 rubygems