Module: Microframe::ORM::InstanceQueries

Includes:
QueryUtils
Defined in:
lib/microframe/orm/instance_queries.rb

Instance Method Summary collapse

Methods included from QueryUtils

#build_query, #execute, #parse_result_to_objects, #process_from, #process_generic, #process_limit, #process_order, #process_query, #process_select, #process_where, #query_processes

Instance Method Details

#destroy ⇒ Object 



20
21
22
23
24
 
# File 'lib/microframe/orm/instance_queries.rb', line 20

def destroy
  query = "DELETE FROM #{table_name} WHERE id =#{id}"
  execute(query)
  self
end

#save ⇒ Object 



5
6
7
8
9
10
11
12
13
 
# File 'lib/microframe/orm/instance_queries.rb', line 5

def save
  queryset = {}
  models_columns.each { |col| queryset[col] = send(col) }
  keys = queryset.keys.join(", ")
  values = queryset.values
  placeholders = Array.new(values.size, "?").join(", ")
  result = Connection.connection.execute("REPLACE INTO #{table_name} (#{keys}) VALUES (#{placeholders})", values)
  result ? self.class.last : self
end

#update(options = {}) ⇒ Object 



15
16
17
18
 
# File 'lib/microframe/orm/instance_queries.rb', line 15

def update(options = {})
  options.each{ |col, val| send("#{col}=", val) }
  save
end