@Override
public String getSaveNewInstanceString(Model instance) {
String sql = "INSERT INTO " + instance.getClass().getSimpleName().toLowerCase() + " (";
for (Object fieldObject : instance.sqlFields.keySet()) {
String field = (String) fieldObject;
if (!field.equals(instance.sqlFields.keySet().toArray()[0])) {
sql = sql + ", ";
}
sql = sql + field;
}
sql = sql + ") VALUES (";
for (Object fieldObject : instance.sqlFields.values()) {
Object field = ((SQLField) fieldObject).get();
if (field.getClass().equals(String.class)) {
field = "'" + field + "'";
}
if (!fieldObject.equals(instance.sqlFields.values().toArray()[0])) {
sql = sql + ", ";
}
sql = sql + (field);
}
sql = sql + ");";
return sql;
}
public String getDeleteString(Model instance) {
String sql =
"DELETE FROM "
+ instance.getClass().getSimpleName().toLowerCase()
+ " WHERE id="
+ instance.getField("id");
return sql;
}
@Override
public String getCheckExistsString(Model instance) {
String sql =
"SELECT id FROM "
+ instance.getClass().getSimpleName().toLowerCase()
+ " WHERE id="
+ instance.getField("id")
+ ";";
return sql;
}
@Override
public String getUpdateInstanceString(Model instance) {
String sql = "UPDATE " + instance.getClass().getSimpleName().toLowerCase() + " SET ";
for (Object fieldObject : instance.sqlFields.keySet()) {
String field = (String) fieldObject;
Object fieldValue = ((SQLField) instance.sqlFields.get(fieldObject)).get();
if (fieldValue.getClass().equals(String.class)) {
fieldValue = "'" + fieldValue + "'";
}
if (!field.equals(instance.sqlFields.keySet().toArray()[0])) {
sql = sql + ", ";
}
sql = sql + field + "=" + fieldValue;
}
sql = sql + " WHERE id=" + instance.getField("id") + ";";
return sql;
}
public String getTableString(Model model) {
String sql = "CREATE TABLE " + model.getClass().getSimpleName().toLowerCase() + " (\n";
sql = sql + getFieldStrings(model) + getForeignKeyStrings(model);
sql = sql + "\n);";
return sql;
}