import groovy.sql.Sql

mysqlDriver         = "com.mysql.jdbc.Driver"
mysqlUrl            = "jdbc:mysql://localhost/IronViper_dbo"
mysqlUser           = ""
mysqlPassword       = ""

postgresqlDriver    = "org.postgresql.Driver"
postgresqlUrl       = "jdbc:postgresql://localhost/irclogger"
postgresqlUser      = ""
postgresqlPassword  = ""


mysql = Sql.newInstance(mysqlUrl, mysqlUser, mysqlPassword, mysqlDriver)
postgresql = Sql.newInstance(postgresqlUrl, postgresqlUser, postgresqlPassword, postgresqlDriver)


println("Inserting channels...")
postgresql.execute("START TRANSACTION")
mysql.eachRow("SELECT * FROM channels", { postgresql.execute("INSERT INTO channels VALUES (?,?,?,?)", [it.id, it.name, it.registrationDate, it.lastActivity])})
postgresql.execute("COMMIT")

println("Inserting users...")
postgresql.execute("START TRANSACTION")
mysql.eachRow("SELECT * FROM users", { postgresql.execute("INSERT INTO users VALUES (?,?,?,?,?,?)", [it.id, it.name, it.host, it.adminLevel, it.lastActivity, it.registrationDate])})
postgresql.execute("COMMIT")


println("Inserting messages...")
postgresql.execute("START TRANSACTION")
mysql.eachRow("SELECT * FROM messages", { postgresql.execute("INSERT INTO messages VALUES (?,?,?,?,?)", [it.id, it.data, it.userId, it.channelId, it.postDate])})
postgresql.execute("COMMIT")