@Configuration
 @EnableJpaRepositories(
    entityManagerFactoryRef = "orderEntityManager",
    transactionManagerRef = "orderTransactionManager",
    basePackages = {"com.StudentPortal.repository.moodleds"})

public class Moodle_Configuration {


@Bean(name = "orderEntityManager")
@Primary
public LocalContainerEntityManagerFactoryBean entityManagerFactory(){
    JpaVendorAdapter vendorAdapter = new HibernateJpaVendorAdapter();
    LocalContainerEntityManagerFactoryBean em = new LocalContainerEntityManagerFactoryBean();
    em.setDataSource(dataSource());
    em.setPackagesToScan(new String[] {"com.StudentPortal.model.moodleds"});
    em.setJpaVendorAdapter(vendorAdapter);
    em.setJpaProperties(additionalJpaProperties());
    em.setPersistenceUnitName("orders");

    return em;
}

//TODO: Can these be ontained from FlywayDB
Properties additionalJpaProperties(){
    Properties properties = new Properties();
    properties.setProperty("hibernate.hbm2ddl.auto", "update");
    properties.setProperty("hibernate.dialect", "org.hibernate.dialect.MySQLDialect");
    properties.setProperty("hibernate.show_sql", "true");

    return properties;
}

@Bean
public DataSource dataSource(){
    return DataSourceBuilder.create()
            .url("jdbc:mysql://localhost/moodle")
            .driverClassName("com.mysql.jdbc.Driver")
            .username("root")
            .password("pakistan")
            .build();
}

@Bean(name = "orderTransactionManager")
public JpaTransactionManager transactionManager(EntityManagerFactory orderEntityManager){
    JpaTransactionManager transactionManager = new JpaTransactionManager();
    transactionManager.setEntityManagerFactory(orderEntityManager);

    return transactionManager;
}

@Configuration
@EnableJpaRepositories(
    entityManagerFactoryRef = "customerEntityManager",
    transactionManagerRef = "customerTransactionManager",
    basePackages = {"com.StudentPortal.repository.papercutds"})

public class PaperCut_Configuration {



@Bean(name = "customerEntityManager")
public LocalContainerEntityManagerFactoryBean entityManagerFactory(){
    JpaVendorAdapter vendorAdapter = new HibernateJpaVendorAdapter();
    LocalContainerEntityManagerFactoryBean em = new LocalContainerEntityManagerFactoryBean();
    em.setDataSource(dataSource());
    em.setPackagesToScan(new String[] {"com.StudentPortal.model.papercutds"});
    em.setJpaVendorAdapter(vendorAdapter);
    em.setJpaProperties(additionalJpaProperties());
    em.setPersistenceUnitName("customers");

    return em;
}

Properties additionalJpaProperties(){
    Properties properties = new Properties();
    properties.setProperty("hibernate.hbm2ddl.auto", "update");
    properties.setProperty("hibernate.dialect", "org.hibernate.dialect.MySQLDialect");
    properties.setProperty("hibernate.show_sql", "true");

    return properties;
}

@Bean
public DataSource dataSource(){
    return DataSourceBuilder.create()
            .url("jdbc:mysql://localhost/papercut")
            .driverClassName("com.mysql.jdbc.Driver")
            .username("root")
            .password("pakistan")
            .build();
}

@Bean(name = "customerTransactionManager")
public JpaTransactionManager transactionManager(EntityManagerFactory customerEntityManager){
    JpaTransactionManager transactionManager = new JpaTransactionManager();
    transactionManager.setEntityManagerFactory(customerEntityManager);

    return transactionManager;
}