@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder builder = new StringBuilder(definition.getName()).append(" bigint"); if (!definition.getNullable()) { builder.append(" not null"); } return builder.toString(); } }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder sql = new StringBuilder(); sql.append(definition.getName()); sql.append(" char(1)"); if (!definition.getNullable()) { sql.append(" not null"); } return sql.toString(); } }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder sql = new StringBuilder(); sql.append(definition.getName()); sql.append(" datetime"); if (!definition.getNullable()) { sql.append(" not null"); } return sql.toString(); } }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder sql = new StringBuilder(); sql.append(definition.getName()); sql.append(" decimal(20,0)"); if (!definition.getNullable()) { sql.append(" not null"); } return sql.toString(); } }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder sql = new StringBuilder(); sql.append(definition.getName()); sql.append(" boolean"); if (!definition.getNullable()) { sql.append(" not null"); } return sql.toString(); } }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder builder = new StringBuilder(definition.getName()).append(" datetime"); if (!definition.getNullable()) { builder.append(" not null"); } return builder.toString(); } }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder sql = new StringBuilder(); sql.append(definition.getName()); sql.append(" date"); if (!definition.getNullable()) { sql.append(" not null"); } return sql.toString(); } }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder sql = new StringBuilder(); sql.append(definition.getName()); sql.append(" date"); if (!definition.getNullable()) { sql.append(" not null"); } return sql.toString(); } }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder sql = new StringBuilder(); sql.append(definition.getName()); sql.append(" double "); if (!definition.getNullable()) { sql.append(" not null"); } return sql.toString(); }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder sql = new StringBuilder(); sql.append(definition.getName()); sql.append(" int"); if (!definition.getNullable()) { sql.append(" not null"); } return sql.toString(); }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder sql = new StringBuilder(); sql.append(definition.getName()); sql.append(" datetime"); if (!definition.getNullable()) { sql.append(" not null"); } return sql.toString(); } }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder sql = new StringBuilder(); sql.append(definition.getName()); sql.append(" nvarchar(").append(definition.getLength()).append(')'); if (!definition.getNullable()) { sql.append(" not null"); } return sql.toString(); } }
/** * the keyDefinitionList tableSql. * * @param keyDefinitionList keyDefinitionList * @return createKeyDefinitionsql */ private String createKeyDefinition(final List<FieldDefinition> keyDefinitionList) { final StringBuilder sql = new StringBuilder(); sql.append(" PRIMARY KEY"); boolean isFirst = true; for (FieldDefinition fieldDefinition : keyDefinitionList) { if (isFirst) { sql.append("("); isFirst = false; } else { sql.append(","); } sql.append(fieldDefinition.getName()); } sql.append(")"); return sql.toString(); }
/** * the keyDefinitionList tableSql. * * @param keyDefinitionList keyDefinitionList * @return createKeyDefinitionsql */ private String createKeyDefinition(final List<FieldDefinition> keyDefinitionList) { final StringBuilder sql = new StringBuilder(); sql.append(" PRIMARY KEY"); boolean isFirst = true; for (FieldDefinition fieldDefinition : keyDefinitionList) { if (isFirst) { sql.append("("); isFirst = false; } else { sql.append(","); } sql.append(fieldDefinition.getName()); } sql.append(")"); return sql.toString(); }
/** * the keyDefinitionList tableSql. * * @param keyDefinitionList keyDefinitionList * @return createKeyDefinitionsql */ private String createKeyDefinition(final List<FieldDefinition> keyDefinitionList) { final StringBuilder sql = new StringBuilder(); sql.append(" PRIMARY KEY"); boolean isFirst = true; for (FieldDefinition fieldDefinition : keyDefinitionList) { if (isFirst) { sql.append("("); isFirst = false; } else { sql.append(","); } sql.append(fieldDefinition.getName()); } sql.append(")"); return sql.toString(); }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder sql = new StringBuilder(); sql.append(definition.getName()); if (definition.getLength() == null) { definition.setLength(new Integer("0")); } final Integer length = definition.getLength(); if (length > new Integer("255")) { sql.append(" clob"); } else { sql.append(" varchar2(").append(length < 1 ? new Integer("255") : length).append(')'); } if (!definition.getNullable()) { sql.append(" not null"); } return sql.toString(); } }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder sql = new StringBuilder(); sql.append(definition.getName()); if (definition.getLength() == null) { definition.setLength(new Integer("0")); } if (definition.getLength() > new Integer("1024")) { sql.append(" text"); } else { sql.append(" varchar(").append(definition.getLength() < 1 ? new Integer("100") : definition.getLength()); sql.append(")"); } if (!definition.getNullable()) { sql.append(" not null"); } return sql.toString(); } }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder sql = new StringBuilder(); sql.append(definition.getName()); sql.append(" decimal("); if (null == definition.getLength()) { sql.append("9, "); } else { sql.append(definition.getLength()); } if (null == definition.getPresision()) { sql.append(2); } else { sql.append(definition.getPresision()); } sql.append(") "); if (!definition.getNullable()) { sql.append(" not null"); } return sql.toString(); } }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder sql = new StringBuilder(); sql.append(definition.getName()); sql.append(" number("); if (null == definition.getLength()) { sql.append("9, "); } else { sql.append(definition.getLength()); } if (null == definition.getPresision()) { sql.append(2); } else { sql.append(definition.getPresision()); } sql.append(") "); if (!definition.getNullable()) { sql.append(" not null"); } return sql.toString(); } }
/** * fillFieldDefinitionData. * * @param fieldDefinitionObject josn model * @return {@link FieldDefinition} * @throws JSONException JSONException */ private static FieldDefinition fillFieldDefinitionData(final JSONObject fieldDefinitionObject) throws JSONException { final FieldDefinition ret = new FieldDefinition(); ret.setName(fieldDefinitionObject.getString(NAME)); ret.setDescription(fieldDefinitionObject.optString(DESCRIPTION)); ret.setType(fieldDefinitionObject.getString(TYPE)); ret.setNullable(fieldDefinitionObject.optBoolean(NULLABLE)); ret.setLength(fieldDefinitionObject.optInt(LENGTH)); ret.setIsKey(fieldDefinitionObject.optBoolean(ISKEY)); if (defaultKeyName.equals(ret.getName())) { ret.setIsKey(true); } return ret; }