Module | Sequel::SQL::QualifyingMethods |
In: |
lib/sequel/sql.rb
|
Includes a qualify and [] methods that create QualifiedIdentifiers, used for qualifying column names with a table or table names with a schema, and the * method for returning all columns in the identifier if no arguments are given.
If no arguments are given, return an SQL::ColumnAll:
Sequel[:a].* # a.*
# File lib/sequel/sql.rb, line 899 899: def *(ce=(arg=false;nil)) 900: if arg == false 901: Sequel::SQL::ColumnAll.new(self) 902: else 903: super(ce) 904: end 905: end
Qualify the receiver with the given qualifier (table for column/schema for table).
Sequel[:table][:column] # "table"."column" Sequel[:schema][:table] # "schema"."table" Sequel[:schema][:table][:column] # "schema"."table"."column"
# File lib/sequel/sql.rb, line 921 921: def [](identifier) 922: QualifiedIdentifier.new(self, identifier) 923: end
Qualify the receiver with the given qualifier (table for column/schema for table).
Sequel[:column].qualify(:table) # "table"."column" Sequel[:table].qualify(:schema) # "schema"."table" Sequel.qualify(:table, :column).qualify(:schema) # "schema"."table"."column"
# File lib/sequel/sql.rb, line 912 912: def qualify(qualifier) 913: QualifiedIdentifier.new(qualifier, self) 914: end