Class: Gct::Database::Data

Inherits:
Object
  • Object
show all
Defined in:
lib/gct/database/data.rb

Instance Method Summary collapse

Constructor Details

#initialize ⇒ Data

Returns a new instance of Data.



6
7
8
9
10
11
 
# File 'lib/gct/database/data.rb', line 6

def initialize
  @host = FileBase.get_config("host")
  @password = FileBase.get_config("password")
  raise "请设置数据库ip地址！".red if @host.nil? 
  raise "请设置数据库密码！".red if @password.nil?
end

Instance Method Details

#query(sql) ⇒ Object 



13
14
15
16
17
18
19
20
21
22
23
24
25
 
# File 'lib/gct/database/data.rb', line 13

def query(sql)
  client = nil
  puts "current sql is 👇👇👇"
  puts sql
  begin
    client = Mysql2::Client.new(:host => @host, :username => "root", :database => "ios_db", :password => @password, :encoding => "utf8")
    client.query(sql)
  rescue => exception
    puts exception
  ensure
    client.close
  end
end