Class: Sequel::Oracle::Dataset
Constant Summary
Constants inherited
from Dataset
Dataset::AND_SEPARATOR, Dataset::BOOL_FALSE, Dataset::BOOL_TRUE, Dataset::COLUMN_CHANGE_OPTS, Dataset::COLUMN_REF_RE1, Dataset::COLUMN_REF_RE2, Dataset::COLUMN_REF_RE3, Dataset::COMMA_SEPARATOR, Dataset::COUNT_OF_ALL_AS_COUNT, Dataset::DATASET_CLASSES, Dataset::DATE_FORMAT, Dataset::JOIN_TYPES, Dataset::MUTATION_METHODS, Dataset::NOTIMPL_MSG, Dataset::NULL, Dataset::N_ARITY_OPERATORS, Dataset::QUESTION_MARK, Dataset::STOCK_COUNT_OPTS, Dataset::STOCK_TRANSFORMS, Dataset::TIMESTAMP_FORMAT, Dataset::TWO_ARITY_OPERATORS, Dataset::WILDCARD
Instance Attribute Summary
Attributes inherited from Dataset
#db, #opts, #quote_identifiers, #row_proc
Instance Method Summary
collapse
Methods inherited from Dataset
#<<, #[], #[]=, #all, #and, #as, #avg, #clone, #column_all_sql, #column_expr_sql, #columns, #columns!, #complex_expression_sql, #count, #create_or_replace_view, #create_view, dataset_classes, #def_mutation_method, def_mutation_method, #delete_sql, #each, #each_page, #except, #exclude, #exists, #filter, #first, #first_source, #from, #from_self, #function_sql, #get, #graph, #grep, #group, #group_and_count, #having, inherited, #initialize, #insert_multiple, #insert_sql, #inspect, #intersect, #interval, #invert, #join_table, #last, #limit, #map, #max, #min, #model_classes, #multi_insert, #multi_insert_sql, #naked, #or, #order, #order_more, #paginate, #polymorphic_key, #print, #qualified_column_ref_sql, #query, #quote_identifier, #quote_identifiers?, #quoted_identifier, #range, #reverse_order, #select, #select_all, #select_more, #set, #set_graph_aliases, #set_model, #single_record, #single_value, #subscript_sql, #sum, #symbol_to_column_ref, #table_exists?, #to_csv, #to_hash, #transform, #transform_load, #transform_save, #unfiltered, #union, #uniq, #unordered, #update_sql
Methods included from Enumerable
#send_each
Instance Method Details
#delete(opts = nil) ⇒ Object
110
111
112
|
# File 'lib/sequel_core/adapters/oracle.rb', line 110
def delete(opts = nil)
@db.do delete_sql(opts)
end
|
#empty? ⇒ Boolean
114
115
116
|
# File 'lib/sequel_core/adapters/oracle.rb', line 114
def empty?
db[:dual].where(exists).get(1) == nil
end
|
#fetch_rows(sql, &block) ⇒ Object
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
|
# File 'lib/sequel_core/adapters/oracle.rb', line 85
def fetch_rows(sql, &block)
@db.synchronize do
cursor = @db.execute sql
begin
@columns = cursor.get_col_names.map {|c| c.downcase.to_sym}
while r = cursor.fetch
row = {}
r.each_with_index {|v, i| row[columns[i]] = v unless columns[i] == :raw_rnum_}
yield row
end
ensure
cursor.close
end
end
self
end
|
#insert(*values) ⇒ Object
102
103
104
|
# File 'lib/sequel_core/adapters/oracle.rb', line 102
def insert(*values)
@db.do insert_sql(*values)
end
|
#literal(v) ⇒ Object
76
77
78
79
80
81
82
83
|
# File 'lib/sequel_core/adapters/oracle.rb', line 76
def literal(v)
case v
when OraDate
literal(Time.local(*v.to_a))
else
super
end
end
|
#select_sql(opts = nil) ⇒ Object
Also known as:
sql
Formats a SELECT statement using the given options and the dataset options.
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
|
# File 'lib/sequel_core/adapters/oracle.rb', line 120
def select_sql(opts = nil)
opts = opts ? @opts.merge(opts) : @opts
if sql = opts[:sql]
return sql
end
columns = opts[:select]
select_columns = columns ? column_list(columns) : WILDCARD
sql = opts[:distinct] ? \
"SELECT DISTINCT #{select_columns}" : \
"SELECT #{select_columns}"
if opts[:from]
sql << " FROM #{source_list(opts[:from])}"
end
if join = opts[:join]
sql << join
end
if where = opts[:where]
sql << " WHERE #{literal(where)}"
end
if group = opts[:group]
sql << " GROUP BY #{column_list(group)}"
end
if having = opts[:having]
sql << " HAVING #{literal(having)}"
end
if union = opts[:union]
sql << (opts[:union_all] ? \
" UNION ALL #{union.sql}" : " UNION #{union.sql}")
elsif intersect = opts[:intersect]
sql << (opts[:intersect_all] ? \
" INTERSECT ALL #{intersect.sql}" : " INTERSECT #{intersect.sql}")
elsif except = opts[:except]
sql << (opts[:except_all] ? \
" EXCEPT ALL #{except.sql}" : " EXCEPT #{except.sql}")
end
if order = opts[:order]
sql << " ORDER BY #{column_list(order)}"
end
if limit = opts[:limit]
if (offset = opts[:offset]) && (offset > 0)
sql = "SELECT * FROM (SELECT raw_sql_.*, ROWNUM raw_rnum_ FROM(#{sql}) raw_sql_ WHERE ROWNUM <= #{limit + offset}) WHERE raw_rnum_ > #{offset}"
else
sql = "SELECT * FROM (#{sql}) WHERE ROWNUM <= #{limit}"
end
end
sql
end
|
#update(*args, &block) ⇒ Object
106
107
108
|
# File 'lib/sequel_core/adapters/oracle.rb', line 106
def update(*args, &block)
@db.do update_sql(*args, &block)
end
|