Class: MiniSql::Postgres::Connection
- Inherits:
-
Connection
show all
- Defined in:
- lib/mini_sql/postgres/connection.rb,
lib/mini_sql/postgres_jdbc/connection.rb
Defined Under Namespace
Classes: IPAddrCoder, NumericCoder
Instance Attribute Summary collapse
Class Method Summary
collapse
Instance Method Summary
collapse
-
#escape_string(str) ⇒ Object
-
#exec(sql, *params) ⇒ Object
-
#initialize(raw_connection, args = nil) ⇒ Connection
constructor
Initialize a new MiniSql::Postgres::Connection object.
-
#prepared(condition = true) ⇒ Object
-
#query(sql, *params) ⇒ Object
-
#query_array(sql, *params) ⇒ Object
-
#query_decorator(decorator, sql, *params) ⇒ Object
-
#query_each(sql, *params) ⇒ Object
-
#query_each_hash(sql, *params) ⇒ Object
-
#query_hash(sql, *params) ⇒ Object
-
#query_single(sql, *params) ⇒ Object
Returns a flat array containing all results.
Methods inherited from Connection
#build, get, #to_sql
Constructor Details
#initialize(raw_connection, args = nil) ⇒ Connection
Initialize a new MiniSql::Postgres::Connection object
38
39
40
41
42
43
|
# File 'lib/mini_sql/postgres/connection.rb', line 38
def initialize(raw_connection, args = nil)
@raw_connection = raw_connection
@deserializer_cache = (args && args[:deserializer_cache]) || self.class.default_deserializer_cache
@param_encoder = (args && args[:param_encoder]) || InlineParamEncoder.new(self)
@type_map = args && args[:type_map]
end
|
Instance Attribute Details
#deserializer_cache ⇒ Object
Returns the value of attribute deserializer_cache.
6
7
8
|
# File 'lib/mini_sql/postgres/connection.rb', line 6
def deserializer_cache
@deserializer_cache
end
|
#param_encoder ⇒ Object
Returns the value of attribute param_encoder.
6
7
8
|
# File 'lib/mini_sql/postgres/connection.rb', line 6
def param_encoder
@param_encoder
end
|
#raw_connection ⇒ Object
Returns the value of attribute raw_connection.
6
7
8
|
# File 'lib/mini_sql/postgres/connection.rb', line 6
def raw_connection
@raw_connection
end
|
#type_map ⇒ Object
Returns the value of attribute type_map.
45
46
47
|
# File 'lib/mini_sql/postgres/connection.rb', line 45
def type_map
@type_map ||= self.class.type_map(raw_connection)
end
|
Class Method Details
.default_deserializer_cache ⇒ Object
8
9
10
|
# File 'lib/mini_sql/postgres/connection.rb', line 8
def self.default_deserializer_cache
@deserializer_cache ||= DeserializerCache.new
end
|
.type_map(conn) ⇒ Object
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
# File 'lib/mini_sql/postgres/connection.rb', line 12
def self.type_map(conn)
@type_map ||=
begin
map = PG::BasicTypeMapForResults.new(conn)
map.add_coder(MiniSql::Postgres::Coders::NumericCoder.new(name: "numeric", oid: 1700, format: 0))
map.add_coder(MiniSql::Postgres::Coders::IPAddrCoder.new(name: "inet", oid: 869, format: 0))
map.add_coder(MiniSql::Postgres::Coders::IPAddrCoder.new(name: "cidr", oid: 650, format: 0))
map.add_coder(PG::TextDecoder::String.new(name: "tsvector", oid: 3614, format: 0))
map.rm_coder(0, 1114)
if defined? PG::TextDecoder::TimestampUtc
map.add_coder(PG::TextDecoder::TimestampUtc.new(name: "timestamp", oid: 1114, format: 0))
else
map.add_coder(MiniSql::Postgres::Coders::TimestampUtc.new(name: "timestamp", oid: 1114, format: 0))
end
map
end
end
|
Instance Method Details
#escape_string(str) ⇒ Object
195
196
197
|
# File 'lib/mini_sql/postgres/connection.rb', line 195
def escape_string(str)
raw_connection.escape_string(str)
end
|
#exec(sql, *params) ⇒ Object
180
181
182
183
184
185
|
# File 'lib/mini_sql/postgres/connection.rb', line 180
def exec(sql, *params)
result = run(sql, params)
result.cmd_tuples
ensure
result.clear if result
end
|
#prepared(condition = true) ⇒ Object
49
50
51
52
53
54
55
|
# File 'lib/mini_sql/postgres/connection.rb', line 49
def prepared(condition = true)
if condition
@prepared ||= PreparedConnection.new(self)
else
self
end
end
|
#query(sql, *params) ⇒ Object
98
99
100
101
102
103
104
|
# File 'lib/mini_sql/postgres/connection.rb', line 98
def query(sql, *params)
result = run(sql, params)
result.type_map = type_map
deserializer_cache.materialize(result)
ensure
result.clear if result
end
|
#query_array(sql, *params) ⇒ Object
90
91
92
93
94
95
96
|
# File 'lib/mini_sql/postgres/connection.rb', line 90
def query_array(sql, *params)
result = run(sql, params)
result.type_map = type_map
result.values
ensure
result.clear if result
end
|
#query_decorator(decorator, sql, *params) ⇒ Object
172
173
174
175
176
177
178
|
# File 'lib/mini_sql/postgres/connection.rb', line 172
def query_decorator(decorator, sql, *params)
result = run(sql, params)
result.type_map = type_map
deserializer_cache.materialize(result, decorator)
ensure
result.clear if result
end
|
#query_each(sql, *params) ⇒ Object
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
|
# File 'lib/mini_sql/postgres/connection.rb', line 106
def query_each(sql, *params)
raise StandardError, "Please supply a block when calling query_each" if !block_given?
if params && params.length > 0
sql = param_encoder.encode(sql, *params)
end
raw_connection.send_query(sql)
raw_connection.set_single_row_mode
loop do
result = raw_connection.get_result
break if !result
result.check
if result.ntuples == 0
else
materializer ||= deserializer_cache.materializer(result)
result.type_map = type_map
i = 0
while i < result.ntuples
yield materializer.materialize(result, i)
i += 1
end
end
result.clear
end
end
|
#query_each_hash(sql, *params) ⇒ Object
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
|
# File 'lib/mini_sql/postgres/connection.rb', line 139
def query_each_hash(sql, *params)
raise StandardError, "Please supply a block when calling query_each_hash" if !block_given?
if params && params.length > 0
sql = param_encoder.encode(sql, *params)
end
raw_connection.send_query(sql)
raw_connection.set_single_row_mode
loop do
result = raw_connection.get_result
break if !result
result.check
if result.ntuples == 0
else
result.type_map = type_map
i = 0
while i < result.ntuples
yield result[i]
i += 1
end
end
result.clear
end
end
|
#query_hash(sql, *params) ⇒ Object
187
188
189
190
191
192
193
|
# File 'lib/mini_sql/postgres/connection.rb', line 187
def query_hash(sql, *params)
result = run(sql, params)
result.type_map = type_map
result.to_a
ensure
result.clear if result
end
|
#query_single(sql, *params) ⇒ Object
Returns a flat array containing all results. Note, if selecting multiple columns array will be flattened
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
|
# File 'lib/mini_sql/postgres/connection.rb', line 63
def query_single(sql, *params)
result = run(sql, params)
result.type_map = type_map
if result.nfields == 1
result.column_values(0)
else
tuples = result.ntuples
fields = result.nfields
array = []
f = 0
row = 0
while row < tuples
while f < fields
array << result.getvalue(row, f)
f += 1
end
f = 0
row += 1
end
array
end
ensure
result.clear if result
end
|