class G2R::RDBMS::Connection
Public Class Methods
new(options)
click to toggle source
# File lib/graph2relational/rdbms-connection.rb, line 5 def initialize(options) # sequel @db = Sequel.connect(options) end
Public Instance Methods
create_table(table)
click to toggle source
# File lib/graph2relational/rdbms-connection.rb, line 10 def create_table(table) @db.create_table! table.name.to_sym do table.columns.each do |column| # primary key if column.primary_key? primary_key column.name.to_sym # foreign key elsif column.foreign_key? foreign_key column.name.to_sym, column.target_table.to_sym index column.name.to_sym # common column else String column.name.to_sym end end end end
insert_data(table)
click to toggle source
# File lib/graph2relational/rdbms-connection.rb, line 29 def insert_data(table) @db.transaction do table.data.each do |row| @db[table.name.to_sym].insert(row) end end end