Package com.mysema.query

Examples of com.mysema.query.QueryFlag

95
96
97
98
99
100
101
102
     * @param position
     * @param flag
     * @return
     */
    public SQLInsertClause addFlag(Position position, String flag) {
        metadata.addFlag(new QueryFlag(position, flag));
        return this;
    }
View Full Code Here
107
108
109
110
111
112
113
114
     * @param position
     * @param flag
     * @return
     */
    public SQLInsertClause addFlag(Position position, Expression<?> flag) {
        metadata.addFlag(new QueryFlag(position, flag));
        return this;
    }
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
        if (!forCountRow && metadata.getModifiers().isRestricting() && !metadata.getJoins().isEmpty()) {
            QueryModifiers mod = metadata.getModifiers();
            if (mod.getOffset() == null) {
                // select top ...
                metadata = metadata.clone();
                metadata.addFlag(new QueryFlag(QueryFlag.Position.AFTER_SELECT,
                        Expressions.template(Integer.class, topTemplate, mod.getLimit())));
                context.serializeForQuery(metadata, forCountRow);
            } else {
                context.append(outerQueryStart);
                metadata = metadata.clone();
View Full Code Here
112
113
114
115
116
117
118
119
120
121
122
    public void serializeDelete(QueryMetadata metadata, RelationalPath<?> entity, SQLSerializer context) {
        // limit
        QueryModifiers mod = metadata.getModifiers();
        if (mod.isRestricting()) {
            metadata = metadata.clone();
            metadata.addFlag(new QueryFlag(QueryFlag.Position.AFTER_SELECT,
                    Expressions.template(Integer.class, topTemplate, mod.getLimit())));
        }

        context.serializeForDelete(metadata, entity);
View Full Code Here
130
131
132
133
134
135
136
137
138
139
140
            List<Pair<Path<?>, Expression<?>>> updates, SQLSerializer context) {
        // limit
        QueryModifiers mod = metadata.getModifiers();
        if (mod.isRestricting()) {
            metadata = metadata.clone();
            metadata.addFlag(new QueryFlag(QueryFlag.Position.AFTER_SELECT,
                    Expressions.template(Integer.class, topTemplate, mod.getLimit())));
        }

        context.serializeForUpdate(metadata, entity, updates);
View Full Code Here
182
183
184
185
186
187
188
189
190
191
192
        if (!forCountRow && metadata.getModifiers().isRestricting() && !metadata.getJoins().isEmpty()) {
            QueryModifiers mod = metadata.getModifiers();
            if (mod.getOffset() == null) {
                // select top ...
                metadata = metadata.clone();
                metadata.addFlag(new QueryFlag(QueryFlag.Position.AFTER_SELECT,
                        Expressions.template(Integer.class, topTemplate, mod.getLimit())));
                context.serializeForQuery(metadata, forCountRow);
            } else {
                throw new IllegalStateException("offset not supported");
            }
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
            QueryModifiers mod = metadata.getModifiers();
            // use top if order by is empty
            if (mod.getOffset() == null) {
                // select top ...
                metadata = metadata.clone();
                metadata.addFlag(new QueryFlag(QueryFlag.Position.AFTER_SELECT,
                        Expressions.template(Integer.class, topTemplate, mod.getLimit())));
                context.serializeForQuery(metadata, forCountRow);
            } else {
                throw new IllegalStateException("offset not supported without order by");
            }
View Full Code Here
67
68
69
70
71
72
73
74
75
76
77
    @Test
    public void Modifiers2() {
        query.from(survey1).limit(5).offset(3);
        query.getMetadata().addProjection(survey1.id);
        query.getMetadata().addFlag(new QueryFlag(QueryFlag.Position.AFTER_PROJECTION, ", count(*) over() "));

        assertEquals("select * from (  " +
          "select a.*, rownum rn from (   " +
          "select survey1.ID, count(*) over()  from SURVEY survey1  ) " +
          "a) " +
View Full Code Here
TOP

Related Classes of com.mysema.query.QueryFlag

  • com.mysema.query.sql.DetachableSQLQuery
  • com.mysema.query.sql.dml.SQLInsertClause
  • com.mysema.query.sql.OracleTemplatesTest
  • com.mysema.query.sql.SQLServer2005Templates
  • com.mysema.query.sql.SQLServer2012Templates
  • com.mysema.query.sql.SQLServerTemplates
  • com.mysema.query.sql.teradata.TeradataQuery
  • com.mysema.query.sql.WithBuilder
    • Copyright © 2018 www.massapicom. 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.