Examples with Pojo org.nutz.dao.sql.Pojo used on opensource projects

Example 21 with Pojo

use of org.nutz.dao.sql.Pojo in project nutz by nutzam.

the class H2JdbcExpert method fetchPojoId.

public Pojo fetchPojoId(Entity<?> en, MappingField idField) {
    String autoSql = "SELECT IDENTITY() as $field from $view";
    Pojo autoInfo = new SqlFieldMacro(idField, autoSql);
    autoInfo.setEntity(en);
    return autoInfo;
}

Example 22 with Pojo

use of org.nutz.dao.sql.Pojo in project nutz by nutzam.

the class SQLiteJdbcExpert method fetchPojoId.

public Pojo fetchPojoId(Entity<?> en, MappingField idField) {
    String autoSql = "SELECT MAX($field) AS $field FROM $view";
    Pojo autoInfo = new SqlFieldMacro(idField, autoSql);
    autoInfo.setEntity(en);
    return autoInfo;
}

Example 23 with Pojo

use of org.nutz.dao.sql.Pojo in project nutz by nutzam.

the class DoClearLinkVisitor method visit.

public void visit(final Object obj, final LinkField lnk) {
    Pojo pojo = opt.maker().makeDelete(lnk.getLinkedEntity());
    pojo.append(Pojos.Items.cnd(lnk.createCondition(obj)));
    pojo.setOperatingObject(obj);
    opt.add(pojo);
}

Example 24 with Pojo

use of org.nutz.dao.sql.Pojo in project nutz by nutzam.

the class DoClearRelationByHostFieldLinkVisitor method visit.

public void visit(Object obj, LinkField lnk) {
    if (lnk instanceof ManyManyLinkField) {
        final ManyManyLinkField mm = (ManyManyLinkField) lnk;
        final Pojo pojo = opt.maker().makeDelete(mm.getRelationName());
        pojo.append(Pojos.Items.cndColumn(mm.getFromColumnName(), mm.getHostField(), mm.getHostField().getValue(obj)));
        opt.add(pojo);
    }
}

Example 25 with Pojo

use of org.nutz.dao.sql.Pojo in project nutz by nutzam.

the class DoFetchLinkVisitor method visit.

public void visit(final Object obj, final LinkField lnk) {
    Pojo pojo = opt.maker().makeQuery(lnk.getLinkedEntity());
    pojo.setOperatingObject(obj);
    pojo.append(Pojos.Items.cnd(lnk.createCondition(obj)));
    pojo.setAfter(new PojoCallback() {

        public Object invoke(Connection conn, ResultSet rs, Pojo pojo, Statement stmt) throws SQLException {
            Object value = lnk.getCallback().invoke(conn, rs, pojo, stmt);
            lnk.setValue(obj, value);
            return value;
        }
    });
    opt.add(pojo);
}