Class: ChineseRegionsRails::DB

Inherits:
Object
  • Object
show all
Defined in:
lib/chinese_regions_rails/db.rb

Class Method Summary collapse

Class Method Details

.db ⇒ Object 



24
25
26
27
28
 
# File 'lib/chinese_regions_rails/db.rb', line 24

def db
  db_file = File.expand_path("../../regions.db", __FILE__)
  db = SQLite3::Database.new db_file
  db
end

.query_regions ⇒ Object 



8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
 
# File 'lib/chinese_regions_rails/db.rb', line 8

def query_regions
  db.execute("select * from regions") do |row|
    hash = {code: row[0],
            parent_code: row[1],
            name: row[2],
            alias: row[3],
            pinyin: row[4],
            abbr: row[5],
            zip: row[6],
            level: row[7]
    }

    yield(hash) if block_given?
  end
end