Class: Kasket::QueryParser

Inherits:
Object
  • Object
show all
Defined in:
lib/kasket/query_parser.rb

Constant Summary collapse

AND =

Examples: SELECT * FROM ‘users` WHERE (`users`.`id` = 2) SELECT * FROM `users` WHERE (`users`.`id` = 2) LIMIT 1 ’SELECT * FROM 'posts' WHERE ('posts'.'id' = 574019247) ‘

/\s+AND\s+/i
VALUE =

Matches: 123, ?, ‘123’, ‘12”3’

/'?(\d+|\?|(?:(?:[^']|''|\\')*))'?/

Instance Method Summary collapse

Constructor Details

#initialize(model_class) ⇒ QueryParser

Returns a new instance of QueryParser.



11
12
13
14
15
16
 
# File 'lib/kasket/query_parser.rb', line 11

def initialize(model_class)
  @model_class = model_class
  @supported_query_pattern = /^select \* from (?:`|")#{@model_class.table_name}(?:`|") where \((.*)\)(|\s+limit 1)\s*$/i
  @table_and_column_pattern = /(?:(?:`|")?#{@model_class.table_name}(?:`|")?\.)?(?:`|")?(\w+)(?:`|")?/ # Matches: `users`.id, `users`.`id`, users.id, id
  @key_eq_value_pattern = /^[\(\s]*#{@table_and_column_pattern}\s+=\s+#{VALUE}[\)\s]*$/ # Matches: KEY = VALUE, (KEY = VALUE), ()(KEY = VALUE))
end

Instance Method Details

#parse(sql) ⇒ Object 



18
19
20
21
22
23
24
25
26
27
28
29
 
# File 'lib/kasket/query_parser.rb', line 18

def parse(sql)
  if match = @supported_query_pattern.match(sql)
    query = Hash.new
    query[:attributes] = sorted_attribute_value_pairs(match[1])
    return nil if query[:attributes].nil?
    query[:index] = query[:attributes].map(&:first)
    query[:limit] = match[2].blank? ? nil : 1
    query[:key] = @model_class.kasket_key_for(query[:attributes])
    query[:key] << '/first' if query[:limit] == 1 && !query[:index].include?(:id)
    query
  end
end