RubyGems Navigation menu

appquery 0.2.0

Improving introspection and testability of raw SQL queries in Rails This gem improves introspection and testability of raw SQL queries in Rails by: - ...providing a separate query-folder and easy instantiation A query like `AppQuery[:some_query]` is read from app/queries/some_query.sql. - ...providing options for rewriting a query: Query a CTE by replacing the select: query.select_all(select: "select * from some_cte").entries ...similarly, query the end result (i.e. CTE `_`): query.select_all(select: "select count(*) from _").entries - ...providing (custom) casting: AppQuery("select array[1,2]").select_value(cast: true) custom deserializers: AppQuery("select '1' id").select_all(cast: {"id" => ActiveRecord::Type::Integer.new}).entries - ...providing spec-helpers and generators

Gemfile:
=

install:
=

Versions:

  1. 0.2.0 November 13, 2024 (16 KB)
  2. 0.1.0 October 14, 2024 (6.5 KB)

Owners:

Pushed by:

Authors:

  • Gert Goet

SHA 256 checksum:

=

Total downloads 421

For this version 145

Version Released:

License:

MIT

Required Ruby Version: >= 3.1.0

Links: