rom-sql
rom-sql copied to clipboard
rom-rb
SQL support for rom-rb
Use case: table with a compound key relation (`:user_id` & `:event_id`) **Table Descriptions** ``` sql /* user */ +------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default |...
_From @johnnoone on June 9, 2017 10:49_ I've defined 2 relations, one with a custom view (to filter some columns), and an association to that view. When I use `relation.combine_children`,...
_From @mrship on January 30, 2017 12:39_ Using a changeset to create a record is failing for me when using Oracle, because (I think) you don't get the result of...
Heya folks, I was working on `hanami/model` support for [one-to-one associations](https://github.com/hanami/model/blob/has_one/lib/hanami/model/associations/has_one.rb) when I noticed that when I associate a new record the old one is kept in the database. What...
## Describe the bug It I try to use the projection dsl in combination with #exlude... ```ruby mentions .select { integer::count(issue_id).as(:unit_mention_count) } .where(unit_id: 3, read: false) .exclude { user_ids.any(1) }...
## Describe the bug When using custom write type and read type to modify the data before inserting / after fetching data from the database, the `create` command passes original...
## Describe the bug Queries with virtual columns will drop or overwrite information when used as part of a `union` query. This is a regression as a result of #334....
- Merging relations with virtual columns the qualified projection (added in #334) causes the virtual column to be moved into the outer select. This means that column will always be...
## Describe the bug We can't make the code for joining relations across different databases. ## To Reproduce Provide detailed steps to reproduce, **an executable script would be best**. 1....
## Describe the bug Following code ```ruby filter_type_id = "test" states .where { filter_type_ids.any(filter_type_id) | filter_type_ids.is(nil) } .order(:order) ``` produces following sql: ```sql SELECT "states"."id", "states"."name", "states"."order", "states"."filter_type_ids" FROM "states"...