rom-sql
rom-sql copied to clipboard
rom-rb
SQL support for rom-rb
## Describe the bug When using a randomly generated string as a primary key, `create` returns `nil`. ``` [1] pry(main)> repo.create(text: 'blah') I, [2020-12-09T10:48:53.147651 #14228] INFO -- : (0.000085s) INSERT...
Sqlite needs its own `Create` command because `Relation#multi_insert(tuples, return: :primay_key)` actually issues multiple inserts. For full context: https://github.com/rom-rb/rom/issues/680
## Describe the bug Inserting records with blob attributes works using `my_relation.command(:create).call(records)` but it fails with `my_relation.multi_insert(records)`. ## To Reproduce ```ruby require 'logger' require 'securerandom' require 'rom' require 'rom-sql' require...
Current PostgreSQL upsert implementation loops through array of tuples and executes upsert sql command one by one. Are you interested in supporting multi upsert (the same way as you support...
It would be an improvement if we can make use of PostgreSQL schemas in rom-sql. Sequel API supports it using the double underscore special notation. Especially for legacy tables, it...
PostgreSQL has the possibility to handle multiple schemas. Within ROM-SQL it is possible to query the table using `Sequel::SQL::QualifiedIdentifier` object instead of a symbol. The join doesn't recognize `Sequel::SQL::QualifiedIdentifier` so...
Currently gateway options does not support passing migrator options, so if you need to customize it, you need to manually instantiate a connection, then migrator, then pass it as an...
Hi! Here I make use of relation dataset to model different types of a task. In `UserRepo` I want a fetch all users having undone tasks and I want to...
Addresses #366 In the issue @flash-gordon identified root cause as eager evaluation of the pager, but my investigation showed that the problem is different. See what calling `users.page(2)` does: ```ruby...
