private void conversionBtnActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_conversionBtnActionPerformed
// TODO add your handling code here:
try {
if (Validation.validationTypeOfSQL(
sourceFileWithOutComments, tokenization, subtractValuesFromListSQL)
== true) {
// System.out.println("this is Sql Server");
SyntaxRule rule = new SyntaxRule();
ArrayList<Token> createSourceCodeTokens =
tokenization.createSourceCodeTokens(sourceFileWithOutComments);
if (Validation.tokenValidation(createSourceCodeTokens) == true) {
createSourceCodeTokens = rule.replaceSQLServerFunctions(createSourceCodeTokens);
createSourceCodeTokens = rule.replaceSQLServerDataType(createSourceCodeTokens);
for (int i = 0; i < createSourceCodeTokens.size(); i++) {
createSourceCodeTokens
.get(i)
.setToken(rule.changeForiegnKey(createSourceCodeTokens.get(i)));
}
file.writeToFile(
"result.sql",
createSourceCodeTokens,
"C:/Users/dacorie/Documents/JavaProject/SqlServerToMySqlMitgrationTool/src/assets/");
String list = "";
for (Token x : createSourceCodeTokens) {
list += x.getToken();
}
String[] listArray = list.split(",");
for (String x : listArray) {
mysqlSoucreCode.setText(
(mysqlSoucreCode.getText() + " " + x + "," + "\n").replace(";,", ";"));
}
JOptionPane.showMessageDialog(
null,
"File Conversation Was successfull",
"Successs",
JOptionPane.INFORMATION_MESSAGE);
}
} else {
JOptionPane.showMessageDialog(
null,
"Not Sql Server File ",
"This is not Sql Server File",
JOptionPane.WARNING_MESSAGE);
}
} catch (Exception ex) {
JOptionPane.showMessageDialog(
null, "Not Sql Server File ", "This is not Sql Server File", JOptionPane.WARNING_MESSAGE);
}
} // GEN-LAST:event_conversionBtnActionPerformed
