web/lib/projects.rb


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
39
40
41
42
43
44
45
46
47
48
49
50
51

# web/lib/projects.rb
class Project

    @@projects = Array.new

    @@attrs = [:id, :json_url, :fetch_date, :fetch_status, :fetch_json, :fetch_result, :data_format, :data_updated, :data_url, :name, :project_url, :doc_url, :icon_url, :description, :contact_name, :contact_email]

    @@attrs.each do |attr|
        attr_reader attr
    end

    # Enumerate all available projects
    def self.each
        @@projects.each do |project|
            yield project
        end
    end

    # Enumerate all available projects
    def self.each_with_index
        @@projects.each_with_index do |project, n|
            yield project, n
        end
    end

    # The number of available sources
    def self.size
        @@projects.size
    end

    def self.init
        db = SQL::Database.new.attach_sources

        db.select("SELECT * FROM projects.projects").execute() do |row|
            @@projects << Project.new(row)
        end
        
        db.close
    end

    def self.get(id)
        @@projects.select{ |p| p.id == id }[0]
    end

    def initialize(row)
        @@attrs.each do |s|
            instance_variable_set("@#{s}", row[s.to_s])
        end
    end

end