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
|
# File 'lib/sqlite2mysql.rb', line 10
def run(args)
arguments = Arguments.new(args)
puts 'Collecting Sqlite3 Info'
db = SqliteClient.new(arguments.sqlite_db, infer_column_types: arguments.infer_types)
schema = db.build_schema
puts "Creating MySQL DB: #{arguments.mysql_db}"
mysql = MysqlClient.new(
host: arguments.mysql_host,
username: arguments.username,
password: arguments.password,
port: arguments.mysql_port)
mysql.recreate(arguments.mysql_db)
mysql.build_from_schema(schema)
print 'Grab a ☕'
schema.keys.each do |table|
puts "\nInserting data: #{table}"
data = db.get_data(table)
mysql.insert_table(table, data)
end
puts ''
end
|