Class: Surfer::Connection

Inherits:
Object
  • Object
show all
Defined in:
lib/surfer/connection.rb

Instance Method Summary collapse

Instance Method Details

#close_connection ⇒ Object 



43
44
45
46
47
48
49
 
# File 'lib/surfer/connection.rb', line 43

def close_connection
	
	if @conn
		@conn.disconnect
		puts "Connection closed"
	end
end

#create_connection ⇒ Object 



5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
 
# File 'lib/surfer/connection.rb', line 5

def create_connection
	file = ReadDbFile.new.read_file
		# puts (file['development']['adapter']).emtpy?
		if (!(file['development']['adapter']).nil?)
			driver = (file['development']['adapter']).capitalize!
			dbase = file['development']['database']
			uname = file['development']['username'] 
			password = file['development']['password']
		else
			abort ( " Please Complete the database.yml file first " )
		end
	begin			
		@conn = DBI.connect( "DBI:#{driver}:#{dbase}", "#{uname}", "#{password}" )                        
	rescue DBI::DatabaseError => e  
		if (e.err == 1049)
			@conq= DBI.connect( "DBI:#{driver}:test", "#{uname}", "#{password}" )
			@conq.do( " create database #{dbase}; " )
			@conq.commit()
			@conq.disconnect if @conq
			@conq= DBI.connect( "DBI:#{driver}:#{dbase}", "#{uname}", "#{password}" )
			# @conq.disconnect if @conq
			puts " #{dbase} Created successfully "
			connection = @conq
			return connection
			# abort ("please create database #{dbase} manually before creating model")
			
		else
			puts " Error code: #{e.err} "
			puts " Error message: #{e.errstr}"

		end
	else
		puts " Connection stablished successfully. "
		connection = @conn
		return connection	    			
	end
end