Module: Forcast::Application::Database

Defined in:
lib/forcast/controllers/application/database.rb

Instance Method Summary collapse

Instance Method Details

#contructor_insert_multiples_object_db_sqlite3(array) ⇒ Object 



21
22
23
24
25
26
27
28
29
30
31
 
# File 'lib/forcast/controllers/application/database.rb', line 21

def contructor_insert_multiples_object_db_sqlite3(array)
	str = '('
	array.each do |arr|
		str += "'"+arr.to_s+"'"+',' 
	end
	str += "'"+Time.now.to_s+"'"+','
	str += "'"+Time.now.to_s+"'"+','
	str = str[0...-1]
	str += ')'
	return str
end

#insert_multiples_object_db_sqlite3(model, array) ⇒ Object 



4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 
# File 'lib/forcast/controllers/application/database.rb', line 4

def insert_multiples_object_db_sqlite3(model,array)
	params = array[0].keys.collect { |x| "'"+x.to_s+"'" }.join(', ').to_s+",'created_at','updated_at'"
	values = []
	array.each do |arr|  
		next if arr.nil?
	    str = contructor_insert_multiples_object_db_sqlite3(arr.values)
	    values.push(str)   
	end
	values = values.join(",")
	begin
		ActiveRecord::Base.connection.execute("INSERT INTO #{model} (#{params}) VALUES #{values}")
	rescue

	end
	ActiveRecord::Base.connection.close
end