Following with my previous post, Dry-web-roda part 1, I have decided to create my own small website to keep track of all the things I learn throughout the day.
Yes, I know, another
Today I Learned Website 😓 - til_web, but this time I started with the persistence layer and I wanted to share my experience with you.
First of all, we will need dry-web-roda that will behave as our web application stack. When creating a new project with it, we have two options regarding the architecture point of view of our application:
Umbrella means that our functionality will be divided into sub-apps - for example the public site and the admin site.
Flat is a simpler architecture with a single module for the entire app.
In my app I decided to use the
flat option for simplicity at the beginning, but in the future I plan to move to sub-apps.
Let’s start by creating our new application by running the new command:
$ dry-web-roda new til_web --arch=flat`
which will generate the file structure that we will need.
Today, we will focus mostly on the persistence layer.
To start we have to create our new development database; note that the name will be extracted from the name of the project (in this case
til_web_development). All the information regarding the
ENV is located in the
.env file in the root of the project.
At the moment we only support PostgreSQL (gem pg) as the database storage. If you don’t have it installed, I find it really easy to use the postgres app to reduce the burden.
To create the database we can use some of the commands that the postgres app installed for us:
$ create_db -h localhost til_web_development`
Let’s continue by creating some migrations files to start setting up the schema of our database.
dry-web-roda uses rom-rb as its persistence toolkit, this allows us to have a clean separation of responsibilities and make an app that remains easy to change.
We can use the rake task provided to create a new migration file:
$ bundle exec rake db:create_migration[add_author]
which will create a new file inside our
Rom uses sequel for the database migration engine.
For any aspect related to migrations, please refer to the Sequel documentation
We continue by creating a table and adding some fields to it.
ROM::SQL.migration do change do create_table :tils do primary_key :id column :title, String, null: false column :text, 'text', null: false column :created_at, DateTime, null: false, default: Sequel::CURRENT_TIMESTAMP column :updated_at, DateTime, null: false, default: Sequel::CURRENT_TIMESTAMP end end end
$ bundle exec rake db:migrate will create our new table.
lib/persistence folder we have
Relations are the interface to a particular collection in our data source, which in SQL terms is either a table or a view. We could think of them as our models.
module Persistence module Relations class Tils < ROM::Relation[:sql] schema(:tils) do attribute :id, Types::Serial attribute :title, Types::Strict::String attribute :text, Types::Strict::String end def by_id(id) where(id: id) end end end end
We need to define a schema and some composable, reusable, query methods to return filtered results from our database table. For example
Let’s continue by creating a new command.
module Persistence module Commands class CreateTil < ROM::Commands::Create[:sql] relation :tils register_as :create result :one end end end
Commands are used to write to our database. By default ROM comes with
delete, but you can create your custom ones by following the commands guide.
Finally let’s create our
Repository. Repository works as the main interface to interact with our Database.
For my project I created the folder
repositories inside the
til_web, that would use auto_register from
dry-system to register them in my container.
require 'til_web/repository' module TilWeb module Repositories class Tils < TilWeb::Repository[:tils] def (id) tils.by_id(id).one! end end end end
Our last step is to create some sample data so we can play with it in the
We open our
sample_data.rb file and change it to:
# need the application to be booted in order to access the container. require_relative '../system/boot' require 'faker' def create_til(attrs) # this line is use to access the rom container, that is created at the booting process # of the application. # inside the `system/boot/rom.rb` TilWeb::Container['persistence.rom'].commands[:tils][:create].call(attrs) end 20.times do create_til( title: Faker::Lorem.sentence(4), text: Faker::Lorem.paragraph(5) ) end
To populate the database we use
$ bundle exec rake db:sample_data.
Now accessing the
console, by typing
$ bin/console allows us to check that everything has been stored in the database.
To access the repository we type
TilWeb::Conatiner['repositories.tils'] which will return an instance of
TilWeb::Repositories::Tils with all the dependencies that it needs.
Lastly we can check that there is data in the database by writing
> TilWeb::Container['repositories.tils'] => #<ROM::Struct::Til id=1 title="Illo qui laborum dolores." text="Illum laboriosam adipisci incidunt. Ad aliquam ratione non adipisci quia velit. Veritatis eum minus ut quod mollitia sit. Ea tenetur aliquam fugit mollitia. Rerum ratione et dignissimos a et enim necessitatibus. Animi nesciunt qui rerum voluptatem ipsum atque ad.">
And thats it 🎉.
I know some concepts are quite different than what we are used to work with, and I could keep talking about them, but this post is getting quite long so I will stop here for now.
If you have any thoughts or questions, please share and I’ll be happy to answer in the comments.
Also here are some extra resources regarding rom-rb at it’s benefits.
Thank you for reading this far!