Class: NetMate::Generators::DatabaseGenerator

Inherits:
Object
  • Object
show all
Defined in:
lib/net_mate/database_generator.rb

Instance Method Summary collapse

Constructor Details

#initializeDatabaseGenerator

Returns a new instance of DatabaseGenerator.



7
8
9
10
# File 'lib/net_mate/database_generator.rb', line 7

def initialize
  iterate
  @db_config = Connection.new("#{Dir.pwd}/database.yml").db_config
end

Instance Method Details

#check_and_create_databaseObject



22
23
24
25
26
27
28
29
30
31
32
33
34
35
# File 'lib/net_mate/database_generator.rb', line 22

def check_and_create_database        
  dbh = Connection.new("#{Dir.pwd}/database.yml").connect
  # connect to the MySQL server
  # Create Table in database 
  if dbh.query "SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = '#{@db_config["database"]}'" 
    puts "USING EXISTING DATABASE #{@db_config['database']}" 
  end
rescue
    puts "Creating new Database #{@db_config['database']}"
    create_database()
  ensure
  # disconnect from server
  Connection.disconnect dbh
end

#in_cur_dir?(dir) ⇒ Boolean

Returns:

  • (Boolean)


12
13
14
15
16
17
18
19
20
# File 'lib/net_mate/database_generator.rb', line 12

def in_cur_dir? dir  
   in_cur_dir = []
   Dir.entries('.').each do |entry| 
     if File.directory? File.join('.', entry) and !(entry =='.' || entry == '..')
       in_cur_dir << entry    
     end
   end
   in_cur_dir.include? dir
end