radar / fixedbytm2

Sinatra App for tracking what's been fixed in TextMate 2

This URL has Read+Write access

fixedbytm2 / models.rb
100644 38 lines (32 sloc) 0.659 kb
raw blame history 
1
2
3
4
5
6
7
8
9
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

DB = ENV['RACK_ENV'] == "test" ? Sequel.sqlite(":memory:") : Sequel.sqlite("fixedbytm2.db")
 
unless DB.table_exists?(:users)
	DB.create_table :users do
		primary_key :id
		string :ip
	end
end
 
unless DB.table_exists?(:fixes)
	DB.create_table :fixes do
		primary_key :id
		integer :user_id
		string :text
		datetime :created_at
		integer :votes_count
	end
end
 
unless DB.table_exists?(:fixes_users)
	DB.create_table :fixes_users do
		integer :user_id
		integer :fix_id
	end
end
 
class User < Sequel::Model
  many_to_many :fixes
end
 
class Fix < Sequel::Model
  many_to_many :users
end
 
class FixesUser < Sequel::Model
  many_to_one :user
  many_to_one :fix
end