FilesExpand file tree

 master

/

test.java

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

159 lines (129 loc) · 4.14 KB

 master

/

test.java

Copy path

Top

File metadata and controls

• Code
• Blame

159 lines (129 loc) · 4.14 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

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

package simpledb;

import java.io.*;

import java.util.BitSet;

public class test {

public static void main(String[] argv) {

//test_1();

//grpAgg_test();

//byte_stuff();

}

public static void byte_stuff()

{

byte[] bytes = new byte[1];

Byte value = Byte.parseByte("00000010",2);

bytes[0] = value;

System.out.println(value.toString());

int i = 0;

int which_byte = i/8;

int position = i%8;

byte get_byte = bytes[which_byte];

int get_bit = (get_byte >> position) & 1;

//System.out.println(get_bit);

//get_byte = get_byte & ~((byte) 0 << position);

//bytes[which_byte] = (byte) (bytes[which_byte] & ~( (byte) 1 << position));

bytes[which_byte] = (byte) (bytes[which_byte] | ( (byte) 1 << position));

Byte b = (Byte) bytes[which_byte];

System.out.println(b.toString());

}

public static void grpAgg_test()

{

// construct a 3-column table schema

Type types[] = new Type[]{ Type.INT_TYPE, Type.INT_TYPE, Type.INT_TYPE };

String names[] = new String[]{ "s_id", "s_zip", "s_num_courses" };

TupleDesc descriptor = new TupleDesc(types, names);

// create the table, associate it with some_data_file.dat

// and tell the catalog about the schema of this table.

HeapFile table1 = new HeapFile(new File("students.dat"), descriptor);

Database.getCatalog().addTable(table1, "students");

TransactionId tid = new TransactionId();

SeqScan f = new SeqScan(tid, table1.getId());

System.out.println("Input file:");

try {

// and run it

f.open();

while (f.hasNext())

{

Tuple tup = f.next();

System.out.print(" tuple-was: "+ tup.toString());

}

f.close();

Database.getBufferPool().transactionComplete(tid);

}

catch (Exception e)

{

System.out.println ("Exception : " + e);

}

//try String Aggregator

StringAggregator agg = new StringAggregator(1, Type.INT_TYPE, 2, Aggregator.Op.COUNT);

try{

f.open();

while (f.hasNext())

{

agg.mergeTupleIntoGroup(f.next());

}

}

catch (Exception e)

{

System.out.println ("Exception : " + e);

}

DbIterator it = agg.iterator();

System.out.println("Group by Zip:");

try

{

// and run it

it.open();

while (it.hasNext())

{

Tuple tup = it.next();

System.out.print(" tuple-was: "+ tup.toString());

}

it.close();

}

catch (Exception e)

{

System.out.println ("Exception : " + e);

}

}

public static void test_1()

{

// construct a 3-column table schema

Type types[] = new Type[]{ Type.INT_TYPE, Type.INT_TYPE, Type.INT_TYPE };

String names[] = new String[]{ "s_id", "s_age", "s_gpa" };

TupleDesc descriptor = new TupleDesc(types, names);

System.out.println("TD = " + descriptor.toString());

// create the table, associate it with some_data_file.dat

// and tell the catalog about the schema of this table.

HeapFile table1 = new HeapFile(new File("students.dat"), descriptor);

TupleDesc my_descriptor = table1.getTupleDesc();

//System.out.println("(still) TD = " + my_descriptor.toString());

System.out.println("HeapFile num_pages = " + table1.numPages());

System.out.println("---------");

//System.out.println("Before first call to Database");

//int num = Database.getCatalog().tables.size();

//System.out.println(num);

Database.getCatalog().addTable(table1, "students");

//num = Database.getCatalog().tables.size();

// construct the query: we use a simple SeqScan, which spoonfeeds

// tuples via its iterator.

//TransactionId tid0 = new TransactionId();

TransactionId tid = new TransactionId();

//System.out.println("tid is: "+ tid.toString());

//System.out.println("tid is: "+ tid.getId());

int id = table1.getId();

//System.out.println("id is: "+ id);

SeqScan f = new SeqScan(tid, table1.getId());

try {

// and run it

f.open();

while (f.hasNext()) {

Tuple tup = f.next();

System.out.println("tuple-was: "+ tup.toString());

//throw new Exception("error: exception of my chooosing... :/");

}

f.close();

Database.getBufferPool().transactionComplete(tid);

} catch (Exception e) {

System.out.println ("Exception : " + e);

}

}

}