Module: Starter::Templates::Sequel

Defined in:
lib/starter/builder/templates/sequel.rb

Instance Method Summary collapse

Instance Method Details

#gemfile ⇒ Object 



82
83
84
85
86
87
88
 
# File 'lib/starter/builder/templates/sequel.rb', line 82

def gemfile
  <<-FILE.strip_heredoc
  # DB stack
  gem 'sequel'
  gem 'pg'
  FILE
end

#initializer ⇒ Object 



10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
 
# File 'lib/starter/builder/templates/sequel.rb', line 10

def initializer
  <<-FILE.strip_heredoc
  # frozen_string_literal: true

  require 'yaml'

  # load Sequel Configuration
  settings = YAML.load_file('config/database.yml')
  DB = Sequel.connect(settings[ENV['RACK_ENV']])

  env = ENV['RACK_ENV'] || 'development'

  logger = if %w[development test].include? env
             log_dir = File.join(Dir.getwd, 'log')
             log_file = File.join(log_dir, 'db.log')
             FileUtils.mkdir(log_dir) unless Dir.exist?(log_dir)
             Logger.new(File.open(log_file, 'a'))
           else
             Logger.new($stdout)
           end

  DB.loggers << logger

  # FIXME: maybe remove it later …
  #   see: https://groups.google.com/forum/#!topic/sequel-talk/QIIv5qoltjs
  Sequel::Model.require_valid_table = false
  Sequel::Model.plugin :force_encoding, 'UTF-8'
  FILE
end

#migration(_klass_name, resource) ⇒ Object 



90
91
92
93
94
95
96
97
98
99
100
101
102
103
 
# File 'lib/starter/builder/templates/sequel.rb', line 90

def migration(_klass_name, resource)
  <<-FILE.strip_heredoc
  Sequel.migration do
    change do
      create_table :#{resource} do
        primary_key :id

        DateTime :created_at
        DateTime :updated_at
      end
    end
  end
  FILE
end

#model_klass ⇒ Object 



6
7
8
 
# File 'lib/starter/builder/templates/sequel.rb', line 6

def model_klass
  'Sequel::Model'
end

#rakefile ⇒ Object 



40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
 
# File 'lib/starter/builder/templates/sequel.rb', line 40

def rakefile
  <<-FILE.strip_heredoc
  # Sequel migration tasks
  namespace :db do
    Sequel.extension(:migration)

    desc "Prints current schema version"
    task version: :connect do
      version = DB.tables.include?(:schema_info) ? DB[:schema_info].first[:version] : 0

      $stdout.print 'Schema Version: '
      $stdout.puts version
    end

    desc 'Run all migrations in db/migrations'
    task migrate: :connect do
      Sequel::Migrator.apply(DB, 'db/migrations')
      Rake::Task['db:version'].execute
    end

    desc "Perform rollback to specified target or full rollback as default"
    task :rollback, [:target] => :connect do |t, args|
      args.with_defaults(:target => 0)

      Sequel::Migrator.run(DB, 'db/migrations', :target => args[:target].to_i)
      Rake::Task['db:version'].execute
    end

    desc "Perform migration reset (full rollback and migration)"
    task reset: :connect do
      Sequel::Migrator.run(DB, 'db/migrations', target: 0)
      Sequel::Migrator.run(DB, 'db/migrations')
      Rake::Task['db:version'].execute
    end

    task connect: :environment do
      require './config/initializers/database'
    end
  end
  FILE
end