public void formatQuery(DaoStatement daoStatement) { if (daoStatement == null) return; SqlContext ctx = daoStatement.getContext(); if (ctx == null || ctx.getPager() == null) return; if (daoStatement instanceof Pojo) formatQuery((Pojo) daoStatement); else if (daoStatement instanceof Sql) formatQuery((Sql) daoStatement); else throw Lang.noImplement(); }
public boolean createEntity(Dao dao, Entity<?> en) { StringBuilder sb = new StringBuilder("CREATE TABLE " + en.getTableName() + "("); // 创建字段 for (MappingField mf : en.getMappingFields()) { if (mf.isReadonly()) continue; sb.append('\n').append(mf.getColumnName()); // 自增主键特殊形式关键字 if (mf.isId() && mf.isAutoIncreasement()) { sb.append(" SERIAL"); } else { sb.append(' ').append(evalFieldType(mf)); // 非主键的 @Name,应该加入唯一性约束 if (mf.isName() && en.getPkType() != PkType.NAME) { sb.append(" UNIQUE NOT NULL"); } // 普通字段 else { if (mf.isUnsigned()) sb.append(" UNSIGNED"); if (mf.isNotNull()) sb.append(" NOT NULL"); if (mf.isAutoIncreasement()) throw Lang.noImplement(); if (mf.hasDefaultValue()) sb.append(" DEFAULT '").append(getDefaultValue(mf)).append('\''); } } sb.append(','); } // 创建主键 List<MappingField> pks = en.getPks(); if (!pks.isEmpty()) { sb.append('\n'); sb.append( String.format( "CONSTRAINT %s_pkey PRIMARY KEY (", en.getTableName().replace('.', '_').replace('"', '_'))); for (MappingField pk : pks) { sb.append(pk.getColumnName()).append(','); } sb.setCharAt(sb.length() - 1, ')'); sb.append("\n "); } // 结束表字段设置 sb.setCharAt(sb.length() - 1, ')'); // 执行创建语句 dao.execute(Sqls.create(sb.toString())); // 创建索引 dao.execute(createIndexs(en).toArray(new Sql[0])); // 创建关联表 createRelation(dao, en); // 添加注释(表注释与字段注释) addComment(dao, en); return true; }
public int updateRelation(Class<?> classOfT, String regex, Chain chain, Condition cnd) { if (chain.isSpecial()) throw Lang.noImplement(); EntityOperator opt = this._opt(classOfT); opt.entity.visitManyMany(null, regex, doUpdateRelation(opt, chain, cnd)); opt.exec(); return opt.getUpdateCount(); }
public void formatQuery(Sql sql) { throw Lang.noImplement(); }
public Pojo duplicate() { throw Lang.noImplement(); }
public Reader getCharacterStream(long pos, long length) throws SQLException { throw Lang.noImplement(); }
public Writer setCharacterStream(long pos) throws SQLException { throw Lang.noImplement(); }
public OutputStream setAsciiStream(long pos) throws SQLException { throw Lang.noImplement(); }
public int setString(long pos, String str, int offset, int len) throws SQLException { throw Lang.noImplement(); }
public long position(Clob searchstr, long start) throws SQLException { throw Lang.noImplement(); }
public String getSubString(long pos, int length) throws SQLException { throw Lang.noImplement(); }