FilesExpand file tree

 master

/

DbTest.java

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

78 lines (74 loc) · 2.99 KB

 master

/

DbTest.java

Copy path

Top

File metadata and controls

• Code
• Blame

78 lines (74 loc) · 2.99 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

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

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

import com.max.test.entities.User;

import com.max.test.interfaces.TestRepo;

import org.hibernate.SessionFactory;

import org.junit.FixMethodOrder;

import org.junit.Test;

import org.junit.runner.RunWith;

import org.junit.runners.MethodSorters;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.ComponentScan;

import org.springframework.context.annotation.Configuration;

import org.springframework.jdbc.datasource.DriverManagerDataSource;

import org.springframework.orm.hibernate5.HibernateTransactionManager;

import org.springframework.orm.hibernate5.LocalSessionFactoryBean;

import org.springframework.test.annotation.Commit;

import org.springframework.test.context.ContextConfiguration;

import org.springframework.test.context.junit4.SpringRunner;

import org.springframework.transaction.annotation.EnableTransactionManagement;

import org.springframework.transaction.annotation.Transactional;

import javax.sql.DataSource;

import java.util.Properties;

//@WebAppConfiguration

@RunWith(SpringRunner.class)

@ContextConfiguration

@FixMethodOrder(MethodSorters.NAME_ASCENDING)

public class DbTest {

@Autowired

TestRepo testRepo;

@Test

@Transactional//auto rollback

@Commit

// @Rollback

// @Sql("/test-schema.sql")

public void dbTest() {

testRepo.saveUser(new User("Max"));

}

@Test

@Transactional

public void dbTest2() {

System.out.println(testRepo.findUser().getName());

}

@Configuration

@ComponentScan("com.max.test")

@EnableTransactionManagement

static class DbTestConfig {

@Bean

public DataSource dataSource() {

DriverManagerDataSource ds = new DriverManagerDataSource();

ds.setDriverClassName("com.mysql.jdbc.Driver");

ds.setUrl("jdbc:mysql://localhost:3306/Lessons");

ds.setUsername("root");

ds.setPassword("1");

return ds;

}

@Bean

public LocalSessionFactoryBean sessionFactory(DataSource dataSource) {

LocalSessionFactoryBean localSessionFactoryBean = new LocalSessionFactoryBean();

localSessionFactoryBean.setDataSource(dataSource);

localSessionFactoryBean.setPackagesToScan(new String[] { "com.max.test.entities" });

Properties props = new Properties();

props.setProperty("hibernate.dialect", "org.hibernate.dialect.MySQL5Dialect");

props.setProperty("hibernate.show_sql", "true");

props.setProperty("hibernate.hbm2ddl.auto", "create-drop");

localSessionFactoryBean.setHibernateProperties(props);

return localSessionFactoryBean;

}

@Bean("myTransaction")

public HibernateTransactionManager txManager(SessionFactory sessionFactory) {

HibernateTransactionManager txManager = new HibernateTransactionManager();

txManager.setSessionFactory(sessionFactory);

return txManager;

}

}

}