-
Notifications
You must be signed in to change notification settings - Fork 6
/
FlywayFixtureExample.java
84 lines (75 loc) · 3.7 KB
/
FlywayFixtureExample.java
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
79
80
81
82
83
84
/*
* Copyright © 2013, Groupon, Inc
* All rights reserved.
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions are met:
* * Redistributions of source code must retain the above copyright
* notice, this list of conditions and the following disclaimer.
* * Redistributions in binary form must reproduce the above copyright
* notice, this list of conditions and the following disclaimer in the
* documentation and/or other materials provided with the distribution.
* * Neither the name of the <organization> nor the
* names of its contributors may be used to endorse or promote products
* derived from this software without specific prior written permission.
*
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
* ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
* WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
* DISCLAIMED. IN NO EVENT SHALL <COPYRIGHT HOLDER> BE LIABLE FOR ANY
* DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
* (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
* LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
* ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
* SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/
package com.groupon.mysql.testing;
import org.junit.ClassRule;
import org.junit.Rule;
import org.junit.Test;
import org.skife.jdbi.v2.DBI;
import org.skife.jdbi.v2.Handle;
import org.skife.jdbi.v2.tweak.HandleCallback;
import org.skife.jdbi.v2.util.StringMapper;
import javax.sql.DataSource;
import java.util.List;
import static org.assertj.core.api.Assertions.assertThat;
public class FlywayFixtureExample
{
@ClassRule public static MySQLRule mysql = MySQLRule.global();
/**
* See src/test/resources/db/ for migration and fixture code. In this case the convention for defining fixtures
* is to take the schema version they are defined at and use the version [schema-version].[fixture-version]
* in order to ensure uniqueness across versions between migration and fixture code. If flyway were being used
* to maintain schemas outside unit tests, the db/migration resources would probably be in main/resources/
* instead of test/resources, but the fixture code would remain under test/resources.
*/
@Rule public MySQLRule.Fixtures fixtures = mysql.createFixtures(new FlywayFixture("db/migration", "db/fixtures"));
@Test
public void testFixturesEstablished() throws Exception
{
DataSource ds = mysql.getDataSource();
List<String> rs = new DBI(ds).withHandle(new HandleCallback<List<String>>()
{
@Override
public List<String> withHandle(final Handle handle) throws Exception
{
return handle.createQuery("select name from something order by id")
.map(StringMapper.FIRST)
.list();
}
});
assertThat(rs).containsExactly("Gene", "Brian");
}
@Test
public void testJustTestAgainToShowThingsGetDroppedAndAllAtThat() throws Exception
{
try (Handle handle = DBI.open(mysql.getDataSource())) {
List<String> rs = handle.createQuery("select name from something order by id desc")
.map(StringMapper.FIRST)
.list();
assertThat(rs).containsExactly("Brian", "Gene");
}
}
}