require 'rubygems'
require 'sequel'

DB = Sequel.sqlite
DB.create_table? :users do
  String :name, :primary_key => true
  String :pattern
  Integer :score
end

DB.create_table? :links do
  String :id, :primary_key => true
  String :url
  String :user_id
  DateTime :time
  Integer :count, :default => 1
end

class User < Sequel::Model
  unrestrict_primary_key
  one_to_many :links
end

class Link < Sequel::Model
  unrestrict_primary_key
  many_to_one :user
end

user = User.create(:name => 'Evl', :pattern => '^Evl')
user2 = User.create(:name => 'Krossarn', :pattern => '^Krossarn')

link = Link.create(:id => "foo", :url => 'http://foo.com', :user => user)

User.dataset.all.each do |user|
  pattern = Regexp.new(user.pattern, true)

  if pattern.match author
    print "Match: %s" % user
  end
end