class Knjappserver::Log_access

Public Instance Methods

data_array(data_id) click to toggle source
# File lib/include/class_log_access.rb, line 22
def data_array(data_id)
        sql = "
                SELECT
                        value_value.value AS value
                
                FROM
                        Log_data_link AS value_links,
                        Log_data_value AS value_value
                
                WHERE
                        value_links.data_id = '#{data_id}' AND
                        value_value.id = value_links.value_id
                
                ORDER BY
                        key_links.no
        "
        
        arr = []
        q_array = db.query(sql)
        while d_array = q_array.fetch
                arr << d_array[:value]
        end
        
        return arr
end
data_hash(type) click to toggle source
# File lib/include/class_log_access.rb, line 48
def data_hash(type)
        col_keys_id = "#{type}_keys_data_id".to_sym
        col_values_id = "#{type}_values_data_id".to_sym
        
        keys_id = self[col_keys_id]
        values_id = self[col_values_id]
        
        keys_data_obj = ob.get(:Log_data, keys_id)
        values_data_obj = ob.get(:Log_data, values_id)
        
        sql = "
                SELECT
                        key_value.value AS `key`,
                        value_value.value AS value
                
                FROM
                        Log_data_link AS key_links,
                        Log_data_link AS value_links,
                        Log_data_value AS key_value,
                        Log_data_value AS value_value
                
                WHERE
                        key_links.data_id = '#{keys_id}' AND
                        value_links.data_id = '#{values_id}' AND
                        key_links.no = value_links.no AND
                        key_value.id = key_links.value_id AND
                        value_value.id = value_links.value_id
                
                ORDER BY
                        key_links.no
        "
        
        hash = {}
        q_hash = db.query(sql)
        while d_hash = q_hash.fetch
                hash[d_hash[:key].to_s] = d_hash[:value]
        end
        
        return hash
end
get() click to toggle source
# File lib/include/class_log_access.rb, line 2
def get
        return data_hash("get")
end
ips() click to toggle source
# File lib/include/class_log_access.rb, line 18
def ips
        return data_array(self[:ip_data_id])
end
meta() click to toggle source
# File lib/include/class_log_access.rb, line 10
def meta
        return data_hash("meta")
end
post() click to toggle source
# File lib/include/class_log_access.rb, line 6
def post
        return data_hash("post")
end