@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; }