package at.ac.tuwien.sepm.assignment.groupphase.application;

import at.ac.tuwien.sepm.assignment.groupphase.util.JDBCConnectionManager;
import java.io.InputStreamReader;
import java.sql.SQLException;
import org.h2.tools.RunScript;
import org.springframework.core.io.ClassPathResource;

public class PopulateDB {
    public static void main(String[] args) throws SQLException {
        JDBCConnectionManager jdbcConnectionManager = new JDBCConnectionManager();

        RunScript.execute(
                jdbcConnectionManager.getConnection(),
                new InputStreamReader(
                        ClassPathResource.class.getResourceAsStream("/sql/testdata.sql")));

        jdbcConnectionManager.closeConnection();
    }
}