@Override
public void getLastInsertedIdIntoVariable(String path, String resultVariableName)
throws VariableManagerException {
File f;
try {
f = FileWriterImpl.getInstace().fileCreate(path);
} catch (IOException ex) {
Logger.getLogger(PHPGenericWriterImpl.class.getName()).log(Level.SEVERE, null, ex);
return;
}
String phpCode = "$" + resultVariableName + " = $dbn->lastInsertId();";
FileWriterImpl.getInstace().writeLine(phpCode, f);
VariableManagerImpl.getInstace().addVariable(resultVariableName, path);
}
@Override
public void executeSqlUpdateAndGetAffectedRowsNumberIntoVariable(
String path, String query, List<Variable> queryParameters, String resultVariableName)
throws VariableManagerException {
executeSqlQuery(path, query, queryParameters);
try {
FileWriterImpl.getInstace()
.writeLine(
"$" + resultVariableName + "= $stmt->rowCount();",
FileWriterImpl.getInstace().fileCreate(path));
} catch (IOException e) {
e.printStackTrace();
}
VariableManagerImpl.getInstace().addVariable(resultVariableName, path);
}
@Override
public void countResultRowsNumberAndGetResultInVariable(
String path, String rowsVariableName, String countResultVariableName)
throws VariableManagerException {
File f;
try {
f = FileWriterImpl.getInstace().fileCreate(path);
} catch (IOException ex) {
Logger.getLogger(PHPGenericWriterImpl.class.getName()).log(Level.SEVERE, null, ex);
return;
}
String phpCode = "$" + countResultVariableName + " = $" + rowsVariableName + "->rowCount();";
FileWriterImpl.getInstace().writeLine(phpCode, f);
VariableManagerImpl.getInstace().addVariable(countResultVariableName, path);
}
@Override
public void executeSqlQueryAndGetResultInVariable(
String path, String query, List<Variable> queryParameters, String variableName)
throws VariableManagerException {
executeSqlQuery(path, query, queryParameters);
try {
FileWriterImpl.getInstace()
.writeLine(
"$" + variableName + "= $stmt->fetchAll(PDO::FETCH_ASSOC);",
FileWriterImpl.getInstace().fileCreate(path));
} catch (IOException e) {
e.printStackTrace();
}
VariableManagerImpl.getInstace().addVariable(variableName, path);
}
private void printInputVars(String path, List<String> input, String method)
throws VariableManagerException {
File f;
try {
f = FileWriterImpl.getInstace().fileCreate(path);
} catch (IOException ex) {
Logger.getLogger(PHPGenericWriterImpl.class.getName()).log(Level.SEVERE, null, ex);
return;
}
FileWriterImpl.getInstace().writeLine("if(" + method + "){", f);
for (String var : input) {
String line = "\t$" + var + " = $" + method + "[\"" + var + "\"];";
FileWriterImpl.getInstace().writeLine(line, f);
VariableManagerImpl.getInstace().addVariable(var, path);
}
FileWriterImpl.getInstace().writeLine("}", f);
}
