Examples of org.apache.cayenne.map.DbAttribute

org.apache.cayenne.map.DbAttribute
A DbAttribute defines a descriptor for a single database table column.

                if (firstPk)
                    firstPk = false;
                else
                    sqlBuffer.append(", ");


                DbAttribute at = pkit.next();


                sqlBuffer.append(context.quoteString(at.getName()));
            }
            sqlBuffer.append(')');
        }
    }

View Full Code Here

        buf.append("ALTER TABLE ");
        buf.append(context.quoteFullyQualifiedName(source));
        buf.append(" ADD UNIQUE (");


        Iterator<DbAttribute> it = columns.iterator();
        DbAttribute first = it.next();
        buf.append(context.quoteString(first.getName()));


        while (it.hasNext()) {
            DbAttribute next = it.next();
            buf.append(", ");
            buf.append(context.quoteString(next.getName()));
        }


        buf.append(")");


        return buf.toString();

View Full Code Here

            int type,
            int size,
            int scale,
            boolean allowNulls) {


        DbAttribute attr = new DbAttribute();
        attr.setName(name);
        attr.setType(type);
        attr.setMandatory(!allowNulls);


        if (size >= 0) {
            attr.setMaxLength(size);
        }


        if (scale >= 0) {
            attr.setScale(scale);
        }


        return attr;
    }

View Full Code Here

            public boolean visitToOne(ToOneProperty property) {
                ObjRelationship rel = property.getRelationship();
                DbRelationship dbRel = rel.getDbRelationships().get(0);


                for (DbJoin join : dbRel.getJoins()) {
                    DbAttribute src = join.getSource();
                    if (src.isForeignKey() && visited.add(src.getName())) {
                        entityResult.addDbField(src.getName(), prefix + index[0]++);
                    }
                }


                return true;
            }

View Full Code Here


        PreparedStatement selectStatement = con.prepareStatement(selectStr);
        try {
            for (int i = 0; i < parametersSize; i++) {
                Object value = qualifierValues.get(i);
                DbAttribute attribute = qualifierAttributes.get(i);


                adapter.bindParameter(
                        selectStatement,
                        value,
                        i + 1,
                        attribute.getType(),
                        attribute.getScale());
            }


            ResultSet result = selectStatement.executeQuery();


            try {
                if (!result.next()) {
                    throw new CayenneRuntimeException("Missing LOB row.");
                }


                // read the only expected row


                for (int i = 0; i < lobSize; i++) {
                    DbAttribute attribute = lobAttributes.get(i);
                    int type = attribute.getType();


                    if (type == Types.CLOB) {
                        Clob clob = result.getClob(i + 1);
                        Object clobVal = lobValues.get(i);

View Full Code Here


        // ... handle special case - PK.size == 1
        // use some not-so-significant optimizations...


        if (pk.size() == 1) {
            DbAttribute attribute = pk.iterator().next();


            String key = (prefix) ? namePrefix + attribute.getName() : attribute
                    .getName();


            Object val = dataRow.get(key);


            // this is possible when processing left outer joint prefetches
            if (val == null) {
                return null;
            }


            // PUT without a prefix
            return new ObjectId(objEntity.getName(), attribute.getName(), val);
        }


        // ... handle generic case - PK.size > 1


        Map<String, Object> idMap = new HashMap<String, Object>(pk.size() * 2);
        for (final DbAttribute attribute : pk) {


            String key = (prefix) ? namePrefix + attribute.getName() : attribute
                    .getName();


            Object val = dataRow.get(key);


            // this is possible when processing left outer joint prefetches
            if (val == null) {
                return null;
            }


            // PUT without a prefix
            idMap.put(attribute.getName(), val);
        }


        return new ObjectId(objEntity.getName(), idMap);
    }

View Full Code Here

            private void visitRelationship(ArcProperty property) {
                ObjRelationship rel = property.getRelationship();
                DbRelationship dbRel = rel.getDbRelationships().get(0);


                for (DbJoin join : dbRel.getJoins()) {
                    DbAttribute src = join.getSource();
                    appendColumn(idVar, null, src, fields);
                }
            }
        };

View Full Code Here

                boolean first = true;
                while (it.hasNext()) {


                    context.append(!first ? ", " : " ");


                    DbAttribute dbAttribute = it.next();


                    if (context.isAppendingResultColumns()) {
                        context.append(" #result('");
                    }
                    else {
                        context.append(' ');
                    }


                    context.append(alias).append('.').append(dbAttribute.getName());


                    if (context.isAppendingResultColumns()) {


                        String javaType = TypesMapping.getJavaBySqlType(dbAttribute
                                .getType());
                        String columnLabel = fields.get(dbAttribute.getName());


                        context.append("' '").append(javaType).append("' '").append(
                                columnLabel).append("' '").append(columnLabel).append(
                                "' " + dbAttribute.getType()).append(")");
                    }


                    first = false;
                }


            }


            @Override
            protected void processTerminatingAttribute(ObjAttribute attribute) {
                DbEntity table = currentEntity.getDbEntity();
                String alias = this.lastAlias != null ? lastAlias : context
                        .getTableAlias(idPath, table.getFullyQualifiedName());


                DbAttribute dbAttribute = attribute.getDbAttribute();


                if (context.isAppendingResultColumns()) {
                    context.append(" #result('");
                }
                else {
                    context.append(' ');
                }


                context.append(alias).append('.').append(dbAttribute.getName());


                if (context.isAppendingResultColumns()) {
                    String columnAlias = context.nextColumnAlias();


                    // TODO: andrus 6/27/2007 - the last parameter is an unofficial
                    // "jdbcType"
                    // pending CAY-813 implementation, switch to #column directive
                    context
                            .append("' '")
                            .append(attribute.getType())
                            .append("' '")
                            .append(columnAlias)
                            .append("' '")
                            .append(columnAlias)
                            .append("' " + dbAttribute.getType())
                            .append(")");
                }
            }
        };
        expression.visit(pathTranslator);

View Full Code Here

                .getFullyQualifiedName());


        Collection<DbAttribute> pks = table.getPrimaryKeys();


        if (pks.size() == 1) {
            DbAttribute pk = pks.iterator().next();
            context.append(' ').append(alias).append('.').append(pk.getName());
        }
        else {
            throw new EJBQLException(
                    "Multi-column PK to-many matches are not yet supported.");
        }

View Full Code Here

                    table.getFullyQualifiedName());


            Collection<DbAttribute> pks = table.getPrimaryKeys();


            if (pks.size() == 1) {
                DbAttribute pk = pks.iterator().next();
                context.append(' ');
                if (isUsingAliases()) {
                    context.append(alias).append('.');
                }
                context.append(pk.getName());
            }
            else {
                throw new EJBQLException(
                        "Multi-column PK to-many matches are not yet supported.");
            }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.cayenne.map.DbAttribute

net.bnubot.bot.gui.DatabaseEditor

org.apache.cayenne.access.DataDomainFlushObserver

org.apache.cayenne.access.DataDomainInsertBucket

org.apache.cayenne.access.DataNodeSyncQualifierDescriptor

org.apache.cayenne.access.DbGenerator

org.apache.cayenne.access.DbLoader

org.apache.cayenne.access.DbLoaderTest

org.apache.cayenne.access.FlattenedArcKey

org.apache.cayenne.access.IdentityColumnsTest

org.apache.cayenne.access.jdbc.BatchAction

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.