class Risu::Models::Reference

Reference Model

Public Class Methods

apple_sa() click to toggle source
# File lib/risu/models/reference.rb, line 215
def apple_sa
        where(:reference_name => "apple-sa").select('DISTINCT value')
end
bid() click to toggle source

Queries all unique BID

# File lib/risu/models/reference.rb, line 83
def bid
        where(:reference_name => "bid").select('DISTINCT value')
end
cert() click to toggle source

Queries all unique cert refs

# File lib/risu/models/reference.rb, line 113
def cert
        where(:reference_name => "cert").select('DISTINCT value')
end
cert_cc() click to toggle source
# File lib/risu/models/reference.rb, line 209
def cert_cc
        where(:reference_name => "cert-cc").select('DISTINCT value')
end
cert_vu() click to toggle source
# File lib/risu/models/reference.rb, line 197
def cert_vu
        where(:reference_name => "cert-vu").select('DISTINCT value')
end
cisco_bug_id() click to toggle source
# File lib/risu/models/reference.rb, line 185
def cisco_bug_id
        where(:reference_name => "cisco-bug-id").select('DISTINCT value')
end
cisco_sa() click to toggle source
# File lib/risu/models/reference.rb, line 173
def cisco_sa
        where(:reference_name => "cisco-sa").select('DISTINCT value')
end
cisco_sr() click to toggle source
# File lib/risu/models/reference.rb, line 191
def cisco_sr
        where(:reference_name => "cisco-sr").select('DISTINCT value')
end
cpe() click to toggle source

Queries all unique CPE

# File lib/risu/models/reference.rb, line 77
def cpe
        where(:reference_name => "cpe").select('DISTINCT value')
end
cve() click to toggle source

Queries all unique CVEs

# File lib/risu/models/reference.rb, line 71
def cve
        where(:reference_name => "cve").select('DISTINCT value')
end
cwe() click to toggle source

Queries all unique cwe refs

# File lib/risu/models/reference.rb, line 155
def cwe
        where(:reference_name => "cwe").select('DISTINCT value')
end
dsa() click to toggle source

Queries all unique dsa refs

# File lib/risu/models/reference.rb, line 143
def dsa
        where(:reference_name => "dsa").select('DISTINCT value')
end
edbid() click to toggle source

Queries all unique edbid refs

# File lib/risu/models/reference.rb, line 119
def edbid
        where(:reference_name => "edb-id").select('DISTINCT value')
end
iava() click to toggle source

Queries all unique IAVA

# File lib/risu/models/reference.rb, line 95
def iava
        where(:reference_name => "iava").select('DISTINCT value')
end
iavb() click to toggle source
# File lib/risu/models/reference.rb, line 161
def iavb
        where(:reference_name => "iavb").select('DISTINCT value')
end
iavt() click to toggle source
# File lib/risu/models/reference.rb, line 167
def iavt
        where(:reference_name => "iavt").select('DISTINCT value')
end
ics_alert() click to toggle source
# File lib/risu/models/reference.rb, line 179
def ics_alert
        where(:reference_name => "ics-alert").select('DISTINCT value')
end
icsa() click to toggle source
# File lib/risu/models/reference.rb, line 221
def icsa
        where(:reference_name => "icsa").select('DISTINCT value')
end
msft() click to toggle source

Queries all unique MSFT

# File lib/risu/models/reference.rb, line 101
def msft
        where(:reference_name => "msft").select('DISTINCT value')
end
msvr() click to toggle source
# File lib/risu/models/reference.rb, line 227
def msvr
        where(:reference_name => "msvr").select('DISTINCT value')
end
osvdb() click to toggle source

Queries all unique OSvdb

# File lib/risu/models/reference.rb, line 107
def osvdb
        where(:reference_name => "osvdb").select('DISTINCT value')
end
owasp() click to toggle source

Queries all unique owasp refs

# File lib/risu/models/reference.rb, line 149
def owasp
        where(:reference_name => "owasp").select('DISTINCT value')
end
reference_string() click to toggle source

Generates a full string of all the references

@TODO automate references to parser references to see if all are covered

@returns [String] of all the references with in-line formatting for
direct output to the report
# File lib/risu/models/reference.rb, line 36
def reference_string
        reference_names = ["cve", "cpe", "bid", "see_also", "iava", "msft",
                "osvdb", "cert", "edbid", "rhsa", "secunia", "suse", "dsa",
                "owasp", "cwe", "iavb", "iavt", "cisco_sa", "ics_alert",
                "cisco_bug_id", "cisco_sr", "cert_vu", "vmsa", "cert_cc",
                "msvr", "apple_sa", "icsa"
        ]

        ref_string = ""

        reference_names.each do |type|
                ref = reference_string_by self.send(type)

                ref_string << "<b>#{type}</b>: #{ref}\n" if ref.length != 0
        end

        ref_string
end
reference_string_by(type) click to toggle source

Generates a string of all the references of the specified type

@param type Result of a [Reference] model reference accessors

@return [String] containing all references of type comma separated

# File lib/risu/models/reference.rb, line 60
def reference_string_by type
        rstring = []
        type.each do |ref|
                rstring << ref.value
        end

        rstring.join(", ")
end
rhsa() click to toggle source

Queries all unique rhsa refs

# File lib/risu/models/reference.rb, line 125
def rhsa
        where(:reference_name => "rhsa").select('DISTINCT value')
end
secunia() click to toggle source

Queries all unique secunia refs

# File lib/risu/models/reference.rb, line 131
def secunia
        where(:reference_name => "secunia").select('DISTINCT value')
end
see_also() click to toggle source

Queries all unique see_also

# File lib/risu/models/reference.rb, line 89
def see_also
        where(:reference_name => "see_also").select('DISTINCT value')
end
suse() click to toggle source

Queries all unique suse refs

# File lib/risu/models/reference.rb, line 137
def suse
        where(:reference_name => "suse").select('DISTINCT value')
end
usn() click to toggle source
# File lib/risu/models/reference.rb, line 233
def usn
        where(:reference_name => "usn").select('DISTINCT value')
end
vmsa() click to toggle source
# File lib/risu/models/reference.rb, line 203
def vmsa
        where(:reference_name => "vmsa").select('DISTINCT value')
end