Class: Arel::Visitors::PostgreSQL
- Inherits:
-
Object
- Object
- Arel::Visitors::PostgreSQL
- Defined in:
- lib/pluck_map/visitors/postgresql.rb
Instance Method Summary collapse
- #visit_PluckMap_BuildJsonArray(o, collector) ⇒ Object
- #visit_PluckMap_BuildJsonObject(o, collector) ⇒ Object
- #visit_PluckMap_JsonArrayAggregate(o, collector) ⇒ Object
- #visit_PluckMap_JsonSubqueryAggregate(o, collector) ⇒ Object
Instance Method Details
#visit_PluckMap_BuildJsonArray(o, collector) ⇒ Object
12 13 14 15 16 |
# File 'lib/pluck_map/visitors/postgresql.rb', line 12 def visit_PluckMap_BuildJsonArray(o, collector) collector << "json_build_array(" visit o.args, collector collector << ")" end |
#visit_PluckMap_BuildJsonObject(o, collector) ⇒ Object
6 7 8 9 10 |
# File 'lib/pluck_map/visitors/postgresql.rb', line 6 def visit_PluckMap_BuildJsonObject(o, collector) collector << "json_build_object(" visit o.args, collector collector << ")" end |
#visit_PluckMap_JsonArrayAggregate(o, collector) ⇒ Object
18 19 20 21 22 |
# File 'lib/pluck_map/visitors/postgresql.rb', line 18 def visit_PluckMap_JsonArrayAggregate(o, collector) collector << "json_agg(" visit o.arg, collector collector << ")" end |
#visit_PluckMap_JsonSubqueryAggregate(o, collector) ⇒ Object
24 25 26 27 |
# File 'lib/pluck_map/visitors/postgresql.rb', line 24 def visit_PluckMap_JsonSubqueryAggregate(o, collector) sql = o.scope.select(o.select.as("object")).to_sql collector << "COALESCE((SELECT json_agg(d.object) FROM (#{sql}) AS d), json_build_array())" end |