Contents

module Forcast
	module Application
		module Database
			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

			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
		end
	end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
forcast-0.0.110	lib/forcast/controllers/application/database.rb