-
Notifications
You must be signed in to change notification settings - Fork 0
/
DBCatalog.java
119 lines (103 loc) · 3.56 KB
/
DBCatalog.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
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
package helpers;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import models.Table;
import utils.PropertyFileReader;
public class DBCatalog {
private static DBCatalog catalogInstance;
// public static String inputDirectory="";
// public static String outputDirectory="";
public static String inputDirectory = "samples" + File.separator + "input" + File.separator;
public static String outputDirectory = "samples" + File.separator + "output" + File.separator;
public static String dbDirectory = "";
public static String dataDirectory = "";
public static String queryPath = "";
public static String schemaPath = "";
PropertyFileReader reader = PropertyFileReader.getInstance();
public static Map<String, ArrayList<String>> schemas = new HashMap<String, ArrayList<String>>();
public static Map<String, String> aliases = new HashMap<String, String>();
public DBCatalog() {
createDirectories(inputDirectory, outputDirectory);
}
public static void createDirectories(String newInputDirectory, String newOutputDirectory){
// samples/input
// samples/output
inputDirectory = newInputDirectory;
outputDirectory = newOutputDirectory;
dbDirectory = newInputDirectory + File.separator+"db" + File.separator;
dataDirectory = dbDirectory + "data" + File.separator;
schemaPath = dbDirectory + "schema.txt";
queryPath = inputDirectory +File.separator+ "queries.sql";
createSchema();
}
public static DBCatalog getCatalogInstance() {
//System.out.println("get catalog called");
if (catalogInstance==null) {
catalogInstance = new DBCatalog();
}
return catalogInstance;
}
public static void createSchema() {
System.out.println("Create Schema Called....");
BufferedReader br;
schemas.clear();
try {
br = new BufferedReader(new FileReader(schemaPath));
String row = null;
while ((row = br.readLine()) != null) {
String[] tokens = row.split(" ");
String key = tokens[0];
ArrayList<String> columnNames = new ArrayList<String>();
for (int i = 1; i < tokens.length; i++) {
columnNames.add(tokens[i]);
}
schemas.put(key, columnNames);
//System.out.println("key=" + key + " ....and.... value=" + columnNames);
}
br.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
// Creates a table object with given table name and schema details.
public static Table getTableObject(String tableName) {
BufferedReader br = createTableBuffer(tableName);
if (br == null) return null;
return new Table(tableName, getSchema(tableName),br);
}
public static BufferedReader createTableBuffer(String fileName) {
fileName = actualName(fileName);
try {
String actualTableName = actualName(fileName);
return new BufferedReader(new FileReader(tableFilePath(actualTableName)));
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
public static String tableFilePath(String tabName) {
return dataDirectory + tabName + ".csv";
}
private static String actualName(String tabName) {
if (aliases.containsKey(tabName))
return aliases.get(tabName);
return tabName.trim();
}
// public static void main(String[] args) {
// DBCatalog dbCatalog = new DBCatalog();
// createSchema();
//
// }
public static List<String> getSchema(String tabName) {
return schemas.get(actualName(tabName));
}
}