SequelPgLtree
notice
Sequel ORM postgresql ltree helper inspired by https://github.com/sjke/pg_ltree
Installation
Add this line to your application's Gemfile:
gem 'sequel_pg_ltree'
And then execute:
$ bundle
Or install it yourself as:
$ gem install sequel_pg_ltree
Usage
id | path
----+-------
1 | A
2 | A.B
3 | A.C
4 | A.C.D
5 | A.C.E
6 | A.C.F
7 | A.B.G
class Tree < Sequel::Model(:tree)
plugin :pg_ltree, :column => :path
end
Tree.find(id: 2).root.path # => A
Tree.find(id: 2).parent.path # => A
Tree.where(id: 1).first.children.each do |c|
c[:path]
end # => A.B A.C
TODO
tests should be added