Package org.apache.cayenne.dba

Examples of org.apache.cayenne.dba.QuotingStrategy.quoteFullyQualifiedName()

100
101
102
103
104
105
106
107
108
109
110
                        .getDataMap()
                        .isQuotingSQLIdentifiers());
                StringBuilder buf = new StringBuilder();
                // http://dev.mysql.com/tech-resources/articles/mysql-cluster-50.html
                buf.append("ALTER TABLE ");
                buf.append(context.quoteFullyQualifiedName(entity));
                buf.append(" DROP FOREIGN KEY ");
                buf.append(fkName);

                return Collections.singletonList(buf.toString());
            }
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
        }
        QuotingStrategy context = getQuotingStrategy(status);

        StringBuilder buf = new StringBuilder();
        buf.append("CREATE TABLE ");
        buf.append(context.quoteFullyQualifiedName(ent));

        buf.append(" (");

        // columns
        Iterator<DbAttribute> it = ent.getAttributes().iterator();
View Full Code Here
94
95
96
97
98
99
100
101
102
103
104
        }
        QuotingStrategy context = getQuotingStrategy(status);

        StringBuilder buf = new StringBuilder();
        buf.append("CREATE TABLE ");
        buf.append(context.quoteFullyQualifiedName(ent));

        buf.append(" (");

        // columns
        Iterator<DbAttribute> it = ent.getAttributes().iterator();
View Full Code Here
114
115
116
117
118
119
120
121
122
123
124
    public String dropTable(DbEntity table) {
        QuotingStrategy context = getQuotingStrategy(table
                .getDataMap()
                .isQuotingSQLIdentifiers());
        StringBuffer buf = new StringBuffer("DROP TABLE IF EXISTS ");
        buf.append(context.quoteFullyQualifiedName(table));
        buf.append(" CASCADE");
        return buf.toString();
    }

    /**
 
View Full Code Here
130
131
132
133
134
135
136
137
138
139
140
        // statement
        StringBuffer buf = new StringBuffer();
        QuotingStrategy context = getQuotingStrategy(table
                .getDataMap()
                .isQuotingSQLIdentifiers());
        buf.append(context.quoteFullyQualifiedName(table));

        return Arrays.asList("SET FOREIGN_KEY_CHECKS=0", "DROP TABLE IF EXISTS "
                + buf.toString()
                + " CASCADE", "SET FOREIGN_KEY_CHECKS=1");
    }
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
            status = false;
        }
        QuotingStrategy strategy =  getAdapter().getQuotingStrategy(status);

        StringBuilder query = new StringBuilder("INSERT INTO ");
        query.append(strategy.quoteFullyQualifiedName(batch.getDbEntity()));
        query.append(" (");

        int columnCount = 0;
        for (DbAttribute attribute : dbAttributes) {
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
                && batch.getDbEntity().getDataMap().isQuotingSQLIdentifiers();

        QuotingStrategy strategy = getAdapter().getQuotingStrategy(status);

        StringBuffer query = new StringBuffer("UPDATE ");
        query.append(strategy.quoteFullyQualifiedName(batch.getDbEntity()));
        query.append(" SET ").append(strategy.quoteString(deletedFieldName)).append(
                " = ?");

        applyQualifier(query, batch);
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
        }
        QuotingStrategy context = getQuotingStrategy(status);

        StringBuilder buf = new StringBuilder();
        buf.append("CREATE TABLE ");
        buf.append(context.quoteFullyQualifiedName(ent));

        buf.append(" (");

        // columns
        Iterator<DbAttribute> it = ent.getAttributes().iterator();
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
            }
        }

        buf
                .append(" FROM ")
                .append(strategy.quoteFullyQualifiedName(updateQuery.getDbEntity()))
                .append(" WHERE ");

        it = qualifierAttributes.iterator();
        while (it.hasNext()) {
            DbAttribute attribute = (DbAttribute) it.next();
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
    }
   
    QuotingStrategy strategy = getAdapter().getQuotingStrategy(status);

    StringBuffer query = new StringBuffer("INSERT INTO ");
    query.append(strategy.quoteFullyQualifiedName(batch.getDbEntity()));
    query.append(" (");

    for (Iterator<DbAttribute> i = dbAttributes.iterator(); i.hasNext();) {
      DbAttribute attribute = i.next();
      query.append(strategy.quoteString(attribute.getName()));
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.