public void addCopyTable() { sb.append("COPY ").append(entityInfo.getTableName()).append(" "); }
public void addLoadDataIntoTable() { sb.append("LOAD DATA LOCAL INFILE '' INTO TABLE "); sb.append(scapeName(entityInfo.getTableName())).append(" "); }
@Override public String dropTableSentence(EntityInfo entityInfo) { StringBuilder sb = new StringBuilder("DROP TABLE IF EXISTS "); sb.append(entityInfo.getTableName()); return sb.toString(); }
@Override public String dropTableSentence(EntityInfo entityInfo) { StringBuilder sb = new StringBuilder("DROP TABLE IF EXISTS "); sb.append(scapeName(entityInfo.getTableName())); return sb.toString(); }
public JdbcBulkInsert(JdbcConfiguration config) { this.cfg = config; this.columns = cfg.getEntityInfo().getNotIdentityColumns(); this.insertSql = createInsertQuery(cfg.getEntityInfo().getTableName(), columns); for (ColumnInfo column : columns) { accessors.add(column.getAccessor()); } FieldPreConvert fieldPreConvert = new FieldPreConvert(); for (ColumnInfo column : columns) { preConvert.add(fieldPreConvert.preConvert(column.getFieldType())); } }
@Override public String createTableSentence(EntityInfo entityInfo) { StringBuilder sb = new StringBuilder("CREATE TABLE "); sb.append(entityInfo.getTableName()); sb.append(" ("); List<ColumnInfo> columns = entityInfo.getColumns(); for (int i = 0; i < columns.size(); i++) { ColumnInfo columnInfo = columns.get(i); String dbType = getDbType(columnInfo.getFieldType()); if (dbType == null) { throw new RuntimeException("Type not found for " + columnInfo.getFieldType().getFieldType().name()); } sb.append(columnInfo.getColumnName()).append(" "); sb.append(dbType); if (columnInfo.getFieldType().isPrimitive()) { sb.append(" NOT NULL"); } if (i < columns.size() - 1) { sb.append(", "); } } sb.append(getPrimaryKey(columns)); sb.append(")"); return sb.toString(); }
@Override public String createTableSentence(EntityInfo entityInfo) { StringBuilder sb = new StringBuilder("CREATE TABLE "); sb.append(scapeName(entityInfo.getTableName())); sb.append(" ("); List<ColumnInfo> columns = entityInfo.getColumns(); for (int i = 0; i < columns.size(); i++) { ColumnInfo columnInfo = columns.get(i); String dbType = getDbType(columnInfo.getFieldType()); if (dbType == null) { throw new RuntimeException("Type not found for " + columnInfo.getFieldType().getFieldType().name()); } sb.append(scapeName(columnInfo.getColumnName())).append(" "); sb.append(dbType); if (columnInfo.getFieldType().isPrimitive()) { sb.append(" NOT NULL"); } sb.append(getAutoIncrement(columnInfo)); if (i < columns.size() - 1) { sb.append(", "); } } sb.append(getPrimaryKey(columns)); sb.append(") DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci"); return sb.toString(); }
@Test public void inspectTableNameByEntityName() { JpaEntityInspector inspector = new JpaEntityInspector(SimpleEntityUnannotated.class); EntityInfo entityInfo = inspector.inspect(); assertEquals("simpleentityunannotated", entityInfo.getTableName()); }
@Test public void inspectTableNameByTableAnnotation() { JpaEntityInspector inspector = new JpaEntityInspector(SimpleEntityAnnotated.class); EntityInfo entityInfo = inspector.inspect(); assertEquals("simple_entity", entityInfo.getTableName()); }