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
85
86
87
88
89
90
91
92
93
94
95
96
97
|
package com.healthmarketscience.jackcess.impl;
import java.io.File;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import com.healthmarketscience.jackcess.ColumnBuilder;
import com.healthmarketscience.jackcess.DataType;
import com.healthmarketscience.jackcess.Database;
import com.healthmarketscience.jackcess.DatabaseBuilder;
import com.healthmarketscience.jackcess.Table;
import com.healthmarketscience.jackcess.TableBuilder;
import junit.framework.TestCase;
import static com.healthmarketscience.jackcess.TestUtil.*;
import static com.healthmarketscience.jackcess.impl.JetFormatTest.*;
/**
* @author Dan Rollo
* Date: Mar 5, 2010
* Time: 2:21:22 PM
*/
public final class UsageMapTest extends TestCase {
public void testRead() throws Exception {
for (final TestDB testDB : SUPPORTED_DBS_TEST) {
final int expectedFirstPage;
final int expectedLastPage;
final Database.FileFormat expectedFileFormat = testDB.getExpectedFileFormat();
if (Database.FileFormat.V2000.equals(expectedFileFormat)) {
expectedFirstPage = 743;
expectedLastPage = 767;
} else if (Database.FileFormat.V2003.equals(expectedFileFormat)) {
expectedFirstPage = 16;
expectedLastPage = 799;
} else if (Database.FileFormat.V2007.equals(expectedFileFormat)) {
expectedFirstPage = 94;
expectedLastPage = 511;
} else if (Database.FileFormat.V2010.equals(expectedFileFormat)) {
expectedFirstPage = 109;
expectedLastPage = 511;
} else {
throw new IllegalAccessException("Unknown file format: " + expectedFileFormat);
}
checkUsageMapRead(testDB.getFile(), expectedFirstPage, expectedLastPage);
}
}
private static void checkUsageMapRead(
final File dbFile, final int expectedFirstPage, final int expectedLastPage)
throws IOException {
final Database db = DatabaseBuilder.open(dbFile);
final UsageMap usageMap = UsageMap.read((DatabaseImpl)db,
PageChannel.PAGE_GLOBAL_USAGE_MAP,
PageChannel.ROW_GLOBAL_USAGE_MAP,
true);
assertEquals("Unexpected FirstPageNumber.", expectedFirstPage,
usageMap.getFirstPageNumber());
assertEquals("Unexpected LastPageNumber.", expectedLastPage,
usageMap.getLastPageNumber());
}
public void testGobalReferenceUsageMap() throws Exception
{
Database db = openCopy(
Database.FileFormat.V2000,
new File("src/test/data/V2000/testRefGlobalV2000.mdb"));
Table t = new TableBuilder("Test2")
.addColumn(new ColumnBuilder("id", DataType.LONG))
.addColumn(new ColumnBuilder("data1", DataType.TEXT))
.addColumn(new ColumnBuilder("data2", DataType.TEXT))
.toTable(db);
((DatabaseImpl)db).getPageChannel().startWrite();
try {
List<Object[]> rows = new ArrayList<Object[]>();
for(int i = 0; i < 300000; ++i) {
String s1 = "r" + i + "-" + createString(100);
String s2 = "r" + i + "-" + createString(200);
rows.add(new Object[]{i, s1, s2});
if((i % 2000) == 0) {
t.addRows(rows);
rows.clear();
}
}
} finally {
((DatabaseImpl)db).getPageChannel().finishWrite();
}
db.close();
}
}
|
