package db.migration;

import org.flywaydb.core.api.MigrationVersion;
import org.flywaydb.core.api.migration.Context;
import org.flywaydb.core.api.migration.JavaMigration;

import java.sql.Connection;
import java.sql.PreparedStatement;

/**
 * Example of a Java-based migration.
 */
public class Another_Book implements JavaMigration {
    @Override
    public MigrationVersion getVersion() {
        return MigrationVersion.fromVersion("1.6");
    }

    @Override
    public String getDescription() {
        return "java脚本插入";
    }

    @Override
    public Integer getChecksum() {
        return null;
    }

    @Override
    public boolean isUndo() {
        return false;
    }

    @Override
    public boolean canExecuteInTransaction() {
        return false;
    }

    public void migrate(Context context) throws Exception {
        Connection connection = context.getConnection();
        PreparedStatement statement = connection.prepareStatement("INSERT INTO `book`(`title`, `description`) VALUES('最代码', '最代码 www.zuidaima.com 最全面,最专业的源代码分享网站,近万名用户分享超过数万份高质量的java/jquery/bootstrap/html/css源代码');");
        try {
            statement.execute();
        } finally {
            statement.close();
        }
    }
}