rom-sql
rom-sql copied to clipboard
rom-rb
SQL support for rom-rb
**Describe the bug** If you paginate over a filtered relation (say, `users.active`) then `rel.total` will return incorrect results since it calls `dataset.unfiltered` which discard all the filtering. **To Reproduce** `user.active.pager.total`...
We store qualified attributes in schemas, that's good. But when you call `.where(name: 'abc')` then symbols from the hash don't get converted to attributes from the schema and thus get...
**Describe the bug** When using string:lower() in a where statement, if the comparison is with an array, the comparison fails. **To Reproduce** Assuming a table "table" with a string field...
**Describe the bug** When using mysql2 as the underlying driver, dealing with a table that has a multi-column primary key, multi_insert tries to get back the primary key from the...
module Edr module Relations class Facilities < ROM::Relation[:sql] schema(:FSEP_DAILY, as: :facilities, infer: true) do attribute :factyp_cd, Types::String.meta(alias: :factype) attribute :locid_cd, Types::String.meta(alias: :locid) attribute :cc_cd, Types::String.meta(alias: :cost_code) end end end when...
Support sharding for SQL databases ## Examples TBD ## Resources Sequel supports sharding: https://github.com/jeremyevans/sequel/blob/master/doc/sharding.rdoc
I have this DB: ``` sqlite3 current_cases.sqlite3 ".schema" CREATE TABLE `current_cases` (`id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `path` varchar(255) NOT NULL UNIQUE, `object` blob NOT NULL); ``` The table...
**Describe the bug** I have a postgres enum called `status_type` with string values, and I used it to set the column type on a column in a table. I want...
First of all, the documentation for ROM is excellent! 👏 (both RDocs and guides) The [Projecting function results](http://rom-rb.org/4.0/learn/sql/queries/#projecting-function-results) section inside the "SQL - Queries" guide shows adding function calls to...
...so that people don't make assumptions/have expectations based on what they know about Sequel. Refs rom-rb/rom#499
