Class: Pluto::CreateDb

Inherits:
ActiveRecord::Migration
  • Object
show all
Defined in:
lib/pluto/schema.rb

Instance Method Summary collapse

Instance Method Details

#down ⇒ Object

Raises:

  • (ActiveRecord::IrreversibleMigration) 


103
104
105
 
# File 'lib/pluto/schema.rb', line 103

def down
  raise ActiveRecord::IrreversibleMigration
end

#up ⇒ Object 



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
39
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
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
 
# File 'lib/pluto/schema.rb', line 6

def up
  create_table :sites do |t|
    t.string   :title,     :null => false    # e.g Planet Ruby, Planet JavaScript, etc.
    t.string   :key,       :null => false    # e.g. ruby, js, etc.
    t.datetime :fetched   #  last fetched/checked date -- make not null ??

    ############
    # filters (site-wide)
    t.string   :includes  # regex
    t.string   :excludes  # regex


    t.timestamps  # created_at, updated_at
  end

  create_table :subscriptions do |t|   # has_many join table (sites/feeds)
    t.references :site, :null => false
    t.references :feed, :null => false
    t.timestamps
  end

  create_table :feeds do |t|
    t.string  :title        # user supplied title
    t.string  :auto_title   # "fallback" - auto(fill) title from feed

    t.string  :title2        # user supplied title2
    t.string  :auto_title2   # "fallback" - auto(fill) title2 from feed e.g. subtitle (atom)

    t.string  :url          # user supplied site url
    t.string  :auto_url     # "fallback" - auto(fill) url from feed

    t.string  :feed_url       # user supplied feed url
    t.string  :auto_feed_url  # "fallback" - auto discovery feed url from (site) url

    t.text    :summary    # e.g. description (rss)

    t.string  :generator   # feed generator (e.g. wordpress, etc.)  from feed
    
    t.datetime :published  # from feed published(atom)+ pubDate(rss)
    t.datetime :built      # from feed lastBuiltDate(rss)
    t.datetime :touched    # from feed updated(atom)

    ############
    # filters
    t.string   :includes  # regex
    t.string   :excludes  # regex
    # todo: add generic filter list e.g. t.string :filters  (comma,pipe or space separated method names?)

    # -- our own (meta) fields
    t.datetime :last_published # cache last (latest) published for items

    t.string  :key,      :null => false
    t.string  :format      # e.g. atom (1.0), rss 2.0, rss 0.7 etc.

    t.integer  :http_code   # last http status code e.g. 200,404,etc.
    t.string   :http_etag    # last http header etag
    ## note: save last-modified header as text (not datetime) - pass through as is
    t.string   :http_last_modified   # last http header last-modified - note: save header as plain text!!! pass along in next request as-is
    t.string   :http_server    # last http server header if present

    t.string   :md5       # md5 hash of body
    t.text     :body      # last http response body (complete feed!)

    t.datetime :fetched    # last fetched/checked date

    t.timestamps   # created_at, updated_at
  end

  create_table :items do |t|
    t.string   :title   # todo: add some :null => false ??
    t.string   :guid
    t.string   :url
    t.text     :summary  # e.g. description (rss), summary (atom)
    t.text     :content
    
    t.datetime :published   # from feed (published)  + pubDate(rss)
    t.datetime :touched     # from feed updated (atom)

    ## todo: add :last_updated_at ??  (NOTE: updated_at already take by auto-timestamps)
    t.references :feed, :null => false

    t.datetime :fetched   # last fetched/check date
    t.timestamps   # created_at, updated_at

    ## t.string   :author
    ## todo: add author/authors, category/categories
  end

  create_table :actions do |t|
    t.string   :title                # e.g. new site, new subscription, update feeds, etc.
    t.string   :object            # todo: find better names for action attribs ??
    t.string   :object_type
    t.timestamps
  end
  
end