schema_inference_spec.rb in rom-sql-1.0.0.beta2

- old
+ new

@@ -52,13 +52,19 @@
 
           conn.create_table :test_inferrence do
             primary_key :id
             String :text, null: false
             Boolean :flag, null: false
+            Time :time
             Date :date
             DateTime :datetime, null: false
+            BigDecimal :bigdec
 
+            if ctx.sqlite?(example)
+              add_constraint(:test_constraint) { char_length(text) > 3 }
+            end
+
             if ctx.postgres?(example)
               Bytea :data
             else
               Blob :data
             end
@@ -71,12 +77,14 @@
         it 'can infer attributes for dataset' do
           expect(schema.to_h).to eql(
             id: ROM::SQL::Types::Serial.meta(name: :id, source: source),
             text: ROM::SQL::Types::String.meta(name: :text, source: source),
             flag: ROM::SQL::Types::Bool.meta(name: :flag, source: source),
+            time: ROM::SQL::Types::Time.optional.meta(name: :time, source: source),
             date: ROM::SQL::Types::Date.optional.meta(name: :date, source: source),
             datetime: ROM::SQL::Types::Time.meta(name: :datetime, source: source),
-            data: ROM::SQL::Types::Blob.optional.meta(name: :data, source: source)
+            data: ROM::SQL::Types::Blob.optional.meta(name: :data, source: source),
+            bigdec: ROM::SQL::Types::Decimal.optional.meta(name: :bigdec, source: source)
           )
         end
       end
     end
 