private void selectFilebtnActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_selectFilebtnActionPerformed
// TODO add your handling code here:
SyntaxRule syntaxRule = new SyntaxRule();
JFileChooser fileChooser = new JFileChooser();
int returnValue = fileChooser.showOpenDialog(null);
if (returnValue == JFileChooser.APPROVE_OPTION) {
File selectedFile = fileChooser.getSelectedFile();
sqlFile = selectedFile.getAbsolutePath();
if (validation.checkIfFileExtensionIsSql(sqlFile, "sql")) {
sqlSourceFile = file.readFileToString(sqlFile);
// boolean test = validation.checkIfEqualAmountOfbraces(sqlSourceFile);
// if (validation.checkIfEqualAmountOfsemeilcon(sqlSourceFile)) {
String databaseName = syntaxRule.getDatabaseNameFromMySqlServerFile(sqlFile);
syntaxRule.databaseName = databaseName;
sqlSourceFile = syntaxRule.removeAlterDatabaseStatements(sqlSourceFile, databaseName);
sqlSourceFile = syntaxRule.replaceSQLServerSymbols(sqlSourceFile);
sqlSourceFile = syntaxRule.CreateDatabaseStatement(sqlSourceFile, databaseName);
// validation.checkIfEqualInsertValues(sqlSourceFile);
// ArrayList<Token> createSourceCodeTokens =
// tokenization.createSourceCodeTokens(sqlSourceFile);
// validation.checkIfInsertToken(createSourceCodeTokens);
sourceFileWithOutComments = sqlSourceFile;
String[] sourceCodeSplit = sourceFileWithOutComments.split(",");
for (String x : sourceCodeSplit) {
if (x.toLowerCase().contains("primary key")) {
sqlServerSourceCodetxt.setText(sqlServerSourceCodetxt.getText() + " " + x + "\n");
} else {
sqlServerSourceCodetxt.setText(
sqlServerSourceCodetxt.getText() + " " + x + " ," + "\n");
}
}
// }
} else {
JOptionPane.showMessageDialog(
null,
"Wrong file Type! Please Select A file Type ",
"File Type Error",
JOptionPane.ERROR_MESSAGE);
}
}
} // GEN-LAST:event_selectFilebtnActionPerformed
private void optimizationBtnActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_optimizationBtnActionPerformed
// TODO add your handling code here:
SyntaxRule syntaxRule = new SyntaxRule();
JFileChooser fileChooser = new JFileChooser();
int returnValue = fileChooser.showOpenDialog(null);
String wtv = "";
if (returnValue == JFileChooser.APPROVE_OPTION) {
File selectedFile = fileChooser.getSelectedFile();
sqlFile = selectedFile.getAbsolutePath();
if (validation.checkIfFileExtensionIsSql(sqlFile, "sql")) {
LinkedList<String> stringList = new LinkedList<String>();
sqlSourceFile = file.readFileToString(sqlFile);
// List<String> items = Arrays.asList(sqlSourceFile.split(";"));
sqlSourceFile = file.readFileToString(sqlFile);
sqlServerSourceCodetxt.setText("");
String[] sourceCodeSplit = sqlSourceFile.split(",");
for (String x : sourceCodeSplit) {
if (x.toLowerCase().contains("primary key")) {
sqlServerSourceCodetxt.setText(sqlServerSourceCodetxt.getText() + " " + x + "\n");
} else {
sqlServerSourceCodetxt.setText(
sqlServerSourceCodetxt.getText() + " " + x + " ," + "\n");
}
}
try {
Scanner scn = new Scanner(selectedFile);
FileWriter writer = new FileWriter("./src/assets/output.sql");
while (scn.hasNextLine()) {
String i = scn.nextLine(); // optimize
// test for language rules
// replace comments
i = i.toLowerCase();
if (i.startsWith("--") || i.contentEquals("")) {
continue;
}
// Swap keywords
if (i.contains("if exists")) {
continue;
}
if (i.contains("insert")) {
System.out.println("");
}
/*if(i.contains("auto_increment"))
i = i.replace("auto_increment", "identity(1,1)");*/
if (i.contains("auto_increment")) {
i = i.replace("auto_increment", "");
}
if (i.contains("unsigned")) {
i = i.replace("unsigned", "");
}
if (i.contains("bool")) {
i = i.replace("bool", "varchar(4)");
}
if (i.contains("set autocommit=0;")) {
i = i.replace("set autocommit=0;", "");
}
if (i.contains("engine=innodb default charset=utf8")) {
i = i.replace("engine=innodb default charset=utf8", "");
}
if (i.contains("create schema ")) {
i = i.replace("create schema ", "create database");
}
if (i.contains(
"timestamp not null default current_timestamp on update current_timestamp")) {
i =
i.replace(
"timestamp not null default current_timestamp on update current_timestamp",
"timestamp");
}
if (i.contains("n'")) {
i = i.replace("n'", "N'");
}
// remove key
/*if(!(i.contains("primary key")||i.contains("foreign key"))){
if(i.contains("key "))
continue;
}*/
writer.write(i + System.getProperty("line.separator"));
wtv = wtv + i + System.getProperty("line.separator");
// System.out.println(i);
}
scn.close();
writer.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
String[] d = wtv.split(",");
for (String x : d) {
if (x.toLowerCase().contains("primary key")) {
mysqlSoucreCode.setText(mysqlSoucreCode.getText() + " " + x + "\n");
} else {
mysqlSoucreCode.setText(mysqlSoucreCode.getText() + " " + x + " ," + "\n");
}
}
/*// if (validation.checkIfEqualAmountOfsemeilcon(sqlSourceFile)) {
String databaseName = syntaxRule.getDatabaseNameFromMySqlServerFile(sqlFile);
syntaxRule.databaseName = databaseName;
sqlSourceFile = syntaxRule.removeAlterDatabaseStatements(sqlSourceFile, databaseName);
sqlSourceFile = syntaxRule.replaceSQLServerSymbols(sqlSourceFile);
sqlSourceFile = syntaxRule.CreateDatabaseStatement(sqlSourceFile, databaseName);
//validation.checkIfEqualInsertValues(sqlSourceFile);
// ArrayList<Token> createSourceCodeTokens = tokenization.createSourceCodeTokens(sqlSourceFile);
//validation.checkIfInsertToken(createSourceCodeTokens);
sourceFileWithOutComments = sqlSourceFile;
String[] sourceCodeSplit = sourceFileWithOutComments.split(",");
for (String x : sourceCodeSplit) {
if (x.toLowerCase().contains("primary key")) {
sqlServerSourceCodetxt.setText(sqlServerSourceCodetxt.getText() + " " + x + "\n");
} else {
sqlServerSourceCodetxt.setText(sqlServerSourceCodetxt.getText() + " " + x + " ," + "\n");
}
}*/
// }
} else {
JOptionPane.showMessageDialog(
null,
"Wrong file Type! Please Enter a file type",
"File Type Error",
JOptionPane.ERROR_MESSAGE);
}
}
} // GEN-LAST:event_optimizationBtnActionPerformed