Sequel foreign keys

fk.rb

# https://github.com/jeremyevans/sequel/issues/830

require 'sequel'
require 'logger'

DB = Sequel.sqlite

logger = Logger.new($stdout)
DB.loggers << logger

DB.create_table :channels do
  String      :id, :primary_key => true
  String      :title, :null => false
end

class Channel < Sequel::Model
  unrestrict_primary_key
  one_to_many :videos
end

DB.create_table :videos do
  primary_key :id
  String      :title, :null => false
  foreign_key :channel_id, :channels, type: String
end

class Video < Sequel::Model
  many_to_one :channel
end

channel = Channel.create(id: 'testId', title: 'testTitle')
channel.add_video(title: 'testTitle')

logger.info "Channel id: #{channel.id}"
logger.info "Video channel id: #{Video.first.channel_id}"