Last active
October 6, 2016 16:45
-
-
Save AMHOL/96c2908e93283eed9e4b5473964a24e1 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
require 'bundler/inline' | |
gemfile(true) do | |
source 'https://rubygems.org' | |
gem 'rom', github: 'rom-rb/rom' | |
gem 'rom-sql', github: 'rom-rb/rom-sql' | |
gem 'rom-repository', github: 'rom-rb/rom-repository' | |
gem 'sqlite3' | |
end | |
config = ROM::Configuration.new(:sql, 'sqlite::memory') | |
gateway = config.gateways[:default] | |
migrations = [] | |
migrations << gateway.migration do | |
change do | |
create_table :users do | |
primary_key :id | |
column :name, String, null: false | |
end | |
end | |
end | |
migrations << gateway.migration do | |
change do | |
create_table :tasks do | |
primary_key :id | |
foreign_key :user_id, :users, null: false, on_delete: :cascade | |
column :title, String | |
end | |
end | |
end | |
migrations << gateway.migration do | |
change do | |
create_table :tags do | |
primary_key :id | |
foreign_key :task_id, :tasks, null: false, on_delete: :cascade | |
column :name, String | |
end | |
end | |
end | |
migrations.each do |migration| | |
migration.apply(gateway.connection, :up) | |
end | |
class Users < ROM::Relation[:sql] | |
def by_id(id) | |
where(id: id) | |
end | |
end | |
class Tasks < ROM::Relation[:sql] | |
def by_id(id) | |
where(id: id) | |
end | |
end | |
class Tags < ROM::Relation[:sql] | |
def by_id(id) | |
where(id: id) | |
end | |
end | |
config.register_relation(Users) | |
config.register_relation(Tasks) | |
config.register_relation(Tags) | |
rom = ROM.container(config) | |
class UserRepo < ROM::Repository[:users] | |
relations :tasks, :tags | |
commands update: :by_id, delete: :by_id | |
def create(graph) | |
command( | |
:create, | |
aggregate(many: tasks.combine_children(many: tags)) | |
).call(graph) | |
end | |
def [](id) | |
users.by_id(id).one | |
end | |
end | |
repo = UserRepo.new(rom) | |
user = repo.create( | |
name: 'Jane', | |
tasks: [{ title: 'Task', tags: [{ name: 'red' }]}] | |
) |
Author
AMHOL
commented
Apr 8, 2016
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment