Sha256: 966f0597e434b6dba61622b590f9953695f3e5df5d6ebd6b975c243e2f0ae5e6
Contents?: true
Size: 1.59 KB
Versions: 7
Compression:
Stored size: 1.59 KB
Contents
require 'digest/sha1'
require 'sequel'
Sequel::Model.plugin(:schema)
Sequel::Model.db =
if defined?(RUBY_ENGINE) && RUBY_ENGINE == 'jruby'
require 'jdbc/sqlite3'
Sequel.connect("jdbc:sqlite::memory:")
else
require 'sqlite3'
Sequel.sqlite(":memory:")
end
Sequel.extension :migration
migration = Sequel.migration do
up do
create_table :accounts do
primary_key :id
String :name
String :surname
String :email
String :crypted_password
String :role
end
create_table :categories do
primary_key :id
foreign_key :account_id
String :name
end
end
down do
drop_table :accounts
end
end
migration.apply(Sequel::Model.db, :up)
# Fake Category Model
class Category < Sequel::Model
many_to_one :account
end
# Fake Account Model
class Account < Sequel::Model
attr_accessor :password, :password_confirmation
one_to_many :categories
def self.admin; first(:role => "admin"); end
def self.editor; first(:role => "editor"); end
##
# Replace ActiveRecord method.
#
def self.find_by_id(id)
self[id] rescue nil
end
end
# We build some fake accounts
admin = Account.create(:name => "DAddYE", :role => "admin", :email => "d.dagostino@lipsiasoft.com",
:password => "some", :password_confirmation => "some")
editor = Account.create(:name => "Dexter", :role => "editor", :email => "editor@lipsiasoft.com",
:password => "some", :password_confirmation => "some")
%w(News Press HowTo).each do |c|
admin.add_category(:name => c)
editor.add_category(:name => c)
end
Version data entries
7 entries across 7 versions & 2 rubygems