Module: Sequel::SQL::CastMethods

Included in:
Dataset, LiteralString, Blob, ComplexExpression, GenericExpression, String, Symbol
Defined in:
lib/sequel/sql.rb

Overview

Holds methods that are used to cast objects to different SQL types.

Instance Method Summary (collapse)

Instance Method Details

- (Object) cast(sql_type)

Cast the reciever to the given SQL type. You can specify a ruby class as a type, and it is handled similarly to using a database independent type in the schema methods.

Sequel.function(:func).cast(:integer) # CAST(func() AS integer)
Sequel.function(:func).cast(String) # CAST(func() AS varchar(255))


676
677
678
# File 'lib/sequel/sql.rb', line 676

def cast(sql_type)
  Cast.new(self, sql_type)
end

- (Object) cast_numeric(sql_type = nil)

Cast the reciever to the given SQL type (or the database's default Integer type if none given), and return the result as a NumericExpression, so you can use the bitwise operators on the result.

Sequel.function(:func).cast_numeric # CAST(func() AS integer)
Sequel.function(:func).cast_numeric(Float) # CAST(func() AS double precision)


686
687
688
# File 'lib/sequel/sql.rb', line 686

def cast_numeric(sql_type = nil)
  Cast.new(self, sql_type || Integer).sql_number
end

- (Object) cast_string(sql_type = nil)

Cast the reciever to the given SQL type (or the database's default String type if none given), and return the result as a StringExpression, so you can use + directly on the result for SQL string concatenation.

Sequel.function(:func).cast_string # CAST(func() AS varchar(255))
Sequel.function(:func).cast_string(:text) # CAST(func() AS text)


696
697
698
# File 'lib/sequel/sql.rb', line 696

def cast_string(sql_type = nil)
  Cast.new(self, sql_type || String).sql_string
end