conn = dao.connect();
if(cp.isDrop){
- executeSqlFile(dao, stmt, folder + "/" + cp.SQL_FILE_NAME[cp.DROP_TABLE], cp, true, false);
+ executeSqlFile(dao, stmt, folder + "/" + cp.SQL_FILE_NAME[cp.DROP_FK], cp, true, false);
executeSqlFile(dao, stmt, folder + "/" + cp.SQL_FILE_NAME[cp.DROP_VIEW], cp, true, false);
executeSqlFile(dao, stmt, folder + "/" + cp.SQL_FILE_NAME[cp.DROP_PROCEDURE], cp, true, false);
executeSqlFile(dao, stmt, folder + "/" + cp.SQL_FILE_NAME[cp.DROP_SYNONYM], cp, true, false);
executeSqlFile(dao, stmt, folder + "/" + cp.SQL_FILE_NAME[cp.DROP_SEQUENCE], cp, true, false);
- executeSqlFile(dao, stmt, folder + "/" + cp.SQL_FILE_NAME[cp.DROP_FK], cp, true, false);
+ executeSqlFile(dao, stmt, folder + "/" + cp.SQL_FILE_NAME[cp.DROP_TABLE], cp, true, false);
}
subFolder = new File(folder + "/TABLES");
inFiles = subFolder.listFiles();
flName = CmnUtils.splitDot(inFiles[k].getName());
tbName = flName[0];
executeSqlFile(dao, stmt, subFolder + "/" + inFiles[k].getName(), cp, false, false);
+ CmnUtils.infoPrint(String.format("%1$-30s",tbName) + " \83\81\83^\83f\81[\83^\82ª\83\8d\81[\83h\82³\82ê\82Ü\82µ\82½\81B");
}
}
executeSqlFile(dao, stmt, folder + "/" + cp.SQL_FILE_NAME[cp.CREATE_PKEY], cp, false, false);
flName = CmnUtils.splitDot(inFiles[k].getName());
viewName = flName[0];
executeSqlFile(dao, stmt, subFolder + "/" + inFiles[k].getName(), cp, false, false);
+ CmnUtils.infoPrint(String.format("%1$-30s",viewName) + " \83\81\83^\83f\81[\83^\82ª\83\8d\81[\83h\82³\82ê\82Ü\82µ\82½\81B");
}
}
subFolder = new File(folder + "/PROCEDURES");
flName = CmnUtils.splitDot(inFiles[k].getName());
procName = flName[0];
executeSqlFile(dao, stmt, subFolder + "/" + inFiles[k].getName(), cp, false, true);
+ CmnUtils.infoPrint(String.format("%1$-30s",procName) + " \83\81\83^\83f\81[\83^\82ª\83\8d\81[\83h\82³\82ê\82Ü\82µ\82½\81B");
}
}
executeSqlFile(dao, stmt, folder + "/" + cp.SQL_FILE_NAME[cp.CREATE_SYNONYM], cp, false, false);
for(int i=0;i<strSplit[2].length;i++)if(!strSplit[2][i].trim().equals(""))pw[0].println(strSplit[2][i]);
pw[0].close();
pw[0] = null;
+ CmnUtils.infoPrint(String.format("%1$-30s",tableName) + " \83\81\83^\83f\81[\83^\82ª\83A\83\93\83\8d\81[\83h\82³\82ê\82Ü\82µ\82½\81B");
sbTbCnts = new StringBuffer();
sbTbCmnt = new StringBuffer();
sbTbCnts.append("CREATE TABLE " + DB_SQL_QUOTED_S[cp.dbType]+ strSplit[0][0] + DB_SQL_QUOTED_E[cp.dbType]);
for(int i=0;i<strSplit[2].length;i++)if(!strSplit[2][i].trim().equals(""))pw[0].println(strSplit[2][i]);
pw[0].close();
pw[0] = null;
+ CmnUtils.infoPrint(String.format("%1$-30s",tableName) + " \83\81\83^\83f\81[\83^\82ª\83A\83\93\83\8d\81[\83h\82³\82ê\82Ü\82µ\82½\81B");
}
for(int i=1;i<4;i++)pw[i].close();
for(int i=1;i<4;i++)pw[i]=null;
}
pw[0].close();
pw[0] = null;
+ CmnUtils.infoPrint(String.format("%1$-30s",strSplit[0][0]) + " \83\81\83^\83f\81[\83^\82ª\83A\83\93\83\8d\81[\83h\82³\82ê\82Ü\82µ\82½\81B");
}
for(int i=1;i<3;i++)pw[i].close();
for(int i=1;i<3;i++)pw[i]=null;
}
pw[0].close();
pw[0] = null;
+ CmnUtils.infoPrint(String.format("%1$-30s",strSplit[0][0]) + " \83\81\83^\83f\81[\83^\82ª\83A\83\93\83\8d\81[\83h\82³\82ê\82Ü\82µ\82½\81B");
}
for(int i=1;i<3;i++)pw[i].close();
for(int i=1;i<3;i++)pw[i]=null;