public static void main(String arr[]) {
ParseQuery pq = new ParseQuery();
// DBSystem.readConfig("/tmp/config.txt");
String configFilePath = arr[0];
DBSystem.readConfig(configFilePath);
// String query = "Select distinct * from countries where id=123 and code like 'jkl' group by
// continent having code like 'antartic' order by name";
String inputFile = arr[1];
try {
BufferedReader br = new BufferedReader(new FileReader(inputFile));
String line;
while ((line = br.readLine()) != null) {
pq.queryType(line);
}
} catch (FileNotFoundException e) {
System.out.println("Input file not found");
// e.printStackTrace();
} catch (IOException e) {
System.out.println("I/O Exception");
// e.printStackTrace();
}
// /String query = "create table rtyui(name varchar, age int, rollno int)";
}
public void createCommand(String query) {
int isValid = validateAndDisplayCreateCommandParameters(query);
PrintWriter pow = null;
if (isValid == 1) {
// System.out.println(DBSystem.PATH_FOR_DATA);
try {
// code to Create the tablename.data and tablename.csv file.
File fdataFile = new File(DBSystem.PATH_FOR_DATA + "/" + tab_name + ".data");
new File(DBSystem.PATH_FOR_DATA + "/" + tab_name + ".csv").createNewFile();
// Add the details in the .data file
pow = new PrintWriter(new FileWriter(fdataFile));
pow.write(sb.toString());
pow.flush();
// Add the details in the config.txt.
pow = new PrintWriter(new FileWriter(DBSystem.CONFIG_FILE_PATH, true));
pow.write("BEGIN\n");
pow.write(tab_name + "\n");
String[] ar = sb.toString().split(",");
for (int j = 0; j < ar.length; j++) {
String[] at = ar[j].split(":");
pow.write(at[0]);
pow.write(",");
pow.write(at[1] + "\n");
}
pow.write("END\n");
} catch (IOException e) {
e.printStackTrace();
} finally {
pow.close();
}
} else {
System.out.println("Query Invalid");
}
DBSystem.readConfig(DBSystem.CONFIG_FILE_PATH);
}
